[Building Sakai] FW: Upgrading to 2.7.0 and error in schedule job.
Karen Tsao
ktsao at stanford.edu
Thu Oct 14 14:30:00 PDT 2010
Hi Rustamali,
The FEEDBACKCOMPONENTOPTION is introduced in
http://jira.sakaiproject.org/browse/SAM-666 which is a 2.8 feature. Do you
use the 2.7 Samigo or trunk code?
Thanks,
Karen
On Wed, Oct 13, 2010 at 11:02 AM, Manesiya,Rustamali R <
rmanesiy at mdanderson.org> wrote:
> Hello, I recently upgraded from 2.6.2 to 2.7.0 and I receive following
> error when I start the tomcat server. Any help would be good. Thanks.
>
>
>
> 2010-10-13 12:00:00,266 INFO QuartzScheduler_Worker-3
> org.sakaiproject.tool.assessment.services.AutoSubmitAssessmentsJob - Start
> Job: AutoSubmitAssessmentsJob $ Job: AssesSubmit Trigger: TrigAssessSubmi
> Fire scheduled: Wed Oct 13 12:00:00 CDT 2010 Fire actual: Wed Oct 13
> 12:00:00 CDT 2010
>
> 2010-10-13 12:00:01,797 WARN QuartzScheduler_Worker-3
> org.hibernate.util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
>
> 2010-10-13 12:00:01,797 ERROR QuartzScheduler_Worker-3
> org.hibernate.util.JDBCExceptionReporter - ORA-00904:
> "PUBLISHEDF3_"."FEEDBACKCOMPONENTOPTION": invalid identifier
>
>
>
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> load an entity:
> [org.sakaiproject.tool.assessment.data.dao.assessment.PublishedAssessmentData#5963];
> nested exception is org.hibernate.exception.SQLGrammarException: could not
> load an entity:
> [org.sakaiproject.tool.assessment.data.dao.assessment.PublishedAssessmentData#5963]
>
> at
> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
>
> at
> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
>
> at
> org.sakaiproject.tool.assessment.facade.PublishedAssessmentFacadeQueries.getSectionSetForAssessment(PublishedAssessmentFacadeQueries.java:2010)
>
> 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:592)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>
> at $Proxy40.getSectionSetForAssessment(Unknown Source)
>
> at
> org.sakaiproject.tool.assessment.services.assessment.PublishedAssessmentService.getSectionSetForAssessment(PublishedAssessmentService.java:528)
>
> at
> org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.completeItemGradingData(AssessmentGradingFacadeQueries.java:2842)
>
> at
> org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.autoSubmitAssessments(AssessmentGradingFacadeQueries.java:2648)
>
> 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:592)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>
> at $Proxy77.autoSubmitAssessments(Unknown Source)
>
> at
> org.sakaiproject.tool.assessment.services.GradingService.autoSubmitAssessments(GradingService.java:1847)
>
> at
> org.sakaiproject.tool.assessment.services.AutoSubmitAssessmentsJob.execute(AutoSubmitAssessmentsJob.java:84)
>
> at
> org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70)
>
> at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
>
> at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
>
> Caused by: org.hibernate.exception.SQLGrammarException: could not load an
> entity:
> [org.sakaiproject.tool.assessment.data.dao.assessment.PublishedAssessmentData#5963]
>
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>
> at org.hibernate.loader.Loader.loadEntity(Loader.java:1878)
>
> at
> org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
>
> at
> org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
>
> at
> org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3039)
>
> at
> org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399)
>
> at
> org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
>
> at
> org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
>
> at
> org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
>
> at
> org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
>
> at
> org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:879)
>
> at
> org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:847)
>
> at
> org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:567)
>
> at
> org.hibernate.type.EntityType.resolve(EntityType.java:389)
>
> at
> org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:120)
>
> at
> org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
>
> at org.hibernate.loader.Loader.doQuery(Loader.java:729)
>
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>
> at org.hibernate.loader.Loader.doList(Loader.java:2217)
>
> at
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
>
> at org.hibernate.loader.Loader.list(Loader.java:2103)
>
> at
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340)
>
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>
> at
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
>
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:930)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
>
> ... 34 more
>
> Caused by: java.sql.SQLException: ORA-00904:
> "PUBLISHEDF3_"."FEEDBACKCOMPONENTOPTION": invalid identifier
>
>
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
>
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
>
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
>
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
>
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
>
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
>
> at
> org.hibernate.loader.Loader.getResultSet(Loader.java:1791)
>
> at org.hibernate.loader.Loader.doQuery(Loader.java:674)
>
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>
> at org.hibernate.loader.Loader.loadEntity(Loader.java:1864)
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101014/ab2c291f/attachment.html
More information about the sakai-dev
mailing list