Unable to replicate CDPOS table through SDI connenction using Oracle ECC Adapter

[sameer_mehta]

Hello,

I replicated the CDPOS table in SDI using OracleECC adapter but while retreiving the data, I am getting following error:

Decluster metadata caching failed: No metadata found for physical table CDCLS for query "SELECT "CDPOS"."MANDANT", "CDPOS"."OBJECTCLAS", "CDPOS"."OBJECTID", "CDPOS"."CHANGENR", "CDPOS"."TABNAME", "CDPOS"."TABKEY", "CDPOS"."FNAME", "CDPOS"."CHNGIND", "CDPOS"."TEXT_CASE", "CDPOS"."UNIT_OLD", "CDPOS"."UNIT_NEW"

Please let me know if anybody has faced this issue and any tips to resolve it.

Thanks,

Sameer

[jeffrey_kresse · Accepted solution]

Looks to be related to ECC Metadata dictionary tables. It depends what version of HANA and DPAgent you have, but possible need to load the dictionaries into a HANA schema like in this documentation: https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS02/en-US/f38fb0318e144bcab5372f9...

[sameer_mehta]

Thanks Jeff for the answer.

I am not getting, where to locate 'replicate_dictionary.sql'?

Thanks,

Sameer