AR Invoice Batch (5 replies)
Annette, are you saying the A/R Posting completes?
Is this the last transform in the integration?
Are there any 3rd party modules? Which could be subclassing the views?
We have managed to isolate this to a 3rd party module – e-transmit. This is failing when a customer is added to the database as well.
After this, there is a routine to flatten the Accpac Import, map the fields, update a flag on the SQL table (SQL Write) and write an Excel file to a folder on the server.
The process was previously running on the Version 2 install of IMAN on Accpac 2012, but has been moved to a new server and upgraded to IMAN Version 3 sp3.
We have encountered this previously, but in that case when the Accpac database was set to run using SQL rather than a Datasource, the problem resolved itself, in this case, it has not helped.
Annette
Annette, it's almost 100% the same issue, and it's almost 100% the same SQL connection deadlock issue that we see with Orchid's Inter-Entity.
I remember the eTransmit issue well and it's interesting that you did resolve this by altering the Sage300's connection settings (which aligns with the issue...assuming it's the same one).
If it is, the issue occurs where ever a 3rd party module opens a connection to another SQL database. The close of the views, triggers the close of the 3rd party's database connection, and this is where the deadlock occurs. For some reason the SQL connection close never completes....I assume it is waiting for another event which never occurs.
Is there anyway we can setup a GotoMeeting onto this server?
Thanks James
I will only have access to the server again tomorrow morning, please let me know if you are available.
On this, I do have 1 confusion and it is making no sense. I have a similar setup in the respect of same data, same IMAN and Accpac versions, the difference, it is on a VM with the operating system Win 7 and the SQL server 2008R2 rather than 2012, and the process runs to the end with no errors.
Annette
Closed due to inactivity.
I have a problem where the AR invoice batch is creating successfully and can be posted, but the transform seems to be locking and not continuing with the process. The transform complete and job complete options never materialise.
I have ruled out security/permissions as an option as other transforms that read and write to Accpac 2012 sp 5 to Items and Customer update with no errors.
I have IMAN 3 sp3 for 2012 installed.
Thanks
Annette