340to350

 

You MUST evaluate the effects of these fixes in a SANDBOX environment.

The following error was encountered while trying to import alterApopen.sql into the database:

ERROR: check constraint "apopen_apopen_status_notnull" is violated by some row QPSQL: Unable to create query

Delete the orphaned records from apopen where apopen_open is null

SELECT * FROM apopen WHERE apopen_open IS NULL;

BEGIN; 
DELETE FROM apopen WHERE apopen_id IN 
  (SELECT apopen_id 
     FROM apopen
       WHERE apopen_open IS NULL);
COMMIT; If # of rows selected above are deleted 
ROLLBACK; If more than that are deleted.