Error while loading data into Data Storage Object

[Former Member]

Hi everybody,

I have a problem when I try to load data from the PSA into a Data Storage Object.

I always receive the following message:

Secondary index key (PSA-table/BIC0000115000) is different from DataSource key.

Message number:239.

Does anyone know what I have to do to get rid of this warning?

Thanks in advanc for your response.

Best regards

Mitch

[satish_waghmare3 · Accepted solution]

Hello Mitch,

In DataSource, There is "Fields" tab which shows list of field attributes. In this tab you will see a column with name "Key Field". Datasource Key Field is used to take care of duplicate records during the data load.(FYI - Keyfields can also in Data Transformation.)

When Secondary index key defined for PSA do not match with above Key Fields seen from Datasource, it will give you above message.

Ideally the DataSource key definition is used in order to create a secondary index on the PSA table, so it should have matched. However if the key field definition is modified in Datasource, then it may cause this kind of mismatch.

If you want to avoid this message, then try to match Secondary index key defined for PSA with Keyfield from Datasource.  I suggest you to do following

Delete the existing requests from the PSA (Tcode. RSDS or RSA1),

Replicate the DataSource and Activate the DataSource

Hope this will help.

Thank you

Satish Waghmare

[Former Member · Accepted solution]

Hello Satish,

thank you very much for your response.

Kind regards

Mitch