6.0.6 portal-ext.properties: jdbc.default.jndi.name= jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.default.url=jdbc:db2://192.168.134.54:50000/paul:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2; jdbc.default.username=db2admin jdbc.default.password=1234 custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL liferay.home=D:/home setup.wizard.enabled=false dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook image.hook.impl=com.liferay.portal.image.FileSystemHook permissions.user.check.algorithm=6 dl.file.extensions=.png upgrade.processes= ------------ TEST STEPS: 1. Startup 6.0.6 with DB2 2. Sign in as sa 1:) Add Document portlet, blogs portlet, web content portlet, message boards portlet, bookmarks portlet, wiki portlet and calendar portlet. (Then add some data in portlet) 2:) Add new site and stagingit . set site private URL. 3. Shut down 4. Startup 6.1.10 EE with fix patch 5. Go to check staging. ------------- 6.1.10 EE portal-ext.properties: jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.default.url=jdbc:db2://192.168.134.54:50000/paul:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2; jdbc.default.username=db2admin jdbc.default.password=1234 custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL liferay.home=D:/home setup.wizard.enabled=false image.hook.impl=com.liferay.portal.image.FileSystemHook dl.store.impl=com.liferay.portlet.documentlibrary.store.FileSystemStore permissions.user.check.algorithm=6 dl.file.extensions=.png upgrade.processes= __________________________________________ CONSOLE AFTER UPGRADE: D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\bin>catalina.bat run Using CATALINA_BASE: "D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25" Using CATALINA_HOME: "D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25" Using CATALINA_TMPDIR: "D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp" Using JRE_HOME: "D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25/jre1.6.0_20/win" Using CLASSPATH: "D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\bin\bootstrap.jar;D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\bin\tomcat-juli.jar" 2012-6-15 7:08:49 org.apache.catalina.core.AprLifecycleListener init 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\jre1.6.0_20\win\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\Xuggle\bin;C:\Program Files (x86)\ImageMagick-6.7.5-Q8;C:\Program Files (x86)\CollabNet\Subversion Client;C:\Java\jdk1.6.0_21\bin;C:\Java\apache-ant-1.7.0\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\DMIX; C:\Program Files\Dell\DW WLAN Card;C:\Program Files (x86)\Bitvise Tunnelier;C:\Program Files\MySQL\MySQL Server 5.5\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Pandoc\bin;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Users\liferay\AppData\Local\Temp 2012-6-15 7:08:49 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["http-bio-8080"] 2012-6-15 7:08:49 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["ajp-bio-8009"] 2012-6-15 7:08:49 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 415 ms 2012-6-15 7:08:49 org.apache.catalina.core.StandardService startInternal 信息: Starting service Catalina 2012-6-15 7:08:49 org.apache.catalina.core.StandardEngine startInternal 信息: Starting Servlet Engine: Apache Tomcat/7.0.25 2012-6-15 7:08:49 org.apache.catalina.startup.HostConfig deployDescriptor 信息: Deploying configuration descriptor D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\conf\Catalina\localhost\ROOT.xml Loading jar:file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties 07:08:51,167 INFO [EasyConf:122] Refreshed the configuration of all components 07:08:51,408 INFO [ConfigurationLoader:56] Properties for jar:file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal loaded from [file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/classes/portal-ext.properties, jar:file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties] Loading jar:file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties Loading file:/D:/0614task/bundle/liferay-portal-6.1.10-ee-ga1/tomcat-7.0.25/webapps/ROOT/WEB-INF/classes/portal-ext.properties 07:08:56,771 INFO [DBFactoryImpl:56] Using dialect com.liferay.portal.dao.orm.hibernate.DB2Dialect Starting Liferay Portal Enterprise Edition 6.1 EE GA1 (Paton / Build 6110 / February 15, 2012) 07:09:16,918 INFO [BaseDB:406] Database supports case sensitive queries 07:09:17,100 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0 07:09:17,102 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema 07:09:37,828 WARN [BaseDB:382] DB2 SQL error: SQLCODE: -478, SQLSTATE: 42893, SQLERRMC: COLUMN;IX_5204C37B;INDEX: alter table User_ drop column active_; 07:09:41,798 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName 07:09:41,847 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets 07:09:41,933 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs 07:09:41,948 INFO [Table:174] Starting backup of BlogsEntry to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-BlogsEntry-1339744181948 07:09:41,961 INFO [Table:210] Finished backup of BlogsEntry to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-BlogsEntry-1339744181948 in 13 ms 07:09:42,759 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences 07:09:43,075 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry 07:09:43,231 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary 07:09:43,637 INFO [Table:174] Starting backup of DLFileVersion to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-DLFileVersion-1339744183637 07:09:43,654 INFO [Table:210] Finished backup of DLFileVersion to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-DLFileVersion-1339744183637 in 17 ms 07:09:45,272 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando 07:09:45,293 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup 07:09:45,300 INFO [Table:174] Starting backup of Group_ to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-Group_-1339744185300 07:09:45,305 INFO [Table:210] Finished backup of Group_ to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-Group_-1339744185300 in 5 ms 07:09:45,559 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery 07:09:45,699 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal 07:09:45,708 INFO [Table:174] Starting backup of JournalArticle to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalArticle-1339744185708 07:09:45,718 INFO [Table:210] Finished backup of JournalArticle to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalArticle-1339744185708 in 10 ms 07:09:46,712 INFO [Table:174] Starting backup of JournalStructure to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalStructure-1339744186712 07:09:46,728 INFO [Table:210] Finished backup of JournalStructure to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalStructure-1339744186712 in 16 ms 07:09:46,957 INFO [Table:174] Starting backup of JournalTemplate to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalTemplate-1339744186957 07:09:46,972 INFO [Table:210] Finished backup of JournalTemplate to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-JournalTemplate-1339744186957 in 15 ms 07:09:47,225 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout 07:09:47,259 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock 07:09:47,266 INFO [Table:174] Starting backup of Lock_ to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-Lock_-1339744187266 07:09:47,271 INFO [Table:210] Finished backup of Lock_ to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-Lock_-1339744187266 in 5 ms 07:09:47,410 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards 07:09:47,525 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation 07:09:47,532 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission 07:09:48,084 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences 07:09:48,216 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties 07:09:48,268 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission 07:09:48,275 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes 07:09:48,300 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial 07:09:48,713 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription 07:09:48,731 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost 07:09:48,977 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow 07:09:48,989 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset 07:09:48,998 INFO [Table:174] Starting backup of AssetEntry to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-AssetEntry-1339744188998 07:09:49,019 INFO [Table:210] Finished backup of AssetEntry to D:\0614task\bundle\liferay-portal-6.1.10-ee-ga1\tomcat-7.0.25\temp/temp-db-AssetEntry-1339744188998 in 21 ms 07:09:49,711 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1 07:09:49,713 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgr