UIM upgrade failed

Document ID : KB000008309
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

If you are running the UIM upgrade and the UIM abort the installation, check the uimserver_ia_install.log and check if you can see this information on the log.

2017-09-23 03:30:59,607 ERROR console.NimCustomCodeConsoleBase:executeConsoleAction:134 [main]  - Exception caught during processing. Aborting installation.
(503) , java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at line 58
: ORA-00942: table or view does not exist
ORA-06512: at line 58

    at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:77)
    at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScript(NimDBProviderBase.java:252)
    at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScriptFile(NimDBProviderBase.java:185)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.runScriptCommon(UIMServerDBSchemaController.java:268)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.configureSlmCreate(UIMServerDBSchemaController.java:204)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
    at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure_dbScript(UIMServerDBSchemaController.java:168)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure(UIMServerDBSchemaController.java:146)
    at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.run(UIMServerDBSchemaController.java:130)
    at com.nimsoft.install.uimserver.console.ia.UIMServerDBSchemaIACustomCodeConsole.nimExecuteConsoleAction(UIMServerDBSchemaIACustomCodeConsole.java:67)
    at com.nimsoft.install.iacore.console.NimCustomCodeConsoleBase.executeConsoleAction(NimCustomCodeConsoleBase.java:114)
    at com.zerog.ia.installer.ConsoleBasedAAMgr.ah(Unknown Source)
    at com.zerog.ia.installer.ConsoleBasedAAMgr.ac(Unknown Source)
    at com.zerog.ia.installer.ConsoleBasedAAMgr.runPostInstall(Unknown Source)
    at com.zerog.ia.installer.LifeCycleManager.consoleInstallMain(Unknown Source)
    at com.zerog.ia.installer.LifeCycleManager.executeApplication(Unknown Source)
    at com.zerog.ia.installer.Main.main(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.zerog.lax.LAX.launch(Unknown Source)
    at com.zerog.lax.LAX.main(Unknown Source)

2017-09-23 03:30:59,607 INFO  util.IAAbortInstallerUtils:abortInstall:23 [main]  - Calling abortInstall

You will see this message just after this part of the oracle_slm_create.sql script or mysql_slm_create.sql or sqlserver_slm_create.sql, this script is based at yours Database.

      BEGIN
        OPEN c;
        FETCH c INTO x;
        IF (c%NOTFOUND)
        THEN
          lVCreateView := 'CREATE VIEW ' || lVName || '(table_id, sampletime, samplevalue) AS ';
          lVCreateView := lVCreateView || 'SELECT table_id, sampletime,samplevalue FROM ' || lRName || ' ';
          lVCreateView := lVCreateView || ' UNION ALL ';
          lVCreateView := lVCreateView || 'SELECT table_id, sampletime,sampleavg AS samplevalue FROM ' || lHName;
          EXECUTE IMMEDIATE lVCreateView;
        END IF;
        CLOSE c;
      END;
    END IF;
  END LOOP;
  CLOSE ciQOS;
END;

Environment:
Any UIM upgrade above 7.x
Cause:

The script is trying to do a UNION for the RN_QOS_DATA and HN_QOS_DATA table queries and if there is a RN that does not have a HN or there is a HN with no RN, this will fail

Missing RH or HN table on the database.

Resolution:

Access the database using a Oracle client like SQLDeveloper and look the list of the tables in the database.   

Look at the RN_QOS_DATA_  and HN_QOS_DATA_ tables.

When you find the missing table

Open the SQLDeveloper to check the structure for the table.

Here my sample I don't have the HN_QOS_DATA_0044

Open the table RH_QOS_DATA_0044 and compare with another table to see if the structure is the same

The table below 0040 has 7 entries include the samplemax

RH40.jpg

Normally we just have two tables formats with 7 rows in collumn_name and one with 6 rows as below

RN11.jpg

 After you find a RN table that has the same format as your missing HN table you will have to go to the HN table to export the file to create the missing table.

HN40.jpg

After you find the references open the HN table and do right click, go to Quick DDL and save to file.

Quick DDL.jpg

save file.jpg

After you save, open the file at notepad++ or any other that you prefer, you need to copy the name the table that you have and replace for the name that your table is missing.

create the table.jpg

After you changed the table names as above you can ask you DBA to run this creation script.

When missing table is created you will be able to upgrade the environment.