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

,
1

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.

2

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

3

Hello Ram,

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

4

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.