Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
thomas hyrien
Document library NoSuchFileException after migration Liferay 5.2.3 to 6.0.5
October 13, 2010 3:03 AM
Answer

thomas hyrien

Rank: New Member

Posts: 15

Join Date: August 4, 2010

Recent Posts

Hi,

I have just migrate from 5.2.3 to 6.0.5
I have a problem with the document library. When I open a file I have a documentlibrary.NoSuchFileException.

In the logs I can see that the URL of the file is wrong. The "." have been replaced by ",".


09:48:12,338 INFO [PortalImpl:3812] Current URL /c/document_library/get_file?uuid=4c50e2c0-f8e4-4e5e-a5a8-0f14b11ac080&groupId=10136 generates exception: C:\dev\essais\liferay-portal-5.2.3\data\document_library\10112\10192\1\1,0
09:48:12,338 INFO [PortalImpl:3827] com.liferay.documentlibrary.NoSuchFileException: C:\dev\essais\liferay-portal-5.2.3\data\document_library\10112\10192\1\1,0
com.liferay.documentlibrary.NoSuchFileException: C:\dev\essais\liferay-portal-5.2.3\data\document_library\10112\10192\1\1,0


The last repository is "1,0" and would be "1.0"

Anyone has an idea?
thomas hyrien
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
October 13, 2010 4:12 AM
Answer

thomas hyrien

Rank: New Member

Posts: 15

Join Date: August 4, 2010

Recent Posts

In the table 'dlfileentry' in my MySQL database, if I update version from '1,0' to '1.0' it works.
Is there a solution to solve this problem during migration ?
Dennis Greiffenberg
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
October 21, 2010 2:58 AM
Answer

Dennis Greiffenberg

Rank: Regular Member

Posts: 222

Join Date: April 30, 2007

Recent Posts

Hi Thomas,

I'm also trying to upgrade from 5.2.3 to 6.0.5 on MySQL and I'm facing severe errors during the transition. Well, to be honest, the transition completely fails due to the following error:
 1Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August 16, 2010)
 213:10:00,865 ERROR [JDBCExceptionReporter:101] Table 'tpliferay6.lock_' doesn't exist
 313:10:01,974 INFO  [BaseDB:399] Database does not support case sensitive queries
 413:10:01,982 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
 513:10:01,983 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
 613:10:03,500 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
 713:10:04,044 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
 8com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
 9        at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)   
10        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
11        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
12        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
13        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
14        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
15        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
16        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
17        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
18        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
19        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
20        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
21        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
22        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
23        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
24        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
25        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
26        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
27        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
28        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
29        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
30        at org.apache.catalina.core.StandardService.start(StandardService.java:519)
31        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
32        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
33        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
34        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
35        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
36        at java.lang.reflect.Method.invoke(Method.java:597)
37        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
38        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)


Tomcat stops after that. If I restart tomcat I get a duplicate key error on the table "dlfileentry".

Did you run into similar errors or does that scenario not sound familiar at all to you?

Any help is greatly appreciated.

/Dennis
thomas hyrien
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
November 2, 2010 9:46 AM
Answer

thomas hyrien

Rank: New Member

Posts: 15

Join Date: August 4, 2010

Recent Posts

Hi Dennis,

Sorry but I didn't have your error during the transition.
Do you use the portal-legacy-5.2.properties file ?
Nicolas GRUE
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
November 18, 2010 10:45 PM
Answer

Nicolas GRUE

Rank: New Member

Posts: 12

Join Date: February 20, 2007

Recent Posts

Hi all,

An issue is opened on JIRA for this.
http://issues.liferay.com/browse/LPS-13281

It seems to be related to the tags properties.

Please do not hesitate to add some comments there.

(EDIT: Dennis, I just noticed you were the original reporter, so forget my comment.)
Nicolas GRUE
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
November 18, 2010 11:26 PM
Answer

Nicolas GRUE

Rank: New Member

Posts: 12

Join Date: February 20, 2007

Recent Posts

As for the original post from Thomas, it may be linked to this:
http://issues.liferay.com/browse/LPS-11363

the obvious workaround would be to call after the upgrade:
update DLFileEntry set version = replace(version, ',', '.');

but it's probably not that simple, because of frenchs settings on the jvm...

Since I'll probably hit the same problem, I'll bring you some news soon.
Tobias Käfer
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
November 18, 2010 11:31 PM
Answer

Tobias Käfer

Rank: Regular Member

Posts: 128

Join Date: March 28, 2008

Recent Posts

The root of this issue is this one:
http://issues.liferay.com/browse/LPS-12109

I came across this one during my upgrading tests from 5.2.3 to 6.0.5

As you can see this is fixed in the trunk.
Hitoshi Ozawa
RE: Document library NoSuchFileException after migration Liferay 5.2.3 to 6
May 8, 2012 6:58 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

I think the default in 5.x was to store data in database whild 6.x stores them in file system.