Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Report runs slowly through Maximo
Migrateduser
<p>Hello everybody!</p><p> </p><p>We are using BIRT 2.1.2 and Maximo 6.2.7, running on Windows Server 2003 SP2.</p><p> </p><p>We have an issue with a report that I've not had any luck troubleshooting. When I run the report through the Eclipse preview window, it finishes in about 50-60 seconds. However, when I try running it through Maximo with the same parameters, it takes about 7.5 minutes just for the SQL queries to finish and the report never actually loads into the report window. I was able to see the report load once, but it took about another 8 minutes after the queries were finished before it did so. It usually just sits there indefinitely with the spinning blue circle of doom.</p><p> </p><p>We have tried running Update Statistics through Maximo. We already have indexes set up. We've tried deleting the log files as sometimes they get too big and that slows us down. I've tried optimizing my SQL queries. I am running out of ideas here and what we have left doesn't sound promising.</p><p> </p><p>So I guess I have two questions. First, has anybody dealt with this particular kind of situation and if so how did you resolve it? Two, can running too many update statements cause a slow-down like this? I'm wondering if I need to set up my report so that all the updates in the first section are executed at the same time. They're currently updating on each record. I'm pretty sure this is how it was done in the SQR version of this report, which ran just fine, so I'm not sure that this is the problem.</p><p> </p><p>Any input would be greatly appreciated, we're just about out of ideas here and we need to get this report fixed.</p><p> </p><p>Thanks!</p><p>Chris</p>
Find more posts tagged with
Comments
There are no comments yet