[cisco-voip] custom reporting w CUIC

[Brian Meade (brmeade)]

Ed,

Right now it’s listed as a feature enhancement request.  Opening a TAC case to get it associated to the bug can help drive it to get put in earlier but the fastest way to get stuff like this pushed into a release is through your account team as they can push on the BU a lot more than we can in TAC.

It looks like they may be targeting this for 10.5 right now.  The reasoning provided for why it is an enhancement request rather than a higher-priority defect is because “it encompasses several aspects including upgrade, dynamic update of CUIC data source etc.” so it looks like it may require some significant redesign.

It looks like there is a TAC root workaround that is more permanent though so a TAC case can get that part done.

Brian

From: Ed Leatherman [mailto:ealeatherman at gmail.com]
Sent: Thursday, December 19, 2013 11:17 AM
To: Brian Meade (brmeade)
Cc: Cisco VOIP
Subject: Re: [cisco-voip] custom reporting w CUIC

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<mailto: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<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/b480125d/attachment.html>