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

ORA-00942 during VerifyWorkflow when starting DXP for the first time using Oracle 11g

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 7.0.X EE
    • Fix Version/s: Master
    • Component/s: Workflow
    • Labels:
      None

      Description

      Steps to Reproduce

      1. Configure a clean Oracle 11g database;
      2. Setup Liferay for using that database in portal-ext.properties;
      3. Start server.

      Expected behavior:
      Liferay starts without throwing any errors into the console.

      Actual behavior:
      Liferay throws following stacktrace into the app server console:

      21:14:35,503 INFO  [localhost-startStop-1][LoggingTimer:70] Starting com.liferay.portal.verify.VerifyWorkflow#deleteOrphaned
      21:14:35,555 ERROR [localhost-startStop-1][DBInspector:80] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at com.liferay.portal.kernel.dao.db.DBInspector.hasColumn(DBInspector.java:67)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.hasColumn(BaseDBProcess.java:133)
      	at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:34)
      	at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1339)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      21:14:35,560 ERROR [localhost-startStop-1][DBInspector:80] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at com.liferay.portal.kernel.dao.db.DBInspector.hasColumn(DBInspector.java:67)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.hasColumn(BaseDBProcess.java:133)
      	at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:34)
      	at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1339)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      21:14:35,568 ERROR [localhost-startStop-1][DBInspector:80] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at com.liferay.portal.kernel.dao.db.DBInspector.hasColumn(DBInspector.java:67)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.hasColumn(BaseDBProcess.java:133)
      	at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:42)
      	at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1339)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      21:14:35,573 ERROR [localhost-startStop-1][DBInspector:80] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at com.liferay.portal.kernel.dao.db.DBInspector.hasColumn(DBInspector.java:67)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.hasColumn(BaseDBProcess.java:133)
      	at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:42)
      	at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1339)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      21:14:35,574 INFO  [localhost-startStop-1][LoggingTimer:38] Completed com.liferay.portal.verify.VerifyWorkflow#deleteOrphaned in 71 ms
      21:14:35,574 INFO  [localhost-startStop-1][VerifyProcess:79] Completed verification process com.liferay.portal.verify.VerifyWorkflow in 72ms
      

      Reproduced on:
      7.0.x @ commit 80303ab5f2179549b78cc040b933cefb4106d4f5

      Not reproduced on:
      master (not possible to test using Oracle databases)
      6.2.x (Portal starts without any problems)

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 25 weeks, 5 days ago

                  Packages

                  Version Package
                  Master