Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38800

Wrong Oracle syntax creating SAKAI_CLUSTER Table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 11.0
    • Fix Version/s: 11.0
    • Component/s: Kernel
    • Labels:
    • Previous Issue Keys:
      KNL-1395

      Description

      Error creating SAKAI_CLUSTER Table.

      2015-11-18 03:14:01,728 WARN Dashboard Event Processing Thread org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 907, sql: CREATE TABLE SAKAI_CLUSTER ( SERVER_ID_INSTANCE VARCHAR2 (64), UPDATE_TIME TIMESTAMP WITH LOCAL TIME ZONE, STATUS ENUM('STARTING', 'RUNNING', 'CLOSING', 'STOPPING'), SERVER_ID VARCHAR(64) ), binds: , error: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                k1team KERNEL TEAM (Inactive)
                Reporter:
                jjmerono@um.es Juan José Meroño Sánchez
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code