Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Getting SQL server Err...
Microsoft Dynamics CRM (Archived)

Getting SQL server Error while Deactivating Main form in contact entity in Default solution

(0) ShareShare
ReportReport
Posted on by Rajeshvarma 40

Hi All,

While am Deactivating Main(contact)  form in Default solution in Contact entity,Am getting Sql Error.

Am  using Dynamics 365 online v9. Can any one tell me the solution how can achieve this issue?

error-contact1.pngerror-contact2.png

*This post is locked for comments

  • VermaNitin Profile Picture
    VermaNitin 455 on at
    RE: Getting SQL server Error while Deactivating Main form in contact entity in Default solution

    Hi,

    From the error log it seems that the process took a long time than expected.

    Kindly recheck with a better network speed.

    Also take care of the fact:

    There should be at least one form of type main in Active state for an entity. System will not allow deactivating all forms of type main.

    Let me know if it works!

    Many thanks,

     Nitin Verma

  • Rajeshvarma Profile Picture
    Rajeshvarma 40 on at
    RE: Getting SQL server Error while Deactivating Main form in contact entity in Default solution

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: SQL timeout expired.

      at Microsoft.Crm.Dialogs.ChangeFormStateDialogPage.ConfigureForm()

      at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)

      at Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e)

      at System.Web.UI.Control.PreRenderRecursiveInternal()

      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.HandleError(Exception e)

      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.ProcessRequest()

      at System.Web.UI.Page.ProcessRequest(HttpContext context)

      at ASP._grid_cmds_dlg_changeformstate_aspx.ProcessRequest(HttpContext context)

      at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

      at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #B674D44EDetail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ActivityId>bf86c752-fb7a-4741-9554-03acd0a28373</ActivityId>

     <ErrorCode>-2147220970</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

     <Message>System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: SQL timeout expired.

      at Microsoft.Crm.Dialogs.ChangeFormStateDialogPage.ConfigureForm()

      at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)

      at Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e)

      at System.Web.UI.Control.PreRenderRecursiveInternal()

      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.HandleError(Exception e)

      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

      at System.Web.UI.Page.ProcessRequest()

      at System.Web.UI.Page.ProcessRequest(HttpContext context)

      at ASP._grid_cmds_dlg_changeformstate_aspx.ProcessRequest(HttpContext context)

      at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

      at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #B674D44E</Message>

     <Timestamp>2018-03-28T10:48:15.7692755Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault>

       <ActivityId>bf86c752-fb7a-4741-9554-03acd0a28373</ActivityId>

       <ErrorCode>-2147204783</ErrorCode>

       <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

       <Message>SQL timeout expired.</Message>

       <Timestamp>2018-03-28T10:48:15.7692755Z</Timestamp>

       <ExceptionRetriable>false</ExceptionRetriable>

       <ExceptionSource i:nil="true" />

       <InnerFault i:nil="true" />

       <OriginalException i:nil="true" />

       <TraceText i:nil="true" />

     </InnerFault>

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

  • Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,203 on at
    RE: Getting SQL server Error while Deactivating Main form in contact entity in Default solution

    Try to download the log file and post it here

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans