1916864 - TREX: Error code 2434 "Join Index inconsistent" / SAP HANA: Missing attributes for ALPHANUM and TIMESTAMP

Symptom

This SAP Note corrects the following two error situations:

• Search on TREX scenario:
  When you try to create connectors, your attempt fails with the error messages:
  Error code: 2434
  Error message: join index inconsistent ...
  The error affects all join indexes.
• Search on SAP HANA scenario - table-based connectors:The system does not support alphanumeric fields or date and time stamp fields. To enable support for these fields, you have to generate additional attributes in the affected tables in SAP HANA. This SAP Note provides the changes required on the ABAP side for this.

Other Terms

TREX: Cannot create join index
SAP HANA: Calculated attributes, ALPHANUM, search with leading zeros, search without leading zeros

Reason and Prerequisites

This SAP Note involves the search on TREX and search on SAP HANA scenarios.
This affects
TREX: All connectors
SAP HANA: table-based connectors with fields of the type ALPHANUM and fields of the type DATE or TIMESTAMP.

Note the prerequisites that affect both the HANA server and the ABAP server.
TREX: There are no dependencies on the TREX revision.
HANA: You need at least SAP HANA 7.0.
ABAP: The SAP Note can be implemented as of SAP BASIS 7.40 SP04, but we recommend that you use at least SP05 for the search on SAP HANA scenario.

Note the required corrections and manual steps described in the solution section for your Support Package.
For more information about the search on TREX scenario, see the information from the related SAP Note 2009345 - TREX : Connectors can not be created - TREX error 2434

Solution

NoteThe manual prerequisites specified below (and the correction in the SAP Note itself) can be implemented using the following collective SAP Notes:
SP04:
 - 1965335 - SAPKB74004: Composite SAP Note 1
 - 1966609 - SAPKB74004: Composite SAP Note 2
SP05:
 - 1965028 - SAPKB74005: Composite SAP Note 1

When importing Support Package 04:

1. HANA requirements

• Ensure that the version of HANA used for the search is at least SAP HANA 7.0.

2. Prerequisites / preliminary tasks: ABAP corrections

• Ensure that the related and required SAP Note 1880038 is implemented:
  all ABAP Dictionary objects specified there must be implemented
  19 ABAP Dictionary objects
  as well as message texts
  no further automatic correction instructions in this SAP Note.
   
• Ensure that the related and required SAP Note 1915724 is implemented:
  in particular, all ABAP Dictionary objects specified there must be implemented
     structure HDBS_CALCULATED_ATTRIBUTE
     table type HDBT_CALCULATED_ATTRIBUTE
  plus correction instructions.
   
• Ensure that the related and required SAP Note 1920188 is implemented:
  in particular, all ABAP Dictionary objects specified there must be implemented
     structure HDBS_STATIC_JOIN_CONDITION
     table type HDBT_STATIC_JOIN_CONDITION
     structure HDBS_VIEW_ATTRIBUTE
     table type HDBT_VIEW_ATTRIBUTES
  plus correction instructions.
   
• Ensure that the related and required SAP Note 1938575 is implemented:
  in particular, all ABAP Dictionary objects specified there must be implemented
     data element ESH_E_CU_FED_AUTH_CHECK_JOIN
     structure enhancement ESH_S_JOIN_ATTRIBUTES_LIST with field S_PATH_NUMBER (which is referenced below)
     structure ESH_S_OM_AUTH_REL_REQ_RESP_FD
     table type ESH_T_OM_AUTH_REL_REQ_RESP_FD
     structure enhancement ESH_S_TREX_REQUEST
     table enhancement ESH_CU_FED
  maintenance dialog for table ESH_CU_FED
  plus correction instructions
   
• After making the ABAP Dictionary changes specified in the above-mentioned SAP Notes, perform the following change:
  
  Call transaction SE11 (ABAP Dictionary):
  Structure ESH_S_JOIN_ATTRIBUTES_LIST
  Insert the following new component after component NO_FREESTYLE_SEARCH and before the component S_PATH_NUMBER added in SAP Note 1938575.
     Component: CALC_NODE_FIELD
  Typing: Types
  Component type: ESH_E_HDB_DBATTRIBUTE
  Save and activate the structure.

3. Automatic step

• Import the correction instructions with validity for Release SAP BASIS 740 Support Package 03/04.

When importing Support Package 05:
1. HANA prerequisites

• Ensure that the version of HANA used for the search is at least SAP HANA 7.0.

2. Prerequisites / preliminary tasks: ABAP corrections

• The following table type (delivered in SAP Note 1880038) contains an incorrectly defined secondary key in the delivery status for Support Package 05.
  This may have to be corrected.
  
  Call transaction SE11 (ABAP Dictionary):
  Table type ESH_T_HDB_CALC
   - Open the tab "Secondary key" and double-click the secondary key OTYPN_CALCATTR
   - Check whether the key access ("Key access") is incorrectly set to "Unique Hashed".
  If this is the case, proceed as follows:
  - Switch to change mode
   - Open the secondary key OTYPN_CALCATTR as described above
   - Change the attribute "Key Access" from "Unique Hashed" to "Non-Unique Sorted"
  - Save and activate your change.
   
• Check whether the following table attribute already exists and create it if necessary:
  
  Call transaction SE11 (ABAP Dictionary):
  Structure ESH_S_JOIN_ATTRIBUTES_LIST
  Insert the following new component after component NO_FREESTYLE_SEARCH and, if necessary, before the component S_PATH_NUMBER (not required by Support Package 05, although it may already exist) added or to be added in SAP Note 1938575:
  Component: CALC_NODE_FIELD
  Typing: Types
  Component type: ESH_E_HDB_DBATTRIBUTE
  Save and activate the structure.

3. Automatic step

• Import the correction instructions with validity for Release SAP BASIS 740 Support Package 05.

------------------------------------------------------------------------
|Manual Activity                                                       |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   SAP_BASIS                      SAP Basis compo...|
| Release 740          SAPKB74004 - SAPKB74005                         |
------------------------------------------------------------------------

Manual activities when importing SAP Note1916864 in SAP BASIS 740 Support Package 04 or Support Package 05.

Note the information in the long text of SAP Note 1916864 for your Support Package level. Note particularly in Support Package 04 the numerous manual changes in the related SAP Notes specified. In addition, note all further required corrections.

Header Data

Released On	24.04.2014 15:12:19
Release Status	Released for Customer
Component	BC-EIM-ESH NetWeaver Enterprise Search
Priority	Correction with high priority
Category	Program error