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

Upgrade from 6.1 to 7.0 throws UpgradeException on DB2

    Details

      Description

      Steps to reproduce:

      1. Configure 6.1.x bundle to connect to a DB2 database.
      2. Start Liferay 6.1.x bundle.
      3. Deploy the Kaleo-Web and Kaleo-Upgrade-Hook apps.
      4. Wait until the apps have been fully deployed and shut down Liferay.
      5. Upgrade to Master.

      Expected result:
      Upgrade successfully.

      Actual result:
      Console throws the following exceptions and fails to start:

      09:39:26,498 INFO  [localhost-startStop-1][node:118] [Sir Steel] version[1.3.4], pid[7504], build[a70f3cc/2014-09-30T09:07:17Z]
      09:39:26,502 INFO  [localhost-startStop-1][node:118] [Sir Steel] initializing ...
      09:39:26,506 INFO  [localhost-startStop-1][plugins:118] [Sir Steel] loaded [], sites []
      09:39:28,092 INFO  [localhost-startStop-1][node:118] [Sir Steel] initialized
      09:39:28,093 INFO  [localhost-startStop-1][node:118] [Sir Steel] starting ...
      09:39:28,101 INFO  [localhost-startStop-1][transport:118] [Sir Steel] bound_address {local[1]}, publish_address {local[1]}
      09:39:28,107 INFO  [localhost-startStop-1][discovery:118] [Sir Steel] LiferayElasticSearch/-HHbhjGzQP6lJkll_rwTsA
      09:39:28,109 INFO  [elasticsearch[Sir Steel][clusterService#updateTask][T#1]][service:118] [Sir Steel] new_master [Sir Steel][-HHbhjGzQP6lJkll_rwTsA][L3-JOYCEWANG][local[1]]{local=true}, reason: local-disco-initial_connect(master)
      09:39:28,145 INFO  [elasticsearch[Sir Steel][clusterService#updateTask][T#1]][gateway:118] [Sir Steel] recovered [0] indices into cluster_state
      09:39:29,197 INFO  [localhost-startStop-1][http:118] [Sir Steel] bound_address {inet[/0.0.0.0:9200]}, publish_address {inet[/192.168.131.179:9200]}
      09:39:29,198 INFO  [localhost-startStop-1][node:118] [Sir Steel] started
      09:39:29,418 INFO  [localhost-startStop-1][ChainActivator:211] Blueprint API detected; enabling Blueprint Container functionality
      09:39:29,453 INFO  [localhost-startStop-1][LoggingActivator:211] Starting [org.eclipse.gemini.blueprint.extender] bundle v.[2.0.0.M02]
      09:39:29,519 WARN  [localhost-startStop-1][NamespacePlugins:221] Bundle Liferay Portal Spring Extender (com.liferay.portal.spring.extender) cannot see class [org.springframework.beans.factory.xml.NamespaceHandlerResolver]; ignoring it as a namespace resolver
      09:39:29,527 WARN  [localhost-startStop-1][NamespacePlugins:221] Bundle Liferay Portal Spring Extender (com.liferay.portal.spring.extender) cannot see class [org.springframework.beans.factory.xml.NamespaceHandlerResolver]; ignoring it as a namespace resolver
      09:39:29,531 INFO  [localhost-startStop-1][ExtenderConfiguration:211] Detected extender custom configurations at {bundleentry://55.fwk1390350054/META-INF/spring/extender/config.xml}
      09:39:29,556 INFO  [localhost-startStop-1][OsgiBundleXmlApplicationContext:211] Refreshing OsgiBundleXmlApplicationContext(bundle=org.eclipse.gemini.blueprint.extender, config=bundleentry://55.fwk1390350054/META-INF/spring/extender/config.xml): startup date [Fri Jan 16 09:39:29 GMT 2015]; root of context hierarchy
      09:39:29,589 INFO  [localhost-startStop-1][OsgiBundleXmlApplicationContext:211] Application Context service already unpublished
      09:39:29,782 INFO  [localhost-startStop-1][OsgiBundleXmlApplicationContext:211] Publishing application context as OSGi service with properties {org.eclipse.gemini.blueprint.context.service.name=org.eclipse.gemini.blueprint.extender, org.springframework.context.service.name=org.eclipse.gemini.blueprint.extender, Bundle-SymbolicName=org.eclipse.gemini.blueprint.extender, Bundle-Version=2.0.0.M02}
      09:39:29,789 INFO  [localhost-startStop-1][ExtenderConfiguration$1:211] Initializing Timer
      09:39:30,209 INFO  [EclipseGeminiBlueprintExtenderThread-1][DependencyServiceManager:211] Adding OSGi service dependency for importer [&liferayDataSource] matching OSGi filter [(&(objectClass=javax.sql.DataSource)(&(bean.id=liferayDataSourceWrapper)(original.bean=true)))]
      09:39:30,211 INFO  [EclipseGeminiBlueprintExtenderThread-1][DependencyServiceManager:211] Adding OSGi service dependency for importer [&com.liferay.portal.kernel.util.InfrastructureUtil] matching OSGi filter [(&(objectClass=com.liferay.portal.kernel.util.InfrastructureUtil)(original.bean=true))]
      09:39:30,211 INFO  [EclipseGeminiBlueprintExtenderThread-1][DependencyServiceManager:211] Adding OSGi service dependency for importer [&javax.servlet.ServletContext] matching OSGi filter [(&(objectClass=javax.servlet.ServletContext)(original.bean=true))]
      09:39:30,212 INFO  [EclipseGeminiBlueprintExtenderThread-1][DependencyServiceManager:211] ServiceBuilderApplicationContext(bundle=com.liferay.bookmarks.service, config=META-INF/spring/parent/*.xml,META-INF/*-spring.xml) is waiting for unsatisfied dependencies [[&javax.servlet.ServletContext, &liferayDataSource, &com.liferay.portal.kernel.util.InfrastructureUtil]]
      09:39:30,334 INFO  [EclipseGeminiBlueprintExtenderThread-2][DependencyServiceManager:211] Adding OSGi service dependency for importer [&liferayDataSource] matching OSGi filter [(&(objectClass=javax.sql.DataSource)(&(bean.id=liferayDataSourceWrapper)(original.bean=true)))]
      09:39:30,336 INFO  [EclipseGeminiBlueprintExtenderThread-2][DependencyServiceManager:211] Adding OSGi service dependency for importer [&com.liferay.portal.kernel.util.InfrastructureUtil] matching OSGi filter [(&(objectClass=com.liferay.portal.kernel.util.InfrastructureUtil)(original.bean=true))]
      09:39:30,336 INFO  [EclipseGeminiBlueprintExtenderThread-2][DependencyServiceManager:211] Adding OSGi service dependency for importer [&javax.servlet.ServletContext] matching OSGi filter [(&(objectClass=javax.servlet.ServletContext)(original.bean=true))]
      09:39:30,337 INFO  [EclipseGeminiBlueprintExtenderThread-2][DependencyServiceManager:211] ServiceBuilderApplicationContext(bundle=com.liferay.polls.service, config=META-INF/spring/parent/*.xml,META-INF/*-spring.xml) is waiting for unsatisfied dependencies [[&javax.servlet.ServletContext, &liferayDataSource, &com.liferay.portal.kernel.util.InfrastructureUtil]]
      09:39:34,175 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for DB2/NT 10
      09:39:34,193 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect com.liferay.portal.dao.orm.hibernate.DB2Dialect
      09:39:45,616 WARN  [localhost-startStop-1][ResourceActionsImpl:618] Cannot load META-INF/resource-actions/default.xml
      09:39:45,695 WARN  [localhost-startStop-1][ResourceActionsImpl:618] Cannot load resource-actions/test.xml
      09:39:52,494 INFO  [localhost-startStop-1][BaseDB:480] Database supports case sensitive queries
      09:39:52,512 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_2_0
      09:39:52,514 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSchema
      09:39:56,332 WARN  [localhost-startStop-1][BaseDB:458] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.IX_CED31606, DRIVER=3.63.123: drop index IX_CED31606;_ [Sanitized]
      09:39:58,893 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.UpgradeMVCC
      09:39:59,518 ERROR [localhost-startStop-1][UpgradeMVCC:107] Table EXPORTIMPORTCONFIGURATION does not exist
      09:40:02,833 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.UpgradeMVCC in 3940ms
      09:40:02,834 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeSchema in 10320ms
      09:40:02,835 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAnnouncements
      09:40:02,846 INFO  [localhost-startStop-1][Table:157] Starting backup of AnnouncementsEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-AnnouncementsEntry-1421401202846
      09:40:02,856 INFO  [localhost-startStop-1][Table:191] Finished backup of AnnouncementsEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-AnnouncementsEntry-1421401202846 in 10 ms
      09:40:03,028 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeAnnouncements in 193ms
      09:40:03,031 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAssetPublisher
      09:40:03,182 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeAssetPublisher in 151ms
      09:40:03,183 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs
      09:40:03,191 INFO  [localhost-startStop-1][Table:157] Starting backup of BlogsEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-BlogsEntry-1421401203190
      09:40:03,196 INFO  [localhost-startStop-1][Table:191] Finished backup of BlogsEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-BlogsEntry-1421401203190 in 4 ms
      09:40:03,538 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs in 355ms
      09:40:03,540 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogsAggregator
      09:40:03,543 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeBlogsAggregator in 3ms
      09:40:03,546 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCalendar
      09:40:03,646 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeCalendar in 100ms
      09:40:03,647 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCompany
      09:40:03,717 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeCompany in 70ms
      09:40:03,719 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCustomizablePortlets
      09:40:03,723 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeCustomizablePortlets in 4ms
      09:40:03,725 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary
      09:40:03,750 INFO  [localhost-startStop-1][Table:157] Starting backup of DLFileEntryType to E:\bundle\master\tomcat-7.0.42\temp/temp-db-DLFileEntryType-1421401203750
      09:40:03,760 INFO  [localhost-startStop-1][Table:191] Finished backup of DLFileEntryType to E:\bundle\master\tomcat-7.0.42\temp/temp-db-DLFileEntryType-1421401203750 in 10 ms
      09:40:04,005 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary in 280ms
      09:40:04,007 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataListDisplay
      09:40:04,011 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataListDisplay in 4ms
      09:40:04,013 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataMapping
      09:40:04,391 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeDynamicDataMapping in 378ms
      09:40:04,392 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeGroup
      09:40:04,397 INFO  [localhost-startStop-1][Table:157] Starting backup of Group_ to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Group_-1421401204397
      09:40:04,422 INFO  [localhost-startStop-1][Table:191] Finished backup of Group_ to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Group_-1421401204397 in 25 ms
      09:40:04,801 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeGroup in 409ms
      09:40:04,803 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeImageGallery
      09:40:04,911 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeImageGallery in 108ms
      09:40:04,914 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeJournal
      09:40:05,630 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeJournal in 716ms
      09:40:05,632 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayout
      09:40:05,637 INFO  [localhost-startStop-1][Table:157] Starting backup of Layout to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Layout-1421401205637
      09:40:05,724 INFO  [localhost-startStop-1][Table:191] Finished backup of Layout to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Layout-1421401205637 in 87 ms
      09:40:06,143 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeLayout in 511ms
      09:40:06,144 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutFriendlyURL
      09:40:06,406 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutFriendlyURL in 262ms
      09:40:06,409 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutRevision
      09:40:06,414 INFO  [localhost-startStop-1][Table:157] Starting backup of LayoutRevision to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutRevision-1421401206414
      09:40:06,423 INFO  [localhost-startStop-1][Table:191] Finished backup of LayoutRevision to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutRevision-1421401206414 in 9 ms
      09:40:06,745 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutRevision in 336ms
      09:40:06,747 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSet
      09:40:06,751 INFO  [localhost-startStop-1][Table:157] Starting backup of LayoutSet to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutSet-1421401206751
      09:40:07,281 INFO  [localhost-startStop-1][Table:191] Finished backup of LayoutSet to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutSet-1421401206751 in 530 ms
      09:40:07,471 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSet in 724ms
      09:40:07,472 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSetBranch
      09:40:07,477 INFO  [localhost-startStop-1][Table:157] Starting backup of LayoutSetBranch to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutSetBranch-1421401207477
      09:40:07,481 INFO  [localhost-startStop-1][Table:191] Finished backup of LayoutSetBranch to E:\bundle\master\tomcat-7.0.42\temp/temp-db-LayoutSetBranch-1421401207477 in 4 ms
      09:40:07,693 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeLayoutSetBranch in 221ms
      09:40:07,695 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoards
      09:40:07,703 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoards in 8ms
      09:40:07,706 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoardsAttachments
      09:40:07,712 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoardsAttachments in 6ms
      09:40:07,713 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradePortletItem
      09:40:07,718 INFO  [localhost-startStop-1][Table:157] Starting backup of PortletItem to E:\bundle\master\tomcat-7.0.42\temp/temp-db-PortletItem-1421401207718
      09:40:07,723 INFO  [localhost-startStop-1][Table:191] Finished backup of PortletItem to E:\bundle\master\tomcat-7.0.42\temp/temp-db-PortletItem-1421401207718 in 5 ms
      09:40:07,912 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradePortletItem in 199ms
      09:40:07,914 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradePortletPreferences
      09:40:07,939 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradePortletPreferences in 25ms
      09:40:07,941 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeRepository
      09:40:07,945 INFO  [localhost-startStop-1][Table:157] Starting backup of Repository to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Repository-1421401207945
      09:40:07,950 INFO  [localhost-startStop-1][Table:191] Finished backup of Repository to E:\bundle\master\tomcat-7.0.42\temp/temp-db-Repository-1421401207945 in 5 ms
      09:40:08,191 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeRepository in 250ms
      09:40:08,193 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSearch
      09:40:08,206 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeSearch in 13ms
      09:40:08,210 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSocial
      09:40:08,837 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeSocial in 627ms
      09:40:08,839 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeUser
      09:40:08,848 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeUser in 9ms
      09:40:08,850 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeWiki
      09:40:08,853 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeWiki in 3ms
      09:40:08,854 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeWikiAttachments
      09:40:08,858 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeWikiAttachments in 4ms
      09:40:08,859 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_6_2_0 in 16347ms
      09:40:08,860 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.UpgradeProcess_7_0_0
      09:40:08,861 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeSchema
      09:40:10,196 WARN  [localhost-startStop-1][BaseDB:458] DB2 SQL Error: SQLCODE=-205, SQLSTATE=42703, SQLERRMC=LO;DB2ADMIN.LAYOUTSET, DRIVER=3.63.123: alter table LayoutSet drop column logo;_ [Sanitized]
      09:40:10,200 WARN  [localhost-startStop-1][BaseDB:458] DB2 SQL Error: SQLCODE=-205, SQLSTATE=42703, SQLERRMC=LO;DB2ADMIN.LAYOUTSETBRANCH, DRIVER=3.63.123: alter table LayoutSetBranch drop column logo;_ [Sanitized]
      09:40:10,300 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.UpgradeMVCC
      09:40:12,844 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.UpgradeMVCC in 2544ms
      09:40:12,845 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeSchema in 3984ms
      09:40:12,847 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeAdminPortlets
      09:40:12,874 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeAdminPortlets in 27ms
      09:40:12,876 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeAsset
      09:40:12,883 INFO  [localhost-startStop-1][Table:157] Starting backup of AssetEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-AssetEntry-1421401212883
      09:40:13,959 INFO  [localhost-startStop-1][Table:191] Finished backup of AssetEntry to E:\bundle\master\tomcat-7.0.42\temp/temp-db-AssetEntry-1421401212883 in 1076 ms
      09:40:14,314 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeAsset in 1438ms
      09:40:14,316 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeBackgroundTask
      09:40:14,319 INFO  [localhost-startStop-1][Table:157] Starting backup of BackgroundTask to E:\bundle\master\tomcat-7.0.42\temp/temp-db-BackgroundTask-1421401214319
      09:40:14,326 INFO  [localhost-startStop-1][Table:191] Finished backup of BackgroundTask to E:\bundle\master\tomcat-7.0.42\temp/temp-db-BackgroundTask-1421401214319 in 7 ms
      09:40:14,566 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeBackgroundTask in 250ms
      09:40:14,570 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeCalEvent
      09:40:14,579 INFO  [localhost-startStop-1][Table:157] Starting backup of CalEvent to E:\bundle\master\tomcat-7.0.42\temp/temp-db-CalEvent-1421401214579
      09:40:14,600 INFO  [localhost-startStop-1][Table:191] Finished backup of CalEvent to E:\bundle\master\tomcat-7.0.42\temp/temp-db-CalEvent-1421401214579 in 21 ms
      09:40:15,757 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeCalEvent in 1187ms
      09:40:15,760 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDLPreferences
      09:40:15,791 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDLPreferences in 31ms
      09:40:15,796 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary
      09:40:16,399 INFO  [localhost-startStop-1][Table:157] Starting backup of DLFolder to E:\bundle\master\tomcat-7.0.42\temp/temp-db-DLFolder-1421401216399
      09:40:16,404 INFO  [localhost-startStop-1][Table:191] Finished backup of DLFolder to E:\bundle\master\tomcat-7.0.42\temp/temp-db-DLFolder-1421401216399 in 5 ms
      09:40:16,590 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 794ms
      09:40:16,593 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDynamicDataLists
      09:40:16,609 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDynamicDataLists in 16ms
      09:40:16,611 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDynamicDataMapping
      09:40:17,920 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDynamicDataMapping in 1309ms
      09:40:17,926 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeEmailNotificationPreferences
      09:40:17,968 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeEmailNotificationPreferences in 42ms
      09:40:17,970 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeExpando
      09:40:17,973 INFO  [localhost-startStop-1][Table:157] Starting backup of ExpandoValue to E:\bundle\master\tomcat-7.0.42\temp/temp-db-ExpandoValue-1421401217973
      09:40:17,981 INFO  [localhost-startStop-1][Table:191] Finished backup of ExpandoValue to E:\bundle\master\tomcat-7.0.42\temp/temp-db-ExpandoValue-1421401217973 in 8 ms
      09:40:18,201 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeExpando in 231ms
      09:40:18,202 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeLanguagePreferences
      09:40:18,211 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeLanguagePreferences in 9ms
      09:40:18,214 INFO  [localhost-startStop-1][UpgradeProcess:163] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeJournal
      09:40:18,617 INFO  [localhost-startStop-1][Table:157] Starting backup of JournalArticle to E:\bundle\master\tomcat-7.0.42\temp/temp-db-JournalArticle-1421401218617
      09:40:18,633 INFO  [localhost-startStop-1][Table:191] Finished backup of JournalArticle to E:\bundle\master\tomcat-7.0.42\temp/temp-db-JournalArticle-1421401218617 in 16 ms
      09:40:19,774 ERROR [localhost-startStop-1][UpgradeJournal:196] Unable to create the basic web content structure
      09:40:19,776 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeJournal in 1562ms
      09:40:19,777 INFO  [localhost-startStop-1][UpgradeProcess:173] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 10917ms
      09:40:19,782 ERROR [localhost-startStop-1][MainServlet:204] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:78)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1230)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:201)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:724)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:179)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:151)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:133)
      	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:156)
      	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:73)
      	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:138)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:155)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:72)
      	... 20 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:191)
      	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:68)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
      	... 28 more
      Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      	at com.ibm.db2.jcc.am.fd.a(fd.java:671)
      	at com.ibm.db2.jcc.am.fd.a(fd.java:60)
      	at com.ibm.db2.jcc.am.fd.a(fd.java:127)
      	at com.ibm.db2.jcc.am.ho.b(ho.java:2317)
      	at com.ibm.db2.jcc.am.ho.c(ho.java:2300)
      	at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
      	at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
      	at com.ibm.db2.jcc.t4.q.a(q.java:50)
      	at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
      	at com.ibm.db2.jcc.am.io.lc(io.java:3318)
      	at com.ibm.db2.jcc.am.io.b(io.java:4275)
      	at com.ibm.db2.jcc.am.io.b(io.java:4429)
      	at com.ibm.db2.jcc.am.io.dc(io.java:759)
      	at com.ibm.db2.jcc.am.io.executeUpdate(io.java:742)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeJournal.addDDMStructure(UpgradeJournal.java:171)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeJournal.addBasicWebContentStructureAndTemplate(UpgradeJournal.java:93)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeJournal.updateJournalArticles(UpgradeJournal.java:521)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeJournal.updateBasicWebContentStructure(UpgradeJournal.java:473)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:376)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
      	... 31 more
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 28 weeks, 1 day ago

                  Packages

                  Version Package
                  7.0.0 CE GA1