[Building Sakai] Problem with deleting old assignment after conversion to 2.7.x
Zhen Qian
zqian at umich.edu
Wed Aug 18 11:07:11 PDT 2010
Looks like the problem might relate to taggable impl changes:
"Hibernate: delete from TAGGABLE_LINK where ACTIVITY_REF=?"
One possible related JIRA would be "SAK-15710". Copying Chris here to see
whether he has any insights...
Thanks,
- Zhen
On Wed, 18 Aug 2010 12:55:38 -0500, Omer Piperdi <omer at rice.edu> wrote:
> It was older 2.6.x.. We did run 2.6.0 to 2.6.1 conversions.. (SAK-16668
> and SAK-16548)
>
> ---
> CREATE TABLE assignment_content
> (content_id VARCHAR2(99) NOT NULL,
> context VARCHAR2(99),
> xml CLOB)
> /
> CREATE UNIQUE INDEX assignment_content_index ON assignment_content
> (
> content_id ASC
> )
> /
> CREATE INDEX assignment_content_context ON assignment_content
> (
> context ASC
> )
> /
> ---
> CREATE TABLE assignment_assignment
> (assignment_id VARCHAR2(99) NOT NULL,
> context VARCHAR2(99),
> xml CLOB)
> /
> CREATE UNIQUE INDEX assignment_assignment_index ON assignment_assignment
> (
> assignment_id ASC
> )
> /
> CREATE INDEX assignment_assignment_context ON assignment_assignment
> (
> context ASC
> )
> /
> ---
> CREATE TABLE assignment_submission
> (submission_id VARCHAR2(99) NOT NULL,
> context VARCHAR2(99) NOT NULL,
> xml CLOB,
> submitter_id VARCHAR2(99) DEFAULT null,
> submit_time VARCHAR2(99) DEFAULT null,
> submitted VARCHAR2(6) DEFAULT null,
> graded VARCHAR2(6) DEFAULT null,
> keep VARCHAR2(1) DEFAULT 'X')
> /
>
> CREATE UNIQUE INDEX assignment_submission_index ON assignment_submission
> (
> submission_id ASC
> )
> /
>
> CREATE INDEX assignment_submission_context ON assignment_submission
> (
> context ASC
> )
> /
>
> CREATE UNIQUE INDEX asn_sub_sub_index ON assignment_submission
> (
> context ASC,
> submitter_id ASC
> )
> /
> ---
>
>
> Thanks
> Omer
>
> On 8/18/2010 12:38 PM, Zhen Qian wrote:
>>
>> 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"
>>
>> !DSPAM:2294,4c6c1aa637251585516343!
>>
>>
More information about the sakai-dev
mailing list