CX_SY_COMPRESSION_ERROR in APD

[Former Member]

Hi All ,

I am facing an issue where I am loading data from a Query into a DSO via an APD.

The APD step is failing with the below error :

An exception with the type CX_SY_COMPRESSION_ERROR occurred, but was neither handled locally, nor declared in a RAISING clause

Error while getting data (AXI); redesign query

Please provide your inputs or guide me through this issue.

Thanks

Prateek

[former_member197610]

Prateek,

Try to run the APD in background, un check the "Process Data in Memory" under GOTO-Performance Settings.

Check if that works and pls share the ABAP Dump details if you have one...

Hope this helps..

[Former Member]

Hi Suresh ,

Thanks for your inputs. Just want to confirm if it will have any impacts in P system as I will have to make the changes there only.

Can this issue be because of large amount if data pulled in query , currently its Aug 2013 - July 2014 ?

Thanks

Prateek

[former_member197610]

Prateek,

Of course it is going to utilize most of the system resources and the large amount of data being an issue ,go ahead and break it to chunks and try running it.

[Former Member]

Suresh

I changed the settings of the APD and repeated the failed step of the PC, but it has again failed.

[Former Member]

I also tried to run the query(used in APD) in browser  , it gives the same error as in APD. I believe the APD error is happening because of the query itself not fetching data. So, I think changes in APD settings might not work as the query independently is not fetching data.

Any suggestions on this.

[former_member197610]

Prateek,

Check these note and go over with Basis team. See if this helps,

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...