Unable to Create a Finalized Reporting Period in OpenPages Due to an OP-00703 error

Technote (troubleshooting)


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;

Rate this page:

(0 users)Average rating

Document information

More support for:

OpenPages GRC Platform

Software version:

5.5, 5.5.2, 5.5.3

Operating system(s):


Software edition:

All Editions

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation