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

[Brian Meade]

I use AGS Server Studio as well.  This is how I do it and make sure the
permissions are okay:

DROP FUNCTION sp_exec_summary(datetime,datetime,integer,lvarchar);

CREATE FUNCTION sp_exec_summary (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_appNameList LVARCHAR(4000) DEFAULT 'NULL' )
END FUNCTION;

grant execute on function
sp_exec_summary(datetime,datetime,integer,lvarchar) to 'public';


AGS Server Studio tries to add 'uccxhruser' in front of the stored
procedure names.  I just get rid of those to make sure it's accessible to
everything.

On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [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  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 
> 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  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@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>
>>
>> --
>> Ed Leatherman
>>
>
>


-- 
Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Bill Talley]

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 
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  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@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
>
> --
> Ed Leatherman
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Bill Talley]

Cool, this includes everything I had been doing as far as I can tell.  Thanks a 
lot for sharing these details Ed!

Sent from an Apple iOS device with very tiny touchscreen input keys.  Please 
excude my typtos.

> On Apr 8, 2016, at 7:29 AM, Ed Leatherman  wrote:
> 
> I haven't touched this in 2 years - here's notes I took when I was playing 
> around with this before in case it will help:
> http://www.evernote.com/l/AAVCJ8P2UbJG5o0yqjxIO6-9p7edydMHCfE/
> 
>> On Fri, Apr 8, 2016 at 8:27 AM, Ed Leatherman  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  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@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> 
>> 
>> 
>> -- 
>> Ed Leatherman
> 
> 
> 
> -- 
> Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Bill Talley]

It does.  I'll take a look at it.  Thanks!

Sent from an Apple iOS device with very tiny touchscreen input keys.  Please 
excude my typtos.

> On Apr 8, 2016, at 7:27 AM, Ed Leatherman  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  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@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> 
> -- 
> Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Ed Leatherman]

I haven't touched this in 2 years - here's notes I took when I was playing
around with this before in case it will help:
http://www.evernote.com/l/AAVCJ8P2UbJG5o0yqjxIO6-9p7edydMHCfE/

On Fri, Apr 8, 2016 at 8:27 AM, Ed Leatherman 
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  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@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
>
> --
> Ed Leatherman
>



-- 
Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Ed Leatherman]

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  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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>


-- 
Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Justin Steinberg]

i haven't experienced this issue before.Care to share your stored
procedure ?

On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip