There is an error displayed in the appadmin while trying to modify the Datasource configuration

From DocWiki

(Difference between revisions)
Jump to: navigation, search
(New page: == There is an error displayed in the appadmin while trying to modify the Datasource configuration == {| border="1" |- ! '''Problem Summary''' | There is an error displayed in the appadmi...)
(There is an error displayed in the appadmin while trying to modify the Datasource configuration)
 
(One intermediate revision not shown)
Line 17: Line 17:
! '''Recommended Action'''
! '''Recommended Action'''
| If there are more than one entry for com.cisco.crs.edbs.DataSourceConfig present in the ConfigSchema table, then  find the highest configClassID. First delete the record from the ConfigSchemaColumn and then from the ConfigSchema table with the same configClassID. There should be only entry corresponding to com.cisco.crs.edbs.DataSourceConfig in the ConfigSchema and ConfigSchemaColumn tables. If there are more than one entries, those needs to be deleted.
| If there are more than one entry for com.cisco.crs.edbs.DataSourceConfig present in the ConfigSchema table, then  find the highest configClassID. First delete the record from the ConfigSchemaColumn and then from the ConfigSchema table with the same configClassID. There should be only entry corresponding to com.cisco.crs.edbs.DataSourceConfig in the ConfigSchema and ConfigSchemaColumn tables. If there are more than one entries, those needs to be deleted.
-
Run the following query from the SQL Query analyzer in node1.
+
Run the following query from the SQL Query analyzer selecting db_cra database in node1.
 +
 
Select configClassID from configSchema where className = ‘com.cisco.crs.edbs.DataSourceConfig’
Select configClassID from configSchema where className = ‘com.cisco.crs.edbs.DataSourceConfig’
 +
From the above query find the configClassID which is having higher value. Suppose higher configClassID is 9. Then run the following queries:
From the above query find the configClassID which is having higher value. Suppose higher configClassID is 9. Then run the following queries:
delete from configSchemaColumn where configClassID = 9
delete from configSchemaColumn where configClassID = 9
 +
delete from ConfigSchema where configClassID = 9
delete from ConfigSchema where configClassID = 9

Latest revision as of 07:35, 4 May 2010

There is an error displayed in the appadmin while trying to modify the Datasource configuration

Problem Summary There is an error displayed in the appadmin while trying to modify the Datasource configuration.

Error message is : Config Error occured creating the DataSource

Error Message "Config Error occured creating the DataSource"
Possible Cause There are duplicate entries in the ConfigSchema table in the db_cra database corresponding to com.cisco.crs.edbs.DataSourceConfig. There can not have more than one entry in the ConfigSchema and ConfigSchema table corresponding to DatasourceConfig.
Recommended Action If there are more than one entry for com.cisco.crs.edbs.DataSourceConfig present in the ConfigSchema table, then find the highest configClassID. First delete the record from the ConfigSchemaColumn and then from the ConfigSchema table with the same configClassID. There should be only entry corresponding to com.cisco.crs.edbs.DataSourceConfig in the ConfigSchema and ConfigSchemaColumn tables. If there are more than one entries, those needs to be deleted.

Run the following query from the SQL Query analyzer selecting db_cra database in node1.

Select configClassID from configSchema where className = ‘com.cisco.crs.edbs.DataSourceConfig’

From the above query find the configClassID which is having higher value. Suppose higher configClassID is 9. Then run the following queries:

delete from configSchemaColumn where configClassID = 9

delete from ConfigSchema where configClassID = 9

Release Release 7.0, Release 5.0
Associated CDETS # None

Rating: 0.0/5 (0 votes cast)

Personal tools