"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 10.1.3.3 and laterInformation 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
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 |