[Building Sakai] Sequence Name for Lit-2.1.2 Oracle DB

[Liu, Peter]

Sam,

Yes, I have them in there:

create SEQUENCE lti_mapping_id_sequence INCREMENT BY 1 START WITH 1;
create SEQUENCE lti_content_id_sequence INCREMENT BY 1 START WITH 1;
create SEQUENCE lti_tools_id_sequence INCREMENT BY 1 START WITH 1;

Many thanks!
Peter

From: Sam Ottenhoff <ottenhoff at longsight.com<mailto:ottenhoff at longsight.com>>
Date: Thu, 13 Mar 2014 17:43:25 -0400
To: Peter liu <peter.liu at yale.edu<mailto:peter.liu at yale.edu>>
Cc: "sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>" <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Subject: Re: [Building Sakai] Sequence Name for Lit-2.1.2 Oracle DB

I believe these sequences should be in the official 2.9.0 upgrade script:

https://source.sakaiproject.org/viewsvn/reference/branches/sakai-2.9.x/docs/conversion/sakai_2_9_0_oracle_conversion.sql?revision=115662&view=markup


On Thu, Mar 13, 2014 at 5:37 PM, Liu, Peter <peter.liu at yale.edu<mailto:peter.liu at yale.edu>> wrote:
Hi,

I am trying to upgrade our Lti 1.3 to Lti 2.1.2 version and have some issues with the sequence for these three LTI tables in Oracle Database as attached.

Since I cannot turn on the ‘auto.ddl = true’ on our Oracle DB, there is no way for me to find out what the Sequence-name is for the tables.

Does anyone know what the Sequence name for these three table’s ID?  Then I can create these SEQs in Oracle DB.

Thanks a lot!
Peter


#####  error log #############
When I try to add one external tool info via External Tool UI page:

at org.sakaiproject.blti.tool.LTIAdminTool.doToolPut(LTIAdminTool.java:534)
        ... 48 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140313/4b9c70ca/attachment.html