Unable to execute DTP, it locks after upgrade

[ssurampally]

Hi,

I am trying to run DTP from DSO to Cube, it is not getting executed. It gets stuck and I could see that it locks the objects in SM12 but no request posted to Cube(not even an yellow one).

I am doing the tests just after the BW 7.3 SP 9 upgrade from BI 7.0 version, please let me know if any one of you faced this situation...

Thanks

Sreekanth.

[former_member182346 · Accepted solution]

hi

is this the case with all the DTPs ?

I will suggest pick the dtp (which has issue) and try to reactivate transformation and dtp using prog RSDG_TRFN_ACTIVATE , you will get the input details from table RSTRAN, and execute it successfully and see DTP works.

If worked then do for all having issues or for everything.

Thank-You.

Regards,

VB

[ssurampally · Accepted solution]

Hi Thanks for the replies,

I have run the program RSDG_RSTMPLIR_GEN_ALL ,  problem is resolved, 

got this program from the note 1604307

[MGrob]

Hi

Run RSDS_DATASOURCE_ACTIVATE_ALL and RS_TRANSTRU_ACTIVATE_ALL to reactivate all datasources and then run  RSDG_TRFN_ACTIVATE to regen all transformation.

this helped us

Martin

[RamanKorrapati]

Hi sree,

Pls try to play with DTP extraction modes serial or parallel .

Thanks