Foren

UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Michele Stoduto, geändert vor 12 Jahren.

UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Junior Member Beiträge: 42 Beitrittsdatum: 07.07.10 Neueste Beiträge
Hi all, I.ve a problem with upgrade process.

15:15:05,087 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
15:15:22,719 ERROR [ImageProcessorImpl:181] com.liferay.portlet.documentlibrary.FileExtensionException: document_thumbnail/0/151/11415/11416.
com.liferay.portlet.documentlibrary.FileExtensionException: document_thumbnail/0/151/11415/11416.
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.validate(DLStoreImpl.java:518)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.validate(DLStoreImpl.java:542)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.addFile(DLStoreImpl.java:92)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.addFile(DLStoreImpl.java:171)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.addFile(DLStoreUtil.java:186)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.addFileToStore(DLPreviewableProcessor.java:184)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.storeThumbnailmage(DLPreviewableProcessor.java:501)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.storeThumbnailImages(DLPreviewableProcessor.java:449)
at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl._generateImages(ImageProcessorImpl.java:176)
at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl.generateImages(ImageProcessorImpl.java:66)
at com.liferay.portlet.documentlibrary.util.ImageProcessorUtil.generateImages(ImageProcessorUtil.java:38)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateThumbnails(UpgradeDocumentLibrary.java:458)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateThumbnails(UpgradeDocumentLibrary.java:414)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:92)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:225)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:64)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
at javax.servlet.GenericServlet.init(GenericServlet.java:242)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844)
at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)


Liferay version: 6.0.4 GA
Mysql: try on different version
S.O.: Windows 7 / fedora
Java: try on Oracle 1.6.0_24 / OpenJdk 1.6.0_18

Can Help me?
Tnx.
thumbnail
Alexander Chow, geändert vor 12 Jahren.

RE: UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Liferay Master Beiträge: 518 Beitrittsdatum: 20.07.05 Neueste Beiträge
There seems to be a bug in the upgrade code if you have images in the document library before the upgrade. Can you edit com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary and add the one line to include the extension in the dlFileVersion at around line 450 and see if that fixes your bug?


				DLFileVersion dlFileVersion = new DLFileVersionImpl();

				dlFileVersion.setFileVersionId(fileVersionId);
				dlFileVersion.setUserId(userId);
				dlFileVersion.setFileEntryId(fileEntryId);
				dlFileVersion.setExtension(extension); // NEW LINE
				dlFileVersion.setMimeType(mimeType);
				dlFileVersion.setVersion(version);


Alex
Michele Stoduto, geändert vor 12 Jahren.

RE: UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Junior Member Beiträge: 42 Beitrittsdatum: 07.07.10 Neueste Beiträge
I've added dlFileVersion.setExtension(extension);
recompiled and deployed.
Restore old situation, data directory and mysql table and restart upgrade process.
It's work.
tnx.


13:59:00,047 INFO [stdout] (MSC service thread 1-3) 13:59:00,046 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
13:59:00,203 INFO [stdout] (MSC service thread 1-3) 13:59:00,203 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
13:59:00,396 INFO [stdout] (MSC service thread 1-3) 13:59:00,395 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
13:59:00,431 INFO [stdout] (MSC service thread 1-3) 13:59:00,431 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
13:59:49,477 INFO [stdout] (MSC service thread 1-3) 13:59:49,476 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
13:59:52,619 INFO [stdout] (MSC service thread 1-3) 13:59:52,618 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
14:00:09,558 INFO [stdout] (MSC service thread 1-3) 14:00:09,558 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
thumbnail
Alexander Chow, geändert vor 12 Jahren.

RE: UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Liferay Master Beiträge: 518 Beitrittsdatum: 20.07.05 Neueste Beiträge
Excellent. For your reference, I have just made the changes in GIT related to LPS-25126.

Alex
thumbnail
Adam T, geändert vor 12 Jahren.

RE: UpgradeDocumentLibrary from 6.0.4 to 6.1 Ga1 FileExtensionException

Junior Member Beiträge: 34 Beitrittsdatum: 12.06.07 Neueste Beiträge
Alex,

I am getting a very similar error on 6.1 EE GA1 after using this parameter:

upgrade.processes=com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0,com.liferay.portal.upgrade.UpgradeProcess_6_1_1

(in order to resolve another upgrade issue).

Any idea why this would still happen?


18:52:13,813 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeDocumentLibrary
18:52:14,728 WARN [StoreFactory:67] Liferay is configured with the legacy property "dl.hook.impl=com.liferay.documentlibrary.util.JCRHook" in portal-ext.properties. Please reconfigure to use the new property "dl.store.impl". Liferay will attempt to temporarily set "dl.store.impl=com.liferay.portlet.documentlibrary.store.JCRStore".
18:52:17,865 ERROR [ImageProcessorImpl:269] com.liferay.portlet.documentlibrary.FileExtensionException: document_thumbnail/0/3/26627/72102.
com.liferay.portlet.documentlibrary.FileExtensionException: document_thumbnail/0/3/26627/72102.
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.validate(DLStoreImpl.java:517)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.validate(DLStoreImpl.java:541)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.addFile(DLStoreImpl.java:92)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.addFile(DLStoreImpl.java:171)
at com.liferay.portlet.documentlibrary.store.DLStoreUtil.addFile(DLStoreUtil.java:186)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.addFileToStore(DLPreviewableProcessor.java:200)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.storeThumbnailmage(DLPreviewableProcessor.java:1001)
at com.liferay.portlet.documentlibrary.util.DLPreviewableProcessor.storeThumbnailImages(DLPreviewableProcessor.java:959)
at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl._generateImages(ImageProcessorImpl.java:263)
at com.liferay.portlet.documentlibrary.util.ImageProcessorImpl.generateImages(ImageProcessorImpl.java:85)
at com.liferay.portlet.documentlibrary.util.ImageProcessorUtil.generateImages(ImageProcessorUtil.java:38)
at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeDocumentLibrary.updateThumbnails(UpgradeDocumentLibrary.java:222)
at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeDocumentLibrary.updateThumbnails(UpgradeDocumentLibrary.java:178)
at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:81)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:54)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1284)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:198)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
18:52:18,041 INFO [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
18:52:18,245 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fallon)' where groupId = 13077' at line 1
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fallon)' where groupId = 13077' at line 1
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1284)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:198)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fallon)' where groupId = 13077' at line 1
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fallon)' where groupId = 13077' at line 1
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:55)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
... 29 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fallon)' where groupId = 13077' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1355)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1270)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:222)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117)
at com.liferay.portal.upgrade.v6_1_0.UpgradeGroup.updateName(UpgradeGroup.java:107)
at com.liferay.portal.upgrade.v6_1_0.UpgradeGroup.doUpgrade(UpgradeGroup.java:46)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
... 32 more
Stopping the server due to unexpected startup errors



For a bit more detail and history see: http://www.liferay.com/es/community/forums/-/message_boards/view_message/12722254

Thanks

Adam