java.sql.SQLException: ORA-00942: table or view does not exist

XWiki.org JIRA | Martin Vanek | 9 years ago
  1. 0

    SW: OracleAS 10.1.3.2 + OracleDB 10.2.0.? Steps: 1. deploy 1.1.2 war 2. import enterprise 1.1.2 xar (works so far) 3. deploy 1.2 RC2 war 4. exception while accessing first page java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721) at com.xpn.xwiki.XWiki.<init>(XWiki.java:672) Steps 2: 1. deploy 1.1.2 war 2. import enterprise 1.1.2 xar (works so far) 3. import enterprise 1.2 RC2 xar (works so far) 4. deploy 1.2 RC2 war 5. same exception while accessing first page

    XWiki.org JIRA | 9 years ago | Martin Vanek
    java.sql.SQLException: ORA-00942: table or view does not exist
  2. 0

    Rebuild Indexes

    j-trac | 10 years ago | rileybolt
    java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification
  3. 0

    Under My Evaluations, clicking the title of the evaluation seems to work, but clicking the (link) next to the title I see HTTP 500 - The server encountered an internal error () that prevented it from fulfilling this request. Is (link) just for testing and can be removed now? <span style="font-size:0.9em;">(<a href="http://localhost:8080/direct/eval-evaluation/1815" title="direct url to the evaluation">link</a>)</span> INFO: No evalGroupId supplied, doing abbreviated check for evalId=1815, userId=f0f507c4-e32a-4a79-00da-3197fa64517e (2007-06-06 11:33:41,679 http-8080-Processor23_org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl) WARN: Empty list of groups for user:f0f507c4-e32a-4a79-00da-3197fa64517e, permission: eval.take.evaluation (2007-06-06 11:33:41,685 http-8080-Processor23_org.sakaiproject.evaluation.logic.impl.EvalExternalLogicImpl) WARN: SQL Error: 936, SQLState: 42000 (2007-06-06 11:33:41,691 http-8080-Processor23_org.hibernate.util.JDBCExceptionReporter) ERROR: ORA-00936: missing expression (2007-06-06 11:33:41,691 http-8080-Processor23_org.hibernate.util.JDBCExceptionReporter) 2007-06-06 11:33:41,769 ERROR (AccessRegistrar.java:82) - <Error handling access request> Target exception of class org.springframework.jdbc.BadSqlGrammarException Successive lines until stack trace show causes progressing to exception site: Error fetching factory bean errorStateManager to initialise bean targettedMessageList --> Error setting dependency requestRSVC of bean errorStateManager --> Error fetching factory bean postDecoder to initialise bean requestRSVC --> Error setting dependency renderSystemDecoder of bean postDecoder --> Error fetching bean renderSystem from factory method getRenderSystem of factory bean renderSystemResolver --> Error fetching bean contentTypeInfo from factory method getContentTypeInfo of factory bean contentTypeInfoFactory --> Error fetching bean viewParameters from factory method getViewParameters of factory bean viewParamsInterceptorManager --> Error fetching bean defaultViewParameters from factory method getViewParameters of factory bean defaultViewInferrerManager --> Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:978) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:119) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:109) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:83) at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.findByProperties(Unknown Source) at org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl.canTakeEvaluation(EvalEvaluationsLogicImpl.java:652) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParametersImpl(EvaluationVPInferrer.java:170) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.access$000(EvaluationVPInferrer.java:49) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer$1.run(EvaluationVPInferrer.java:96) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:94) at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.invokeTransactionalAccess(Unknown Source) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:39) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParameters(EvaluationVPInferrer.java:94) at uk.ac.cam.caret.sakai.rsf.entitybroker.EVPIManager.getViewParameters(EVPIManager.java:57) at uk.org.ponder.rsf.viewstate.DefaultViewInferrerManager.getViewParameters(DefaultViewInferrerManager.java:21) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$a25f3849.get(<generated>) at uk.org.ponder.rsf.viewstate.BasicViewParametersParser.parse(BasicViewParametersParser.java:62) at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:248) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:124) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:113) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:571) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$5ca323fe.get(<generated>) at uk.org.ponder.rsf.viewstate.ViewParamsInterceptorManager.getViewParameters(ViewParamsInterceptorManager.java:22) at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$4dbcb9e3.get(<generated>) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentType(ContentTypeInfoFactory.java:46) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentTypeInfo(ContentTypeInfoFactory.java:60) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.content.ContentTypeInfo$$EnhancerByCGLIB$$f63a8ba4.get(<generated>) at uk.org.ponder.rsf.renderer.RenderSystemResolver.getRenderSystem(RenderSystemResolver.java:33) at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:32) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:436) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.ac.cam.caret.sakai.rsf.entitybroker.AccessRegistrar.handleAccess(AccessRegistrar.java:78) at org.sakaiproject.entitybroker.servlet.DirectServlet.dispatch(DirectServlet.java:180) at org.sakaiproject.entitybroker.servlet.DirectServlet.handleRequest(DirectServlet.java:138) at org.sakaiproject.entitybroker.servlet.DirectServlet.doGet(DirectServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:532) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:613) WARN: dispatch(): exception: (2007-06-06 11:33:41,778 http-8080-Processor23_org.sakaiproject.entitybroker.servlet.DirectServlet) org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID23_0_, this_.LAST_MODIFIED as LAST2_23_0_, this_.OWNER as OWNER23_0_, this_.group_id as group4_23_0_, this_.group_type as group5_23_0_, this_.INSTRUCTOR_APPROVAL as INSTRUCTOR6_23_0_, this_.INSTRUCTORS_VIEW_RESULTS as INSTRUCT7_23_0_, this_.STUDENTS_VIEW_RESULTS as STUDENTS8_23_0_, this_.EVALUATION_FK as EVALUATION9_23_0_ from EVAL_ASSIGN_GROUP this_ where this_.EVALUATION_FK=? and this_.INSTRUCTOR_APPROVAL=? and this_.group_id in ()]; nested exception is java.sql.SQLException: ORA-00936: missing expression java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:978) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:119) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:109) at org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findByProperties(HibernateBasicGenericDao.java:83) at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.findByProperties(Unknown Source) at org.sakaiproject.evaluation.logic.impl.EvalEvaluationsLogicImpl.canTakeEvaluation(EvalEvaluationsLogicImpl.java:652) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParametersImpl(EvaluationVPInferrer.java:170) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.access$000(EvaluationVPInferrer.java:49) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer$1.run(EvaluationVPInferrer.java:96) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:94) at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy5.invokeTransactionalAccess(Unknown Source) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:39) at org.sakaiproject.evaluation.tool.inferrers.EvaluationVPInferrer.inferDefaultViewParameters(EvaluationVPInferrer.java:94) at uk.ac.cam.caret.sakai.rsf.entitybroker.EVPIManager.getViewParameters(EVPIManager.java:57) at uk.org.ponder.rsf.viewstate.DefaultViewInferrerManager.getViewParameters(DefaultViewInferrerManager.java:21) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$a25f3849.get(<generated>) at uk.org.ponder.rsf.viewstate.BasicViewParametersParser.parse(BasicViewParametersParser.java:62) at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:248) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:124) at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:113) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:571) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$5ca323fe.get(<generated>) at uk.org.ponder.rsf.viewstate.ViewParamsInterceptorManager.getViewParameters(ViewParamsInterceptorManager.java:22) at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.viewstate.ViewParameters$$EnhancerByCGLIB$$4dbcb9e3.get(<generated>) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentType(ContentTypeInfoFactory.java:46) at uk.org.ponder.rsf.content.ContentTypeInfoFactory.getContentTypeInfo(ContentTypeInfoFactory.java:60) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACBridgeProxy.getTarget(RSACBridgeProxy.java:64) at uk.org.ponder.rsac.RSACPeaProxyFactory.intercept(RSACPeaProxyFactory.java:62) at uk.org.ponder.rsf.content.ContentTypeInfo$$EnhancerByCGLIB$$f63a8ba4.get(<generated>) at uk.org.ponder.rsf.renderer.RenderSystemResolver.getRenderSystem(RenderSystemResolver.java:33) at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:27) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:21) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:81) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:464) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.fetchDependent(RSACBeanLocator.java:626) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:513) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:456) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:32) at uk.org.ponder.rsac.RSACBeanLocator.createBean(RSACBeanLocator.java:436) at uk.org.ponder.rsac.RSACBeanLocator.getLocalBean(RSACBeanLocator.java:340) at uk.org.ponder.rsac.RSACBeanLocator.getBean(RSACBeanLocator.java:367) at uk.org.ponder.rsac.PerRequestInfo$1.locateBean(PerRequestInfo.java:47) at uk.ac.cam.caret.sakai.rsf.entitybroker.AccessRegistrar.handleAccess(AccessRegistrar.java:78) at org.sakaiproject.entitybroker.servlet.DirectServlet.dispatch(DirectServlet.java:180) at org.sakaiproject.entitybroker.servlet.DirectServlet.handleRequest(DirectServlet.java:138) at org.sakaiproject.entitybroker.servlet.DirectServlet.doGet(DirectServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:532) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:613)

    Sakai JIRA | 10 years ago | Richard Ellis
    java.sql.SQLException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: ORA-0094 caught when using quartz

    Stack Overflow | 5 years ago | Xuanzi Han
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    errors with use_capture_lobs and use_stream_lobs

    symmetricds | 4 years ago | kart-ak
    org.jumpmind.db.sql.SqlException: ORA-00942: table or view does not exist

    12 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      11 frames
    3. Commons DBCP
      DelegatingPreparedStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      2 frames
    4. Hibernate
      CriteriaLoader.list
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:662)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      5. org.hibernate.loader.Loader.doList(Loader.java:2145)
      6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      7. org.hibernate.loader.Loader.list(Loader.java:2024)
      8. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
      8 frames
    5. Hibernate
      CriteriaImpl.uniqueResult
      1. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
      2. org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
      3. org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
      3 frames
    6. com.xpn.xwiki
      XWiki.<init>
      1. com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64)
      2. com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      3. com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
      4. com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
      5. com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
      6. com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      7. com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
      8. com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      8 frames