Liferay throwing QueryTimeoutException while importing LAR

Message Boards

avasek atok, modified 8 Years ago.

Liferay throwing QueryTimeoutException while importing LAR

Junior Member Posts: 41 Join Date: 1/9/15 Recent Posts

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, modified 8 Years ago.

RE: Liferay throwing QueryTimeoutException while importing LAR

Junior Member Posts: 41 Join Date: 1/9/15 Recent Posts

Can you please share your experiences or suggestions

David H Nebinger, modified 8 Years ago.

RE: Liferay throwing QueryTimeoutException while importing LAR

Liferay Legend Posts: 14919 Join Date: 9/2/06 Recent Posts

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, modified 8 Years ago.

RE: Liferay throwing QueryTimeoutException while importing LAR

Junior Member Posts: 41 Join Date: 1/9/15 Recent Posts

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??