Consultor Eletrônico

Status: Verified

GOAL:

ADM2. Error 129 with Joins in a SDO - DataServer

GOAL:

The total length of the fields in an index exceeds max key size. (129)

FACT(s) (Environment):

Progress 9.x
DataServer

CAUSE:

You might get the following error when running a SDO against a DataServer:
The total length of the fields in an index exceeds max key size. (129)

The error occurs when your SDO has a join with more than 3 tables against ORACLE DataServer or any join against ODBC / MS SQL Server DataServer.

FIX:

There are two possible workarounds for the problem:

Create a SDO for each table and join the SDO's,

or,

Comment the last line on file:

%dlc%\src\adm2\robjflds.i

/* INDEX RowIdent RowIdent */

Then recompile your SDO's.

If you are using SmartPanel, you may also need to change two other include files:

Comment the index for temp-table RowIdent on file:

%dlc%/src/adm2/data.i

/* INDEX RowIdent IS PRIMARY RowIdent */

For version 9.1B, comment the last line on file:

%dlc%/src/adm2/rupdflds.i

/* INDEX RowIdent RowIdent */

Compile your SDO's.

NOTE: If you already had a session running when you changed the file, don't forget to recompile the SDO.

This is also fixed on the latest patch for 9.1B.