New Transaction not allowed error on bulk inventories import

[sameermoin]

Hello Everyone,

I am using the Inventory SaveEnd event for creating a custom webhook event asynchronously so that it won't block the main thread and its works fine when I update or create an inventory from the inventory maintenance form but when I do a bulk import using the Jiwa import utility I am getting "New transaction is not allowed because there are other threads running in the session" error. I am just reading SOH, attribute groups, and custom fields using SQL queries and not updating anything.

I also attached the custom plugin with a CSV file.

[sameermoin]

Due to no limitation attaching the attribute template in the new comment.

[SBarnes]

Without taking too much of a look at the code, that error is caused by a reader being open whilst Jiwa tries to commit a transaction to the database, whilst it looks like all your code has finally blocks to close the readers but check these anyway, you have helper class calls that are marked as async which means you can't guarantee the timing of the calls I would suggest starting with making the code synchronous and see if that fixes it.

The other thing you can do is run SQL profiler to see if you can determine anything from the SQLs ahead of the commit that could cause the issue.

[Mike.Sheen]

when I do a bulk import using the Jiwa import utility I am getting "New transaction is not allowed because there are other threads running in the session" error.

Thanks for supplying the plugin, sample import data and exported attribute data - I've downloaded these imported them and can repro your issue.

I'm just exploring your options and will post back here.

[Mike.Sheen]

Attached is a revised plugin that uses an ORMLite connection for the asynchronous reads you are performing.

I also removed the use of the Newtonsoft Json serialiser embedded reference and instead use the ServiceStack serialiser already shipped with Jiwa (it's a lot faster, too). Note that importing plugins won't ever delete references that were removed, so it would be best to delete your plugin, then import this modified one.

The ServiceStack OrmLite queries use the same connection string information as the application, but as it is a separate connection it won't interfere with the transactions in play by the Jiwa application during the import. It also handles a lot of the boilerplate code for you, so mapping a query result to a List<T> is automatic - so if you look at the code you'll find it is now a lot simpler and cleaner.

[sameermoin]

Hi Mike,

first, thank you so much for helping me.

Newtonsoft is outclassed as it has more flexibilities than others like ignoring the properties based on conditions when serializing or deserializing, handling multiple JSON cases, and much more. I need all these in my requirements. The plugin that I attached is just for demonstration, I am doing a lot of other stuff in the code.

[sameermoin]

Without taking too much of a look at the code, that error is caused by a reader being open whilst Jiwa tries to commit a transaction to the database, whilst it looks like all your code has finally blocks to close the readers but check these anyway, you have helper class calls that are marked as async which means you can't guarantee the timing of the calls I would suggest starting with making the code synchronous and see if that fixes it.

The other thing you can do is run SQL profiler to see if you can determine anything from the SQLs ahead of the commit that could cause the issue.

Thanks for the suggestions.

It was working fine on the synchronous code but I want to keep that asynchronous due to good user experience. I tried many different approaches and checked each and every SQL query, and all seems good but ADO.NET method didn't work, now I updated my queries with ORMLite, and working fine so far.