Why is the Grid View not loading after publish?

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>