Distilling a file fails and times out. The error logs show the following error:
2016-07-12 13:34:21,321 WARN [com.tririga.excel.RecordMappingUtils](WebContainer : 11) Unable to set field in distilled file: General.cstPITResponsiblePartyTX Caused by: null[MID-3245432220]
Meanwhile, the same input file works in another environment with the same platform, WebSphere and SQL Server. The workflow failure shows the following…
It looks like the issue is due to a transaction timeout in WebSphere: “Global transaction timed out after 120 seconds”. Go into the WAS Console, in your Server, under Container Settings, expand Container Services. Click Transaction Service. Change the Total transaction lifetime timeout to a large value, for example, 900000. Change the Maximum transaction timeout to a large value, for example, 900000. Click OK. Click Save to save your changes to the master configuration.
[Admin: This post is related to the 09.16.15 post about the distill process failing with certain Excel functions.]