Skip to Content
avatar image
Former Member

DTP keeps trying to load from wrong PSA table

Hello experts,

I have a Problem concerning a DTP thta keeps trying to load from a PSA table that doesn't exist anymore. I executetd

RSAR_PSA_CLEANUP_DIRECTORY

RSAR_PSA_NEWS_MAPPING_CHECK

RSBKDTPREPAIR

several times but the problem stays the same.

I can see two entries in the table RSTSODS marked as ACT for my data source an i can't get rid of the wrong one (which doesn't exist anymore)

I should probably mention that we upgraded to 7.4 and HANA and that I am talking about a 3.x Metadate Attribute Datasource.

My question now is:Does anybody know a way to get the DTP to load from the correct PSA table?

Thanks in advance!

Take care,

Petra

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 02, 2016 at 12:50 PM

    Hi Raman and Sander,

    thanks you for your replies. What actually did solve the Problem was using the Report

    RSAR_PSA_CLEANUP_DEFINITION

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2016 at 09:21 AM

    Hi Petra,

    In addition to what you already tried I suggest to activate the DataSource in the affected system.

    If that does not help, then there might be an inconsistency in BW. In this case I suggest to raise an SAP Support message.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2016 at 09:44 AM

    Hi Petra,

    if your facing this at prod system, please try to do below things.

    1. Retransport your data source form dev source to prod source system.

    2. Replicate data source into bw system(dev/prod)

    3. Later you can transport bw dev active data source to bw prod.

    4.Once your data source was active prod, then you can activate rest of the flow or retransport(rest of the data flow) thru transport from dev.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded