I've created a new user-defined function under the uccxhruser and made sure that uccxHrUserRole has execute permission. The new user-defined function is actually just a copy of an existing function that one of the cisco historical reports uses. I simply changed the function name within the spl code. I get a "Routine cannot be resolve" error when trying to run the new report under Cisco Client which calls the new function. I did some tests with the new function by calling the function from an SQL client (AGS server studio) and also directly from Crystal Reports. Both tests passed and were able to run the new function and return data. I just can't get it to run under the Cisco client. It seems to be a permission issue with the cisco client but I've verified that uccxHrUserRole has execute permission for this function.
A few things I've noticed but don't know if they are relevant:
Pre-existing functions and stored procedures are under "informix" schema. I see that these functions were granted 'uccxHrUserRole execution permission by user "informix".
For the new function that I created, it was created under the "uccxhruser" and granted 'uccxHrUserRole' execuation permission by user 'uccxhruser'.
Also, from what I can tell, we are only on one server with no failover servers in existance.
Cisco UCCX 8.5(1.10)
Thanks in advance for any insight that can be provided.