IBM Support

OPBackup is Failing with Oracle Error Messages (ORA-31693 and ORA-00922)

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.

[{"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1.3;6.0.1.2;6.0.1.1;6.0.1;6.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21592192

Page Feedback