Network access for Distributed Transaction Manager... Please enable DTC... [ Edited ]

[RKushner]

Here's my error message:

"Failed to execute deployed method 'DataValue', using entity 'Grid1'. Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)"

But why should MetaStorm need distributed transactions? The only connection that I am using is MetastormDefault. My tables are in the Metastorm database instance!

I even removed all but one business object, and that one uses the eEvent table. In the business objects grid, the fields populate from the database and the test works fine as well. There is nothing distributed!!!

[Jerome҉]

We had that too, and it was the configuration of the MSDTC. We were accessing tables in a different database, so I was not surprised at the 'D' part, but I agree it seems odd if you remain in the same database.

It was resolved by the SQL Server admin adjusting the MSDTC settings, but I'm afraid I am not certain what he did. I'll see if I can find out.

[RKushner · Accepted solution]

I found this in the Installation Guide and it resolved the problem:

1.3.20 MSDTC Configuration

To connect a Table Business Object or Query Business Object executing from the Process Engine to a

database running on a separate machine, the MSDTC configuration settings should be changed.

The following configuration is required on both Engine and Database systems:

1. Go to Start>Control Panel> Administrative Tools.

2. Open Component Services>Computer>My Computer.

3. Right-click My Computer and click Properties.

4. Under Default Coordinator section, select Use Local Coordinator.

5. Select the MSDTC tab and click the Security Configuration button.

6. Select Network DTC Access.

7. Under Transaction Manager Communication, select Allow Inbound and Allow Outbound.

8. Click OK. When you click OK, you will be prompted for MSDTC service to restart.

9. Once the MSDTC service is restarted, restart the Metastorm Process Engine Service by going to Start->control Panel->Administrative Tools->Services.