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

[Former Member]

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

[Former Member · Accepted solution]

Did you try following notes -

Note 1461146 - MDX: Incorrect data when the query result is very large

Note 1596989 - MDX: Long runtime in method CHECK_IF

[Former Member · Accepted solution]

HI,

I got the solution for the issue, That programme runs for log periods, and is connected to the selection variable, as well as "Conditions" used in the base query.

As per my issue, As there was a Condition is the Query it was taking unnecessarily long time. We took the following steps :

1. Remove the condition from Base Query.

2. Asked Basis to increase the memory space of internal tables.

Apart from this we have also done the performace tuning for APD as per the Notes.

Thanks.