I have added a new HA license and an IPCCX server (Slave) recently.
Historical Reports client login but when trying to generate a report it displays an error message prompting the user to reconnect since a database connexion was lost.
In the hrcConfig.ini I found that :
SERVER=172.16.100.6\CRSSQL ==> the slave HR server IP address
When I change 172.16.100.6 address to the master HR server IP address and restart the client it doesn't change.
So I put that address in the CRA_Database_alternative.
Looking in the Historical Reports Log in the client machine I found the following :
12: 19/04/2007 17:38:56 %CHC-LOG_SUBFAC-3-UNK:CRA_DATABASE Connection String:
13: 19/04/2007 17:38:56 %CHC-LOG_SUBFAC-3-UNK:SQL command failed, couldn't establish database connection
14: 19/04/2007 17:38:56 %CHC-LOG_SUBFAC-3-UNK:Failed to run Interpreted SQL Command(Exec db_cra.dbo.sp_agent_log_activity '04/19/2007 12:00:00 AM', '04/19/2007 10:00:00 AM', 0, 'NULL', 'NULL', 'NULL', 'NULL')
What may be the cause of that issue?
I really don't understant what is the problem because before adding the new server it works perfectly.