1
0
-1

hi,

 

am getting below error, all tables are created as per the manual..

 

INFO  15 May 2018 17:07:09 org.joget.commons.util.SetupManager  - Initializing setup cache

INFO  15 May 2018 17:07:09 org.joget.plugin.base.PluginManager  - PluginManager initialized

ERROR 15 May 2018 17:07:11 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ORA-00942: table or view does not exist

 

INFO  15 May 2018 17:07:12 org.joget.workflow.model.service.WorkflowManagerImpl  - Datasource bound to jwdb

SharkEngineManager -> Shark engine is being initialized ...

2018-05-15 17:07:13,063:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

2018-05-15 17:07:13,064:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(ProcessStateQuery.java:1181)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(ProcessStateQuery.java:632)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(ProcessStateQuery.java:1406)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(ProcessStateDO.java:862)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(ProcessStateDO.java:769)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(DODSPersistentManager.java:4668)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(DODSPersistentManager.java:4642)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.initActivityAndProcessStatesTable(DODSPersistentManager.java:226)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(DODSPersistentManager.java:191)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:266)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:872)

        at org.enhydra.shark.SharkEngineManager.configure(SharkEngineManager.java:535)

        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 org.enhydra.shark.Shark._conf(Shark.java:127)

        at org.enhydra.shark.Shark.configure(Shark.java:54)

        at org.joget.workflow.shark.JSPClientUtilities.init(JSPClientUtilities.java:115)

        at org.joget.workflow.model.service.WorkflowManagerImpl$2.doInTransactionWithoutResult(WorkflowManagerImpl.java:204)

        at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)

        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)

        at org.joget.workflow.model.service.WorkflowManagerImpl.setPath(WorkflowManagerImpl.java:200)

        at org.joget.workflow.model.service.WorkflowManagerImpl.<init>(WorkflowManagerImpl.java:140)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142)

        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)

        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1148)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1051)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)

        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)

        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)

        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

        at org.joget.commons.spring.web.CustomContextLoaderListener.contextInitialized(CustomContextLoaderListener.java:31)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuilder.java:2522)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(ProcessStateQuery.java:1592)

        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQuery.java:118)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(ProcessStateQuery.java:904)

        ... 58 more

*** Caused by:

java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuilder.java:2522)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(ProcessStateQuery.java:1592)

        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQuery.java:118)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(ProcessStateQuery.java:904)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(ProcessStateQuery.java:632)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(ProcessStateQuery.java:1406)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(ProcessStateDO.java:862)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(ProcessStateDO.java:769)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(DODSPersistentManager.java:4668)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(DODSPersistentManager.java:4642)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.initActivityAndProcessStatesTable(DODSPersistentManager.java:226)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(DODSPersistentManager.java:191)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:266)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:872)

        at org.enhydra.shark.SharkEngineManager.configure(SharkEngineManager.java:535)

        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 org.enhydra.shark.Shark._conf(Shark.java:127)

        at org.enhydra.shark.Shark.configure(Shark.java:54)

        at org.joget.workflow.shark.JSPClientUtilities.init(JSPClientUtilities.java:115)

        at org.joget.workflow.model.service.WorkflowManagerImpl$2.doInTransactionWithoutResult(WorkflowManagerImpl.java:204)

        at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)

        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)

        at org.joget.workflow.model.service.WorkflowManagerImpl.setPath(WorkflowManagerImpl.java:200)

        at org.joget.workflow.model.service.WorkflowManagerImpl.<init>(WorkflowManagerImpl.java:140)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142)

        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)

        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1148)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1051)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)

        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)

        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)

        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

        at org.joget.commons.spring.web.CustomContextLoaderListener.contextInitialized(CustomContextLoaderListener.java:31)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

*** Caused by:

java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

)

        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuilder.java:2522)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(ProcessStateQuery.java:1592)

        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQuery.java:118)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(ProcessStateQuery.java:904)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(ProcessStateQuery.java:632)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(ProcessStateQuery.java:1406)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(ProcessStateDO.java:862)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(ProcessStateDO.java:769)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(DODSPersistentManager.java:4668)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(DODSPersistentManager.java:4642)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.initActivityAndProcessStatesTable(DODSPersistentManager.java:226)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(DODSPersistentManager.java:191)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:266)

        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:872)

        at org.enhydra.shark.SharkEngineManager.configure(SharkEngineManager.java:535)

        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 org.enhydra.shark.Shark._conf(Shark.java:127)

        at org.enhydra.shark.Shark.configure(Shark.java:54)

        at org.joget.workflow.shark.JSPClientUtilities.init(JSPClientUtilities.java:115)

        at org.joget.workflow.model.service.WorkflowManagerImpl$2.doInTransactionWithoutResult(WorkflowManagerImpl.java:204)

        at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)

        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)

        at org.joget.workflow.model.service.WorkflowManagerImpl.setPath(WorkflowManagerImpl.java:200)

        at org.joget.workflow.model.service.WorkflowManagerImpl.<init>(WorkflowManagerImpl.java:140)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142)

        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)

        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1148)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1051)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)

        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)

        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)

        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

        at org.joget.commons.spring.web.CustomContextLoaderListener.contextInitialized(CustomContextLoaderListener.java:31)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

2018-05-15 17:07:13,132:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00942: table or view does not exist

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, the error "ORA-00942: table or view does not exist" indicates some required tables do not exist. Did you create the database and verify that the tables exist correctly according to the steps in Configure for Oracle 18c, 12c, 11g, 10g?

      1. prasa

        Hi thanks for your reply as per manual i have created all the table without any errors in jwdb schema using the file "jwdb-oracle.sql" . but getting this error msg.

      CommentAdd your comment...