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

UpgradeSubscription tries to update a table that doesn't exist

    Details

    • Fix Priority:
      5
    • Sprint:
      Sprint 10: Feb, 01 - Feb, 19

      Description

      The below code:

      		_getGroupIdSQLPartsMap.put(
      			WorkflowInstance.class.getName(),
      			"WorkflowInstance,groupId,workflowInstanceId");
      

      Generates the following exception. There is no such table called WorkflowInstance. There is WorkflowInstanceLink, which I assume is what should be referenced here?

      8:43:55,017 INFO  [main][UpgradeProcess:65] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeSubscription in 218ms
      08:43:55,018 INFO  [main][UpgradeProcess:65] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 10808245ms
      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Invalid object name 'WorkflowInstance'.
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:184)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:152)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:134)
      	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
      	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
      	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:145)
      	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:67)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Invalid object name 'WorkflowInstance'.
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:83)
      	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:101)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
      	... 7 more
      Caused by: java.sql.SQLException: Invalid object name 'WorkflowInstance'.
      	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
      	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
      	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
      	at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
      	at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
      	at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
      	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
      	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
      	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedPreparedStatementHandler.executeQuery(UpgradeOptimizedPreparedStatementHandler.java:62)
      	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedPreparedStatementHandler.invoke(UpgradeOptimizedPreparedStatementHandler.java:47)
      	at com.sun.proxy.$Proxy317.executeQuery(Unknown Source)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeSubscription.getGroupId(UpgradeSubscription.java:135)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeSubscription.updateSubscriptionGroupId(UpgradeSubscription.java:193)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeSubscription.updateSubscriptionGroupIds(UpgradeSubscription.java:222)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeSubscription.doUpgrade(UpgradeSubscription.java:90)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
      	... 10 more
      

        Attachments

          Activity

            People

            • Assignee:
              inacio.nery Inácio Nery
              Reporter:
              brett.swaim Brett Swaim
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 33 weeks ago

                Packages

                Version Package
                7.0.0 Beta 6