IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Reg:JDBC Driver][Oracle]ORA-00942: table or view does not exist

  • 1.  Reg:JDBC Driver][Oracle]ORA-00942: table or view does not exist

    Posted Tue July 10, 2018 11:42 AM

    Hello Experts,

    I have installed all DB scripts for BPM and IS, TN(wM9.12) but still showing error in the error log while doing build and upload process to MWS. from the designer.
    Can you please suggest here:

    Error:

    java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
    at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
    at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
    at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.dde3.y(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
    at com.wm.app.prt.storage.StorageJDBC.executeQuery(StorageJDBC.java:3969)
    at com.wm.app.prt.storage.StorageJDBC.setModelExists(StorageJDBC.java:147)
    at com.wm.app.prt.storage.Storage.setModelExists(Storage.java:269)
    at com.wm.app.prt.ModelManager.rereadPackage(ModelManager.java:187)
    at com.wm.app.prt.ModelManager.readAllPackages(ModelManager.java:86)
    at wm.prt.admin.startup(admin.java:80)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:404)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:646)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
    at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
    at com.wm.app.b2b.server.ACLManager

    Thanks,
    Ram.


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Reg:JDBC Driver][Oracle]ORA-00942: table or view does not exist

    Posted Wed July 11, 2018 09:18 AM

    Hi Ram,

    are the jdbc functions ProcessEngine and ProcessAudit assigned to the right pools pointing the matching db user/schema?

    Is Designer configured to point to the right logical server and its database function?

    Regards,
    Holger


    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Reg:JDBC Driver][Oracle]ORA-00942: table or view does not exist

    Posted Wed July 11, 2018 10:03 AM

    Hello Ram,

    Go To Windows>Preferences>Software AG>Process Development > Process Audit Database
    Set the process audit pool here


    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Reg:JDBC Driver][Oracle]ORA-00942: table or view does not exist

    Posted Wed July 11, 2018 11:21 AM

    Thanks for the reply,

    I have done previously what you have specified.

    can you please suggest here.

    Error log:

    com.wm.monitor.common.util.MonitorException: com.wm.monitor.common.util.MonitorException: com.webMethods.bpo.common.process.model.container.plugins.modeler.SQLRuntimeException: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    at com.wm.monitor.app.Model.getAllModels(Model.java:1193)
    at ws.monitor.process.model.getFilteredProcessModels(model.java:169)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:404)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:646)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
    at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:299)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:377)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:545)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:382)
    at com.wm.app.b2b.server.wss.ISAdapter.invokeEndpointService(ISAdapter.java:295)
    at com.wm.app.b2b.server.wss.ISAdapter.decodeSOAPRequestAndInvokeEndpointService(ISAdapter.java:200)
    at com.wm.app.b2b.server.wss.ISAdapter.execute(ISAdapter.java:139)
    at com.wm.app.b2b.server.wss.ISDyn…

    Thanks,
    Ram.


    #Integration-Server-and-ESB
    #webMethods


Related Content