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

Technote (troubleshooting)


Problem(Abstract)

When an OpenPages administrator attempts to finalize a reporting period, an OP-00703 is encountered.

Symptom

Unable to create a finalized reporting period due to OP-00703 error


Cause

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;
COMMIT;

Rate this page:

(0 users)Average rating

Add comments

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:

2013-02-14

Translate my page

Machine Translation

Content navigation