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

Jayark: /* There is an error displayed in the appadmin while trying to modify the Datasource configuration */

2010-05-04T07:35:29Z

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

← Older revision		Revision as of 07:35, 4 May 2010
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’

Jayark at 07:34, 4 May 2010

2010-05-04T07:34:27Z

← Older revision		Revision as of 07:34, 4 May 2010
Line 18:		Line 18:
	\| 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 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

Jayark: 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...

2010-05-04T07:33:23Z

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...

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 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 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'''
|-
|}

[[Category:Unified CCX, Release 7.0]]