Identify Failed Data Loads with This Check Tool

  • by Mark Theunissen, Reporting and Analytics, Rio Tinto
  • July 1, 2006
Dealing with data load failure is an inevitable part of BW support team members’ jobs. Expedite the way you check for data loads using this standardized process.
Key Concept
Daily and monthly loads fail from time to time. If you have no process in place to identify these failures at the time of failure, then BW support team members need to readily identify these failures.

Identifying failed loads at the time of failure is a goal that all BW teams should aspire to. However, more pressing concerns overshadow this task. Consequently, BW support teams have to check loads every morning to ensure the data integrity of the warehouse. I’ve created a tool called the Daily Load Checker to speed up this process drastically.

Checking loads must be the worst task assignment a BW person can get. It is tedious, but really important because the credibility of the warehouse rests on the data being available. A cursory look at a process chain or InfoCube load is insufficient to really get the status of the load. I found that you actually have to individually check the loads to cater for the possibility of zero or overlapping loads or aggregate problems.

Having spent many hours routinely checking InfoCube and master data loads for failures or problems, I knew that there must be a better way to undertake this work. I also realized it was an important yet thankless task that was certainly worthy of some assistance.

For this reason, I created the ZDAILYLOADS transaction to:

  • Check the success or otherwise of InfoCube/ODS loads including checks for duplicate or overlapping loads

  • Check the status of process chains

  • Check the status of the subprocess rollup for aggregate loads within a process chain load

Mark Theunissen

Mark Theunissen has worked in IT since 1980, starting as a trainee programmer with Mobil Oil in South Africa in 1980. In 1990, Mark was involved in an SAP R/2 implementation with Engen Petroleum (formerly Mobil Oil) and then in 1995 migrated to Australia. Mark worked for SAP Australia for six and a half years and is currently a freelance SAP consultant living in Perth, Western Australia.

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.