[cisco-voip] custom reporting w CUIC

[Ed Leatherman]

Thanks Brian that looks like its exactly the issue, I'll try the temporary
working around this afternoon. Does opening a TAC case on this help the bug
get any more visibility with development? I see it's a fairly low priority
one.


On Thu, Dec 19, 2013 at 10:57 AM, Brian Meade (brmeade)
<brmeade at cisco.com>wrote:

>  Ed,
>
>
>
> I don’t know much at all about CUIC but I did find a bug that potentially
> matches what you’re seeing-
> https://tools.cisco.com/bugsearch/bug/CSCul06940
>
>
>
> Brian
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] *On Behalf
> Of *Ed Leatherman
> *Sent:* Thursday, December 19, 2013 10:19 AM
> *To:* Cisco VOIP
> *Subject:* [cisco-voip] custom reporting w CUIC
>
>
>
> Good day!
>
>
>
> I'm exploring making some custom reports in UCCX 9 using the lab version
> of CUIC, running into a problem I'm hoping someone's seen before.
>
>
>
> Report I'm working on is a slightly modified version of the Traffic
> Analysis report - internal customers want the same information but just
> specific to a particular application on UCCX rather than all applications.
> So I've created copies of the two stored procedures that this report uses
> (sp_ivr_traffic_analysis and drop_table) and modified them to take an extra
> parameter (varchar(20) appName), and changed all the select statements
> against the contactcalldetail table to filter on the applicationName. I
> gave uccxHrUserRole execute permissions on these.
>
>
>
> I created the report on CUIC, and it works OK.
>
>
>
> When I export the report and import to the uccx cuic, initially it doesnt
> work because there is an XML element in the CUIC version called
> enableUnauthenticatedAccess that uccx doesn't support. Removing that from
> the XML file allows UCCX to import it.
>
>
>
> However if I run the report, I get this exception:
>
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException:
> CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException;
> SQLState: IX000 Vendor code: -313 Message: Not owner of table. } at
>
> ETC
>
>
>
> I don't see anything else in the trace file that makes any sense to me.
>
>
>
> Anyone know how I can figure out what table it's referring to? The SP
> looks like it creates some temp tables, but I'm not a DBA by trade and
> Informix is pretty new to me. The fact that it's working on CUIC and not on
> UCCX is puzzling me, must be some permissions thing I'm missing.
>
>
>
> Have a great day!
>
>
>
> --
> Ed Leatherman
>



-- 
Ed Leatherman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20131219/e90d1324/attachment.html>