Uncover Process Chain Execution Errors When SAP NetWeaver BI Fails To Notify You

  • by Jeevan Kumar Ravindran, Independent BI Solution Architect
  • March 1, 2008
Learn how you can implement a custom watchdog program in just three steps to back up the standard messaging functionality. This ensures that you find out about process chain errors as soon as possible and allows you to quickly address issues as they arise. Also find out tips to optimize your use of the watchdog program.
Key Concept

SAP NetWeaver BI does not send out email alerts if an error occurs in your process chain in the following three cases: a dump in the program used in the ABAP process type, lack of messaging in the process type's variant, or an unexpected system shutdown in the middle of a process chain execution. However, by using a custom watchdog program, you can set up your system to send out messages for any of these scenarios.

Process chains are a part of a periodic data loading process in an SAP NetWeaver BI system. The lion’s share of SAP NetWeaver BI installations relies exclusively on process chains to automate data load schedules, monitor data load progress, and administer data targets.

If a process chain fails, end users do not have access to the most recent data. In the worst case, the failure can introduce data inconsistencies in different layers of the data warehouse depending on the location of the error in the data flow path. Inconsistencies could occur in the data acquisition (staging), primary data management (DataStore objects), or data delivery (architected data marts or InfoCubes) layer. Therefore, timely data availability in SAP NetWeaver BI greatly depends on the successful execution of process chains.

If you are unaware of a process chain failure, you do not have a chance to react in a timely manner. To avoid this, I created a watchdog program that you can implement in your SAP BW or SAP NetWeaver BI system to notify you when an issue occurs. The watchdog program complements the standard messaging functionality. This means that if SAP NetWeaver BI has sent out notifications about a process chain failure, the program doesn’t send duplicate messages.

Jeevan Kumar Ravindran

Jeevan Kumar Ravindran is an SAP-certified (in BW and SAP NetWeaver Portal) independent consultant specializing in end-to-end BI implementations. Jeevan has more than 14 years of SAP experience in a wide range of industries. Since 2002, he has been focusing on SAP BW projects, and has worked in many phases of these projects, including project planning, configuration, development, and post-go-live support.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.