TSV_TNEW_PAGE_ALLOC_FAILED error in APD execution

 Symptom:

During APD execution, the job fails with error and throws a dump. The dump can be seen in transaction ST22 or double clicking on job log itself.

TSV_TNEW_PAGE_ALLOC_FAILED error

 

Cause:

This dump is seen when the work processess are busy and there are not enough system resources to handle the APD execution

Mostly the APD is processing lakhs or records at a time.

Solution:

  1. Make sure that work processess are free while running the APD, go to SM66 and analyze the status of your BW system. If possible try to cancel the jobs that are not required
  2. Run the below programs to clear the temporary tables before repeating the failed APD-

Go to transaction RSANWB, search for your APD technical name, double click on name to open the APD in display mode.

Go to top menu. Choose Environment -> Clean up temporary tables

Press "Delete" button

 

3. Check the performance setting of the APD, uncheck the option "Execute in memory"

Press F3, F3

 

4. If none of the above actions work out, the only solution is to split the APD or give filters so that data is lesser at one chunk of execution

e.g. If APD is fetching data from cube, consider building a new cube with only relevant data e.g. Plant IN01

 

Note:

If the APD is fetching information from cubes or DSO, try to reduce the number of requests in cube/DSO.

You can build a new cube for the APD which is daily delete and full load from old cube so that it has only one request per day based on APD selection only.

Then use this new cube in the APD. In this way, APD will not fail.

Comments

Post a Comment

Popular posts from this blog

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more