Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

UCCX 8.5.1 Informix uccxhruser access

We are attempting to connect Jaspersoft reporting to UCCX (vers. 8.5.1) informix database for read all access. We have set the uccxhruser password, installed the informix JDBC drivers into jaspersoft application and are using the following connection:

            

jdbc:informix-sqli://<IP>:1504/db_cra:INFORMIXSERVER= <hostname>

We are getting the following error:

image.png

Is there anything obvious in the setup, any help is appreciated.

  • Contact Center
4 REPLIES
New Member

UCCX 8.5.1 Informix uccxhruser access

Your particular database name should be "uccx_publisher_uccx".

One should note however, be careful in how often you query the database as it can have an impact on system stability and performance.

Tanner Ezell

www.ctilogic.com

UCCX 8.5.1 Informix uccxhruser access

Your particular database name should be "uccx_publisher_uccx".

One should note however, be careful in how often you query the database as it can have an impact on system stability and performance.

Tanner Ezell
www.ctilogic.com

Tanner Ezell www.ctilogic.com
New Member

UCCX 8.5.1 Informix uccxhruser access

Yes, thanks for the help. In fact we did have an underscore where required, I inadvertently posted an original error message. The latest attempt with the proper syntax: uccx_publisher_uccx  gave the same error.

Regards,

UCCX 8.5.1 Informix uccxhruser access

Reformat your connection string as such:

jdbc:informix-sqli://:1504/db_cra:INFORMIXSERVER=

Tanner Ezell
www.ctilogic.com

Tanner Ezell www.ctilogic.com
833
Views
0
Helpful
4
Replies