Run-time error -2147418105 (80010007) in IM module

Using v7.05 SP4 March w/ SQL 2005 Std x86.

 

I had a user encounter a runtime error twice today while trying to register/print/post an 'IM Sale Return' Inventory Transaction.  She had entered the transaction, clicked the green triangle, selected 3 copies to be printed in the print dialog box, and then clicked 'OK.'  Then the following error appeared.

 

Run-time error -2147418105 (80010007): Automation error The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have been executed.

I shadowed her TS session and we tried to register/print/post the transaction once again, and when I was watching it worked fine.  3rd time's a charm. 

 

This exact error is addressed in Sage KBID 486913, but it's for a completely different scenario.  It has to do with when a user is in SM -> User Preferences and attempting to change their password.  It also says it's fixed in the March '08 update, which is what we're using.  But again it's a completely different scenario so I don't think that particular KBID is relevant.

 

My question is this... Does anyone happen to think that this particular error might be eliminated by using the "SQL Native Client" ODBC driver instead of the standard SQL Server ODBC driver?  Supposedly using the "SQL Native Client" corrects the error sometimes encountered in AP register posting "Error 4600 occurred at frmRegister in Procedure Form_QueryUnload.  Connection is busy with results for another hstmte."  I've not yet made the switch to the "SQL Native Client" though.  I'm just curious if anyone feels that the error we saw today in IM Transactions might also be resolved by using the "SQL Native Client."

 

Thanks for any insight you may have about this.

 

Parents
  • Hmmm.   You could give it a shot and change to SQL Native Client to see what happens since support blesses it.  I believe on the old Sage Talk someone else posted a thread on getting intermittent errors and disconnects on Terminal Server.  I don't remember if they resolved the problem or not and if they did how they did it.   Maybe someone else remembers that thread.

     

    One final question though.  Do any of the standard client installs report the same issues or is it all the Terminal Server users?   That will definitely narrow it down a bit as to where to look for the problem.

     

     

    Message Edited by LouDavis on 01-29-2009 10:56 AM
Reply
  • Hmmm.   You could give it a shot and change to SQL Native Client to see what happens since support blesses it.  I believe on the old Sage Talk someone else posted a thread on getting intermittent errors and disconnects on Terminal Server.  I don't remember if they resolved the problem or not and if they did how they did it.   Maybe someone else remembers that thread.

     

    One final question though.  Do any of the standard client installs report the same issues or is it all the Terminal Server users?   That will definitely narrow it down a bit as to where to look for the problem.

     

     

    Message Edited by LouDavis on 01-29-2009 10:56 AM
Children
No Data