Data Flow issue

[Former Member]

Hello, I have a 3.5 data flow and some time it brings me some bad records into BW so these are the steps that I take to fix those records.

First turn the light red in DSO and delete the request.

Go into monitor and check the problematic records and fix them manually in PSA and SAVE.

then, schedule the request to be updated manually from PSA in to the dso.

once it is loaded then turn the light green

but then when i go back in to monitor and see those problematic records they are back to status "ERRONEOUS STATUS".

but the problem is here.

When I look at Transferred/Added records in the DSO it shows me some shortage of number of records for example: if I brought in 100 recs from ecc. and 2 recs are bad after following the above steps it shows for transferred/added as 100/98 and 2 records that i have corrected in PSA are missing in NEW TABLE of DSO.  i want to know how to push those 2 records in to my DSO. thanks

[anilkumar_kalkivai · Accepted solution]

Hi,

Check the PSA records which are changed whether they are in changed state or previous state.

Regards,

Anil.

[Former Member · Accepted solution]

Anil, they are in previous state and I am not sure why, because I changed them and saved them, they showed the changed symbol on them but now they are back to error status.

[anilkumar_kalkivai · Accepted solution]

Hi,

As others told try changing the records in PSA try to save it again, if it does not work.

There is an other way if they have infopackage data selection but it is not recommended for just two records, if you want you can try,

Delete the PSA request and Use the ABAP Routine method in the infopackage data selection try changing the records as per your requirement and then try to trigger infopackage again.

Regards,

Anil.

[former_member188080]

Hi Venkat,

I think they are appearing in PSA fledge and once u correct them and save them . You have to update them again there is button to process them further to data target.

see if it works.

Thanks and regards

Kiran

[Former Member]

Kiran, what do you mean by PSA fledge?  also is that button called "Schedular", if yes then I am using the very button.

[Former Member]

Hi,

First do the modifications correctly in the PSA then you need to update to manually to the upper layer.

It might works fine...

Thanks,

Purushotham.

[Former Member]

Puru, it is done correctly what else can i do?

[former_member378735]

HI,

Please check if you saved the edited records.

Then after pushing from PSA manually and the upload completes change status back to technical status.

Regards,

Sunith

[Former Member]

Sunith, thanks, i DO save them, i exit the screen go back in and make sure they are still in changed status.  after loading when i try to do what you are saying that click on the monitor light on manage screen of the DSO and select the radio button to change back to tech. status which already has that status then i get this message:

"REQ ****  in Datastoreobject NAME must have QM status green before it is activated"

i am afraid if i turn the green manually and activate i will lose those records.

[former_member182470]

Hi,

After rectifying on PSA, you need to save and update through scheduler. Finally activate the request in DSO. Then it automatically turns to green.

You should not do it manually.

If you do like that your second problem regarding transferred records will also be resolved.

REgards,

Suman

[Former Member]

Suman, thank you. I am doing what you said about saving in PSA and saving.  but when i try to activate the red request, it says

"REQ ****  in Datastoreobject NAME must have QM status green before it is activated"

Should I make it green manually and then activate?

thanks    

[RamanKorrapati]

Hi Venkat,

Your doing something wrong. but not sure where your doing.

Please tell me:

1. At DSO how many request are red? if yes then  why? its there

2. You loaded one request today with 100 records, 2 records wrong, delete req at DSO level.

3. At PSA you edited 2 wrong records,saved, reloaded.if yes then this req will green once load was success.

4. which req your turned red to green?? without rectifying?

5. if you rectified, then why its req was there

Thanks

[Former Member]

Ok, i only have one request red right now at the DSO level.  I am planning to do the following:

Delete that request from the DSO level.

Go into PSA and correct the records that have errors in them.

then go to datasource, right click on it and hit manage, then select the same request, go in to the request correct the error records, save them.

come back to data source , right click on the datasource, click on manage, select the request and click on UPDATE WITH SCHEDULAR. 

i have done this in the past as well.

once data gets loaded in to the DSO :

this is what will happen at the dso level is i have a total of 100 records and i edited 2 of them.

If i go in to the manage of DSO transferred column will show 100 records and added column will show 98 records which means the data records that i edited did not get added to the dso. moreover, i can not find those records in NEW TABLE.  ALSO, the same request would still have the red monitor light on it.  and at this time if i go back in to the psa request the same records that i had corrected in the past would have "ERRONEOUS RECORDS" symbol on them when earlier before updating to the data target it was showing as "CHANGED RECORDS".  HOW is this possible? Please help. thanks.

[RamanKorrapati]

Hi venkat,

am not familiar with that option Update with scheduler.

You followed correct steps. but its look like something causing.

please try this way.

1. Find the wrong 2 records.

2. at DSO level, make the request red an delete it.

3. Edit the wrong records at PSA  and save it.

4. Go to DSO--> right click--> manage---> reconstruction.

5. there you may see deleted request. select that  red request and click on reconstruction/insert.

6. keep on refresh. from that area request will vanish.

7. check request at Request tab. if it success then try to do activate.

Thanks

[former_member182470]

After correcting the records in PSA, save them by clicking on Save on top.

Update through scheduler-->Select your DSO in targets-->execute to load this req to DSO.

Make sure you have deleted the red request before starting to activate this req(which is loaded from PSA). Activate it and check the transfered/added records count. Hope you don't have any routines.

Regards,

Suman

[RamanKorrapati]

Hi Venkat,

At montor screen don't see the red request. at target level you can check the latest request which you loaded with corrected data from PSA.

Thanks