1

Hi All,   I have oracle database connected to mendix service, now when i run the service console i got below error: any Idea Please     com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist                   at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:428)   Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist                   at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.executeValidationQuery(ModelSynchronizationUpdater.java:236)   Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist                   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)                 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)                 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)                 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)                 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)                 at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310)                 at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.executeValidationQuery(ModelSynchronizationUpdater.java:231)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.validateConstraint(ModelSynchronizationUpdater.java:215)                 at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)                 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)                 at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)                 at java.base/java.util.HashMap$ValueSpliterator.forEachRemaining(HashMap.java:1675)                 at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)                 at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)                 at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)                 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)                 at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)                 at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)                 at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)                 at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)                 at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654)                 at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)                 at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)                 at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)                 at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)                 at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.analyzeConstraints(ModelSynchronizationUpdater.java:201)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.validateConstraints(ModelSynchronizationUpdater.java:158)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.analyzeAndRender(ModelSynchronizationUpdater.java:106)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeMappingModel(SynchronizationManager.scala:243)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeModel(SynchronizationManager.scala:233)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCurrentDatabase(SynchronizationManager.scala:149)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$3(SynchronizationManager.scala:83)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCopying(SynchronizationManager.scala:190)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$2(SynchronizationManager.scala:82)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeSourceStructureForCopy(SynchronizationManager.scala:158)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$1(SynchronizationManager.scala:81)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyze(SynchronizationManager.scala:139)                 at com.mendix.connectionbus.ConnectionBusImpl.collectDatabaseSynchronizationInformation(ConnectionBusImpl.java:359)                 at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBusAnyway(MxRuntimeImpl.java:505)                 at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:407)                 at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:49)                 at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30)                 at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:129)                 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)                 at org.eclipse.jetty.server.Server.handle(Server.java:502)                 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)                 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)                 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)                 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)                 at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)                 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)                 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)                 at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)                 at java.base/java.lang.Thread.run(Thread.java:834)   Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not exist                   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)                 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)                 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)                 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)                 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)                 at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310)                 at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.executeValidationQuery(ModelSynchronizationUpdater.java:231)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.validateConstraint(ModelSynchronizationUpdater.java:215)                 at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)                 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)                 at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)                 at java.base/java.util.HashMap$ValueSpliterator.forEachRemaining(HashMap.java:1675)                 at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)                 at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)                 at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)                 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)                 at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)                 at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)                 at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)                 at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)                 at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654)                 at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)                 at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)                 at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)                 at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)                 at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.analyzeConstraints(ModelSynchronizationUpdater.java:201)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.validateConstraints(ModelSynchronizationUpdater.java:158)                 at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.analyzeAndRender(ModelSynchronizationUpdater.java:106)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeMappingModel(SynchronizationManager.scala:243)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeModel(SynchronizationManager.scala:233)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCurrentDatabase(SynchronizationManager.scala:149)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$3(SynchronizationManager.scala:83)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCopying(SynchronizationManager.scala:190)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$2(SynchronizationManager.scala:82)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeSourceStructureForCopy(SynchronizationManager.scala:158)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$1(SynchronizationManager.scala:81)                 at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:57)                 at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyze(SynchronizationManager.scala:139)                 at com.mendix.connectionbus.ConnectionBusImpl.collectDatabaseSynchronizationInformation(ConnectionBusImpl.java:359)                 at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBusAnyway(MxRuntimeImpl.java:505)                 at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:407)                 at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:49)                 at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30)                 at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:129)                 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)                 at org.eclipse.jetty.server.Server.handle(Server.java:502)                 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)                 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)                 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)                 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)                 at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)                 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)                 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)                 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)                 at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)                 at java.base/java.lang.Thread.run(Thread.java:834)

asked 2020-03-10

1 answers