Cleanup After an Early Exit - Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

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.

This should need be necessary in most cases as the IN_DB_UTIL_SP_SESSION_SETUP and IN_DB_UTIL_SP_CLEAR_IDENTIFIER procedures will manage these tables during execution.

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 IN_CLEAR_IDENTIFIER 'ALL';

• Clear session and call stack for only the SYNC identifier

  EXEC IN_CLEAR_IDENTIFIER 'SYNC';

• Clear session and call stack for only the UPGRADE identifier

  EXEC IN_CLEAR_IDENTIFIER 'UPGRADE';

• Clear session and call stack for only the IN_DB_UTIL identifier (Include SPID if different than yours)

  EXEC IN_CLEAR_IDENTIFIER 'IN_DB_UTIL'[, @SPID = ###];