Skip to Content
Author's profile photo Former Member

Query not executing in APD, Hangs in Programe CL_RSR_MDX_FILTER_SETXX=======CP

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:


    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!!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jason Lax
      Jason Lax

      This query should have been posted as a new discussion and not a blog.  Selecting the correct content type is important to ensure it gets the right visibility and replies from other SCN users: see The Difference Between a Discussion, Blog Post, Document and Wiki

      Please consider deleting this and posting again via the correct content type.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for the info.

      Updated on discussion.

      will post some of my findings in Blog soon! 🙂