Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Getting the Dump due to large data

Former Member

‎2014 Aug 27 10:57 AM

0 Likes
2,495

Hi,

I have a requirement to get order block details related to all the Sales Orgs. Due to huge data the report has performance issue and some times its getting to dump due to lack of space on server, The basis have extended to 15GB on the server but the report is requring much more. Could any suggest me how to deal with this.

Regards,

Arun.

Hi,

I have a requirement to get order block details related to all the Sales Orgs. Due to huge data the report has performance issue and some times its getting to dump due to lack of space on server, The basis have extended to 15GB on the server but the report is requring much more. Could any suggest me how to deal with this.

Regards,

Arun.

Reply
5 REPLIES 5
Read only

Former Member

‎2014 Aug 27 11:11 AM

0 Likes
1,906

Hi Arun,

Firstly, if BASIS increase the space even more on server, you will not have this error.

Secondly, may be you should verify the ABAP coding, which might pull a huge amount of data in one go.

Regards,

Ashvin

Read only

JuanCarlosDelga
Contributor

‎2014 Aug 27 11:33 AM

0 Likes
1,906

Hi Bharat,

First, can this report be done in BW.

Second, if the problem are the select, are you using SQL cursors?

Are you aggregating the data?

Regards,

JCD

Read only

Former Member

‎2014 Aug 27 11:37 AM

0 Likes
1,906

Hi,

Can you post part of the dump where it says when the dump occurrs? Is it during selection or other statements/processing?

If during select, try selecting smaller amounts at once and use cursor.

R,

Tim

Read only

Former Member

‎2014 Aug 27 11:42 AM

0 Likes
1,906

Dear

This all depend on you database

OS which are you are using

how much RAM you have

bcaz for all database and os there is different document from SAP..

depending upon that you have change the parameter setting in sap level and database level

send us some logs for better verification of issue

Regards

Read only

Former Member

‎2014 Sep 18 12:21 PM

0 Likes
1,906

Hi Bharat,

I have worked on similar type of requirement recently. We developed a report which gives us the Block details of around 200+ sales orgs. Due to large volume of data there are high chances of getting a dump or will have performance issues. For handling this we have used parallel processing concept and used cluster tables. We have developed 3 reports as a part of the development. In the first report we give the input and this will be submitted to the 2nd report. While Submitting the input, we are looping the internal table consisting of all the sales orgs,we are taking first 4 sales orgs and submitting them to 2nd program using SUBMIT. which will be running as a background job.  In this way for every 4 sales orgs a job will be triggered which will be running independently from one another. We are then loading these parallel jobs data into a cluster table using a unique index. The Job which will be executing at last will trigger a final job (the 3rd report ) which will consolidate all these jobs data and placed into a final internal table. we are using this table to display the results.

Regards,

Shafi