Technote (troubleshooting)
Problem(Abstract)
OP-00703 is received when creating a Finalized Reporting Period
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
Environment
Windows/Weblogic FCM 5.X
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:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.