0bbp_td_sc_1 Delta Queue Extraction error.

[shaik_sajeed2]

Hi Experts need immediate Help.

we are having the Data source 0bbp_td_sc_1 .When the particular shopping cart is edited multiple times on same day the sequence of changes comes wrong to delta queue from their to PSA.

Here in the above example .This is screen shot from PSA. Record number 903 is the latest but Record number 910 is getting overwritten the Record number 903.Means New record is getting overwritten with old record.

[Former Member · Accepted solution]

Hi Shaik,

Did you try the semantic keys in DTP which will ensure the serialization.Just mention the DSO key fields as Semantic keys and check.If it doesn't work please let me know i had another way to achieve.But this is the best.

Regards,

Rambabu

[shaik_sajeed2 · Accepted solution]

Hi Rambabu ,

I tired using semantic keys its not working.Please provide the other way of doing it.

You can reach me at sajeedsk@gmail.com

[Former Member · Accepted solution]

Hi Shaik,

Please make sure are there any time stamp fields are available in the extractor and is being updated for each record.If so in the start routine of transformation write the below code.

sort source_package ascending by dso-key1(as in ds)

                                                    dso-key2(as in ds)

                                                                 .

                                                                 .

                                                                 .

                                                                 .

                                                         timestamp field.

the above approach had its own limitation.in 99% cases it will work.  

Regard,

Rambabu

[shaik_sajeed2 · Accepted solution]

Hi Ramababu,

Thanks for suggesting. But i tired  other changing the semantic groups in DTP by adding changed data and changed time and it worked. Irrespective of sequence of records based on the time changed the records are getting in order of they have changed to DSO.The issue is solved.

[shaik_sajeed2]

We are in Version

Source SAP SRM 7.0

Target SAP NetWeaver BI 7.0

[former_member197610]

Shaik,

What is the final data you are seeing in the DSO? It should be the right numbers..

The delta type of 0BBP_TD_SC_1 DS is based on the type ‘AIMD’ (after images with deletion indicator via delta queue).

Check in your change log table and see how the records are updated in the DSO.

Check in SCN, there are more documents explains about the delta types .

Hope this helps...

[shaik_sajeed2]

Hi suresh ,

thanks for replying, in dso also same sequence is maintained and the old record is available in DSO now.

[former_member197610]

shaik,

Check your keys and data fields in the DSO. Check the Key figure properties.

Take a Shopping cart for example and analyze the data in change log and in active table of the DSO and see how the data is populated.

Hope this helps...

[shaik_sajeed2]

Hi Suresh ,

Can you please help me with this. I read your analysis on SRM Flow.

I believe you can answer this.

http://scn.sap.com/thread/3618078

Please reply me ,Eagerly waiting for your reply

sajeedsk@gmail.com