SAP Note 16135 - Deadlock on table APQI (INF143, INF240, INF244)

Symptom:

The Informix ISAM error
INF143 "deadlock detected"
occurs in connection with the Informix SQL errors
INF240 "Could not delete a row"
INF244 "Could not do a physical-order read to fetch next row"
INF246 "Could not do an indexed read to get the next row"
INF271 "Could not insert new row into the table"
during the parallel processing of batch input sessions in table APQI.

Cause and prerequisites

Due to a primary index of database table APQI, a deadlock occurs at database level when processing several batch input sessions at the same time under Informix. The affected R/3 transactions are reset.

Solution

Check the available indexes on table APQI
(with 'dbaccess': info indexes for apqi;).

If only one index is displayed via the fields

(destsys,destapp,datatyp,mandant,groupid,progid,formid,qattrib,qid)

(the index name does not play an important role; usually it is 'apqi___1', 'apqi______1' or it consits only of digits and
' '(blanks)), you have to create an informix specific index on the table APQI.

1. For Releases < 30A:

Obtain and execute from sapservX machines the respective most current version of the program 'SBCREIND'.

The report is stored on sapservX machines in the directory '/general/3rdparty/informix/ddic' under the name 'SBCREIND.NEW'.

To import the report into your SAP System proceed as follows:


(1) Log on as user 'adm' to the central application server.

(2) Change into the directory '/usr/sap/trans/tmp'.

(3) Load the file 'SBCREIND.NEW' via ftp from sapservX
directory '/general/3rdparty/informix/ddic'.

(4) Import the report with the command

"R3trans -i SBCREIND.NEW.
CAUTION: The database has to be active.

Then execute the report (SE38 -- SBREIND -- Execute).
The required informix specific index will be created.

2. For SAP Releases >= 3.0A

Obtain and execute from sapservX machines the respective most current version of the program 'SINDXINF'.

The report is stored on sapservX machines in the directory '/general/3rdparty/informix/ddic' under the name 'SINDXINF.NEW'.

To import the report into your SAP System proceed as follows:


(1) Log on as user 'adm' to the central application server.


(2) Change into the directory '/usr/sap/trans/tmp'.

(3) Load the file 'SINDXINF.NEW' via ftp from sapservX
directory '/general/3rdparty/informix/ddic'.

(4) Import the report with the command

"R3trans -i SINDXINF.NEW.
CAUTION: The database has to be active.

Then execute the report (SE38 -- SINDXINF -- Execute).
The required informix specific index will be created.