Soa-Infra does not start due to the following error: Caused By: Error : 942, Position : 17, Sql = SELECT GUID from VERSION, OriginalSql = SELECT GUID from VERSION, Error Msg = ORA-00942: table or view does not exist (Doc ID 2901449.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

On : 12.2.1.4.0 version, Fabric

Soa-Infra application fails to start due to the following error:

<Error> <HTTP> <BEA-101216> <Servlet: "FabricInit" failed to preload on startup in Web application: "/soa-infra".
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.integration.platform.kernel.FabricKernelInitializerServlet.initInstanceTrackingPersistence(FabricKernelInitializerServlet.java:551)
at oracle.integration.platform.kernel.FabricKernelInitializerServlet.init(FabricKernelInitializerServlet.java:441)
at javax.servlet.GenericServlet.init(GenericServlet.java:244)
at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:356)
at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:307)
Truncated. see log file for complete stacktrace
Caused By: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.integration.platform.instance.store.ToplinkSession.checkDescriptor(ToplinkSession.java:241)
at oracle.integration.platform.instance.store.ToplinkSession.createServer(ToplinkSession.java:141)
at oracle.integration.platform.instance.store.ToplinkSession.init(ToplinkSession.java:84)
at oracle.integration.platform.instance.store.ToplinkSession.<init>(ToplinkSession.java:67)
at oracle.integration.platform.instance.store.DOStoreFactory.getToplinkSession(DOStoreFactory.java:211)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
Truncated. see log file for complete stacktrace
Caused By: Error : 942, Position : 17, Sql = SELECT GUID from VERSION, OriginalSql = SELECT GUID from VERSION, Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
Truncated. see log file for complete stacktrace
>

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.