Can't create a new Datasource from the Appadmin - Revision history

Jayark: /* Can't create a new Datasource from the Appadmin */

2010-05-04T07:30:41Z

Can't create a new Datasource from the Appadmin

← Older revision		Revision as of 07:30, 4 May 2010
Line 4:		Line 4:
	\|-		\|-
	! '''Problem Summary'''		! '''Problem Summary'''
-	\| Cannot create a new Datasource; get this error - Config Error occurred creating the Datasource. ~~Also trying to edit an existing Datasource gives the same error.~~ Even after refreshing the database schema from the editor step, the datasource not getting displayed.	+	\| Cannot create a new Datasource; get this error - Config Error occurred creating the Datasource. Even after refreshing the database schema from the editor step, the datasource not getting displayed.

	\|-		\|-

Jayark: /* Can't create a new Datasource from the Appadmin */

2010-05-04T05:28:58Z

Can't create a new Datasource from the Appadmin

← Older revision		Revision as of 05:28, 4 May 2010
Line 15:		Line 15:
	\|-		\|-
	! '''Recommended Action'''		! '''Recommended Action'''
-	\| Open SQL Query Analyzer and run the following queries.	+	\| Open SQL Query Analyzer and run the following queries in db_cra database.

	select ConfigClassID from ConfigSchema where className='com.cisco.crs.edbs.DataSourceConfig'		select ConfigClassID from ConfigSchema where className='com.cisco.crs.edbs.DataSourceConfig'

Jayark: New page: == Can't create a new Datasource from the Appadmin == {| border="1" |- ! '''Problem Summary''' | Cannot create a new Datasource; get this error - Config Error occurred creating the Dataso...

2010-05-04T05:27:55Z

New page: == Can't create a new Datasource from the Appadmin == {| border="1" |- ! '''Problem Summary''' | Cannot create a new Datasource; get this error - Config Error occurred creating the Dataso...

New page

== Can't create a new Datasource from the Appadmin ==

{| border="1"
|-
! '''Problem Summary'''
| Cannot create a new Datasource; get this error - Config Error occurred creating the Datasource. Also trying to edit an existing Datasource gives the same error. Even after refreshing the database schema from the editor step, the datasource not getting displayed.

|-
! '''Error Message'''
| "Config Error occurred creating the Datasource"

|-
! '''Possible Cause'''
| Even though the datasource gets created in the config object, the notification to the engine is failing. Even after enabling SS_DB DEBUG logging, you will not be able to see any logging related with the changes. The root cause of this issue is the presence of duplicate entries for className='com.cisco.crs.edbs.DataSourceConfig' in ConfigSchema and ConfigSchemaColumn table in the db_cra database.
|-
! '''Recommended Action'''
| Open SQL Query Analyzer and run the following queries.

select ConfigClassID from ConfigSchema where className='com.cisco.crs.edbs.DataSourceConfig'

Suppose the query returns two values, say 8 and 13. Take the higher value which is 13. Run the below queries using ConfigClassID as 13. You have to take the higher value returned in customer setup for executing the below queries.

delete from ConfigSchemaColumn where ConfigClassID = 13

delete from ConfigSchema where ConfigClassID = 13
|-
! '''Release'''
| Release 7.0, Release 5.0
|-
! '''Associated CDETS #'''
| None'''
|-
|}

[[Category:Unified CCX, Release 7.0]]