Skip to Content

Hi Experts,

We have created an APD  on Query as base. Query is on a Multiprovider. The Query takes only a few minutes to execute on RSRT and Analyser but if we run the APD(on background or Dialogue) it takes very long time , and returns runtime error : TSV_TNEW_PAGE_ALLOC_FAILED.

We also referred notes 1032937, 751577,794257 and did the performance tuning for APD such as:

1. Uncheck “In Memory” in performance.

2. Partitioning of APD.

3. Define package size.

Also, we restricted (narrowed down) the query output by hardcoding of 0CALYEAR , and on Plant ,

Now, Query output has only 5000 records, and executed fast on RSRT and Analyzer.

But even if we calculate the “Immediate result” for Query in Background, on SM50 it gets stuck at a Program class “CL_RSR_MDX_FILTER_SETXX=======CP” for many hours.

on terminating it gives runtime errors:

   “SYSTEM_CORE_DUMPED”

    Error in the SAP kernel.     Process terminated by signal 6.

   

The current ABAP “CL_RSR_MDX_FILTER_SETXX=======CP” program had to be terminated because the  ABAP processor detected an internal system error.

and on waiting it gives TSV_TNEW_PAGE_ALLOC_FAILED.

Other APDs with more than 5000 records are working fine in the system, also we re-transported the APD and made another APD on Query, but it continues to give the same error.

Please help!

If anyone has come across this scenario , please share if any solutions are advisable.

Thanks in Advance!!

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply