Skip to Content

Fields with variable length (STRG, SSTR, RSTR) must not be key fields

Hi,

I am facing issue while activating the data source.

Error : Field NODENAME : Fields with variable length (STRG, SSTR, RSTR) must not be key fields. Please help me to fix the issue. Thanks!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 01 at 03:22 PM

    Hi Srinivasa,

    STRING fields can not be flagged as key fields because this results in an error during the generation of the Persistent Staging Area (PSA) (an index is not allowed to contain an STRG, SSTR, or RSTR field).

    You have to either unmark those fields as Key Fields or change it's type.

    Kind regards,

    Sebastian

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02 at 12:43 PM

    Hi Sebastian,

    Recently we upgraded Dev system to 7.5, earlier it was 7.4. Currently in Acceptance and Production system filed NODENAME was a key field with data type SSTRING and it's not giving any error. May be post upgrade we should not allow to make String fields as a key, if that is the case how can I achieve the same functionality.

    Thanks & Regards

    Sri

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02 at 08:38 AM

    Hi Srinivasa,

    Check NODENAME on Fields tab of DataSource

    BW does not support string format key field, the key fields are restricted in such a way that the requirements of all supported database platforms are met. See more here:

    https://help.sap.com/saphelp_nw74/helpdata/en/4a/40815bacb51cece10000000a42189b/frameset.htm

    https://help.sap.com/saphelp_nw74/helpdata/en/4a/1be8b2aece044fe10000000a421937/frameset.htm

    Best regards, Andras

    Add comment
    10|10000 characters needed characters exceeded