How to troubleshoot any issue in your SAP BI 4.x deployment
Being in the IT/Software industry for close to 20 years I’ve seen a lot of troubleshooting sessions and late nights spent trying to fix a problem.
With this experience came an understanding that with proper methodology it is possible to troubleshoot and find root cause of any issue.
So what is the right methodology ?
I’ll list what I use and you can comment on what you use. In the end we can create a set of steps that will resolve any problem.
Here is how I start my troubleshooting :
- Determine what is the exact workflow that is problematic. – I cannot stress enough how important this is.
A lot of time can be lost troubleshooting wrong problems….
You need to be sure you know when exactly, what exactly and how exactly a problem is happening. Do not trust your user words !!!
Verify by asking to show you !! Users, for the most part, are not technical people, to them “report doesn’t work” is good enough description. You, as administrator, need more !!
If you do not have access to your user machine, have the user take a screenshot of the error message. Most users know how to take a screenshot these days, and having the exact error message and error code helps to search the “Error Messages Explained” document on help.sap.com. That can help the admin then target the pieces involved.
- Once you know what is happening – determine what pieces you’re dealing with – how many servers, what’s installed on each, any proxies/ web servers and firewalls, any other devices are part of the workflow etc.
As administrator, you should have all the environments properly diagrammed and documented so this part should be easy.
Work with your IT colleagues who manage network and servers to determine what sort of network latency is between pieces etc.
Environment diagrams and proper documentation of your deployment is very useful when asking SAP support for help.
- Start simplifying the picture !!
Simplify to the lowest possible level (no web, no ssl, no proxies, no LB’s, no network : single box etc) – is the issue still there ?
If yes – concentrate on that last remaining piece , rest are not a factor !!
If no – let’s add next piece and so forth !!!
(this works with any product or tool, adjust freely – use your imagination)
- Once you know How exactly and Where exactly the issue is happening, only then go and look if the issue is known, if there are KB articles, SCN posts, your internal knowledge base history etc. that are related to this problem.
A lot of times, specially if you’re using an established version of SAP product, the issue will be known and documented.
- When all of the above is done – here comes the technical part : traces, debug, head scratching, detailed configuration reviews etc…
Now that we have covered the basics, what basic tools does the SAP BI4.0 administrator should utilize in troubleshooting ?
- SAP BI4.0 has an improved tracing functionality. You no longer need to restart services to enable various level of tracing. Please see Admin guide for details
- End to End trace functionality, explained in a great KBA found here
Or in the blogs here :
- Know how the product works, so you know which traces to enable.
Great place to start is to learn SAP BI4.0 process flows in Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform 4.x
- SAP BI4.0 Platform monitoring , you can find details about it in the Admin guide I mentioned before and in this great blog.
- Remote Support Tools. Learn about them here.
This set of tools and methods allows you, the administrator to see what happens in your deployment, they also allow SAP support easy access in case you need help.
- Speaking of SAP Support – they can be a great asset in your troubleshooting. If you provide them with correct and full information (see beginning of this post 😉 ) they will be able to quickly identify the root cause and provide solution.
- New addition to the list is the SCN WiKi BI Platform troubleshooting page : Troubleshooting – Business Intelligence (BusinessObjects) – SCN Wiki
It has great info and links to Root Cause Analysis Wiki, Troubleshooting Scenarios and latest and greatest troubleshooting tools.
Using this Wiki and above Methodology – no issue can remain unsolved.