You can use the following procedures to release the application resource locks for the procedures and identifiers or to manually clear the call stack and session attribute tables as needed due to an unhandled exception or after manually cancelling an operation before completion.
Important Do not execute any of the following commands if any operations are still in progress as it will clear the call-stack and session attributes which will lead to undesired results and unhandled exceptions.
- Clear session and call stack for all identifiers (SYNC and
UPGRADE)
EXEC inuser.IN_DB_UTIL_SP_CLEAR_IDENTIFIER 'ALL';
- Clear session and call stack for only the SYNC
identifier
EXEC inuser.IN_DB_UTIL_SP_CLEAR_IDENTIFIER 'SYNC';
- Clear session and call stack for only the UPGRADE identifier
EXEC inuser.IN_DB_UTIL_SP_CLEAR_IDENTIFIER 'UPGRADE';