When an OpenPages administrator attempts to finalize a reporting period, an OP-00703 is encountered.
Unable to create a finalized reporting period due to OP-00703 error
Data inconsistency error in resources table where LATESTVERSION is set to NULL.
Diagnosing the problem
The aurora.log contains:
|java.sql.SQLException: ORA-01400: cannot insert NULL into ("OPENPAGES"."LABELASSOCIATIONS"."VERSIONID")
ORA-06512: at "OPENPAGES.OP_LABEL_MGR", line 1197
ORA-06512: at "OPENPAGES.OP_LABEL_MGR", line 820
ORA-06512: at line 1
Resolving the problem
Need to execute this SQL update to resolve issue:
|UPDATE resources SET latestversion=(SELECT max(versionid) FROM versions WHERE resources.resourceid=versions.resourceid) WHERE latestversion is null and type=1;