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 09, 2019

Applies to:

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

Symptoms

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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