IBM Support

Installation failed, ORA-00942: table or view does not exist

Troubleshooting


Problem

Installation failed, ORA-00942: table or view does not exist

Symptom

During Installation of SI 5005 build, the install failed with the error message indicated in the Error Message below:

Error Message

ORA-00942: table or view does not exist

===============================

DynamicClassLoader.appendToSearchPath(X:\SterlingCommerce\SI5005\install\ant\xmlParserAPIs.jar) returned: true
processed 1 tasks
adding generic version information
java.lang.ClassNotFoundException: com.sterlingcommerce.woodstock.install.versions.GenericServiceVersions
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)<b r /> at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.addVersionIn fo(ServiceInstall.java:2869)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(Serv iceInstall.java:459)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(Serv iceInstall.java:240)
at com.sterlingcommerce.woodstock.install.InstallSI.ModuleLoader(InstallSI.java:139 9)
at com.sterlingcommerce.woodstock.install.InstallSI.PerformInstall(InstallSI.java:6 14)
at com.sterlingcommerce.woodstock.install.InstallSI.main(InstallSI.java:124)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(I nstallSIBootstrapper.java:350)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(I nstallSIBootstrapper.java:354)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.doIt(InstallSIBoots trapper.java:188)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.main(InstallSIBoots trapper.java:81)
No version info to add
versions added to sandbox.cfg only.
...DONE

Service X:\SterlingCommerce\SI5005\install\packages\install_core_3205.jar installed

Mon Aug 30 18:52:23 CDT 2010 : Service install complete.
Service install took 8422 milli seconds.
FileOutputString opened for: .\properties\sandbox.cfg
sandboxProp stored to: .\properties\sandbox.cfg
FileOutputStream closed for: .\properties\sandbox.cfg
[TIMING] - Installing: X:\SterlingCommerce\SI5005\install\packages\install_core_3205.jar completed in: 8 seconds.
Attempting to extract serviceinstallbootstrapper.jar
ORA-00942: table or view does not exist

java.lang.NullPointerException
at java.util.StringTokenizer.<init>(StringTokenizer.java:182)
at java.util.StringTokenizer.<init>(StringTokenizer.java:204)
at com.sterlingcommerce.woodstock.install.utils.FormerUpgrade.check42orEarlier(Form erUpgrade.java:350)
at com.sterlingcommerce.woodstock.install.utils.FormerUpgrade.is42orEarlier(FormerU pgrade.java:386)
at com.sterlingcommerce.woodstock.install.InstallSI.PerformInstall(InstallSI.java:6 47)
at com.sterlingcommerce.woodstock.install.InstallSI.main(InstallSI.java:124)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(I nstallSIBootstrapper.java:350)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(I nstallSIBootstrapper.java:354)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.doIt(InstallSIBoots trapper.java:188)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.main(InstallSIBoots trapper.java:81)
EXIT_VALUE=-1
ERROR: Installation failed '0'
-1
Install Complete

[{"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

NFX9820

Document Information

Modified date:
14 November 2019

UID

swg21557687