Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-34888

ORA-00971: missing SET keyword in VerifyLayout

    Details

      Description

      Steps to reproduce

      1) Compile Liferay from source (use that GIT ID I specified above).

      2) Set-up Liferay with Oracle.

      jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
      jdbc.default.url=jdbc:oracle:thin:@localhost:1521:LPISSUES
      jdbc.default.username=lportal_trunk
      jdbc.default.password=password
      

      3) Start the portal up.

      4) Observe the following exception on the console.

      10:31:55,992 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyJournal
      10:31:56,037 INFO  [localhost-startStop-1][VerifyJournal:215] Do not fix oracle new line
      10:31:56,058 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyLayout
      10:31:56,077 ERROR [localhost-startStop-1][MainServlet:215] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword
      
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword
      ...
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
      	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
      	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
      	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:269)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:289)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:282)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:35)
      	at com.liferay.portal.verify.VerifyLayout.verifyUuid(VerifyLayout.java:74)
      	at com.liferay.portal.verify.VerifyLayout.verifyUuid(VerifyLayout.java:49)
      	at com.liferay.portal.verify.VerifyLayout.doVerify(VerifyLayout.java:33)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
      	... 31 more
      Stopping the server due to unexpected startup errors
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                yang.gao Yang Gao (Inactive)
                Reporter:
                laszlo.csontos Laszlo Csontos (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 23 weeks, 1 day ago

                  Packages

                  Version Package
                  6.1.2 CE GA3
                  6.1.30 EE GA3
                  6.2.0 CE M6