CUIC Agent Team Summary

Version 1
    This document was generated from CDN thread

    Created by: ED VILLARREAL on 10-04-2012 12:36:22 PM
    I have a customer on 8.5.3 and using the latest summary reports available on Developer Network Site.  After the Agent Team Daily/Weekly/Monthly reports are run by users, the last few lines of the SQL query in the report definition are truncated and the report fails to run.  I thought it may be an issue with the length of the query, so I cleaned up all the unncessary spaces and the issue still occurs.  Has anyone else run into this issue?

    Subject: RE: CUIC Agent Team Summary
    Replied by: Senthil Kumar Natarajan on 11-04-2012 10:28:09 AM
    I have a customer on 8.5.3 and using the latest summary reports available on Developer Network Site.  After the Agent Team Daily/Weekly/Monthly reports are run by users, the last few lines of the SQL query in the report definition are truncated and the report fails to run.  I thought it may be an issue with the length of the query, so I cleaned up all the unncessary spaces and the issue still occurs.  Has anyone else run into this issue?

     
    Can you please post a screenshot of the error that you are getting? I have used the summary reports from CDN and never had any.

    Subject: Re: New Message from ED VILLARREAL in Contact Center Reporting (CCR) - Cont
    Replied by: Nathan Luk on 11-04-2012 11:07:27 AM
    I found that out as well. CUIC appears to have an undocumented 15000 character limit to the SQL in the report definition which also includes white space.

    Nathan Luk


    On 12/04/2012, at 1:04, "Cisco Developer Community Forums" <cdicuser@developer.cisco.com> wrote:

    > ED VILLARREAL has created a new message in the forum "Contact Center Reporting":
    >
    > --------------------------------------------------------------
    > I was able to resolve the issue. I found that when the "Save As" feature on the Agent Team Daily/Weekly/Monthly reports was used, the last few lines of the SQL in the report definition were truncated. Not sure why. As I said in my original post, I cleaned up the SQL by taking out carriage returns and I noticed that less of the SQL was truncated after that. I went back again and cleaned it up even more by taking out ALL extra spacing and was able to get it to a size that was no longer truncated.
    > --
    > To respond to this post, please click the following link:
    >
    > <http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/5436337>
    >
    > or simply reply to this email.

    Subject: RE: CUIC Agent Team Summary
    Replied by: ED VILLARREAL on 11-04-2012 11:01:46 AM
    I was able to resolve the issue.  I found that when the "Save As" feature on the Agent Team Daily/Weekly/Monthly reports was used, the last few lines of the SQL in the report definition were truncated.  Not sure why.  As I said in my original post, I cleaned up the SQL by taking out carriage returns and I noticed that less of the SQL was truncated after that.  I went back again and cleaned it up even more by taking out ALL extra spacing and was able to get it to a size that was no longer truncated.

    Subject: RE: CUIC Agent Team Summary
    Replied by: Senthil Kumar Natarajan on 11-04-2012 11:15:01 AM
    Agree that there is character limit but its the definition that was downloaded from Cisco and should have worked without any modifications. Any case, glad its working and we know the fix.

    Subject: RE: Re: New Message from ED VILLARREAL in Contact Center Reporting (CCR) -
    Replied by: Luis Yrigoyen on 11-04-2012 11:23:59 AM
    Nathan, Ed,

    That's good to know, thank you for posting your findings.

    Subject: RE: CUIC Agent Team Summary
    Replied by: ED VILLARREAL on 11-04-2012 12:14:05 PM
    I have a theory on why this broke.  There does appear to be a 15000 character limit as Nathan noted.  The query itself is less than 15000, so it should work.  I only encountered this issue when using the "Save As" feature.  Well, when you use the "Save As" feature, it will save the report with the default parameters that you chose prior to running the report.  I bet that the scope of your filter, in this instance hundreds of agents, are included in that SQL statement and thus truncates the SQL after the 15000 character mark.  I was able to validate this by copying the original report using the save as feature and selecting hundreds of agents when it failed to save properly.  I reimported the report so it would work correctly again and then performed the same procedure while only selecting a few agents and it worked properly.  Hopefully this saves someone some troubleshooting time in the future.