[cisco-voip] UCCx 10.5 custom stored procedure for reporting

[Ed Leatherman]

Glad to help. I've had tac do the workaround before so if you find you need
the temp tables it's a easy fix - they just have to shell into your UCCX to
create the extra account for you.

On Fri, Apr 8, 2016 at 10:18 AM, Bill Talley <btalley at gmail.com> wrote:

> Closing the loop here, this was my issue. I was able to execute a stored
> procedure which wasn't creating a temp table.  Thanks again for sharing Ed.
>
> On Fri, Apr 8, 2016 at 7:27 AM, Ed Leatherman <ealeatherman at gmail.com>
> wrote:
>
>> Bill,
>>
>> Does your SP use temporary tables? look at CSCul06940 - I dont know that
>> its resolved in 10.X yet.
>>
>> Ed
>>
>>
>>
>> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley <btalley at gmail.com> wrote:
>>
>>> Hi all,
>>>
>>> Has anyone imported custom stored procedures into the db_cra for use in
>>> CUIC?  I'm having an issue getting a new stored proc loaded using either
>>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
>>> stored proc; however, when I do that I get an error that uccxhruser doesn't
>>> have permission to execute the stored proc.  It seems I can't apply
>>> permissions to the uccxhruser account on the stored proc until the stored
>>> proc is loaded.   Would anyone have any tips on how I can go about getting
>>> the stored proc loaded to the database?
>>>
>>> Hopefully this makes sense to someone ;-)
>>>
>>> TIA,
>>> Bill
>>>
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>
>>
>> --
>> Ed Leatherman
>>
>
>


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