Question & Answer
Question
When an OpenPages administrator is attempting to run an OPBackup, the utility is failing with oracle errors stating: "ORA-01555: snapshot too old: rollback segment number 8 with name '_SYSSMU8$' too small
Cause
The OPBackup utility is failing with errors such as:
[exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBMANDATE_REQUIREMENT [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBMANDATE_RISK [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBMANDATE_SIGNOFF [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBMANDATE_SUBMANDATE [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_ACCOUNT [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_ACTIONPLAN [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_CONTROLOBJECTIV [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_FILE [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_ISSUE [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_LINK [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_MANDATE [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_RISK [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small [exec] . . exporting table RT__SUBPROCESS_SERVICE [exec] EXP-00008: ORACLE error 1555 encountered [exec] ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small |
Answer
The Oracle DBA needs to review the database instance to determine why the oracle errors are being generated. Once the DBA has made the appropriate changes, the OpenPages administrator should then try to launch the OPBackup utility again.
Related Information
[{"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.2.1;6.2;6.1;6.0.1;6.0;5.5.3;5.5.2;5.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21649073