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.
If anyone has come across this scenario , please share if any solutions are advisable.
Thanks in Advance!!