Getting a failure when distilling a file on WebSphere & SQL Server


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.]

Continue reading →

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s