1828493 - ESH on SAP HANA: Attribute lengths in physical tables

Symptom

Embedded Search on SAP HANA:
Physical tables are created with incorrect attribute lengths.

Other Terms

ESH on HANA, HDB table attribute definition

Reason and Prerequisites

There is a program error.
Validity: Release 7.40, specified SP
Relevant for Embedded Search on SAP HANA as well as in other scenarios if this SAP Note is a prerequisite for follow-up corrections.

Solution

1. Prerequisites
As a prerequisite, implement SAP Note 1825255.
Manual steps:
Create structure HDBS_ATTR_DEF and table type HDBT_ATTR_DEF.

2. Manual step
Change the following structure:
ABAP Dictionary maintenance: SE11 -> Structure ESH_S_TREX_INDEX_METADATA

Between the components TREX_ATTRIBUTE_DEFINITION and TREX_KEY_ATTRIBUTES, add the following new components in position 8:
Component HDBT_ATTRIBUTE_DEFINITION, type HDBT_ATTR_DEF

Activate your changes.

3. Manual step
Maintain the following message texts:
(Logon language: English)
Message text maintenance SE91 -> Message class ESH_HANA_ADMIN

Add the following new messages
047     Proxy API error: Attempt to create HDB column table via TREX API '&1'
048     Proxy API error: Attempt to create TREX index via HDB Proxy API '&1'
049     Proxy API error: Attempt to modify HDB column table via TREX API '&1'
050     Proxy API error: Attempt to modify TREX index via HDB Proxy API '&1'

4. Automatic correction
Implement the correction instructions.

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

See the long text of this SAP Note:
Change the ABAP Dictionary structure
Maintain message texts

Header Data

Released On	01.03.2013 09:30:08
Release Status	Released for Customer
Component	BC-EIM-ESH NetWeaver Enterprise Search
Priority	Correction with medium priority
Category	Program error