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

[Sam Ottenhoff]

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> 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
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140313/1275e99f/attachment.html