IBM Support

Applying build to GIS43 with Oracle produces error ORA-00942: table or view does not exist in InstallService.log

Troubleshooting


Problem

Applying build to GIS43 with Oracle produces error ORA-00942: table or view does not exist in InstallService.log

Symptom

Applying build to GIS43 with Oracle produces error "java.sql.SQLException: ORA-00942: table or view" does not exist in InstallService.log and install build fails with Error -1 installing service files

Error Message

InstallService.log:  

 

[java] ...Getting metadata from database. This is time consuming. Please wait...
     [java] WARNING:  The system catalog CTX_USER_INDEXES was not found...assuming text search is not enabled.
     [java] Exception in thread "main" java.lang.Exception: java.lang.reflect.InvocationTargetException
     [java]     at com.sterlingcommerce.woodstock.noapp.NoAppLoader.main(NoAppLoader.java:79)
     [java] Caused by: java.lang.reflect.InvocationTargetException
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at java.lang.reflect.Method.invoke(Method.java:585)
     [java]     at com.sterlingcommerce.woodstock.noapp.NoAppLoader.main(NoAppLoader.java:76)
     [java] Caused by:
     [java] <Errors>
     [java]     <Error ErrorCode="java.sql.SQLException"

     [java]         <Attribute Name="ErrorCode" Value="java.sql.SQLException"/>
     [java]         <Attribute Name="ErrorDescription" Value="java.sql.SQLException"/>
     [java]         <Error ErrorCode="java.sql.SQLException" ErrorDescription="" ErrorRelatedMoreInfo="ORA-00942: table or view does not exist ">
     [java]             <Stack>java.sql.SQLException: ORA-00942: table or view does not exist

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX11457

Document Information

Modified date:
03 January 2020

UID

swg21552687

Page Feedback