Unchecked SAP HANA processing possible check box in Transformation

[former_member210615]

Dear Experts,

I am having one wierd issue in BW HANA system, I have create one transformation in my dev environment is direct 1:1 mappings and no start or end routine, for that I could see that option of HANA processing possible is checked mark automatically, so when i created DTP for this transformation it has default option of SAP HANA execution checked.

when i moved my transformation to QA environment, that checbox of HANA processing is unchecked in transformation while the DTP still has HANA execution checked somehow, when i try to run the DTP it gives error  Transformation ODSO  ABC123 -> ODSO ABC234  must not be executed on HANA.

I am failing to understand why this happened in QA while in dev everything was fine, I tried retransport still that issue is not going.

I noticed one more thing In dev i could see HANA generated transformation process, while in QA  i got an error "Prefix 'TR_' for HANA transformation is missing" if i try to generate HANA generated transformation.

Please provide your suggestion on same on why this issue happend and how to correct in QA.

BW version :            7.4 SP11

HANA DB version:   1.00.85.02.399857

regards

laksh

[former_member210615 · Accepted solution]

sorry guys for late reply...... issue was solved  by re activating the transformation through program rsdg_trfn_activate then everything become consistent automatically and was able to run DTP as well.....

..... weird thing though but thats world we live in

[Former Member]

hi Laksh,

as a quick solution maybe re-create transformation and DTP with checkbox 'SAP HANA processing possible' unselected?

you could also check whether this OSS Note (relevant for your SP11) has been already applied:

2149500 - SAP HANA Processing: BW 7.40 SP09-SP11: HANA Analysis Processes and HANA Transformations (Part 13)

kind regards, Andrei

[Former Member]

Hi Laksh, yes it is recommend to implement ALL notes with "..HANA Analysis Processes and HANA Transformations" up to part 19

Best regards, Andras

[former_member210615]

just to add to one more thing,even if i try to run the DTP, it  fails giving error message:  Analysis process 'TR_00O2*******' is not active. Execution not possible.

[alessandro_gandelli]

Hi,

try checking the trfn in QA system.

And see if it gives you some good error messages.

[former_member210615]

Hello Alessandro,

it gives success message, when i click on that check.

The transformation can be processed in SAP HANA

[alessandro_gandelli]

Hi Laksh,

have you tried to re-activate the transformation and the dtp?

Regards.

[former_member216148]

Hi..This case is weird. I can send you some links on this topic and hope you will find your solution.

Emerging best practices for SAP BW HANA data modeling & reporting: Q&A with Dr. Bjarne Berg...

76 Steps in a BW-to-HANA Migration Workplan</title><meta name="news_keywords" co...

Regards

Saad

[former_member210615]

Hello Saad,

link you shared were informative but sadly they didnt help in resolution of current problem.

It will be great if you can share pointer in order to solve the issue in hand