Deleted requests from PSA & missing records

[Former Member]

Hi experts,

I'm working with BI 7 but with a 3.x workflow

(datasource -> infosource -> dso with DELTA infopackage of the datasource which loads datas on PSA and directly on DSO).

A process chain is used to launch infopackage (which loads PSA and DSO) and to activate datas in the DSO.

The last requet of the PSA was wrong with no data in PSA and the request before this wrong request was too wrong because the DSO was not good activated.

So :

- 30.05.2008 : request in error in PSA with 0 datas

- 23.05.2008 : request in error in PSA because of bad activation of DSO with 1.000.000 records

So I deleted from the PSA these two wrong requests puting them red status.

But this morning I manually loaded datas in the PSA then DSO with the infopackage, and the PSA recovers less than the 1.000.000 records !! (80.000 records !).

Where are my 1.000.000 records ???

My problem is to get all the 1.000.000 (and more) records in the PSA !! (and the DSO) !!

Can you help me please ??

Points will be assigned !

Vince.

[Former Member]

First thing, even there is some error in the request, we never delete it from the PSA. We always delete it from the data target.

Since, you have deleted the request from the PSA, it wont be available for reconstruction also, because you get a req. in reconstruction tab only when data is present in the PSA.

In your case, data is lost as you have delted PSA also.

If you are not into Production environment, I'll suggest you to reinit again from the R3.

Please keep updating.

Thanks...

Shambhu

[Former Member]

So you think I should initialize PSA and DSO ? (many hours or perhaps days)

[Former Member]

Hi,

While loaded from PSA to DSO how many records are transfered and how many are added records.

If any routines exist then your records will reduce in DSO.

If no routines everything 1:1 mapping then It is strange to check this.

How many records are present to run load to PSA.

You mentioned already u runned the reload for psa.

If not reload the data to PSA and then to DSO.

Check for any data consistency.

Hope this will help you,

Regards,

Anand Tej

[Former Member]

Hi,

Once again make the Request red and load to PSA and run the delta's to DSO If not run the Repair full request to DSO from PSA.

Regards,

Anand Tej.

[Former Member]

There is only one possibility....if before deleting, you have forget to make the QM status red of the request, the delta will be lost.

Now, check in the reconstruction tab whether these request of 23 and 30 is present. if yes, reconstruct it from there.

Thanks..

Shambhu

[Former Member]

I forgot to make the QM status red of the request in the PSA.

After deleting these request in PSA, I put in red this status (in the monitor of the corresponding infopackage).

- So do you think that my records are really lost ?

- The recontruction is just for DSO, not for PSA (of Datasource), isn't it ? Else, where can i reconstruct for my PSA ? And if I can reconstruct for the PSA, how can i get these "lost" records ?

PS : I think I can't do a "full repair" from PSA because my records are too lost in the PSA.

[Former Member]

Hi,

Can you please let me know if the InfoPackage loads Delta data from DataSource to DSO via PSA?

Has this load gone wrong successively?

I shall be able to suggest based on the above replies.

[Former Member]

Vince,

This is reaaly strange....do one thing...try to activate this request....there is a possibility that you might be having some routines....which is causing this records mismatch.

After activation, see how many records its showing in the dso.\

Thanks,..

Shambhu

[Former Member]

The activation is still done.

The records are missing in the PSA (and so in DSO).

The load time was this morning 5-6 minutes but for the deleted request with the 1.000.000 records this load time was more than one hour...

Is there a problem with the Delta ? (change log table, ....?) I'm not very good for this subject.