"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 MARCH 08, 2017

Applies to:

Oracle Application Server Integration BAM - Version: 10.1.3.3 and later   [Release: AS10gR3 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms