How to query UCCX 8.5 Stored Procedures

[rickyd1976]

Can anyone give some tips and pointers on how to query UCCX 8.5 Stored Procedures?

I get the following error when attempting to query.

ERROR: [Informix][Informix ODBC Driver][Informix]The specified
table (final_result) is not in the database. Error Code: -206

Query = call getcsqs()

[Deepak Rawat]

Have you created a successful ODBC connection to the UCCX server?? Refer to Creating a System DSN for Wallboard section of below document, there is only one change that the userid you will need to use is uccxhruser instead of uccxwallboard

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/configuration/guide/uccx851ag.pdf

Regards

Deepak

[rickyd1976]

I have a valid connection via ODBC and I am using the uccxhruser account. I am able to query tables, but I am not able to execute or call the stored procedures. Does this sound like a permission issue?

[Deepak Rawat]

grant execute on <your procedure name> to 'uccxHrUserRole';

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/programming/guide/uccx85hradm.pdf

Regards

Deepak