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
  • I'm not sure if the SQL Native Client is supported or not.  You should check with support to see if it is.  In any case, before making that switch there are a few questions I have.

     

     First is it only this client machine having issues or is it all client machines? 

     

     Is is it a standard client that is having problems or are you using Citrix/Terminal Server?  

     

     Is Customizer being used on this form?  If so, does the same error occur when it is turned off?

     

    If it is one machine, have you tried logging in another user and seeing if the same error occurs?

     

    If Citrix/Terminal Server do other users report the problem?

     

    Did this start occurring or has it always happened?  If it just started what has changed on the machine, environement, etc.?

     

    Maybe answering these questions will reveal what the issue may be.

     

     

Reply
  • I'm not sure if the SQL Native Client is supported or not.  You should check with support to see if it is.  In any case, before making that switch there are a few questions I have.

     

     First is it only this client machine having issues or is it all client machines? 

     

     Is is it a standard client that is having problems or are you using Citrix/Terminal Server?  

     

     Is Customizer being used on this form?  If so, does the same error occur when it is turned off?

     

    If it is one machine, have you tried logging in another user and seeing if the same error occurs?

     

    If Citrix/Terminal Server do other users report the problem?

     

    Did this start occurring or has it always happened?  If it just started what has changed on the machine, environement, etc.?

     

    Maybe answering these questions will reveal what the issue may be.

     

     

Children
No Data