I have a COM+ application running on a Win2K sp2 box that executes a series of large jobs on demand. The application begins execution of each job by executing a MAIN stored proc on a SQL Server 7.0 DB, that in turn executes a series of stored procedures on 2 linked SQL servers. After the MAIN stored proc completes, the Data tier of the COM+ application sets a transaction vote and returns back to the business tier, which sets the final tx vote.
I'm having a problem with the small steps inside each MAIN procedure. Every so often, I receive the following error:
Error Description: -2147217900
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
I receive this error before the global timeout value (global timeout is 1 hr, i get this error in 15 min).
Also, it has proved difficult for me to repeat this error with any regularity. Example: The batch works with one set of paramters, but the same batch fails with a different set of parameters. When i use the word "batch" i'm referring to the job begun by the COM+ component, executed by Stored procs, and returned to COM+ to set tx votes.
Also, the MAIN stored procedure always works fine with any set of paramters, if it is run through MS Query Analyzer, and not through the COM+ App.
finally, I've received this error number many times with different (yet equally ambigious) error messages.