0
Answered

Identity Broker Service does not start - event viewer error indicates that connection string attribute is missing even though attribute exists in extensible configuration

Joe Varkey 14 years ago updated by anonymous 9 years ago 4

Task:
Installation of Identity Broker for SAP HCM

Task List:
1. Install Identity Broker service
2. Configure Identity Broker service
3. Install and configure connector and adapter components.

After the successfull installation of Identity Broker service the Identity Broker database was created and the Identity Broker script ran sucessfully. The next step was to configure the service with the datbase connection details as given below. Upon starting the Identity Broker service the following error was captured as given below.

The error indicates that the connection string is missing in the configuration file however the string is present in the DataEngine.extensibility.config.xml configuration.

DataEngine Configuration:
<DataEngine>
<dataRepository>
<dataConnection name="sql" repository="FIM_DEV_Unify_IdentityBroker" connectionString="Data Source=amausgcdbad05;Initial Catalog=FIM_DEV_Unify_IdentityBroker;Integrated Security=True" />
</dataRepository>
</DataEngine>

DataEngine Configuration Values:
Database type = SQL
Database server = amausgcdbad05
Database Name = FIM_DEV_Unify_IdentityBroker

Event Viewer:

  • <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  • <System>
    <Provider Name="UNIFY Identity Broker v3.0 service" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-01-11T23:07:57.000000000Z" />
    <EventRecordID>1264</EventRecordID>
    <Channel>Application</Channel>
    <Computer>AMSGCQAP01.int.alliedmills.com.au</Computer>
    <Security />
    </System>
  • <EventData>
    <Data>Service cannot be started. Unify.Framework.AdoNetDataControlConfigurationException: Missing connectionString attribute from <dataConnection name="sql" repository="FIM_DEV_Unify_IdentityBroker" /> at Unify.Framework.AdoNetDataControlFactoryBase.SetConfiguration(XElement configurationElement) at Unify.Framework.SqlServerDataControlFactory..ctor(XElement element) at Unify.Framework.SqlServer.SqlServerDataControlGenerator.CreateComponent(XElement element) at Unify.Framework.PlugInGeneratorBase`4.CreateComponent(TFactoryInfo factoryInformation) at Unify.Framework.StoredValuesEngine..ctor(IAdoNetDataControlGenerator dataControlGenerator, DirectoryInfo executingAssemblyDirectory) at Unify.Framework.StoredValuesEnginePlugInFactory.CreateComponent(IUnifyEnginePlugInFactoryInformation factoryInformation) at Unify.Framework.DependencyPlugInGenerator`4..ctor(ICollection`1 plugInGenerator, IPlugInFactory`2 factoryInformationFactory) at Unify.Framework.UnifyEngine..ctor(IEnumerable`1 additionalPlugInFactories, Di...</Data>
    </EventData>
    </Event>

Hi Joe,

You're receiving this error because you've made unnecessary edits to a number of configuration files. The only change you need to make from the default is the connection string contained in the <dataConnection> element of the DataEngine file.

The "repository" name should remain as "Unify.IdentityBroker", and other files (such as the StoredValues file which is the one causing this error) should remain unchanged. For example, the dataConnection element in StoredValues would look like this:

<dataConnection name="repository" repository="Unify.IdentityBroker" />

Thanks, service started successfully.

Service started sucessfully