Problems with transport dimensions, masterdata cache store is missing for dimension

[Olj]

Hi Dear Experts,

We have some problems with transport environment to QAS system(before trans works properly),

after transport we get an error (8):

Table YMD17B3 does not exist

Failed to import entity Dimension, ID:VERSION

Table YMD17B3 really does not exist, but table /CPMB/YMD17B3 (Version) is exist in both systems.

UJA_DATA_CHECKER - in development system is good, but in QAS system error - Masterdata cache store is missing for dimension VERSION

Can you help me please?

STMS error:

[former_member193143]

Hello Daulet,

please follow the following steps.

1. In the target system, open SAP GUI
2. Run transaction SE38
3. Run the program UJA_REFRESH_DIM_CACHE
4. Select the environment in 'Environment Id' field and choose the you entity(which dimension causing problem) dimension in 'Dimension Id' field (leave the option "Re-generate Cache File?" ticked by default)
5. Click on 'Execute'
6. Import again the transport request

Hope this will help you ..

Best Regards,

Saida Reddy Gogireddy

[Olj]

Thank Saida,

But your decision does not help ...

I got an error in UJA_REFRESH_DIM_CACHE: Table YMD17B3 does not exist

[former_member193143]

Hello Daulet,

can you please check whether that dimension is available in target system or not.

Thank you very much

Best Regards,

Saida Reddy Gogireddy

[Olj]

Hi Saida,

Dimensions is available in target system.

In target system UJA_DATA_CHECKER is getting error:

[former_member193143]

Hello Daulet,

Can you please run the following programs

UJXO_CLEAN_CACHE	Clean Query Cache
UJXO_CLEAN_DIM_CACHE	Program UJXO_CLEAN_DIM_CACHE

let me know whether it works or not...?

Best Regards,

Saida Reddy Gogireddy

[Olj]

Hi Saida,

are these programs harmless to the system? Must I switch to offline environment?

[former_member193143]

No I don't think so its required, These program will clear the cache ..

After that run UJA_DATA_CHECKER also ..

Regards,

Saida Reddy Gogireddy

[Olj]

Hi Saida,

your resolution doesn't help me.

I've got the same errors ...

[chuan_ding]

Hi Daulet

Can you check if infoobject VERSION is available in RSA1(BW)?
if yes, you may run program UJA_GEN_SLT_TBL.(see note 1774880 for details)

Best regards,
Chuan

[Olj]

Hi Chuan Ding,

Thank you,

but this note is not suitable for us, we have newer SP.