Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SQL Generic Error
Microsoft Dynamics CRM (Archived)

SQL Generic Error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Dynamic Stars,

I am unable to see any records from any entity and its stating that "A SQL Server error occurred". When I see in event viewer below error showing. For info we were doing integration of CRM with AX at the time we activated some mappings and deactivated again when we got this error then also no luck.

I have repair the CRM also...

Thanks in Advance.

RequestUrl: http://organization/crm/workplace/home_dashboards.aspx?pagemode=iframe&sitemappath=Workplace%7cMyWork%7cnav_dashboards, StackTrace: [CrmException: Generic SQL error.]

at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

at Microsoft.Crm.Application.Controls.DashboardSelector.RetrieveDashboard(String logicalName, String[] columns)

at Microsoft.Crm.Application.Controls.DashboardSelector.AddUserDashboard()

at Microsoft.Crm.Application.Components.UI.CrmUIControlBase.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

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

　

[HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]

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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

　

Regards,

Yogi.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Generic Error

    Hi David and Nithya Gopinath,

    Thanks for reply.

    I have resolved the issue, i just loaded the DB Backup files into CRM data base. After that CRM is working fine.

    Regards,

    yoig

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: SQL Generic Error

    Hi,

    You could also use the following diagnostic tool to get more details of the generic SQL error.

    http://crmdiagtool2011.codeplex.com/

    Hope this helps.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: SQL Generic Error

    If you have CRM OnPremise, you can enable tracing, and this should give you a more helpful error message

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

Product updates

Dynamics 365 release plans