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

Unable to upgrade to 7.0 using Oracle: MVCCVersion column is not added

    Details

      Description

      Steps to reproduce it:

      1. Startup a 6.2 using Oracle.
      2. Upgrade to 7.0

      Result:
      You will get the following errors:

      18:43:22,073 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Account_ does not exist
      18:43:22,074 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Address does not exist
      18:43:22,075 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table BrowserTracker does not exist
      18:43:22,077 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ClassName_ does not exist
      18:43:22,078 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ClusterGroup does not exist
      18:43:22,080 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Company does not exist
      18:43:22,081 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Contact_ does not exist
      18:43:22,082 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Country does not exist
      18:43:22,084 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table EmailAddress does not exist
      18:43:22,086 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Group_ does not exist
      18:43:22,087 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Image does not exist
      18:43:22,088 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Layout does not exist
      18:43:22,089 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutBranch does not exist
      18:43:22,091 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutFriendlyURL does not exist
      18:43:22,092 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutPrototype does not exist
      18:43:22,094 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutRevision does not exist
      18:43:22,097 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutSet does not exist
      18:43:22,099 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutSetBranch does not exist
      18:43:22,101 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table LayoutSetPrototype does not exist
      18:43:22,104 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ListType does not exist
      18:43:22,105 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table MembershipRequest does not exist
      18:43:22,107 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Organization_ does not exist
      18:43:22,108 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table OrgGroupRole does not exist
      18:43:22,110 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table OrgLabor does not exist
      18:43:22,111 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PasswordPolicy does not exist
      18:43:22,117 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PasswordPolicyRel does not exist
      18:43:22,118 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PasswordTracker does not exist
      18:43:22,119 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Phone does not exist
      18:43:22,121 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PluginSetting does not exist
      18:43:22,122 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PortalPreferences does not exist
      18:43:22,124 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Portlet does not exist
      18:43:22,125 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PortletItem does not exist
      18:43:22,126 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table PortletPreferences does not exist
      18:43:22,127 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table RecentLayoutBranch does not exist
      18:43:22,128 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table RecentLayoutRevision does not exist
      18:43:22,129 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table RecentLayoutSetBranch does not exist
      18:43:22,130 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Region does not exist
      18:43:22,131 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Release_ does not exist
      18:43:22,136 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Repository does not exist
      18:43:22,137 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table RepositoryEntry does not exist
      18:43:22,138 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ResourceAction does not exist
      18:43:22,139 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ResourceBlock does not exist
      18:43:22,140 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ResourceBlockPermission does not exist
      18:43:22,141 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ResourcePermission does not exist
      18:43:22,142 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ResourceTypePermission does not exist
      18:43:22,143 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Role_ does not exist
      18:43:22,144 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ServiceComponent does not exist
      18:43:22,145 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Subscription does not exist
      18:43:22,146 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table SystemEvent does not exist
      18:43:22,147 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Team does not exist
      18:43:22,148 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Ticket does not exist
      18:43:22,149 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table User_ does not exist
      18:43:22,150 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserGroup does not exist
      18:43:22,150 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserGroupGroupRole does not exist
      18:43:22,151 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserGroupRole does not exist
      18:43:22,152 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserIdMapper does not exist
      18:43:22,153 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserNotificationDelivery does not exist
      18:43:22,154 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserNotificationEvent does not exist
      18:43:22,155 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserTracker does not exist
      18:43:22,156 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table UserTrackerPath does not exist
      18:43:22,157 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table VirtualHost does not exist
      18:43:22,158 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table WebDAVProps does not exist
      18:43:22,159 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Website does not exist
      18:43:22,160 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table WorkflowDefinitionLink does not exist
      18:43:22,161 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table WorkflowInstanceLink does not exist
      18:43:22,163 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table ExportImportConfiguration does not exist
      18:43:22,164 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table BackgroundTask does not exist
      18:43:22,165 ERROR [localhost-startStop-1][UpgradeMVCCVersion:54] Table Lock_ does not exist
      

      And finally it is not able to upgrade since you will get this error endless:

      18:48:10,665 INFO  [localhost-startStop-1][UpgradeProcess:50] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeLookAndFeel
      18:48:10,878 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,918 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,923 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,932 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,946 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,957 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,967 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,973 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,978 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,982 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,988 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,991 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,995 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      18:48:10,999 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "PORTLETIMP0_"."MVCCVERSION": invalid identifier_ [Sanitized]
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 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