Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 RequestTimeOut		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

krigans

India
2 Posts
Posted - 02/24/2010 :  01:32:44  Show Profile  Reply with Quote
Hello,
Below is the query being generated from the portal. i always get reques timed out from the reportporal application. But when executed this query on the sqlserver query analyser it gets 555 records in 8 mins 51 secs (this does vary but in secs). I have changed the sqlserver property not to timeout is there any other settings to be done on the portal app ? quick help is appreciated.

SELECT
COALESCE(
'' + CASE WHEN GROUPING(srh.GenderACode) = 1 THEN NULL ELSE COALESCE(CONVERT(varchar, srh.GenderACode), 'Unknown') END,
'' + CASE WHEN GROUPING(srh.ActionUserCode) = 1 THEN NULL ELSE COALESCE(CONVERT(varchar, srh.ActionUserCode), 'Unknown') END,
'All') as [H1],
Sum(srdc.ServiceBillAddlConcAmt) as [Service Bill Addl Conc Amt],
Sum(srdc.ServiceBillGrossAmt) as [Service Bill Gross Amt]
FROM ServiceRqstDetailCommercial srdc
INNER JOIN ServiceRqstHeader srh ON srh.ServiceRqstNumber = srdc.ServiceRqstNumber
GROUP BY
srh.ActionUserCode,
srh.GenderACode
WITH ROLLUP
ORDER BY
GROUPING(srh.ActionUserCode) DESC, srh.ActionUserCode,
GROUPING(srh.GenderACode) DESC, srh.GenderACode


Wrgds
Ganesh K

marco

Netherlands
588 Posts
Posted - 02/24/2010 :  01:35:56  Show Profile  Reply with Quote
Is this query based on Adventure Works or your own database ?

You can add this query as view in SQL Server and have this view in ReportPortal.

By the way are the indexes of the tables ok ?

Marco
Go to Top of Page

krigans

India
2 Posts
Posted - 02/24/2010 :  01:44:32  Show Profile  Reply with Quote
the query is of on my own tables indexes are fine. But what our idea is that the analyst can build the cubes using the raw tables and join them. The query which was posted is the query which was generated from reportportal interface. any other suggestions will really help me to proceed ahead. Again i fired the query backend returns in 8 mins 341 secs.

What my question was
1] Is there a way to remove this error by some settings.
2] Does the cube generated store the data also.
3] If it does then not an issue even if it takes 1 hr i would keep it for process on offline and allow to be viewed when ready.

Ganesh K
Go to Top of Page

admin

1637 Posts
Posted - 02/25/2010 :  02:07:18  Show Profile  Reply with Quote
Please increase the Command Timeout: Admin > Settings > Command Timeout to 600. The default Command Timeout is 30 seconds.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page