12-11-2016 09:13 PM - edited 03-14-2019 04:50 PM
Hi,
Need help.
We have migrated clients UCCX 7.x to 11.5, after migration client started complaining that they are not able to pool complete reports which has more then 8000 rows.
After some findings we found it is 8000 rows is limitation of product UCCX CUIC.
Client earlier use to pool the report in earlier version of UCCX 7.x hence he wants same in 11.5 version also.
My question is does this can be achieved using customization or any workaround for this?
Regards
Akash
12-12-2016 05:16 AM
03-13-2017 08:06 AM
Since that white paper was written for UCCE and TSQL does it apply to UCCX and informix?
03-15-2017 02:45 PM
mserwon,
Not sure if this will answer your question, but please refer to this document:
UCCX Repository Restrictions - Cisco
Hope this helps,
Kelli Glass
Moderator for Cisco Customer Communities
03-15-2017 02:53 PM
Thanks for the response Kelli but I do not see the overlap between your web post and the white paper mentioned earlier. The white paper was written for using CUIC in a UCCE environment and does not apply to using CUIC in a UCCX environment.
04-03-2017 08:28 AM
I don't think this report by Kelli has any answers...
What I'd like to see is at least being able to FTP out a report larger than 8000 rows...
04-07-2017 01:14 PM
Hello,
The approach logic for UCCE and UCCX should be the same - only the SQL language to achieve the result is different (UCCE is MS SQL and UCCX DB is Informix)
The logic oversees the number of rows to be returned, reserves them temporarily and allows the reporting user to call the records in chunks. In MS SQL (and in the paper) this is achieved via temp table and inserting complete number of rows into this table with a sequence number. Same/similar SQL tricks should exist in Informix SQL language as well.
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