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

[Omer Piperdi]

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!
>
>