[Building Sakai] Problem with deleting old assignment after conversion to 2.7.x
Omer Piperdi
omer at rice.edu
Wed Aug 18 12:52:50 PDT 2010
I think we missed..
http://jira.sakaiproject.org/browse/SAK-17824
Thanks
Omer
On 8/18/2010 1:07 PM, Zhen Qian wrote:
>
> 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,4c6c215837255810511824!
>
>
More information about the sakai-dev
mailing list