DTP records from PSA to Std DSO

[Former Member]

Hi Gurus,

My PSA from transactional data source has 15000 records which is coming in through IP full load. The transformations and the end routines are correctly working fine as I tested it in a diff flow that uses the same the transformation and routines. While executing the DTP it bot bringing any records from PSA. I tried deleting the request and executing again and it did not work. I also deleted the PSA request and re-scheduled the IP--the DTP which delta still is into bringing any records.

Please advice.

thanks!

[former_member199691 · Accepted solution]

I will suggest to go step by step to find out the issue e.g.

- firstly comment the end routine and see if you get any records. If yes, it means you need to check your start routine.

- In start routine, you can comment your delete statements and see if you get any records.

Regards,

Gaurav

[Former Member · Accepted solution]

Gaurav,

I already did the part that you just mentioned. Any other views or ideas that I can implement?

thanks!

[former_member199691 · Accepted solution]

did you find which part of the routine is creating issues?

[Former Member · Accepted solution]

routine is fine as I mentioned that I am using the same in another flow to the same std dso.. basically my DSO has two sources one from WODSO and one from transactional data source having the same filter and mapping. the WODSO DTP is working fine.. onyl the data source is giving problem.. and this model is being implemented in production too... I modified this one last month in dev and everything works fine in prod. Now the same model has some enhancements going in.. and the DTP is not bringing any records..

Please advice

[former_member182343 · Accepted solution]

Hi,

Did you checked the status of request st PSA of transaction datasource.

Did you got any error. What is the error message.

Is it short dump?

- rvc

[Former Member · Accepted solution]

hi vijay,

no error, no short dump, 15000 records are there in 1 data packet.. requests are all green.. any suggestion?

[former_member182343 · Accepted solution]

Hi,

Try to do this:

SE16 >> RSBODSLOG >> <ODSOBJECT> >> sort descending on REQUID

session 2: SE16 >> RSBODSLOGSTATE >> <ODSOBJECT> >> <ACTIVE> will have the last active req. number of the ods <PROCESSED_ALL> and <PROCESSED_ONE> fields should be 0 or have the highest number of REQUID from RSBODSLOG.

Run this one first

RSBO_PROCESSEDALL_SET

then

Use FM RSBO_PROCESSEDONE_SET

to set Processsed_One / Processed_all field to 0.

Then recontruct the request again and activate.

- rvc

[Former Member · Accepted solution]

Hi,

Since PSA is full load ,you can change the extraction mode as Full in DTP and check once.If it works, in process chain u keep Detele PSA data and delete overlapping request processes to avoid duplicate records.

Thanks

Bin.

[Former Member · Accepted solution]

Hi,

If the data load is to DSO then no need to keep above processes in process chain as DSO has overwriting functionality.

[Former Member · Accepted solution]

the DTP used in PC is delta load...I am still at loss at what I should do-- the PSA request is green.. in DSO 15000 records are transferred but 0 added. Code works perfectly fine... Is there any other scenarios that I can look into?

[Former Member]

Hello Everyone,

thanks for the help. I fixed it. It seems the filter in start routine was deleting the value since from data source I didnot had any records from 01012011 onwards.

thanks!

[former_member183113]

hai ..how u fixed this error????? can u post it here clearly???

[Former Member]

there was a delete statement in SR which was deleting the records past 01/01/2011. Basically my source was not bringing the 01/01/2011 records in PSA. So, for testing I modified some records to 2011 and then tested. So, it worked fine...

[Former Member]

this is the message I get in logs:

Message Text

Server group (for Activation): No Server Group Configured

Technical Data

Message type__________	I (Information)
Message class_________	RSODSO_TOOLS
Message number________	022
Message variable 1____	Activation
Message variable 2____	No Server Group Configured
Message variable 3____
Message variable 4____

Message Attributes

Level of detail_______	3 (Level of detail 3)
Problem class_________
Sort criterion________
Number________________