Skip to Content
0
Apr 19, 2013 at 07:20 AM

Delta update process failed due to unknown reason

427 Views

Hi Experts,

We have three delta update process in BW everyday but suddenly failed from 03/26.

In BW, the monitor shows the red light and give the messages

"

Error message from the source system

Diagnosis

An error occurred in the source system.

System response

Caller 09 contains an error message.

Further analysis:

The error occurred in Extractor .

Refer to the error message.

Procedure

How you remove the error depends on the error message.

"

Then I checked the background job logs in source system, our ERP system., the background job shows finish with success with below job logs:

"

Job started

Step 001 started (program SBIE0001, variant &0000000101727, user ID ALEREMOTE1)

Format "X_PAPER" not defined for printer "$LP01"

Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)

DATASOURCE = 0CO_OM_CCA_9

RLOGSYS = PBP300

REQUNR = REQU_3EIIQ0Z18PLUIQYK0XISPTLSV

UPDMODE = D

LANGUAGES = *

*************************************************************************

* Current Values for Selected Profile Parameters *

*************************************************************************

* abap/heap_area_nondia......... 2000683008 *

* abap/heap_area_total.......... 4000683008 *

* abap/heaplimit................ 4000683008 *

* zcsa/installed_languages...... ED *

* zcsa/system_language.......... E *

* ztta/max_memreq_MB............ 1500 *

* ztta/roll_area................ 12000000 *

* ztta/roll_extension........... 3401239040 *

*************************************************************************

1 LUWs confirmed and 1 LUWs to be deleted with function module RSC2_QOUT_CONFIRM_DATA

OPEN_CURSOR DB-System ORA COVP

Start FETCH

FETCH: 593 RECORDS

IDOC: Info IDoc 2, IDoc No. 38352074, Duration 00:00:00

IDoc: Start = 19.04.2013 09:20:27, End = 19.04.2013 09:20:27

Synchronized transmission of info IDoc 3 (0 parallel tasks)

IDOC: Info IDoc 3, IDoc No. 38352075, Duration 00:00:00

IDoc: Start = 19.04.2013 09:20:28, End = 19.04.2013 09:20:28

Job finished

"

However, delta update failed. but we tried to do the delta update manually again, the update is finished and success.

Then I tried to check the background job in ERP again, different messages appears.

"

Job started

Step 001 started (program SBIE0001, variant &0000000101728, user ID ALEREMOTE1)

Format "X_PAPER" not defined for printer "$LP01"

Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)

DATASOURCE = 0CO_OM_CCA_9

RLOGSYS = PBP300

REQUNR = REQU_4HWFSY4ZZ3F3I4J76CI4LFQW2

UPDMODE = R

LANGUAGES = *

*************************************************************************

* Current Values for Selected Profile Parameters *

*************************************************************************

* abap/heap_area_nondia......... 1601175552 *

* abap/heap_area_total.......... 4000683008 *

* abap/heaplimit................ 4000683008 *

* zcsa/installed_languages...... ED *

* zcsa/system_language.......... E *

* ztta/max_memreq_MB............ 1500 *

* ztta/roll_area................ 9000960 *

* ztta/roll_extension........... 2401239040 *

*************************************************************************

Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 1.153 records

Result of customer enhancement: 1.153 records

Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 1.153 records

Result of customer enhancement: 1.153 records

PSA=0 USING & STARTING SAPI SCHEDULER

Asynchronous send of data package 1 in task 0002 (1 parallel tasks)

IDOC: Info IDoc 2, IDoc No. 38329439, Duration 00:00:00

IDoc: Start = 19.04.2013 09:26:55, End = 19.04.2013 09:26:55

Asynchronous transmission of info IDoc 3 in task 0003 (1 parallel tasks)

Altogether, 0 records were filtered out through selection conditions

IDOC: Info IDoc 3, IDoc No. 38329440, Duration 00:00:00

IDoc: Start = 19.04.2013 09:26:57, End = 19.04.2013 09:26:57

tRFC: Data Package = 1, TID = 0A0E000600915170E390019D, Duration = 00:00:11, ARFCSTATE =

tRFC: Start = 19.04.2013 09:26:56, End = 19.04.2013 09:27:07

Synchronized transmission of info IDoc 4 (0 parallel tasks)

IDOC: Info IDoc 4, IDoc No. 38329441, Duration 00:00:00

IDoc: Start = 19.04.2013 09:27:07, End = 19.04.2013 09:27:07

Job finished

"

I have no idea why our scheduled delta update always failed but can be done if we manually update it again.

Anyone can help me for the issue?

I have one more questions, in RSA1 we set the failed delta update queue to red in status, is it right?

When I click the red bottom, there is message shows below for QM status.

"

If you set a 'red' delta upload to green,

with the next request, BW sends a delta request

to the source system and this delivers the next delta data.

The data from the 'red' delta load is then no longer available

(even with a repeat). This can lead to loss of data.

Do you want to execute a QM Action?

".