UIM upgrade failed

book

Article ID: 8309

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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;

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.

Environment

Any UIM upgrade above 7.x

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

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNFAA4" alt="RH40.jpg" width="953" height="252">

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

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNGAA4" alt="RN11.jpg" width="933" height="227">

 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.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNDAA4" alt="HN40.jpg" width="930" height="377">

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

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNEAA4" alt="Quick DDL.jpg" width="533" height="531">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNHAA4" alt="save file.jpg" width="586" height="460">

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.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKNCAA4" alt="create the table.jpg" width="1398" height="412">

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.

 

 

 

 

 

 

Attachments

1558714182708000008309_sktwi1f5rjvs16td1.jpeg get_app
1558714180696000008309_sktwi1f5rjvs16td0.jpeg get_app
1558714178616000008309_sktwi1f5rjvs16tcz.jpeg get_app
1558714176773000008309_sktwi1f5rjvs16tcy.jpeg get_app
1558714174816000008309_sktwi1f5rjvs16tcx.jpeg get_app
1558714172941000008309_sktwi1f5rjvs16tcw.jpeg get_app