Not sure if anyone is activly using UCCX 8 yet but i have a question.
When trying to access the AgentStateDetail and Resource tables all i get is a permissions error. This is using the uccxwallboard user.
You can still access the RT tables as before with no issues.
I am guessing cisco have limited this and i need to know how to add select permisions on all tables for the uccxwallboard user.
Is this possible?
The only way you had access to those tables pre-8.0 is that you (or someone else) manually change SQL permissions, which is not supported. Given that 8.0 is on linux/informix, this is no longer possible to do, and therefore you lost access to these tables.
Here is one way of changing access for a user in 7.0 and lower, for the curious:
osql -E -S IPCCSRV\CRSSQL -Q "USE db_cra EXEC sp_addrolemember 'db_datareader', 'IPCCSRV\CiscoWbUsr'"
Replace you server name and user account as required.
Also, your UCCX questions will gain more visibility in the Contact Center forum:
When you user the uccxhruser account as specified in the historical reporting guide you gain access to the other t
ables you need...procedure as below.... good luck !
Step 7Select the Connection tab. In the sever name field, enter the instance name of Informix server of the set up. The instance name is ‘the host name of UCCX ‘ + ‘underscore’ + ‘uccx’. For example, if the host name of UCCX server is ‘Uccx_n1’ then the IDS instance name will be ‘Uccx_n1_uccx’. In the host name field, enter either host name or IP address of UCCX server. In service field, enter 1504 which is the TCP port number. In the ‘Protocol’ field, choose ‘onsoctcp’. In the database field, enter ‘db_cra’ which is the database name that stores historical data. In the userId field, enter ‘uccxhruser’ which is the default Historical Reporting user. The password for this user can be set at ‘Password Management’ page of the Unified CCX Administration web interface. The password 4-3 Cisco Unified Contact Center Express Historical Reporting Administrator and Developer Guide, Release 8.0(1) Chapter 4 Creating Custom Historical Reports for Cisco Unified CCX Creating a Report
management page appears under ‘tools’ menu of appadmin. In the password field of ODBC Driver set up page, enter the password which is set at ‘Password management page’ by administrator. Click
Apply & Test connection.Select the Environment tab. Select the Use Server Database locale check box. Ensure that the entry for Fetch Buffer size field is 32767. If default entry is other than 32767, then manually change it to 32767. Click Apply.The ODBC Driver Setup window is displayed. Enter a unique DSN name. Enter a suitable description. Click Apply.The Create New Data Source window is displayed. From the list of available data sources, select IBM INFORMIX ODBC DRIVER. Click Finish.Click on Add to create a new dsn.Select the System DSN tab. ODBC Data Source Administrator window is displayed. Go to Control Panel > Administrative Tools > Data Sources.
Ensure that the Test Connection was successful message is displayed. You can view the newly created DSN in the list of DSNs. Close the window.
Is there a way to find out which tables are still accessible for queries and which are not (need extra permission which is no longer allowed in v8)?
I hope this sheet bellow will help you:
looks great ...
but how can you selected the table from db_cra ????
as this is uccx8 not 7 . and for uccx7 you select all of the table from sql .. so how can can you do that on UCCx8 ?
Unfortunately there is no such builtin possibility to browse the tables like with MSSQL Enterprise Manager or Query Browser was comming with MSSQL Enterprise that was comming with a Premium licensed UCCX 7.x or prior. Morover, the programatical access trough ODBC from a windows host was given as the Windows operating system comes with MSSQL odbc driver by default.
In case of UCCX 8 the used db system is Informix.
If you want to access it you have to install the proper driver on the accessing PC.
You can download it from here an AP for the proper operating system:
The package contains ODBC driver for informix, and c++ library for native access as I remember. The package is free.
Unfortunately the JDBC driver for informix is not free.
You can setup an ODBC connection for example, and trough that you can query the table from your application.
If you just want to browse the tables, there are a bunch of sql tools on the market supporting informix. I am sure you can find the proper one.
Hope this helps you.
I've used http://squirrel-sql.sourceforge.net/
And the IBM informix jdbc driver
But as previous stated, IBM notes on the download page that it is a "trial" driver with limited features and not meant for production. I have no clue what the real driver costs..
I've used AGS Server studio to connect to informix: http://www.serverstudio.com/ You can use it to view the permissions on each object and also create stored procedures and other database objects. This has a 30day limit.
Another option is IBM Data Studio which is based on eclipse and it's free. This too will let you connect and manage the informix database: http://www.ibm.com/developerworks/downloads/im/data/
First thanks a lot for the post and instructions. I spend few hours but I am able to make the connection.
Now the problem I am having is refreshing the page. I have set "RefreshTime = 10" and in "Real Time Snapshot Writing Configuration for Wallboard" its set to 10 seconds.
First time the page shows fine but then after 10 seconds I get
The page cannot be found
|The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.|
Please try the following:
HTTP 404 - File not found
We have UCCX 8.0.2 and I used IBM Informix in ODS System DSN.
Thanks for the help.
I had same issue cannot get agent table display ..
so can you share your agent .asp file to me ?
I just found your message that your wallboard is working with UCCX 8 server. I have UCCX8.02 and try to use Symon board. We can get connection between UCCX8 and Symon board but we received "The parameter is incorrect" and "Login failed. Catalog information cannot be retrieved" error message.
Can you advise what we can do to Symon board to be working? We use uccxwallboard as the user ID....
My customer is using UCCX 8.5.1 in HA>
We are trying to map reason codes to reason code descriptions to display them on a Wallboard and we are looking in the table:
We have managed to connect to the database to get reporting statsistics. However whenever we run the following query, we get 0 results back:
Select * from EEMReasonCodeDescription
The user we are using is: uccxhruser as per the “Cisco Unified Contact Center Express 8.5(1) Historical Reporting Administrator and Developer Guide"
However when I look at the "Cisco Unified CCX Administration Guide, Release 8.5(1)", this guide mentions that we should be using uccxwallboard on page 491.
My question is has anyone used either of these users to successfully retrieve data from a UCCX 8.0 or 8.5? If so which user did you use and was there anything else required to gain access to the eemreasoncodedescription table?
Any assistance with this would be greatly appreciated.
Kiarash, The EEM part of the table refers to the optional email tables and is not the table used for the reasoncodes…..
You need to use the user UCCXHRUSER and this will allow access to the stats you need.
Cisco do not promote the use of this user as it is also used for the HR tool
You will need to change the HR user password on both nodes as you did for the wallboard user.
Thanks Mark -We are using the UCCXHRUSER and have established a connection. We get stats about the CSQ etc.
@Jeroen - Do you know what is the correct table if this not the correct one to get the Reason code to Reason code description?
Cisco's schema definition below for EEMReasonCodeDescription is very misleading:
EEMReasonCodeDescription: The EEMReasonCodeDescription table contains descriptive text (in English only) for each possible reason code.
This thread seemed to indicate that this was the correct table but no one seems to have got it to work:
There is no table in the DB with reason code descriptions. The reason codes are stored only as ints.
When I've worked with reports etc that use these codes, I've had to map them to static strings in whatever app I'm querying the DB with (e.g. wallboard, crystal etc). It's not ideal, but changing reason codes is generally not done frequently.
'EEM' is the clue in that table name, it refers to the email subsystem.
Please rate helpful posts...
That’s right Aaron, in the older versions there was. The reasoncode numbers can be found in the CAD admin tool. The standard reason codes are explained in the historical reports user guide (search for uccx85hrug)
Thanks so much for your help gents. I can't see how Cisco can take functionality away and provide no new method attaining this information.
There must be a way of attaining the mapping between the Reason Code and the Definition as CAD does it in Desktop Admin. Has anyone actually asked Cisco directly with regards to this?
I just tried with my lab setup, and the table stays empty. I have never asked Cisco as to why they choose not to use this table at all, or in which case this table does get filled…..
Me neither - since the functionality doesn't exist now, I'm sure TAC would say it was 'working as designed' and we should submit a feature request/usage case etc. I've never needed it enough to go through such pain.
CAD does it easy enough, as the DB that CAD and the other desktop apps connects to is (I believe) the LDAP db that the Calabrio half of the system uses. That's where the codes are stored, and it's not easy to get at the information programatically.
I have put a question into a friend at Calabrio. If I don't get a response I will escalate this to TAC to pose the question and will update this thread with what they say.