Cannot change Agent config in RM - database read/write error

Unanswered Question
Feb 20th, 2008

If i try to change the config of an agent, i get an error that says

There was an error reading/updating the database. Please contact your administrator.

All SQL services are started or activated.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
hadbou Tue, 02/26/2008 - 14:05

When trying to add some like "skill" or update something like "Contact Service Queues" via CRSADMIN page, I got "There was an error in reading/updating database. Please contact your administrator".

Analysis: CRS SQL server history datastore (HDS) and CRS SQL server config datastore (CDS) were marked as invalid due to temp replication error during CRS upgrade, then node manager will not start SQL server history and config task, so update ICD config will fail.

Workaround: For HDS invalid datastore flag issue on CRS server,

Do the following LDAP change on CCM pub, using DC directory,

1. I changed the flag at location CCNApp-> Clusters-> ivr2->Nodes->1->NodeSpecific->Components-> CRS Historical Datastore->invalidDatastore from "true" to "false"

2. Restarted the publisher node CRS Node Manager

For CDS invalid datastore flag issue on CRS server:

1. Changed the flag at location CCNApp-> Clusters-> ivr2->Nodes->2->NodeSpecific->Components-> CRS Config Datastore->invalidDatastore from "true" to "false"

2. CRS Node Manager services on both nodes needs to be restarted.

3. On subscriber node CRS server, got to control center-> component activation page and deactivate both HDS & CDS and

shincanada Mon, 05/26/2008 - 15:18

What are the rest of the steps after you deactivate both HDS & CDS?

sorinbadea Wed, 02/27/2008 - 13:57

I personally was getting that error when I was not on the master server on a HA setup. Do you have HA? Have you tried the other server?


This Discussion