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.
