Kbase P184667: Oracle query of a Progress database fails with a record lock error.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/03/2011 |
|
Status: Unverified
SYMPTOM(s):
Oracle query of a Progress database fails with a record lock error.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Failure getting record lock on a record from table
FACT(s) (Environment):
Running either of the following two SQL statements on a progress DB using the AIX 64 bit ODBC driver fails tith a record locked error:
select * from "pub"."contract"@REM_CONTRACT_DBL where "ContractID" = 'R0123456';
select count(*) from rem_contract a where "CONTRACTID" = 'R0123456';
The odbc.ini file has the default isolation level set to READ UNCOMMITTED.
The .ora file used also setting the following properties:
HS_FDS_TRANSACTION_MODEL=READ_ONLY
HS_FDS_TRANSACTION_ISOLATION=READ_UNCOMMITTED
HS_FDS_CONNECT_PROPERTIES="isolationLevel='readUncommitted'"
IBM AIX 6.1
OpenEdge 10.2A03 64-bit Service Pack
Oracle DataServer
CAUSE:
This is a known Oracle issue that has been fixed.
FIX:
Contact Oracle technical support to find out which versions contain a fix.