Liferay throwing QueryTimeoutException while importing LAR

[8年前 に avasek atok によって更新されました。]

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.

[8年前 に avasek atok によって更新されました。]

Can you please share your experiences or suggestions

[8年前 に David H Nebinger によって更新されました。]

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?

[8年前 に avasek atok によって更新されました。]

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