ODBC error - "LOCK TABLE IS FULL 7870"???!

mdemon

New Member
I hope I'm in the right bit.... Forgive the Newbie!:)

We have a Progress back end for an ERP package called Proteus. We are trying to extract the data into SQL before we ditch Proteus in a short while.

Unfortunately, trying to get at the data via MS SQL Server or Crystal Reports comes back with the following; "Query Engine Error HY000. DataDirect Technologies ODBC Progress driver - Lock Table is full (7870)"

1) Is this a flaky ODBC driver? If so, which tool would I use in Progress to view and fix the data?

2) Where can I find the lookup for this particular error code?

Any thoughts? Starting to get a bit desparate here!

Cheers,

John
 

vinod_home

Member
hello,

7870 is a Progress Error Message. ..... Here are the details


------------
Progress 9.1x

SYMPTOM(s):

Error querying database

Connecting with MERANT 3.60 32-bit SQL92 Driver

Lock table is full. (7870)

Launching a query with READ COMMITTED Transaction Isolation Level

CAUSE:

READ COMMITTED is a non-read-only Isolation Level, therefore, the Lock
Table is updated.

FIX:

If only querying the database, and not updating, use the READ
UNCOMMITTED Transaction Isolation Level instead. For more information
on Transaction Isolation Levels, please reference Chapter 3 of the
SQL92 Guide and Reference under the SET TRANSACTION ISOLATION LEVEL
statement.
----------------

HTH
V
 

mdemon

New Member
Most kind! I'll see if we have a manual around...

Is there some way I could tweak DTS in MS SQL server to us the READ UNCOMMITTED?

Many thanks for your reply, most kind!
 
Top