Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Latest update appears ...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Latest update appears to have broken child dialogs

(0) ShareShare
ReportReport
Posted on by LXX 20

Our Dynamics 365 Online was automatically upgraded to v1710(9.1.0.10123) at the end of last week.

Now all our out-of-the-box dialogs that call child dialogs are failing with error code -2147220970.

Is anyone else having the same issue and/or does anyone know if this is a known issue and how to fix it?

<d2p1:key>ApiOriginalExceptionKey</d2p1:key>
      <d2p1:value xmlns:d4p1="">www.w3.org/.../XMLSchema" i:type="d4p1:string">Microsoft.Crm.CrmException: An unexpected error occurred. ---&gt; System.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initialized
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Crm.CrmDbConnection.LockConnectionAndExecuteMethod[TResult](IDbConnection connection, Func`1 executeMethod)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command, ICrmTransaction crmTransaction)
   at Microsoft.Crm.CrmDbConnection.&lt;&gt;c__DisplayClass138_0.&lt;InternalExecuteNonQuery&gt;b__0()
   at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)
   at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
   at Microsoft.Crm.Platform.Server.DataEngine.SqlDataAccessManager.ExecuteNonQuery(IDbCommand command, ISqlExecutionContext context, Int32 sourceLineNumber, String memberName, String sourceFilePath)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteNonQuery(IDbCommand command, ISqlExecutionContext context)
   at Microsoft.Crm.BusinessEntities.DenormalizedAttributeTrigger.PerformSelectAndUpdateForDenormalizedFields(SelectPlan selectPlan, String updateEntityName, String updateFilterAttributeName, Guid updateEntityId, Dictionary`2 sourceDestinationColumnMap)
   at Microsoft.Crm.BusinessEntities.DenormalizedAttributeTrigger.PopulateChildDenormalizedFieldsForEachParentId(Guid triggerEntityId)
   at Microsoft.Crm.BusinessEntities.DenormalizedAttributeTrigger.Update(Guid id)
   at Microsoft.Crm.BusinessEntities.TriggersExtension.ExecuteTriggers(BusinessEntity entity, ArrayList triggers, OperationType operationType)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoUpdate(IBusinessEntity entity, FilterExpression filter, ExecutionContext context)
   --- End of inner exception stack trace ---
   at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.PipelineInstrumentationHelper.Execute(Boolean instrumentationEnabled, String stopwatchName, ExecuteWithInstrumentation action, PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.Pipeline.&lt;&gt;c__DisplayClass2_1.&lt;Execute&gt;b__0()</d2p1:value>

  • LXX Profile Picture
    LXX 20 on at
    RE: Latest update appears to have broken child dialogs

    We had to raise a request with Microsoft support to get them to deploy the patch mentioned below:

    This information can be found on O365 Service Health Overview status page

    Title: Workflow failures

    User Impact: Users with workflows containing child dialogs may have experienced failures.

    Final Status: The code fix has been developed and confirmed to resolve the Workflow failures. This will be deployed to all affected regions in the next scheduled deployment. If your organization would like to receive this patch sooner, please contact Microsoft Dynamics 365 customer support.

    Preliminary Root Cause: A recent update identified a compatibility configuration issue with legacy Workflow features.

    Next Steps: We're reviewing our update procedures to better identify similar issues during our development and testing cycles.

    User Experience: Users with workflows containing child dialogs may have experienced failures.

    For more information and status updates, please see the Service Health Dashboard in Office 365.

    Impacted customers will have two options to receive the code fix.

       The first option is for them to contact support, by opening a case at https://admin.powerplatform.microsoft.com and have support run the mitigation on the instance.

       The second option is to wait until a permanent fix is developed, and is included in the next scheduled deployment.

  • Felix Brem Profile Picture
    Felix Brem 55 on at
    RE: Latest update appears to have broken child dialogs

    Hello Sapna, do you have more information to this service interruption, e.g. a statement from MS?

  • Felix Brem Profile Picture
    Felix Brem 55 on at
    RE: Latest update appears to have broken child dialogs

    Hello, we do have the same problem, have you found a solution yet? Thank you in advance.

  • Anne_Sivesind Profile Picture
    Anne_Sivesind 5 on at
    RE: Latest update appears to have broken child dialogs

    Hi, 

    Unfortunately I'm not able to reach the script. Looks like the repository is locked for all users. 

    Anne

  • Sapna Girish Profile Picture
    Sapna Girish 200 on at
    RE: Latest update appears to have broken child dialogs

    There is a service interruption and currently, there is a workaround to resolve the issue -

    1. If you are with Online environment you will need to open a Service Request so the mitigation script is ran to fix the issue. Mention this thread on the description of the case. Please open the case from https://admin.powerplatform.microsoft.com

    2. Go customization -> Publish customization

    3. Go to customization -> entity -> Flow session -> 1:N Relationship

    4. Look for relationship lk_workflowlog_flowsessions ,lk_workflowlog_flowsession_childworkflow

    5. Use the delete option to delete the relationship lk_workflowlog_flowsessions ,lk_workflowlog_flowsession_childworkflow

  • LXX Profile Picture
    LXX 20 on at
    RE: Latest update appears to have broken child dialogs

    By out-of-the-box dialogs, I mean dialogs that we have created via Settings --> Processes. They aren't custom plug-ins.

    e.g.

    We have a dialog that allows the user to update fields on an entity.

    The next step in the dialog is to call a child dialog (that is shared across multiple dialogs) that sends a confirmation email

    As soon as the user clicks "Next" within the main dialog to move to the child dialog we get an "Unexpected error"

    An unexpected error occurred.

    System.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initialized

    The only common thread with the dialogs that are failing is that they fail when user clicks "Next" to move to a child dialog

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Latest update appears to have broken child dialogs

    Hi partner,

    Could you give me an example of out-of-the-box dialogs that call child dialogs?

    My environment is also v1710 (9.1.0.10123), if I can reproduce this problem, then I will reflect it to the Microsoft team as a bug.

  • LXX Profile Picture
    LXX 20 on at
    Latest update appears to have broken child dialogs

    Our Dynamics 365 Online was automatically upgraded to v1710(9.1.0.10123) at the end of last week.

    Now all our out-of-the-box dialogs that call child dialogs are failing with error code -2147220970.

    Is anyone else having the same issue and/or does anyone know if this is a known issue and how to fix it?

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans