Network access for Distributed Transaction Manager (MSDTC) has been disabled

Kinetic ERP
1

I have a post-processing BPM on SalesOrder.Update that worked. Then I added this code and now I’m getting an error. The code runs when the user checks a UD field checkbox on order entry - and it still works there. But when they check the same checkbox on an updateable dashboard it triggers the error. Any ideas?


string sQueryName= "GetShipToAddress";
        var context = (Erp.ErpContext)Ice.Services.ContextFactory.CreateContext();
        using (var svc = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.DynamicQuerySvcContract>(context))
        {
          Ice.Tablesets.DynamicQueryTableset dsQuery = svc.GetByID(sQueryName);
          if (dsQuery !=null)
            {
            Ice.Tablesets.QueryExecutionTableset dsBAQ = svc.GetQueryExecutionParameters (dsQuery);
            dsBAQ.ExecutionParameter[0].ParameterID = "OrderNum";
            dsBAQ.ExecutionParameter[0].IsEmpty=false;
            dsBAQ.ExecutionParameter[0].ParameterValue = OrderNum.ToString();
            DataSet results = svc.Execute(dsQuery, dsBAQ);
            if(results !=null && results.Tables.Count>0 && results.Tables[0].Rows.Count > 0 )
              {
              DataRow srow = results.Tables[0].Rows[0];
              ShipToAddress = srow["Calculated_ShipToAddress"].ToString();
              }
            dsBAQ=null;
            }
            dsQuery=null;
        
        }

Ice.Common.EpicorServerException: BPM runtime caught an unexpected exception of ‘EntityException’ type.
See more info in the Inner Exception section of Exception Details. —> System.Data.Entity.Core.EntityException: The underlying provider failed on Open. —> System.Transactions.TransactionManagerCommunicationException: 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. —> System.Runtime.InteropServices.COMException: The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)
at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim)
at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken)

2

You create new context

 var context = (Erp.ErpContext)Ice.Services.ContextFactory.CreateContext();

and use it in transaction, this gives the error.
Either use the existing context or suppress transaction

3

How would I do that?

4

i think Db variable references the current context. So you should be able to just use it.

and you suppress transaction with something like this:

           using (new SuppressedTransactionScope())
                using (var dataContext =  code_to_create_context)) {
                  // do something with dataContext
                }
2 Likes
5

I don’t know what I’m doing wrong.

image
image864×494 29.8 KB

6

You have an extra “)” at the end of the CreateContext()); line (2)

7

ugh, thank you. That allows it to compile but still get the same error when using the updateable dashboard.

8

you have it in wrong order. You need to add line with Suppress before you create context.
You added it after context creation.
Switch 2nd and 3rd line (and add using for context as a good citizen

9

Still getting the same error :frowning:

image
image874×376 27.4 KB

10

If this is in a BPM dont create a new context just use Db

Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.DynamicQuerySvcContract>(Db)

https://www.epiusers.help/search?q=getservice

1 Like
11

it is not context, it is service rendeder - reference to the service method that takes context as a parameter.

You create context on line 2
var context = … CreateContext()

12

Thanks!

13

Thank you for all your help!!