Guys, I am running my SAS code in Oracle and in the past, I was able to trap the error message "ERROR: ORACLE execute error: ORA-01555: snapshot too old: rollback segment number 70 with name "_SYSSMU70_3114942609$" too small" when it was encountered and sent to the team. However, for the past month I haven't been able to do that per the log below because SAS system stopped processing. Please can anyone help with this? 15730 +); ERROR: ORACLE execute error: ORA-01555: snapshot too old: rollback segment number 70 with name "_SYSSMU70_3114942609$" too small. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 15731 + 15732 +%dm_check_status; SYMBOLGEN: Macro variable SYSERR resolves to 0 SYMBOLGEN: Macro variable SQLXRC resolves to -1555 SYMBOLGEN: Macro variable SQLXMSG resolves to ORA-01555: snapshot too old: rollback segment number 70 with name "_SYSSMU70_3114942609$" too small SYMBOLGEN: Macro variable PMSG resolves to "Begin DM_CHECK_STATUS" "Begin DM_CHECK_STATUS" 28AUG2023:14:36:21 SYMBOLGEN: Macro variable SYSERR resolves to 0 SYMBOLGEN: Macro variable LSYSERR resolves to 0 SYMBOLGEN: Macro variable LSQLXRC resolves to -1555 SYMBOLGEN: Macro variable LSQLXRC resolves to -1555 SYMBOLGEN: Macro variable LSQLXMSG resolves to ORA-01555: snapshot too old: rollback segment number 70 with name "_SYSSMU70_3114942609$" too small SYMBOLGEN: Macro variable PMSG resolves to "End DM_CHECK_STATUS" "End DM_CHECK_STATUS" 28AUG2023:14:36:21 The SAS System SYMBOLGEN: Macro variable SYSERR resolves to 0 15733 + %DM_LOG (PMSG="SQL command run with status:&SQLXRC."); SYMBOLGEN: Macro variable SQLXRC resolves to -1555 SYMBOLGEN: Macro variable PMSG resolves to "SQL command run with status:-1555" "SQL command run with status:-1555" 28AUG2023:14:36:21 SYMBOLGEN: Macro variable SYSERR resolves to 0 15734 + 15735 +** Disconnect from databases and close the files **; 15736 +DISCONNECT FROM ORADB_FSMS; NOTE: Statement not executed due to NOEXEC option. 15737 +QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. NOTE: PROCEDURE SQL used (Total process time): real time 3:20:47.95 cpu time 11.94 seconds
... View more