12-22-2022 03:32 AM
I have a custom report which runs fine.
The SQL when copied from CUIC SQL output runs directly on the SQL Server in less than 1 second.
The CUIC report runs and outputs successfully, but I noted that the footer values were not visible and that the report continuously is stating "Checking report execution progress" and never changes to "Success".
Any ideas on why this might occur?
For info - this is UCCE and CUIC 12.6
Gerry
Solved! Go to Solution.
12-30-2022 04:30 AM
OK Finally - I think I found the bug.
Its not related to the SQL in itself.
If I include any column with a footer (set to SUM) in the report definition the issue occurs.
if I don't have this - the report completes to success - but then obviously I don't have the footer values - which I wanted!
Thanks for your input / help Bill. I have a TAC open - so I will update it with this info.
Regards,
Gerry
12-25-2022 05:44 AM
Out of curiosity, what type of report is it? They have this defect but not exactly same scenario as yours. Is yours a real time report I'm guessing?
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvv78840
12-27-2022 09:40 AM
Bill,
Its not that bug - as that bug states the SQL query has the same issue on the AW SQL Server itself.
When I run the SQL query - it works perfectly fine.
So I believe the SQL is good and that this is a CUIC bug.
Its not a very typical SQL query - as it contains a pivot and is a little more complex than a typical SQL query.
In CUIC this is created as a anonymous block.
Its a pretty nice report (if I do say so myself!).
It shows the repeat callers to the contact centre in a nice clear manner against all CallTypes. As I say the CUIC report runs perfectly fine (but without the footer row, which I believe that purely related to CUIC not thinking the report has completed).
I have confirmed the same issue occurs in the lab - even if there is only a single row in the RCD table.
Here the SQL itself - if you want to have a look at it.
Regards,
Gerry
12-29-2022 04:25 AM
I know there a couple bugs specific to anonymous block reports. If you reduce say the number of parameters the user can choose, does it work?
12-29-2022 04:45 AM
Bill,
There are only two parameters, ":start_date" and ":end_date"
Regards,
Gerry
12-29-2022 05:10 AM
As a test can you change it to database query format to see if that makes any difference for it?
12-29-2022 06:21 AM
Bill,
I gave that a go. I had to create it as a Real time report and fix the DateTime to be > GetDate()-30 (last 30 days).
The report ran the same but with the same issue.
Gerry
12-29-2022 04:15 PM
Very strange. I know this doesn't solve the issue, but if you try and use only the temp1 and temp2 tables (or even just temp1), does it work then? In other words, is it some type of nesting issue that's too complex for CUIC?
I had an issue with anonymous block as an example where we had to open a defect since CUIC (not SQL obviously) didn't like the fact that we had a couple of parameters that CUIC couldn't parse even though they were valid with SQL, just curious if you're hitting something like that.
In my case, this was no good:
Select DateTime from Route_Call_Detail
Where DateTime >= :ZZ
And CallTypeID >= :ZZ2
But this was OK:
Select DateTime from Route_Call_Detail
Where DateTime >= :ZZ
And CallTypeID >= :YZZ2
12-30-2022 04:17 AM - edited 12-30-2022 04:18 AM
Bill,
If I simplify the last SQL query and remove the Pivot - to the point it is only as as below the report completes to "success" in CUIC.
I will simplify the pivot and see if that works at all.
SELECT
CallTypeID = PV.MyCallTypeID
,CallTypeName = CT.EnterpriseName
FROM TEMP3 PV
LEFT JOIN Call_Type CT ON CT.CallTypeID = PV.MyCallTypeID
12-30-2022 04:30 AM
OK Finally - I think I found the bug.
Its not related to the SQL in itself.
If I include any column with a footer (set to SUM) in the report definition the issue occurs.
if I don't have this - the report completes to success - but then obviously I don't have the footer values - which I wanted!
Thanks for your input / help Bill. I have a TAC open - so I will update it with this info.
Regards,
Gerry
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide