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
  • Lou, thanks for the reply.

    I think SQL Native Client is supported.   It was Sage Support who told me about it and that it would solve the other error I mentioned above.

     

    We use Terminal Server, so with the exception of a few users working here in our headquarters who use a local client, everyone is using the client on a Terminal Server.  We don't use Citrix.

     

    Customizer is not being used on the form.

     

    The error is not repeatable; it seems random.  The user told me that she has seen it before, but since she got it on two attempts in a row this time, she decided to report it.  Normally a user not reporting an error would be a bad thing, right?  But in our case, since we have had random errors daily in just about every module ever since moving from Windows 2000 TS to Windows 2003 TS last spring, which no one has been able to figure out yet, users don't report most errors to me.  It wouldn't make sense to since they happen so often.  But anyway, the random application error situation is a whole other issue aside from this particular run-time error saying the "server is not available and disappeared; and all connections are invalid."

    It just seemed to me that it could potentially be an error that might be fixed by the SQL Native Client, based on the other somewhat similar type of error that the SNC is known to fix.

     

    Message Edited by Ralph on 01-29-2009 01:14 PM
Reply
  • Lou, thanks for the reply.

    I think SQL Native Client is supported.   It was Sage Support who told me about it and that it would solve the other error I mentioned above.

     

    We use Terminal Server, so with the exception of a few users working here in our headquarters who use a local client, everyone is using the client on a Terminal Server.  We don't use Citrix.

     

    Customizer is not being used on the form.

     

    The error is not repeatable; it seems random.  The user told me that she has seen it before, but since she got it on two attempts in a row this time, she decided to report it.  Normally a user not reporting an error would be a bad thing, right?  But in our case, since we have had random errors daily in just about every module ever since moving from Windows 2000 TS to Windows 2003 TS last spring, which no one has been able to figure out yet, users don't report most errors to me.  It wouldn't make sense to since they happen so often.  But anyway, the random application error situation is a whole other issue aside from this particular run-time error saying the "server is not available and disappeared; and all connections are invalid."

    It just seemed to me that it could potentially be an error that might be fixed by the SQL Native Client, based on the other somewhat similar type of error that the SNC is known to fix.

     

    Message Edited by Ralph on 01-29-2009 01:14 PM
Children
No Data