Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

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

Posted on by 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

  • Suggested answer
    MateuszBender Profile Picture
    MateuszBender 210 on at
    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 Profile Picture
    gowthamtalluri 30 on at
    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 Profile Picture
    Kokulan 18,048 on at
    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 Profile Picture
    MateuszBender 210 on at
    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 Profile Picture
    Kalpavruksh D365 CoE 2,545 on at
    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 Profile Picture
    Kokulan 18,048 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans