Troubleshooting
Problem
In OpenPages 6.0.1.x, the OPBackup utility can fail with ORA-31693 and ORA-00922 error messages
Symptom
The following is a sample of the error messages:
[exec] Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
[exec] Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
[exec] Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
[exec] ORA-31693: Table data object "OPWORKFLOW"."PROCESSDATASET" failed to load/unload and is being skipped due to error:
[exec] ORA-00922: missing or invalid option
[exec] ORA-31693: Table data object "OPWORKFLOW"."PROCDEFACCESS" failed to load/unload and is being skipped due to error:
[exec] ORA-00922: missing or invalid option
[exec] Processing object type SCHEMA_EXPORT/JOB
[exec] . . exported "OPWORKFLOW"."DATASETDEFINITIONVALUES" 171.6 MB 11143 rows
[exec] . . exported "OPWORKFLOW"."ACTIVITYDEFINITION" 237.0 MB 82666 rows
[exec] . . exported "OPWORKFLOW"."PROCESSDATASETDEFINITION" 120.6 MB 1103589 rows
Resolving The Problem
To workaround the issue:
1. Log onto the application server.
2. Backup the op-backup-restore.xml.
3. Open the op-backup-restore.xml in a text editor.
4. Find the tags for the opworkflow export and remove the high-lighted argument below that references FLASHBACK_SCN
<echo message="Exporting workflow schema on the Database server ..." />
<echo message="Database Username:${DB_WF_USER} Database Alias:${DB_ALIAS} TimeStamp: ${TS}" />
<exec dir="${OP_BACKUP_DB_DIR}" executable="expdp" failonerror="true">
<env key="NLS_LANG" value="${NLS_LANG}" />
<arg value="${DB_WF_USER}/${DB_WF_PWD}@${DB_ALIAS}" />
<arg value="DIRECTORY=${DB_BACKUP_DIR}" />
<arg value="DUMPFILE=${DB_WF_USER}_${NOW}.dmp" />
<arg value="LOGFILE=${DB_WF_USER}_${NOW}.log" />
<arg value="FLASHBACK_SCN=${SCN_NUMBER}" />
</exec>
5. Save the file.
To resolve the issue permanently, the oracle database server and client should be upgraded to the latest supported version.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21592192