Troubleshooting database errors after failover

If, after failover, you see errors in the GUI logs relating to the NETWORKVIEWSUMR or networkViewSumr table, you must drop and recreate this table.

About this task

The procedure for dropping and recreating the table differs on DB2 and Oracle.

Procedure

  1. For DB2, complete the following steps:
    1. Enter the following commands at the DB2 command prompt. 
      SET SCHEMA ncpgui;
DROP TABLE networkViewSumr;
    2. Find the section of $PRECISION_HOME/scripts/sql/db2/createPrecisionGUIDb.sql that creates networkViewSumr and copy it into the DB2 command line.
    3. Enter the following command at the DB2 command prompt: 
      COMMIT;
    4. Exit the DB2 command line.
  2. For Oracle, comnplete the following steps:
    1. Enter the following commands at the Oracle command prompt. 
      ALTER SESSION SET CURRENT_SCHEMA = ncpgui;
DROP TABLE networkViewSumr;
    2. Find the section of $PRECISION_HOME/scripts/sql/oracle/createPrecisionGUIDb.sql that creates networkViewSumr and copy it into the Oracle command line.
    3. Exit the Oracle command line.