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

Another error in Oracle fresh startup

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.2
    • Fix Version/s: 12.0 [Tentative]
    • Component/s: Citations
    • Labels:
    • 11 status:
      Merge

      Description

      This error is in nightly oracle logs:

      24-Feb-2017 00:38:16.789 WARN [localhost-startStop-1] org.sakaiproject.db.impl.BasicSqlService.dbWriteCount Sql.dbWrite(): error code: 907 sql:  CREATE TABLE CITATION_COLLECTION_ORDER ( COLLECTION_ID VARCHAR2 (36) NOT NULL, CITATION_ID VARCHAR (36), SECTION_TYPE ENUM('HEADING1','HEADING2', 'HEADING3', 'DESCRIPTION', 'CITATION'), VALUE TEXT, LOCATION NUMBER(10,0) NOT NULL ) binds:  
      java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  nickwilson Nick Wilson
                  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: