SAP easy learning

  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: 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 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"

 Whenever there is a dependancy between process chains, you can use interrupt step for one process chain to wait for other to complete. In other words, supporse a dso A load should start once dso B activation is finished, but these are in separate process chains. In such case it is not recommended to change the entire process chains are they are already up and running in the production environment. You need to add an interrupt step before load to dso A in process chain which has dso A load without doing any changes in process chain having dso B load. Below are the steps to do the same: Go to dso B process chain in Log view. Right click on the activation step and choose "Displaying Messages" 3. Go to chain tab and note down the end event and parameter 4. Go to process chain having dso A in planning mode - > select edit 5. Add interrupt step before DTP load to dso A 6. In the interrupt step settings, give the event and paramet

  This type of error was seen in one of the DTP load in my project. System : BW 7.5 on HANA DTP load : DSO to DSO Symptom: The load failed after repeatition of DTP also. There were no error stack records. The data was transactional and loading from one aDSO to another aDSO. The type of aDSO was standard DataStore Object. The DTP was not having HANA execution enabled. Cause: The error comes when multiple packages are processed in parallel by the DTP and it tries to insert records in target in parallel. Solution: The error was resolved after enabling the semantic grouping in DTP. Hope this helps. :)