Migration issue ?

[RAVI RAJAMANI, modificado hace 7 años.]

Hi

I have migrating from liferay 6.1 to liferay 6.2
while migrating following errors are throughout how to resolve this errors
com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fileEntryTypeKey' at row 1

Any solution.

Regards,
Ravi R

11:16:50,061 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAnnouncements
11:16:50,228 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeAssetPublisher
11:16:53,078 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogs
11:16:53,138 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeBlogsAggregator
11:16:53,145 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCalendar
11:16:55,207 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCompany
11:16:56,359 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeCustomizablePortlets
11:16:56,465 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary
11:16:56,478 INFO  [localhost-startStop-1][Table:153] Starting backup of DLFileEntryType to E:\trialMigrations\liferay-portal-6.2-ee-sp11\tomcat-7.0.42/temp/temp-db-DLFileEntryType-1469531816478
11:16:56,504 INFO  [localhost-startStop-1][Table:187] Finished backup of DLFileEntryType to E:\trialMigrations\liferay-portal-6.2-ee-sp11\tomcat-7.0.42/temp/temp-db-DLFileEntryType-1469531816478 in 26 ms
11:17:02,623 ERROR [localhost-startStop-1][MainServlet:212] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fileEntryTypeKey' at row 1
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fileEntryTypeKey' at row 1
	at com.liferay.portal.events.StartupAction.run(StartupAction.java:79)
	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1245)
	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:209)
	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(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

[Shyam G, modificado hace 6 años.]

We are also facing the same Issue . Can you help me on this , if you already fixed this issue?

[Alberto Chaparro, modificado hace 6 años.]

Hi Shyam,

The problem is caused because the upgrade is trying to populate DLFileEntryType.fileEntryTypeKey field whose length is VARCHAR(75) with DLFileEntryType.name whose length is LONGTEXT.

You should check which DLFileEntryType records have a name higher than 75 and truncate it from the UI before during the upgrade.

Regards!

[Shyam G, modificado hace 6 años.]

We are trying to upgrade from6.1 CE to DXP using upgrade tool.
Getting the below error.
15:01:12,011 INFO [main][LoggingTimer:38] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#DLFileEntryType in 221 ms
15:01:12,012 INFO [main][LoggingTimer:38] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 947 ms
15:01:12,012 INFO [main][LoggingTimer:70] Starting com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary#updateFileEntryTypes
15:01:12,564 INFO [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary#updateFileEntryTypes in 552 ms
15:01:12,565 INFO [main][UpgradeProcess:99] Completed upgrade process com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary in 1504ms
15:01:12,565 INFO [main][UpgradeProcess:99] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_6_2_0 in 22258ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-12899: value too large for column "LRDB"."DLFILEENTRYTYPE"."FILEENTRYTYPEKEY" (actual: 141, maximum: 75)

at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:93)
at com.liferay.portal.upgrade.Pre7UpgradeProcess.upgrade(Pre7UpgradeProcess.java:42)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:99)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-12899: value too large for column "ELRDB"."DLFILEENTRYTYPE"."FILEENTRYTYPEKEY" (actual: 141, maximum: 75)

We dont have FILEENTRYTYPEKEY values which have more than 75 chars
Can you please help me how we can proceed ?

[Alberto Chaparro, modificado hace 6 años.]

As I said before, you need to check the field DLFileEntryType.name, there shouldn't be names with more than 75 chars before the upgrade

[Shyam G, modificado hace 6 años.]

Thank you for your help. We have updated the table DLFileEntryType.name values which are having more than 75 character. After this chnage, i run the upgrade, the upgrade got struck at the below line.
15:16:10,799 INFO [main][Table:200] Finished backup of DLFileEntryType to C:\Us
ers\XXX\AppData\Local\Temp\temp-db-DLFileEntryType-5729802415608426531.tmp in
71 ms.

Log file :

15:16:10,050 INFO [main][LoggingTimer:70] Starting com.liferay.portal.kernel.up
grade.UpgradeProcess#alter
15:16:10,727 WARN [main][UpgradeProcess:434] Fallback to recreating the table
java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specifie
d or timeout expired_ [Sanitized]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatem
ent.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStateme
ntWrapper.java:280)
at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.ja
va:120)
at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxy
Statement.java)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:292)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:262)
at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.j
ava:66)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess
.java:406)
at com.liferay.portal.upgrade.v6_2_0.UpgradeDocumentLibrary.doUpgrade(Up
gradeDocumentLibrary.java:87)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:90)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:117)
at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProc
ess_6_2_0.java:70)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:90)
at com.liferay.portal.upgrade.Pre7UpgradeProcess.upgrade(Pre7UpgradeProc
ess.java:42)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradePro
cess(UpgradeProcessUtil.java:175)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProc
ess(UpgradeProcessUtil.java:143)
at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProc
ess(UpgradeProcessUtil.java:125)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.
java:164)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHel
perUtil.java:81)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:99)
15:16:10,727 INFO [main][LoggingTimer:70] Starting com.liferay.portal.kernel.up
grade.UpgradeProcess#upgradeTable#DLFileEntryType
15:16:10,728 INFO [main][Table:166] Starting backup of DLFileEntryType to C:\Us
ers\XXX\AppData\Local\Temp\temp-db-DLFileEntryType-5729802415608426531.tmp
15:16:10,799 INFO [main][Table:200] Finished backup of DLFileEntryType to C:\Us
ers\XXX\AppData\Local\Temp\temp-db-DLFileEntryType-5729802415608426531.tmp in
71 ms

[Alberto Chaparro, modificado hace 6 años.]

Hi Shyam,

The process stopped in the middle of the upgrade process executing an ALTER over fileEntryTypeKey table.

Please, check the Oracle documentation about the error, it seems that there were a lock on that table when the alter was executed, maybe because you modified the content of the table prior to the upgrade without unlocking it.

Regards.