Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-16 : 08:19:39
|
| Cynthia writes "Hi,I am really not a MS SQL Server DBA and we have no support here either for DBA support, but there is an error on the application error log for the MS SQL server database.Error is as follows from the application logs in the event viewer:Failed to add message record. Record follows:7/5/2004 16:04:39 Time : 07/05/04 16:04:097/5/2004 16:04:39 Time Sent to Agent : 07/05/04 16:04:097/5/2004 16:04:39 Time Responded : 07/05/04 16:04:097/5/2004 16:04:39 Tracking Number : CSW20040705000004407/5/2004 16:04:39 ID : -999997/5/2004 16:04:39 Pool ID : 437/5/2004 16:04:39 Agent ID : -999997/5/2004 16:04:39 Current Status ID : 650007/5/2004 16:04:39 Current Status Record ID : 16768787/5/2004 16:04:39 Message To : cswithdrawals@etrade.ca7/5/2004 16:04:39 Message From : jovin.shen@etrade.com7/5/2004 16:04:39 Subject : 9KTEZXA 0 C CASH 1. MR. BRIAN RUKAVINA7/5/2004 16:04:39 --- End of Message Record ---7/5/2004 16:04:39 The IMC Server is shutting down due to an unexpected database error7/5/2004 16:04:48 DB Error: 80040e31 (message="IDispatch error #3121", source="Microsoft OLE DB Provider for ODBC Drivers", description="[Microsoft][ODBC SQL Server Driver]Timeout expired", location="Database::AddMessageRecord", info="imc_AddMessage")7/5/2004 16:04:48 Failed location: 27Can you help explain to me how to debug this to get the application back up and running please?TIA,Cynthia" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-09-16 : 10:18:52
|
| "Timeout expired"I think the query the applciation tries to execute is taking too long.- Sekar |
 |
|
|
|
|
|
Please help with a MS SQL Server 7.0 db problem