Andy,
Vantage will also lock tables when users are doing certain transactions.
This will bite you when trying to query heavily-trafficked tables, such
as PartTran and LaborDtl. If you've correctly set your default
isolation level in the ODBC driver (odbcad32.exe) then Excel will obey
it. Then make sure your data collectors are not being used and your job
adjustment users and payroll users are not in the table. You can easily
see which tables are locked, how you see it depends upon your Vantage
version.
have fun,
john
----- Original message -----
From: "amossrmt" <amoss@...>
To: vantage@yahoogroups.com
Date: Mon, 18 Jan 2010 22:41:25 -0000
Subject: [Vantage] Table Lock on ODBC through Excel
Today I've been working on a project using ODBC through Excel to pull in
data for pivot tables. When I try to get data from PUB.LaborDtl, nearly
every time I am getting this error:
[DataDirect-Technologies][ODBC PROGRESS Driver][PROGRESS] Failure
getting record lock on a record from the table PUB.LaborDtl
I occasionally get this error on the PUB.Part table in some similar
Excel Pivot Table documents I've created, but not often enough that it
has been a major problem. My ODBC connection IS set to "Read
Uncommitted", and everything we've tried seems to point us to the fact
that somehow Excel ignores the default isolation level specified in your
ODBC driver's configuration and uses "Read Committed" instead. I've also
tried creating and pulling data via a macro/vba in Excel, and using code
to manually set the default isolation level, but no joy there either.
Anybody else run into this problem or have any pointers for me?
Andy Moss
Vantage will also lock tables when users are doing certain transactions.
This will bite you when trying to query heavily-trafficked tables, such
as PartTran and LaborDtl. If you've correctly set your default
isolation level in the ODBC driver (odbcad32.exe) then Excel will obey
it. Then make sure your data collectors are not being used and your job
adjustment users and payroll users are not in the table. You can easily
see which tables are locked, how you see it depends upon your Vantage
version.
have fun,
john
----- Original message -----
From: "amossrmt" <amoss@...>
To: vantage@yahoogroups.com
Date: Mon, 18 Jan 2010 22:41:25 -0000
Subject: [Vantage] Table Lock on ODBC through Excel
Today I've been working on a project using ODBC through Excel to pull in
data for pivot tables. When I try to get data from PUB.LaborDtl, nearly
every time I am getting this error:
[DataDirect-Technologies][ODBC PROGRESS Driver][PROGRESS] Failure
getting record lock on a record from the table PUB.LaborDtl
I occasionally get this error on the PUB.Part table in some similar
Excel Pivot Table documents I've created, but not often enough that it
has been a major problem. My ODBC connection IS set to "Read
Uncommitted", and everything we've tried seems to point us to the fact
that somehow Excel ignores the default isolation level specified in your
ODBC driver's configuration and uses "Read Committed" instead. I've also
tried creating and pulling data via a macro/vba in Excel, and using code
to manually set the default isolation level, but no joy there either.
Anybody else run into this problem or have any pointers for me?
Andy Moss