How to fix - If site list is empty and throwing the error “Sorry, something went wrong...”

This issue is because some sites did not have institutes assigned. In OS v2.0, we have added the institute_id column and the value for this is populated from the site coordinator’s institute. The sites with no coordinator will have no institute value.

To resolve the issue, we need to find out the active sites which do not have institute and set it manually.

Step 1: Find active sites which do not have institute

select 
	* 
from 
	catissue_site 
where 
	institute_id is null and 
	activity_status = 'Active' ;

Step 2: Update institute ID, for each site received in step 1

update 
	catissue_site 
set
	institute_id = (select identifier from catissue_institution where name = '<valid_institute_name>') 
where
	identifier = <site_identifier>;