Transport import error: Attribute xxx is invalid in masterdata cache store for dimension XXXXX

[Former Member]

Hi Friends,

I am getting below transport import error and please suggest me.

Attribute xxx is invalid in masterdata cache store for dimension xxxx

But dimension with that particular attribute imported into target system but not data even though I collected both dim definition and members.

I have recently added around 15 properties and all these properties giving this problem.

Thanks,

Kumar

[Former Member · Accepted solution]

Hi Kumar

One of the possible reasons could be that your dynamic dimension table and BW dimension table are out of sync.

Have you tried to run the program UJA_REFRESH_DIM_CACHE on the target system, and then try to re-import the transport again ?

• Was the dimension processed on the source system before you generated the transport ?
• Do you have any values in the dimension that you want to transport?

You can use the following below links for assistance in troubleshooting the transport errors

SAP BPC 10 Transport Guide

BPC 10 - UJA_REFRESH_DIM_CACHE

BPC-NW Transports - Configuration and Error Assessment (versions 10 and 10.1 Classic)

Hope this helps,

Kind Regards

Daniel

[former_member196060]

Note 2163622

[Former Member]

Thanks for all you replies.

BPC QA hosted by 2 servers. One one server transport import failing and basis person tried to do it on 2nd server and it went successful. I don't know technically at basis level. 

[former_member190501]

Hi,

Have you done any direct changes in PRD before transport?

Thanks,

Raju

[Former Member]

No, I haven't done. 

Other transports also failing even that TR doesn't have this dimension(WBS). E.g: One user defined dim.

Thanks