Skip to Content
0

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

Mar 01 at 12:40 PM

60

avatar image
Former Member

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!!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sebastian Gesiarz Mar 01 at 03:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 02 at 12:43 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Andras Margitics
Mar 02 at 08:38 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded