Troubleshooting - Perceptive Content Database Upgrade Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Upgrade Package for Oracle Server

Platform
Perceptive Content
Product
Perceptive Content Database Upgrade Package for Oracle Server
Release
Foundation 24.1
License

  • To view active session details, execute the following procedure.

    EXECUTE INUSER.IN_DB_UTIL.IN_CONTEXT_PRINT

  • To view a report on uptime progress, execute the following procedure.

    EXECUTE INUSER.IN_DB_UPGRADE.UPTIME_GET_STATUS

  • To view a report on downtime progress, execute the following procedure.

    EXECUTE INUSER.IN_DB_UPGRADE.DOWNTIME_GET_STATUS

  • To view a report on synchronization events, execute the following procedure.

    EXECUTE IN_DB_UPGRADE.SYNC_GET_STATUS('IN_DOC')

  • To view the current state of synchronization, execute the following query. This table is queried by the SYNC_GET_STATUS procedure.

    SELECT * FROM INUSER.SYNC_STATE_DOC;

  • To view the history of synchronization activity, execute the following query. This table is queried by the SYNC_GET_STATUS procedure.

    SELECT * FROM INUSER.SYNC_HIST_DOC ORDER BY SYNC_DATETIME;

  • To view the history of synchronization errors, execute the following query. This table is queried by the SYNC_GET_STATUS procedure.

    SELECT * FROM INUSER.SYNC_ERROR_DOC ORDER BY ACTION_DATETIME;

  • To view the control table for synchronization default values, execute the following query.

    SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_SYNC;

  • To view the control table for upgrade default values, execute the following query.

    SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_UPGRADE;

  • The INUSER.IN_DB_UTIL_LOG table contains a log of any exceptions that occur during the execution of the IN_DB_UTIL and IN_DB_UPGRADE packages. It also contains a log of calls to the IN_SESSION_SET, and IN_SESSION_CLEAR, and IN_SESSION_CLEAR_ALL stored procedures.
  • To view the contents of the IN_DB_UTIL_LOG table execute the following query.

    SELECT * FROM INUSER.IN_DB_UTIL_LOG ORDER BY LOG_TIME;

  • For more in-depth troubleshooting see the Debugging section below to enable the debug option.