Foren

Liferay throwing QueryTimeoutException while importing LAR

avasek atok, geändert vor 8 Jahren.

Liferay throwing QueryTimeoutException while importing LAR

Junior Member Beiträge: 41 Beitrittsdatum: 09.01.15 Neueste Beiträge
Hi - I have created a new site and was trying to import a LAR, a LAR with pages and permissions. However import is taking very long time and finally ending up with the below querytimeoutexception.

Exception:-
caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: Could not execute JDBC batch update

Is there a way to increase the database time out value in liferay and get rid of this issue
or
any other means to successfully import the LAR.

Please advise.
avasek atok, geändert vor 8 Jahren.

RE: Liferay throwing QueryTimeoutException while importing LAR

Junior Member Beiträge: 41 Beitrittsdatum: 09.01.15 Neueste Beiträge
Can you please share your experiences or suggestions
thumbnail
David H Nebinger, geändert vor 8 Jahren.

RE: Liferay throwing QueryTimeoutException while importing LAR

Liferay Legend Beiträge: 14914 Beitrittsdatum: 02.09.06 Neueste Beiträge
My experiences is that LAR imports are very fragile instruments for transferring data between portals.

This particular issue seems to point to the size of the LAR being perhaps too large? Can you break it up into smaller pieces?
avasek atok, geändert vor 8 Jahren.

RE: Liferay throwing QueryTimeoutException while importing LAR

Junior Member Beiträge: 41 Beitrittsdatum: 09.01.15 Neueste Beiträge
At first I tried importing pages alone with out permissions and it is successful.
Now i am trying to import permissions alone.
However enabling liferay logs I noticed the LAR import stops with a message "Extracting manifest file".
Manifest file is around 180MB size. Is there is any limitation with file size??
Secondly I see the LAR is uploaded to tomcat and I can see it in temp folder of tomcat.

With the above observations is there a way to overcome and import permissions successfully??