problem loading data with DTP

[Former Member]

Hi everyone,

I trying to load data from a DSO to a INFOCUBE, the problem is as follow. Normally in a DTP the system process packages in the request. In this case the DTP don't proccess any package but finish with status green.

When I manage the target, I see that the request finish in red.

The symptom is that the DTP don't process any request. I don´t know why.

Status: The DSO have active data, and the infocube is empty.

I don't know what happen, but I've not carry the data from the DSO to the target.

I hope that you help me,

Regards.

Jose

[Former Member]

Hello,

When creating DTP, take data from change log of ODS and try again.

[mr_v]

Try to activate DSO data, if any request available.

Make sure of conditions in transformation routine/start routine (if u wrote any) and the filters in DTP.

Reactivate Transformation (DSO --> CUBE) and corresponding DTP.

[Former Member]

Do you find any errors in DTP Monitor - Details ?

Try deleting the request and rerun the DTP.

Do you see any request ids in Header - Selections ?

[Former Member]

Answering your questions:

Do you find any errors in DTP Monitor - Details ?

No errors appear in the DTP monitor - Details, All appear in green

Try deleting the request and rerun the DTP.

I did this but still without working

Do you see any request ids in Header - Selections ?

No request apperar in Header - Selections, But the header traffic light is in red.

thanks

Jose

[Former Member]

Hi Jose,

If you are in Development system, please activate the DTP again.

Log out and log back in.

[Former Member]

Hello Raj,

I did that you told me,

but still without working

thanks

jose.

[Former Member]

Delete the request like Beekay said and run DTP again.

[Former Member]

Ok, I have to tell you something.

Another thing happen, I erase the request, and the system mark the request with the trash icon. When I refresh, the trash icon disappear and the request still there. (Thist is not common)

So I erase all data in the infocube, so the request disappear.

Afte this, I execute again the DTP, but still without working.

What else can I do?

Jose

[Former Member]

delete or ignore the current DTP and create a new one and try.

[Former Member]

Hello,

I erase the DTP and create a new DTP.

but still without working.

thanks.

[Former Member]

When I refresh, the trash icon disappear and the request still there. (Thist is not common)

This would happen if you have insufficient authorization, you can check the job log for BI_DEL or click on the request from manage itself - Display batch jobs at the bottom of - Manage - Requests.

Are you seeing the request red in Manage and Green in Monitor Details ?

Are the requests green and active in the source DSO ?

Also check if this is an auth issue - SU53 ..

In Monitor Header - Selections - You should see the requests which have been loaded from source.

[Former Member]

Answering your questions:

Are you seeing the request red in Manage and Green in Monitor Details ?

Yes in manage I see the requests in red, but in the monitor details all is in green, although there are not requests processed in the monitor details..

Are the requests green and active in the source DSO ?

Ok, this DSO is direct input, an it's filled by a APD process. So the DSO don't have active request. This DSO Just have the data in table of active data. I think that it doesn't matter because I'm trying to do the same thing between two infocubes and doesn't work too.

I'm looking that the problem y general for all warehouse.

Additional, this DTP works correct the last week.

This week begins to fail.

Could be a System problem.

What can I check??

Also check if this is an auth issue - SU53 ..

I check SU53 but all it's ok.

In Monitor Header - Selections - You should see the requests which have been loaded from source.

I don't see anything in this field.

Thanks

Jose

[Former Member]

Check if you can find anything from SM21 and ST22 .

[Former Member]

Hi,

I execute the ST22 and appear a short dump

the description is LOAD_PROGRAM_LOST

is familiar to you this dump??

the next screen says

What happened?

Runtime error

The current ABAP program "SAPLRSSG" had to be termin

of the statements could not be executed at runtime.

thanks

[Former Member]

I upload a video in youtube with the process that i'm doing.

http://www.youtube.com/watch?v=M5Yovg_dMoQ

check it and tell me your comments.

The videos is not clear at all.

thanks

[mr_v]

SAP note 452644 & 357768 may be helpful