Stored procedure error. - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Stored procedure error.

Author

Topic

cparker
Starting Member

16 Posts

Posted - 2007-12-12 : 18:01:53

0 2007/12/12 16:54:05 2972 Stored procedure => [sp_set_act_overdue], Param => 0 [i_svrdtime = '2007/12/12 22:54:05'] 0
0 2972 Error
2972 Code = 80040e31
2972 Code meaning = IDispatch error #3121
2972 Source = Microsoft OLE DB Provider for SQL Server
2972 Description = Timeout expired
0 3592 D:\vsswf\newyork\src\server\hwsqlexe\sqlutil.cpp(687): ERR> 0 5708 = HW_DB_SQL_ERROR
0 2972 2007-12-12 16:54:45 \src\SERVER\HWSCHD\src\dline_db.cpp(52): call CDCommand.Execute() error(5708) !!!
0 2972 2007-12-12 16:54:45 \src\SERVER\HWSCHD\src\dline_db.cpp(180): call uSetOverdueState() error(5708) !!!
0 2972 2007-12-12 16:54:45 \src\server\hweng\src\cemisc.cpp(568): call EndTrans() error(5708) !!!
0 2972 2007-12-12 16:54:45 \src\SERVER\HWSCHD\src\dline.cpp(770): call uGetDeadlineData() error(5708) !!!
0 2972 BeginTrans() = 0
0 2007/12/12 16:55:05 2972 SQL => [update deadline set checkoutmsg = ?
where checkoutmsg is null], Param => [locked_by_172.20.8.167_7201]
0 2007/12/12 16:55:05 2972 Number of rows affected..(0)
0 2007/12/12 16:55:05 2972 RDB_COMMIT_TRANSACTION:[0]
0 2007/12/12 16:55:05 2972 RDB_COMMIT_TRANSACTION:[0] Elapsed Time => 0.000 sec.
0 2007/12/12 16:55:05 2972 SQL => [select * from deadline
where svrid = ?
and startdtime <= ?
and nextdtime <= ?
and checkoutmsg = ?
and errno = 0 order by nextdtime], Param => [00000010012007/12/12 22:55:052007/12/12 22:55:05locked_by_172.20.8.167_7201]
0 2972 BeginTrans() = 0
0 2007/12/12 16:55:05 2972 Stored procedure => [sp_set_proc_overdue], Param => 0 [i_svrdtime = '2007/12/12 22:55:05'] 0
0 2007/12/12 16:55:05 2972 RDB_COMMIT_TRANSACTION:[0]
0 2007/12/12 16:55:05 2972 RDB_COMMIT_TRANSACTION:[0] Elapsed Time => 0.000 sec.
0 2972 BeginTrans() = 0
0 2007/12/12 16:55:05 2972 Stored procedure => [sp_set_act_overdue], Param => 0 [i_svrdtime = '2007/12/12 22:55:05'] 0
0 2972 Error
2972 Code = 80040e31
2972 Code meaning = IDispatch error #3121
2972 Source = Microsoft OLE DB Provider for SQL Server
2972 Description = Timeout expired
0 1200 D:\vsswf\newyork\src\server\hwsqlexe\sqlutil.cpp(687): ERR> 0 5708 = HW_DB_SQL_ERROR
0 2972 2007-12-12 16:55:46 \src\SERVER\HWSCHD\src\dline_db.cpp(52): call CDCommand.Execute() error(5708) !!!
0 2972 2007-12-12 16:55:46 \src\SERVER\HWSCHD\src\dline_db.cpp(180): call uSetOverdueState() error(5708) !!!
0 2972 2007-12-12 16:55:46 \src\server\hweng\src\cemisc.cpp(568): call EndTrans() error(5708) !!!
0 2972 2007-12-12 16:55:46 \src\SERVER\HWSCHD\src\dline.cpp(770): call uGetDeadlineData() error(5708) !!!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-12 : 18:04:11

Reinstall SQL Server?
Really, I have absolutely no idea before I've seen the SP.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources