Every DTP running turn to yellow forever only in development system whereas

[former_member245361]

Hi Friends,

I run a DTP (any DTP) will result as yellow(and yellow for days then turn red),look up the job overview,is "finished" what's wrong with the system? It shows the transfered records as 33773 but added as 0 records.

-

---

In DTP monitor under Processing request

Data Package 1 ( 33773 Data Records ) [yellow]

1) Extraction DataSource ..... : 33773 Data Records [green]

2) No Message: Prepare Error Handling [yellow]

3) No Message: RSDS DTP[yellow]

4) No Message: Updating to InfoCube ..... [yellow]

Next No More Data Available step is [green]

No Message: Set Technical Status to Green [yellow]

No Message: Set Overall Status to Green [yellow]

-

---

Joblog for Jobname: BIDTPR_294774_1(finished)

Job started

Step 001 started (program RSBATCH_EXECUTE_PROZESS, variant &0000001184716, user ID BWALEREMOTE)

LOGID: D66I8PANRE2RNJ818EOPB5RG5

EXTRACTION OF DATAPACKAGE 000001

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_294774_1 with ID 15125800

EXTRACTION OF DATAPACKAGE 000002

Job finished

Thanks

[Former Member · Accepted solution]

Hi,

Contact your Basis team and ask them about the tablespace in your development system.

I had faced a similar issue sometime back. It got solved after the tablespace was increased.

Hope this helps...

[former_member245361 · Accepted solution]

Thanks for the reply

but the Info package is running fine in DEV system ,so I gues there should not be the table space prolem.

Can u just elaborate which table space you are talking about so that i can pass the same to our BASIS folks here.

Thank U !!!!!

[Former Member · Accepted solution]

I am talking about the database space, which can be seen using DB02 t-code

[former_member245361 · Accepted solution]

BASIS confirmed a lot of spaces free in the system(30%)

Probably the problem lies in other area I guess,

[former_member245361]

Hi Friends,

did not get a solution till for this issue.. we also checked with our BASIS Team, this is not a space issue. could u help me .

[Former Member]

Hi,

What is the DTP Error message after the status turned Red.

Thanks,

ChandraDeepak

[Former Member]

Hi,

Also check the code written if any between Source and Target.

Might be it's not working properly.

Check is there any filters in DTP.

Let us know the details of your data flow.

Reg

Pra

[former_member245361]

Hi Pra,

Its not a code problem because there is no maping with coding between PSA and Cube.and the same DTPs running fine in Production.

and after executing the load in RSMO screen if we see a job over view for this particular load starting TWO jobs with same technical name,.in that two ,one job showing as status *Ready" then next one is geting finsh after few seconds. the status "Ready" job not geting Activation .

[former_member245361]

Hi Chandra,

No error message is giving..after 1 or 2 days request status changing to "Red" ,

After deleting the red request If I execute the DTP again ..in SM37 Job overveiw screen with same technical name two jobs are scheduling , in that one is shaowing the status as "Ready" , and the other one is geting Finish.

[Former Member]

Hi ,

1. Double click on the info-package and check the schedule tab there we have a setting where u have check box to change the setting to set the status of the request from Yellow to Green.

As the requets will stay in yelow untill all the data targets request become green.

Also check if the PSA tablespace is set to autoextended mode.

Also try delete unused PSA data .

Hope that helps

Thanks

Mukesh

[former_member245361]

Hi Mukesh Thyanks for the reply,

the problem was when we run the DTP , In the job overview screen (sm37) particuler job status was showing as "Ready" , due to this job request remain yellow with "zero" added records.

for this we find a solution that,in the Job overveiw(SM37) screen selected the "Ready" status job then in the same screen top left side clicked on the option Job>check status(ctlshiftf12)-> one pop-up will come> selected the option> Start ASAP, then the status "Ready" job get activated . then in few seconds it has finished .

Note: for status "Ready" jobs only the pop-up option will come, in that we can find 3 options 1. Start ASAP 2. schedule 3. Cancel

Regards ,

Zurki

[Former Member]

Hi Zurki,

It's a very good reply from you.

Keep updating if you found any.

Reg

Pra