On Feb 23, 1:46 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.comwrote:
"The Man" <LeJon7...@gmail.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...
Hello All:
I am in desparate need of assistance. We are using an application
called PaperVision Enterprise which takes scanned invoices and puts
them into a database for the purpose of easy reference to any scanned
invoice in the db. 2 weeks ago while trying to perform a 'match and
merge' of the newly scanned docs, we received a Run-time error
'-2147217871 (80040e31)": Timeout expired message. After being told by
the company who supports this software that they couldn't help me
since it is using a MS SQL Server Table Lookup I started googling the
error with minimal success. I am not very proficient with SQL so I'm
kind of stuck. I have narrowed this down to an ODBC run-time error,
but looking for some kind of guidance as to how I can resolve it. Any
info would be greatly appreciated. We are using MS SQL Server 2000.
Really not much to go on here.
It's not clear to me, did this happen just once? Or all the time?
Can you open query analyzer and do a sp_who2 on the server in question?
It's possible something has a lock on that table. Killing that (and
determining who/why) should solve your problem.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
ok i did what you have ask me to do and these are the results. Thank
you for your assistance on this issue.
also i am in the sql server enterprise manger and i killed all the
process. i tried to run the query again and i get the same error. i
opened up the sql server enterprise manager and checked the locks/
objects tree and that database is in there. Its seems like whenever i
try and run the query the database is getting locked with locked type
(DB).
there are the results of the command you told me to run:
53 sleeping sa
PVE . pvedb AWAITING COMMAND 1052 239
02/23 14:18:08 PaperVision DM Automation
Server 53
54 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:18 Microsoft(R) Windows (R) 2000 Operating
System 54
55 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:11 Microsoft(R) Windows (R) 2000 Operating
System 55
56 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 56
57 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 57
58 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 58
59 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:12 Microsoft(R) Windows (R) 2000 Operating
System 59
60 sleeping sa
PVE . pvedb AWAITING COMMAND 16 0
02/23 14:22:38 Microsoft(R) Windows (R) 2000 Operating
System 60
61 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 61
62 sleeping sa
PVE . pvedb AWAITING COMMAND 0 8
02/23 14:22:38 Microsoft(R) Windows (R) 2000 Operating
System 62
63 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 63
64 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 64
65 RUNNABLE sa
PVE . pvedb UNKNOWN TOKEN 123015 2253
02/23 14:23:25 PaperVision DM Automation
Server 65
66 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 66
67 RUNNABLE sa
PVE . pvedb SELECT INTO 31
9 02/23 14:23:01 SQL Query
Analyzer 67