missed get delta once option in dtp and transported to prod

[Former Member]

hi all

we have transported DTP for our infocube 0wbs_c11 into production.

This infocube 0wbs_c11 is loaded from 4 datasources of which one datasource supports delta and rest donot.

so in process chains we are using the option for delete overlapping requests. for all the 3 datasources which doesnot support delta.

But for one of these 3 datasources we have transported DTP without ticking GET DELTA ONCE OPTION AND loaded to infocube.

now we should tick the get delta once option and transport it to production, where we already ran this dtp once.

Since we cannot enable the get delta once option enabled in dtp after the first dtp run

my question is should i delete the request from infocube and transport the dtp transport request (to prod )with getdelta once option ticked and run the dtp again will it work.

or do i need to delete the request as well as dtp from prod and then transport the new request with delta once option ticked.

regards

krishna

[Former Member · Accepted solution]

Hi Krishna,

No need to delete the DTP, just delete the request from target.

move the DTP with get delta option checked and run the DTP in Prod.

this will rectify your issue.

Regards,

Venkatesh

[Former Member]

Hi Krishna,

As suggested by others, no need to delete the old DTP. Leave it as it is now in prod.

Just delete the request from cube. Modify the DTP and transport to prod. Then run the DTP in prod. Your problem will be solved.

Indrashis

[Former Member]

thanks all for the replies....

I have deleted the request from ic in prod and transported new request from dev to prod.(having get delta once option ticked for dtp)then deleted request from psa and have done ip and dtp it worked .

but now i see in development all the trnasforamtions and dtp's from all these 4 datasources as inactive.

and when i am activating it is prompting me a transport request.

why have these transformations and dtps got inactive in development whereas in my prod all are active.

regards

[Former Member]

Hi Krishna,

If you do any changes to DTP, transformations will get in active.

use the program RSDG_TRFN_ACTIVATE to activate the transformations

Regards,

Venkatesh

[Former Member]

ya i have run the program for all four transformations and they got active but what about dtp's they are still inactive. when i am trying to activate dtp's directly it is asking me for request.

and can you tell me why these transformations and dtps got inactive when i have changed only one dtp and transported it to prod and all of them are active in prod?

regards

Edited by: krishnav3.5 on Sep 16, 2011 3:41 PM

[Former Member]

Hi Krishna,

We have program RSDKDTPREPAIR to activate the DTP, but in this we don't have any selections and it will activate all the DTP's in your system.It recommended to run this program in background.

If you want to create Z program to activate the DTP based on DTP selection, in the below article you have code.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d02513b2-7fb6-2c10-3a8b-887fc115d...

Regards,

Venkatesh

[Former Member]

here in the above post i see that when we run the process chains it will activate dtp's

does this really work ?

regards

[Former Member]

Hi Kirshna,

As he told it's working, why can't you give a try.but do this in DEV.

Regards,

Venkatesh

[Former Member]

based on the above link which says after activating transformations using the program rsdg_trfn_activate if we run process chain the dtp's get activated by itself

i have done a trial based on the above point

i went to dtp execute tab and press execute ,and when it asks me for furthur process

YES NO CANCEL

I have cancelled the execution of dtp.

and now when i refresh the tree the dtp is seen active .

i followe the same for all.

regards

Edited by: krishnav3.5 on Sep 16, 2011 4:17 PM

[Former Member]

Hi Krishan,

If your DTP is inactive, then execute button will be in disable mode.

as you said you pressed cancel, goto monitor and check you will DTP request is running.

Regards,

Venkatesh

[former_member199691]

You need to use get delta only once option if you do not want to load a request from PSA even if request from the target is deleted. In case of full load, if you have Delta DTP, it will load the new request only. Even then if you need to change the DTP, I would suggest the delete the request from production before transporting the DTP change.

Regards,

Gaurav