IBM Support

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;

Document information

More support for: OpenPages GRC Platform

Software version: 5.5, 5.5.2, 5.5.3

Operating system(s): Windows

Software edition: All Editions

Reference #: 1586287

Modified date: 14 February 2013

Translate this page: