Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Vasu K
Liferay upgrade from 6.0.6 to 6.1
21 de enero de 2014 8:41
Respuesta

Vasu K

Ranking: Junior Member

Mensajes: 34

Fecha de incorporación: 5 de octubre de 2009

Mensajes recientes

Hi All, liferay basic db upgreade is failing.

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

14:45:19,315 INFO [VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
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.

  1upgrade:
  2     [java] Loading jar:file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/system.properties
  3     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
  4     [java] INFO: No server detected
  5     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
  6     [java] INFO: Global shared lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/
  7     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
  8     [java] INFO: Global lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/
  9     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
 10     [java] INFO: Portal lib directory /C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/util-java.jar!/
 11     [java] Loading jar:file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/portal.properties
 12     [java] Loading file:/C:/Users/D492640/Desktop/liferay-portal-db-upgrade-6.1.1-ce-ga2/portal-ext.properties
 13     [java] Jan 21, 2014 2:44:28 PM com.liferay.portal.kernel.log.Jdk14LogImpl info
 14     [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
 15pgrade-6.1.1-ce-ga2/lib/portal-impl.jar!/portal.properties]
 16     [java] 14:44:35,426 INFO  [main][DialectDetector:71] Determine dialect for Oracle 11
 17     [java] 14:44:35,483 INFO  [main][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
 18     [java] 14:44:53,413 INFO  [main][BaseDB:452] Database supports case sensitive queries
 19     [java] 14:44:53,715 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
 20     [java] 14:44:53,716 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
 21     [java] 14:44:56,778 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
 22     [java] 14:44:56,816 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
 23     [java] 14:44:56,895 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
 24     [java] 14:44:57,001 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
 25     [java] 14:45:06,918 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
 26     [java] 14:45:07,079 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
 27     [java] 14:45:07,451 INFO  [main][Table:174] Starting backup of DLFileVersion to C:\Users\D492640\AppData\Local\Temp\/temp-db-DLFileVersion-1390315507451
 28     [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
 29     [java] 14:45:07,624 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
 30     [java] 14:45:07,636 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
 31     [java] 14:45:07,656 INFO  [main][Table:174] Starting backup of Group_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Group_-1390315507656
 32     [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
 33     [java] 14:45:07,905 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
 34     [java] 14:45:08,043 WARN  [main][UpgradeImageGallery:378] Ignoring exception for image 16408
 35     [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
 36     [java]     at com.liferay.portal.image.FileSystemHook.getImageAsStream(FileSystemHook.java:74)
 37     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateFile(UpgradeImageGallery.java:355)
 38     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImage(UpgradeImageGallery.java:374)
 39     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.migrateImageFiles(UpgradeImageGallery.java:531)
 40     [java]     at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:316)
 41     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
 42     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
 43     [java]     at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:67)
 44     [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
 45     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
 46     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
 47     [java]     at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
 48     [java]     at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:130)
 49     [java]     at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
 50     [java]     at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:129)
 51     [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:61)
 52     [java] 14:45:08,258 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal
 53     [java] 14:45:08,318 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
 54     [java] 14:45:13,987 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock
 55     [java] 14:45:14,006 INFO  [main][Table:174] Starting backup of Lock_ to C:\Users\D492640\AppData\Local\Temp\/temp-db-Lock_-1390315514006
 56     [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
 57     [java] 14:45:14,077 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
 58     [java] 14:45:15,686 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation
 59     [java] 14:45:15,694 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission
 60     [java] 14:45:16,507 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences
 61     [java] 14:45:18,146 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties
 62     [java] 14:45:18,337 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission
 63     [java] 14:45:18,342 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes
 64     [java] 14:45:18,423 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial
 65     [java] 14:45:18,605 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription
 66     [java] 14:45:18,614 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost
 67     [java] 14:45:18,640 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow
 68     [java] 14:45:18,653 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset
 69     [java] 14:45:18,675 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1
 70     [java] 14:45:18,676 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeSchema
 71     [java] 14:45:18,789 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeDocumentLibrary
 72     [java] 14:45:18,813 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayout
 73     [java] 14:45:18,816 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet
 74     [java] 14:45:18,825 INFO  [main][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSetBranch
 75     [java] 14:45:19,257 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
 76     [java] 14:45:19,258 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
 77     [java] 14:45:19,314 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
 78     [java] 14:45:19,314 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
 79     [java] 14:45:19,315 INFO  [main][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
 80     [java] com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
 81     [java]
 82     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
 83     [java]     at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
 84     [java]     at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
 85     [java]     at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
 86     [java]     at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
 87     [java]     at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
 88     [java]     at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
 89     [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:62)
 90     [java] Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
 91     [java]
 92     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
 93     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
 94     [java]     at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
 95     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
 96     [java]     ... 7 more
 97     [java] Caused by: java.sql.SQLException: ORA-01723: zero-length columns are not allowed
 98     [java]
 99     [java]     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
100     [java]     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
101     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
102     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
103     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
104     [java]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
105     [java]     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
106     [java]     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
107     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
108     [java]     at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
109     [java]     at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
110     [java]     at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:274)
111     [java]     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
112     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
113     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
114     [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
115     [java]     at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
116     [java]     at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
117     [java]     at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
118     [java]     at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
119     [java]     ... 10 more
120     [java] Java Result: 1
121
122BUILD SUCCESSFUL
123Total time: 58 seconds


Any help on this?
Which table creation is failing?

Thanks in advance.
David H Nebinger
RE: Liferay upgrade from 6.0.6 to 6.1
21 de enero de 2014 12:49
Respuesta

David H Nebinger

Community Moderator

Ranking: Liferay Legend

Mensajes: 11511

Fecha de incorporación: 1 de septiembre de 2006

Mensajes recientes

make sure you're going to 6.1 ga3, do not try to go to one of the earlier releases.
Vasu K
RE: Liferay upgrade from 6.0.6 to 6.1
27 de enero de 2014 11:19
Respuesta

Vasu K

Ranking: Junior Member

Mensajes: 34

Fecha de incorporación: 5 de octubre de 2009

Mensajes recientes

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