| T O P I C R E V I E W |
| krigans |
Posted - 02/24/2010 : 01:32:44
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 02/25/2010 : 02:07:18
Please increase the Command Timeout: Admin > Settings > Command Timeout to 600. The default Command Timeout is 30 seconds. |
| krigans |
Posted - 02/24/2010 : 01:44:32
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 |
| marco |
Posted - 02/24/2010 : 01:35:56
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 |
|
|
Report Portal
