SAP Note 10851 - SQL Error "ISAM-103: illegal key descriptor"

Component : Database Interface/DBMS for Informix -

Solution : https://service.sap.com/sap/support/notes/10851 (SAP Service marketplace login required)

Summary :
The SAP transaction execution fails with the ABAP/4 runtime error DBIF_RSQL_SQL_ERROR. The syslog and the detailed ABAP/4 error report display entries like "SQL Error at ... access to table

." Depending on error number , entries like "INF-240: Could not delete a row," "INF-245: Could not position within a file via an index," and others may follow. An extended error message "ISAM-103: illegal key descriptor (too many parts or too long)" accompanies these errors. Similar issues occur in R3trans operations. The root cause is an inconsistent and corrupt table index with an unknown cause. To resolve, check and rebuild indices with the SAPDBA tool, following the detailed steps outlined, including stopping and restarting the R/3 System.

Key words :
isam103illegal key descriptorindex corruption inconsistencypts pts_bug pts_bug_xxxxx, additional key words dbif_rsql_sql_error, abap/4 runtime error dbif_rsql_sql_error, abap/4 runtime error show, illegal key descriptor, sap transaction terminates, sql error <errno>, error number <errno>, $ oncheck -ci <sid>, oncheck finds inconsistencies

Related Notes :

38401Download the latest SAPDBA version
36314Assert Failed: index inconsistent or corrupted