DTP in Process Chain always reports error

[Former Member]

Hi gurus here.

When the process chain sheduled in background it reports an error, but execute it manually it works well.

So what's wrong?

Thanks,for your help.

[former_member188080]

Hi,

Check following things

1. Check whether sufficient background processes are available or not

2. Check in SU53 whether there is any authrisation error

3. Check whether ALEREMOTE/BW REMOTE user access is not expired. Check in SM59.

4. mYSELF SOURCE system connection/authorisation test in SM59.

I hope this helps.

Thanks and regards

Kiran

[Former Member]

Hi,thanks. I've checked the field foutine and ensure there is no so-called error "Division by zero".

The error is sent by email,it's content:

Alert ID: ##00005##

Process DTP_DBCWF9I41QGNNA1N8O18RMZPC of Type DTP_LOAD (Instance

DTPR_DBQ4A2WJWV0M0EVRM9O8GAOCM) Has Errors in Process Chain

ZPC_BUDGETVSACTUAL_DELTA, Run DBQ4A2WJWUMRP903UJV78LJGM

Process ZOD_SD02 -> ZOD_SD04 Of Type Data Transfer Process Has Status

Ended with errors (Process Chain SD Budget VS Actual) It is now

05:30:09 on 24.11.2011 (time zone CET) Current Process Chain Run:

DBQ4A2WJWUMRP903UJV78LJGM in System BWP (Host SAN00190)

Error:

-

---

Process Data Transfer Process , variant ZOD_SD02 -> ZOD_SD04 has status

Ended with errors (instance DTPR_DBQ4A2WJWV0M0EVRM9O8GAOCM )

-

---

Update terminated in accordance with error handling setting

-

---

Division by zero

-

---

An exception has occurred

-

---

Error in substep

-

---

Messages for 1 data records saved; request is red acc. to configuration

Diagnosis Messages have been created for 1 data records. 1 of these

data records have not been processed further because of serious errors

in the data in these records.

The overall status of the request has been set to red in order to

prevent reporting on the valid data records.

Procedure

Correct the data records that have been filtered out in the error stack

of the DTP and use an error DTP to update these data records.

-

---

Data package 1 / 24.11.2011 05:30:09 / Status 'Processed with Errors '

Log for the Current Process:

-

---

Update terminated in accordance with error handling setting Division by

zero An exception has occurred Error in substep Messages for 1 data

records saved; request is red acc. to configuration Data package 1 /

24.11.2011 05:30:09 / Status 'Processed with Errors '

-

---

Log of Respective Background Job:

Job started

Step 001 started (program RSPROCESS, variant &0000000016763, user ID

ALEREMOTE) Start process DTP_LOAD DTP_DBCWF9I41QGNNA1N8O18RMZPC in run

DBQ4A2WJWUMRP903UJV78LJGM of chain ZPC_BUDGETVSACTUAL_DELTA Performing

check and potential update for status control table Performing check

and potential update for status control table

Source-Request-List: 16.799

Status 'Executable' (user ALEREMOTE)

Status 'Active' (user ALEREMOTE)

Start of Serial Processing Processing is Executed in a Separate LUW End

of Serial Processing Exeucted in a Separate LUW Program

RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIDTPR_16802_1

with ID 12300500 Job finished

-

---

Information for Process

DataSource Object as Source: ZOD_SD02

DataStore Object: ZOD_SD04

No. of Incorrect Records: 0

Number of Data Records Selected: 750

Number of Data Records Received: 0

Status of DTP Request (Domain RSBKUSTATE): 3

[Former Member]

Whenever we schedule data load through process chain "ALEREMOTE" user came in picture. your's ALEREMOTE may not have authorization.

You can check it by Right click on failed process varaint in your process chain --> Displying Messages --> then select Tab "Backg" . Here you find the proper reason of failure.

Regards,

Sushant

[Former Member]

what error does the DTP throw when the process chain is executed in background can you mention it ?

[Former Member]

what is the error, can you share some details. Also, check if you user has the required access to schedule a job in the background. you can do that from SU53 tcode. run an SU53 after you receive the error.

Regards,

Parth.