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

[Zhen Qian]

Omer:

What was the version used before the conversion? 

Could you send the assignment table descriptions(ASSIGNMENT_CONTENT,
ASSIGNMENT_ASSIGNMENT, ASSIGNMENT_SUBMISSION)?

thanks,

- Zhen

On Wed, 18 Aug 2010 11:30:02 -0500, Omer Piperdi <omer at rice.edu> wrote:
> 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)
> ----
> _______________________________________________
> 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"