SAP_COLLECTOR_FOR_PERFMONITOR + IMPORT_DECOMPRESS_FAILED

[Former Member]

Hi All,

In Our BW 7.0 system, SAP_COLLECTOR_FOR_PERFMONITOR job is failing at particular time (around 5AM, 7AM and 8PM system time only) with ABAP dump.

4AM and 6AM job run is success.

Runtime Errors IMPORT_DECOMPRESS_FAILED

Exception CX_SY_COMPRESSION_ERROR

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

Short text

Error when decompressing during IMPORT.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLSDBORA3" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_COMPRESSION_ERROR', was not

caught in procedure "GET_SE_AGG_SP_HISTORY" "(FORM)", nor was it propagated by a RAISING

clause. Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated.

The reason for the exception is:

When IMPORTing compressed data, an error occurred when decompressing.

Unable to read an IMPORT dataset.The dataset may have been processed using SQL and is

thus no longer readable for the IMPORT.

How to correct the error

Determine which actions resulted in the destruction of the

dataset.

The exception must either be prevented, caught within proedure

"GET_SE_AGG_SP_HISTORY" "(FORM)", or its possible occurrence must be declared

in the RAISING clause of the procedure.

Information on where terminated

Termination occurred in the ABAP program "SAPLSDBORA3" - in

"GET_SE_AGG_SP_HISTORY".

The main program was "RSORACOL ".

In the source code you have the termination point in line 987

of the (Include) program "LSDBORA3F02".

The program "SAPLSDBORA3" was started as a background job.

Job Name....... "SAP_COLLECTOR_FOR_PERFMONITOR"

Job Initiator.. "DDIC"

Job Number..... 04002100

The termination is caused because exception "CX_SY_COMPRESSION_ERROR" occurred

in

procedure "GET_SE_AGG_SP_HISTORY" "(FORM)", but it was neither handled locally

nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPLSDBORA3 "; its source code begins in line

976 of the (Include program "LSDBORA3F02 ".

Source Code Extract

976 FORM get_se_agg_sp_history USING con_name

977 curr_date

978 curr_cweek

979 monikey

980 process_type

981 source_mkey

982 hist_life.

983 DATA answer(3).

984 DATA tab_new TYPE tytab_agg_root_s.

985 DATA tab_old TYPE tytab_agg_root_s.

986

>>>>> IMPORT tab_agg_root TO tab_old tab_root_sp_hi

988 FROM DATABASE moni(db) ID monikey.

989

*********

DB: Oracle 10.2.0.2

SP Stack : 14

OS: AIX 5.3

Kernel: 146

Not able to find the reason for failing. Could you please help me on this.

Thanks..

Preethish

[Former Member]

Hi All,

As per the note 1064524 monikey DEF651 is deleted from the system and issue is resolved.

In ABAP Dump we had below entry under "Chosen variables"

MONI

DB--DBW DEF651 #ƃ ઇ©롩죫⍱#ི楾#ꍶ믎釙멻뼛#뵭#쬔#묟宽#嗎柋㲘巴駫ᒑ슑##ᔷ#紤⺻##롩죫⍱##ᔷ#紤⺻#岚ἂ풮⾒巔#燓郗䟢늋켢풩롩졵쓜规朑##

[Former Member]

Hi Preetish,

I think this is a program error.

You can check with a abaper for this.

Regards

Ashok

[Former Member]

Hi Experts,

Is there any inputs on this.

Thanks..

Preethish