"There is no active transaction" error and no meaningful trace to go on

(0) Share

Report

Posted on by MateuszBender

210

A customer running Dynamics 365 online is getting the following error when attempting to qualify leads.

{"ActivityId":"f4185e25-7cb6-4f5d-b13f-77ea896bb8c7","errorCode":2147746385,"message":"There is no active transaction. This error is usually caused by custom plug-ins that ignore errors from service calls and continue processing.","stacktrace":"   
at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext, Dictionary`2 optionalParameters)\r\n   
at Microsoft.Crm.Extensibility.OData.CrmODataExecutionContext.Execute(OrganizationRequest request, ExecutionContext executionContext)\r\n   
at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.ExecuteOperation(CrmODataExecutionContext context, EdmOperation edmOperation, Dictionary`2 parameters, Dictionary`2 boundParameters)\r\n   
at Microsoft.Crm.Extensibility.OData.ActionController.ProcessOperationRequest(String operationName, Dictionary`2 operationParameters, EntityReference entityReference, String boundEntityName, String boundEntityType)\r\n   
at Microsoft.Crm.Extensibility.OData.ActionController.<>c__DisplayClass11_0.<PostBoundAction>b__0()\r\n   
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n   
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n   
at lambda_method(Closure , Object , Object[] )\r\n   
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n   
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n
--- End of stack trace from previous location where exception was thrown ---\r\n   
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n
--- End of stack trace from previous location where exception was thrown ---\r\n   
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n
--- End of stack trace from previous location where exception was thrown ---\r\n   
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   
at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()","Timestamp":1557238317547}

The problem seems to be intermittent - it shows for some records, not all. It also seems to be related to permissions somehow, as CRM administrators are able to qualify the leads for which the users are getting the above error.

Normally when such an error shows up it there's some meaningful information in the trace which either points to a different error (for ex. no permissions for a specific entity) or a plugin (class name, step type, etc). This time, however, the error is meaningless and doesn't seem to contain anything of value and I don't know how to proceed.

Any help would be appreciated.

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

MateuszBender 210 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

The problem vanished as suddenly as it appeared after we contacted MS for help. I've no idea what was going on, but it seems MS did something magical on their end of things - at least in my case.
gowthamtalluri 30 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

Hi,

Wondering if you are able to find the solution? our organization is also facing the same issue from last week.

Thanks,
Kokulan 18,048 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

You might have already tried, but just wanted to double check if you enabled plugin trace log and asked the users to try again?
MateuszBender 210 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

This, unfortunately, doesn't help me much. The issue seems to occur (seemingly) at random, and only for non-admin accounts on a customers production CRM. As such, we (as in, the people developing solutions for the customer) have a single administrative account and no "regular" user accounts. In other words - I'm unable to replicate the problem. At best I can ask the customer to do something, but not in real-time. This makes debugging the problem extremely frustrating.

While the above isn't an insurmountable obstacle and sooner or later - probably later - someone will finally set up an additional "user" account for us to use to debug this. But I was hoping there's something else I can try from an administrative perspective to try and get some better logs.
Suggested answer

Kalpavruksh D365 CoE 2,545 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

Hi,

This error occurs when we assign team/user to another record and the logged in user does not have rights to that entity. Please check if there are any missing read permissions on Opportunity or Lead.

Please refer this link for more details: community.dynamics.com/.../crm-error-there-is-no-active-transaction-this-error-is-usually-caused-by-custom-plug-ins-that-ignore-errors-from-service-calls-and-continue-processing

Please mark this answer as verified, if found useful.
Suggested answer

Kokulan 18,048 on at

Like (0)

Report

RE: "There is no active transaction" error and no meaningful trace to go on

Hi

You get this error when a plugin or process failed but the qualify lead action was not able to get the actual Inner Exception error message.

Your assumption could be right, it could be due to permission issue.

If you enable plugin trace log and then try the Qualify, you should be able to get the actual error message

Please see the link below if you would like to know how to enable plugin trace log

ssharmacrm.wordpress.com/.../dynamics-crm-enable-plugin-trace-log

If the plugin trace log does not log the actual error, you could also check if there are any plugins/real-time workflows on Lead, Opportunity, Account and Contact and see if you could disable/deactivate one by one and see if you could isolate the issue.