Error in process chain DTP not executed

[Former Member]

Hello,

Sorry tried to find the most appropriate forum, not sure it is the one. Am a newbee

In a process chain we have a event passing information from one cube to another that stops and do not go until the end of the job. But it doesn't happen all the time, which is rather strange.

Here is the log when everything goes well:

2007-11-16 Dynamic List Display 1

Job log Job log Message text uncoded Msg.typ Message ID Msg.no.

16/11/2007 10:46:44 Job started S 0 516

16/11/2007 10:46:44 Step 001 started (program RSPROCESS, variant &0000000006327, user ID ALEREMOTE) S 0 550

16/11/2007 10:46:52 Performing check and potential update for status control table S RSM1 490

16/11/2007 10:46:52 Performing check and potential update for status control table S RSM1 490

16/11/2007 10:46:53 Status 'Executable' (user ALEREMOTE) S RSBK 223

16/11/2007 10:46:53 Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_16322_1 with ID 10465300 S RSM 703

16/11/2007 10:46:58 Status 'Active' (user ALEREMOTE) S RSBK 223

16/11/2007 10:46:59 Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_16322_1 with ID 10465800 S RSM 703

16/11/2007 10:46:59 Job finished S 0 517

And here is the one when it stops:

2007-11-16 Dynamic List Display 1

Job log Job log Message text uncoded Msg.typ Message ID Msg.no.

16/11/2007 10:48:27 Job started S 0 516

16/11/2007 10:48:27 Step 001 started (program RSPROCESS, variant &0000000006327, user ID ALEREMOTE) S 0 550

16/11/2007 10:48:35 Performing check and potential update for status control table S RSM1 490

16/11/2007 10:48:36 Performing check and potential update for status control table S RSM1 490

16/11/2007 10:48:36 Status 'Executable' (user ALEREMOTE) S RSBK 223

16/11/2007 10:48:36 Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_16328_1 with ID 10483600 S RSM 703

16/11/2007 10:48:41 Status 'Active' (user ALEREMOTE) S RSBK 223

16/11/2007 10:48:42 EXTRACTION OF DATAPACKAGE 000001 S RSAR 51

16/11/2007 10:48:42 Processing of data package 000001 started S RSBK 244

16/11/2007 10:48:43 All records forwarded S RSM2 730

16/11/2007 10:48:44 SQL: 16.11.2007 10:48:44 ALEREMOTE I DBMAN 99

16/11/2007 10:48:44 ALTER TABLE "/BIC/FZHREMPL" ADD PARTITION I DBMAN 99

16/11/2007 10:48:44 /BIC/FZHREMPL0000000430 VALUES LESS THAN I DBMAN 99

16/11/2007 10:48:44 (0000000430 ) TABLESPACE "PSAPCAR" I DBMAN 99

16/11/2007 10:48:44 SQL-END: 16.11.2007 10:48:44 00:00:00 I DBMAN 99

16/11/2007 10:48:44 SQL: 16.11.2007 10:48:44 ALEREMOTE I DBMAN 99

16/11/2007 10:48:44 ALTER TABLE "/BIC/FZHREMPL" MODIFY PARTITION I DBMAN 99

16/11/2007 10:48:44 /BIC/FZHREMPL0000000430 REBUILD UNUSABLE LOCAL I DBMAN 99

16/11/2007 10:48:44 INDEXES I DBMAN 99

16/11/2007 10:48:44 SQL-END: 16.11.2007 10:48:44 00:00:00 I DBMAN 99

16/11/2007 10:48:44 SQL: 16.11.2007 10:48:44 ALEREMOTE I DBMAN 99

16/11/2007 10:48:44 ANALYZE TABLE "/BIC/FZHREMPL" PARTITION ( I DBMAN 99

16/11/2007 10:48:44 /BIC/FZHREMPL0000000430 ) ESTIMATE STATISTICS I DBMAN 99

16/11/2007 10:48:44 SAMPLE 10 PERCENT I DBMAN 99

16/11/2007 10:48:44 SQL-END: 16.11.2007 10:48:44 00:00:00 I DBMAN 99

16/11/2007 10:48:45 Job BIDTPR_16328_1 no longer exists S BT 127

16/11/2007 10:49:45 Technical status 'Green' (user ALEREMOTE) S RSBK 224

16/11/2007 10:50:45 Status transition 8 / 8 to 8 / 8 completed successfully S RSBK 222

16/11/2007 10:50:46 Overall status 'Green' (user ALEREMOTE) S RSBK 225

Can anyone help and tell me where i could search to improve performance...I don't want a plain vanilla answer but some leads to an answer would already be very helpfull

Thanks a lot in advance

[Former Member]

Dear friends

I am also facing the same issue :

Below is the job log when the DTP is completed successfully,

Job started

Step 001 started (program RSPROCESS, variant &0000000391261, user ID BWREMOTE)

Performing check and potential update for status control table

Status 'Executable' (user BWREMOTE)

Status 'Active' (user BWREMOTE)

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_335754_1 with ID 06532200

Job finished

But when its yellow forever or failed, I get the below Job log

Job started

Step 001 started (program RSPROCESS, variant &0000000391306, user ID BWREMOTE)

Performing check and potential update for status control table

Status 'Executable' (user BWREMOTE)

Status 'Active' (user BWREMOTE)

EXTRACTION OF DATAPACKAGE 000001

EXTRACTION OF DATAPACKAGE 000002

Job finished

Can anyone help, is this happening because there is no resouce available to schedule "RSBATCH_EXECUTE_PROZESS".

Any help is appreciated!

Regards

MultiABAP