Troubleshooting Commands - Troubleshooting Commands - Perceptive Content - Perceptive Content Database Upgrade Package for SQL Server - Perceptive-Content/Perceptive-Content-Database-Upgrade-Package-for-SQL-Server/Foundation-26.1/Perceptive-Content-Database-Upgrade-Package-for-SQL-Server-Reference-Guide/Troubleshooting-Commands - Foundation 26.1 - Foundation 26.1

Perceptive Content Database Upgrade Package for SQL Server Reference Guide

Platform
Perceptive Content
Product
Perceptive Content Database Upgrade Package for SQL Server
Release
Foundation 26.1
License
ft:lastPublication
2026-04-16T22:28:17.811000
ft:locale
en-US

  • To view the log table for history and any errors, execute the following query.
    SELECT * FROM inuser.IN_DB_UTIL_LOG ORDER BY LOG_ID; 
  • To view active session details, execute the following procedure.
    EXEC inuser.IN_DB_UTIL_SP_SESSIONS_DISPLAY;
  • To view call stack details, execute the following procedure.
    EXEC inuser.IN_DB_UTIL_SP_CALLSTACK_PRINT; 
  • To view the contents of the table containing active session details and attributes, execute the following command. This table is queried by the IN_DB_UTIL_SP_SESSIONS_DISPLAY procedure, which should be used instead.
    SELECT * FROM inuser.IN_DB_UTIL_SESSION_ATTRIBUTES ORDER BY IDENTIFIER;
  • To view the contents of the table containing call stack depth between stored procedures execute the following command. This table is queried by the IN_DB_UTIL_SP_CALLSTACK_PRINT procedure, which should be used instead.
    SELECT * FROM inuser.IN_DB_UTIL_CALLSTACK ORDER BY IDENTIFIER, DEPTH; 
  • To view the current state of synchronization, execute the following. This table is queried by the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used instead.
    SELECT * FROM inuser.SYNC_STATE_DOC;
  • To view the history of synchronization activity, execute the following command. This table is queried by the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used instead.
    SELECT * FROM inuser.SYNC_HIST_DOC ORDER BY SYNC_DATETIME;
  • To view the history of synchronization errors, execute the following command. This table is queried by the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used instead.
    SELECT * FROM inuser.SYNC_ERROR_DOC ORDER BY ACTION_DATETIME;