Posted by: Ashish Kumar | April 18, 2009

Siebel Actuate Reports -Troubleshooting Steps


Troubleshooting Steps
All the above factors can contribute to the poor performance of reports. If you are encountering report performance issues, the following checks should be made to isolate the problem. Please refer to the previous sections as appropriate.
1. Are all the reports perform badly or is it only specific reports that are performing badly?
2. If all reports are performing badly, check the following:

1. Investigate the Report Server.
• Is it heavily loaded?
• Run the report on its own, with no other users running reports. Is the performance better or the same? If better, then the load on the Report Server may be the issue.

2. Investigate the Siebel Object Manager.
• Is it heavily loaded?
• Run the report on its own with no users accessing the Object Managers. Is the performance better or the same? If better, then the load on the Object Manager may be the issue.

3. If specific reports are performing badly, check the following:
      1. Investigate how much data is being processed by the report.
                 •  Try the report with different volumes to get picture of performance.

      2. Investigate the Report Design:
                 • Check search specifications.
                 • Check sort specifications. 
                 • Are aggregate functions being used? 
                 • Is MemoryDataSorter being used?
                 • Check memory usage.

      3. Break the report down to determine where the bottleneck is. Once the constraint is identified, a course or action can be defined to correct it.

Advertisements

Responses

  1. siebeloracle.wordpress.com – da best. Keep it going!

  2. Hi, Thank you! I would now go on this blog every day!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: