[Building Sakai] Problem with deleting old assignment after conversion to 2.7.x

Omer Piperdi omer at rice.edu
Wed Aug 18 09:30:02 PDT 2010


We are having problem with deleting old assignment after converting to 2.7x.

Below is the error that we are seeing with hibernate debugger on..

Any idea or suggestion? Did we miss any sql conversion during the upgrade.

Thanks
Omer


-----
Hibernate: delete from TAGGABLE_LINK where ACTIVITY_REF=?
2010-08-18 11:22:04,188  WARN http-8443-Processor3 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 942, SQLState: 42000
2010-08-18 11:22:04,188 ERROR http-8443-Processor3 
org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does 
not exist

2010-08-18 11:22:04,197  WARN http-8443-Processor3 
org.sakaiproject.cheftool.VelocityPortletPaneledAction - Exception 
calling method doDelete_assignment 
java.lang.reflect.InvocationTargetException (Caused by 
org.springframework.dao.InvalidDataAccessResourceUsageException: could 
not execute update query; nested exception is 
org.hibernate.exception.SQLGrammarException: could not execute update query)
java.lang.reflect.InvocationTargetException
         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:597)
         at 
org.sakaiproject.cheftool.VelocityPortletPaneledAction.actionDispatch(VelocityPortletPaneledAction.java:622)
         at 
org.sakaiproject.cheftool.VelocityPortletPaneledAction.processAction(VelocityPortletPaneledAction.java:532)
         at 
org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:230)
         at 
org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1029)
         at 
org.sakaiproject.cheftool.ToolServlet.doPost(ToolServlet.java:154)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
         at 
org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
         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:580)
         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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
         at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
----


More information about the sakai-dev mailing list