The Grid View is not loading for users after publishing to review or production.
There are 2 types of errors to check for first:
1) In error_log on OneSuperMaster, there is an error message with the text:
A column named "<field name>" already belongs to the DataTable.
This is caused by a duplicate field that has been created during the publish to review/production.
Solution: Mark the duplicate field as deleted (is_deleted = 1) in the document_metadata table in the Review database if it hasn't been published to production.
2) When looking into console errors and see the following (screenshot below).
Solution: Restrict the fields the user's have access to and do not grant them access to all fields. There is a bad/duplicate field that needs to be identified and removed.
Once the 2 scenarios above have been eliminated, you can try clearing user preferences with the SQL queries below:
Use [OneSuperMaster]
select [db_name], * from or_case where name like '%<Insert Case Name>%'
use [<Insert Review Database>]
--Backup user table
select *
INTO user_BKP_YYYYMMDD_A
from [user]
update u
set u.preferences = NULL
from [user] u
where [user_id] = <Insert User ID>