Liferay upgrade from 6.0.6 to 6.1

[Vasu Kumar Piduru, modificado hace 10 años.]

Hi All, liferay basic db upgreade is failing.

The process went for few seconds and failed with the below message.

[java] 14:45:19,315 INFO [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
[java] com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed

Full log is here.

upgrade:
     [java] Loading jar:file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/system.properties
     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
     [java] INFO: No server detected
     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
     [java] INFO: Global shared lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/
     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
     [java] INFO: Global lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/
     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
     [java] INFO: Portal lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/util-java.jar!/
     [java] Loading jar:file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/portal.properties
     [java] Loading file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/portal-ext.properties
     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
     [java] INFO: Properties for portal loaded from [file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/portal-ext.properties, jar:file:/C:/Users/D492640/Desktop/liferay-portal-db-u
pgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/portal.properties]
     [java] 14:44:35,426 INFO  [main][DialectDetector:71] Determine dialect for Oracle 11
     [java] 14:44:35,483 INFO  [main][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
     [java] 14:44:53,413 INFO  [main][BaseDB:452] Database supports case sensitive queries
     [java] 14:44:53,715 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
     [java] 14:44:53,716 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
     [java] 14:44:56,778 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
     [java] 14:44:56,816 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
     [java] 14:44:56,895 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
     [java] 14:44:57,001 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
     [java] 14:45:06,918 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
     [java] 14:45:07,079 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
     [java] 14:45:07,451 INFO  [main][Table:174] Starting backup of DLFileVersion to C:\Users\D492640\AppData\Local\Temp\/temp-db-DLFileVersion-1390315507451
     [java] 14:45:07,469 INFO  [main][Table:208] Finished backup of DLFileVersion to C:\Users\D492640\AppData\Local\Temp\/temp-db-DLFileVersion-1390315507451 in 18 ms
     [java] 14:45:07,624 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
     [java] 14:45:07,636 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
     [java] 14:45:07,656 INFO  [main][Table:174] Starting backup of Group_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Group_-1390315507656
     [java] 14:45:07,696 INFO  [main][Table:208] Finished backup of Group_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Group_-1390315507656 in 40 ms
     [java] 14:45:07,905 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
     [java] 14:45:08,043 WARN  [main][UpgradeImageGallery:378] Ignoring exception for image 16408
     [java] com.liferay.portlet.documentlibrary.NoSuchFileException: C:\Users\D492640\Desktop\liferay-portal-db-upgrade-6.1.1-ce-ga2\liferay\data\images\16\40\16408.png
     [java]     at com.liferay.portal.image.FileSystemHook.getImageAsStream(FileSystemHook.java:74)
     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateFile(UpgradeImageGallery.java:355)
     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImage(UpgradeImageGallery.java:374)
     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImageFiles(UpgradeImageGallery.java:531)
     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:316)
     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
     [java]     at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:67)
     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
     [java]     at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:130)
     [java]     at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
     [java]     at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:129)
     [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:61)
     [java] 14:45:08,258 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal
     [java] 14:45:08,318 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
     [java] 14:45:13,987 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock
     [java] 14:45:14,006 INFO  [main][Table:174] Starting backup of Lock_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Lock_-1390315514006
     [java] 14:45:14,011 INFO  [main][Table:208] Finished backup of Lock_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Lock_-1390315514006 in 5 ms
     [java] 14:45:14,077 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
     [java] 14:45:15,686 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation
     [java] 14:45:15,694 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission
     [java] 14:45:16,507 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences
     [java] 14:45:18,146 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties
     [java] 14:45:18,337 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission
     [java] 14:45:18,342 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes
     [java] 14:45:18,423 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial
     [java] 14:45:18,605 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription
     [java] 14:45:18,614 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost
     [java] 14:45:18,640 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow
     [java] 14:45:18,653 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset
     [java] 14:45:18,675 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1
     [java] 14:45:18,676 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeSchema
     [java] 14:45:18,789 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeDocumentLibrary
     [java] 14:45:18,813 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayout
     [java] 14:45:18,816 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet
     [java] 14:45:18,825 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSetBranch
     [java] 14:45:19,257 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
     [java] 14:45:19,258 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
     [java] 14:45:19,314 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
     [java] 14:45:19,314 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
     [java] 14:45:19,315 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
     [java] com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
     [java]
     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
     [java]     at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
     [java]     at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
     [java]     at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
     [java]     at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
     [java]     at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
     [java]     at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
     [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:62)
     [java] Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
     [java]
     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
     [java]     at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
     [java]     ... 7 more
     [java] Caused by: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
     [java]
     [java]     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
     [java]     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
     [java]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
     [java]     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
     [java]     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
     [java]     at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
     [java]     at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
     [java]     at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:274)
     [java]     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
     [java]     at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
     [java]     at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
     [java]     at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
     [java]     ... 10 more
     [java] Java Result: 1

BUILD SUCCESSFUL
Total time: 58 seconds

Any help on this?
Which table creation is failing?

Thanks in advance.

[David H Nebinger, modificado hace 10 años.]

make sure you're going to 6.1 ga3, do not try to go to one of the earlier releases.

[Vasu Kumar Piduru, modificado hace 10 años.]

Thanks for your reply,


This issue is coming only in the case the schema has any tables other than liferay tables. I had like 10 to 12 tables which are not part of liferay schema. After dropping the tables which are not part of liferay schema solved the problem.

But the way the error is being thrown is wrong, it should some how list down the table which is not part of the liferay schema or simply say encountered some non liferay tables.


Thanks
Vasu