My Oracle Support Banner

"Format of the initialization string does not conform to specification starting at index" when using an External Data Source with BAM (Doc ID 1214236.1)

Last updated on OCTOBER 20, 2021

Applies to:

Oracle BAM (Business Activity Monitoring) - Version and later
Information in this document applies to any platform.


You have created an an External Data Source pointing to an Oracle Database 
You have created a Data Object pointing to the External Data Source  
Find that if you attempt to see the content of the Data Object the following error is generated:

Oracle.BAM.ActiveDataCache.Common.Exceptions.CacheException: ADC Server exception in OpenViewset(). ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 77.
  at System.Data.Common.DBConnectionString.GetKeyValuePair(Char[] connectionString, Int32 currentPosition, String& key, Char[] valuebuf, Int32& vallength, Boolean& isempty)
  at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
  at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
  at System.Data.Odbc.OdbcConnectionString.ParseString(String connectionString)
  at System.Data.Odbc.OdbcConnection.set_ConnectionString(String value)
  at System.Data.Odbc.OdbcConnection..ctor(String connectionString)
  at Oracle.BAM.ActiveDataCache.ExternalDataSources.ODBC.Open(String strXml)
  at Oracle.BAM.ActiveDataCache.Kernel.Datasets.ExternalStorageEngine.GetDataReader(DSEQuery oDseQuery)
  at Oracle.BAM.ActiveDataCache.Kernel.Viewsets.Utilities.ExternalData.DataImporter.ExecuteQuery()
  at Oracle.BAM.ActiveDataCache.Kernel.Viewsets.Utilities.ExternalData.ExternalDataManager.ImportExternalData(String strDatasetID, String strTempName, FilterExpression filter)
  at Oracle.BAM.ActiveDataCache.Kernel.Viewsets.Utilities.ExternalData.ExternalDataManager.ImportExternalFactData()
  at Oracle.BAM.ActiveDataCache.Kernel.Viewsets.Utilities.ExternalData.ExternalDataManager.GetExternalData()
  at Oracle.BAM.ActiveDataCache.Kernel.Viewsets.Viewset.LoadData()
  at Oracle.BAM.ActiveDataCache.Ker




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.