Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in process chain DTP not executed

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
Not what you were looking for? View more on this topic or Ask a question