Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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?
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.
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