I got the same error occasionally when parsing X12 files. Lock table got filled up when saving a transaction that contains hundreds of objects.
- Log in to post comments
I got the same error occasionally when parsing X12 files. Lock table got filled up when saving a transaction that contains hundreds of objects.
Hopefully they will tell the provider of the files to NOT send files that way and we do not need to come up with a work-around.
We understand what happened after we looked at the console log.
We failed to acquire locks when there were two actors because the lock table was full.
The rollback failed because journaling was off.
We will address our configuration.
Hello Sean,
Thank you for your response.
We attempted a different approach yesterday using XML Adapter in our persistent class and routing the message to an SQL Outbound Adapter. We were able to insert data into our table. However we see errors logged in our SQL Operation (Business Operation):
ERROR <Ens>ErrRequestNotHandled: Request message '13@Test.SubscriberX' not handled
Do you know what we need to do to avoid getting these errors?
Thank you