[cisco-voip] custom reporting w CUIC

[Ed Leatherman]

Just by way of follow-up on this one.

TAC was able to apply a workaround that involved setting up the uccxhrc
account with a password that I can know about - creating any custom stored
procedures with this account resolves the permissions problem. So a decent
long-term fix until it becomes a full "feature" later on.


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

>  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>
> 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
>



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