Monday, April 16, 2012

A Database Connection Error 5051 error appears in HRC 8.0 or 8.5 when a user tries to login to HRC in a Windows 7 64bit machine

This error is seen when the HRC client is unable to connect to the Informix DB of the UCCX server.

After basic configurations are verified(such as):

Ensure Informix is up on the UCCX
“uccxhrc” username has not been changed
There is no firewall/blocked ports between the PC and the UCCX node
Under C-->Program Files-->Cisco UCCX Historical Reports

Install the Informix drivers on the client machine. Download the same from:

http://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html

The error 5051 points to the inability of the HRC client to open a ODBC connection to the Informix Database on the UCCX. Thus, the issue can be either on the server side(where the DB is down) or on the client side (where it is unable to open a ODBC connection).

The above wokaround is for a client side resolution and also for a Windows 7 x64bit machine.

An Exceptional Error 5022 error appears in HRC 8.0 or 8.5 when a user tries to login to HRC in a Windows 7 64bit machine

When a user tries to login to HRC, the following error is seen: “An Exceptional Error occurred. Application exiting. Check the log file for error 5022”

This could occurs because of a particular file and its dependant .dll files being unregistered. You can verify from the logs, when you see the error similar to:

“Error # 339 ,Description= Component 'MSMASK32.ocx' or one of its dependencies not correctly registered: a file is missing or invalid ,LastDllError= 0”

Therefore, please follow this workaround:

Reinstall HRC (install as Administrator this time)
If the issue still remains, verify the logs if you see the above mentioned error.
If yes, please register the dll manually.

Open the “command prompt” on the PC

•1. cdC:\Windows\SysWOW64
•2. regsvr32msmask32.ocx

You should get a prompt saying “DllRegisterServer in MSMASK32.ocx succeeded”

Try to open and login to HRC again.

P.S. The .ocx file name could be different to the one mentioned here.