cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

244
Views
0
Helpful
0
Replies
Gerry O'Rourke
Rising star

UCCX CUIC/DB permission issues with custom stored procedures - CSCul06940

Issue:

As per BUG https://bst.cloudapps.cisco.com/bugsearch/bug/CSCul06940

Symptom:
CUIC report continuously fails after some time with error "not owner of table".

Conditions:
CUIC custom report using custom stored procedures which utilise temp tables.
The stored procedures are created with owner "uccxhruser" user.

The recommended "temporary workaround" detailed below, is of no use, as the issue will re-occur as soon as you run a standard report which uses the same temp tables as your custom report.

A better workaround is to create a custom version of the temp tables, by renaming them in your custom copy of your report.

e.g. from "temp_summary" to "temp_summary_uccxhruser"

This needs to be changed everywhere your custom Store procedures reference the temp tables.

Official Workaround:
As a temporary work-around, reset the database connection by "refreshing" the CUIC data source (saving a change) or restarting the CUIC service on the UCCX server. This temporarily resolves the issue by cleaning up all temp tables.

Recreate the stored procedures using user "uccxhrc" so it matches the user which CUIC executes the stored procedures as. TAC assistance will be required to achieve this.

Better Workaround

Create your own version of the temp tables within your custom store procedure

Permanent Fix - allow custom reports which use the uccxhruser have access to drop these tables?

Gerry.

0 REPLIES 0
Create
Recognize Your Peers
Content for Community-Ad