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

Ramanjaneyulu_Borusu1 · July 10, 2018, 3:41pm

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.

Holger_von_Thomsen · July 11, 2018, 1:18pm

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

Sasanka · July 11, 2018, 2:03pm

Hello Ram,

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

Ramanjaneyulu_Borusu1 · July 11, 2018, 3:21pm

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.