cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

QMAD2003 Error while synching database in Cisco Unified Workforce Optimization Quality Management (QM) administration pages

3512
Views
10
Helpful
3
Comments

QMAD2003 error is usually due to UCCX server's hostname not all being in lowercase or having special characters in the hostname, etc.  That in turn will cause the database instance name not being recognized by QM.  As a rule:

  • Informix DB name must be in all lower case
  • If Informix DB name contains dashes "-", they should be replaced with underscores "_"
  • If Informix DB name starts with a number, add "i" to beginning
  • Example: 1234-INFORMIX should be entered as i1234_informix

The sync.dbg log may contain error like this:

2011-05-26 10:29:38,171 STACK SYNC2000  [pool-3-thread-1|RedundantDatabase#getConnection:43] java.sql.SQLException: [Informix][Informix ODBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.

The best way to handle this is to change the hostname (server name) in appadmin of UCCX server, follow the naming convention mentioned above and restart both UCCX server and QM server afterwards.

Comments
Beginner

will changing the hostname automatically change the informix db server name?

Beginner

Got it to work already no need to change hostname, just the configuration on Cisco Unified CC Database in Site Configuration of QM.

Also need to change password of the 'uccxworkforce' on the UCCX admin page.

Beginner

works for me, Running the postinstall file in cisco\wfo_qm\bin\postinstall.exe, change the uccx server name to lowercase, retype the uccxworkforce password.

Then restart the sync service, then you will see the users administration agents

But the first tool i used was the sync.log as mentioned before.

Thanks everybody

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards