Skip to Content
author's profile photo Former Member
Former Member

Wrong records do not appear in PSA

Posted on Aug 03, 2006 at 09:08 AM 6 Views

Hello,

I have a problem, because some wrong records in a load do not appear in PSA errors.

They are duplicated in the start routine of the update rules, so they are not original from the source system, but created modifying the data_package table in the start routine. So, when you make a load to a cube, the load fails, but it is not possible to go the error psa.

Does anybody know why the PSA is not generated?

Regards, Inma

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:13 AM

    Hi,

    PSA contains the original data that you take from source system. PSA contains un-modified data.

    Update rules come into picture after PSA, so PSA wont have those error records.

    You should debug the routine anc check.

    Thanks,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:25 AM

    Hi Inma,

    That because the PSA step comes in the data flow before the update rules.

    The data flow is like this: PSA -> Transfer rules -> Update rules -> Data target.

    Bye

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:34 AM

    Hi

    PSA do not contain transformed data. It contains the data as-it-is from the source system and on that data update rule transformation takes place.

    Load the data till PSA and then using Infopackage monitor detail tab you can debug the update rules to find out where exactly it is going wrong.

    Regards

    Pradip

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 03, 2006 at 09:50 AM

      Hello,

      Wrong records? Anything which is posted in R/3 will be picked up in psa.

      if there are special characters, only then the psa may highlight them as incorrect.

      but if there is any mistake in say the date input or any field input(i.e wrong value input by mistake from the drop down), psa won't know if it is wrong from business point of view.

      Such incorrect values need to be validated by R/3 side. Anything that is posted in source system is simply picked up in psa.

      Hope it helps..

      thanks,

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 10:00 AM

    Hi Inma,

    The PSA validation only includes checking whether the data format for the source system is correct or not. In case the data is wrongly assigned and if the data types match even then you would get an error in the PSA. It also check if it contains any special characters or not.

    What exactly is your error? If you can post here you should get the solution.

    Bye

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded