web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / MS CRM 2013 Generic SQ...
Microsoft Dynamics CRM (Archived)

MS CRM 2013 Generic SQL Error

(0) ShareShare
ReportReport
Posted on by Suresh Sorde 1,077

Hi All,

I have installed new server for ms crm and restore old backup. 

Now i am getting 'Generic sql error' during edit of contact and account name.

Also lead entity page is loaded with same error. 

6052.Lead.png

Log detail :

-----------

[2017-10-12 03:10:03.432] Process: w3wp |Organization:17eeb24c-ba4d-4d35-b077-26fef79a3d4f |Thread: 13 |Category: Platform |User: 0d3700bf-63ff-4c35-acf8-8413ed610d2a |Level: Error |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | MessageProcessor.Execute ilOffset = 0x1CB
>MessageProcessor fail to process message 'RetrieveMultiple' for 'lead'.
[2017-10-12 03:10:03.432] Process: w3wp |Organization:17eeb24c-ba4d-4d35-b077-26fef79a3d4f |Thread: 13 |Category: Platform |User: 0d3700bf-63ff-4c35-acf8-8413ed610d2a |Level: Verbose |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | ExternalMessageDispatcher.ExecuteInternal ilOffset = 0x16E
>ExecutionContext not in use (OnErrorRequest) for organization {17EEB24C-BA4D-4D35-B077-26FEF79A3D4F}
[2017-10-12 03:10:03.433] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 13 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | FaultHelper.ConvertToFault ilOffset = 0x0
>TryConvertToFaultExceptionInternal: exception: Microsoft.Crm.CrmException
[2017-10-12 03:10:03.433] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 13 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | ExceptionConverter.DumpExceptionRecursive ilOffset = 0x26D
>NestingDepth: 24
[2017-10-12 03:10:03.434] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 13 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | ExceptionConverter.DumpExceptionRecursive ilOffset = 0x26D
>NestingDepth: 24
[2017-10-12 03:10:03.434] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 13 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId: 333392f4-df93-43fc-95ce-ebae94e06286 | ExceptionConverter.TryConvertToFaultExceptionInternal ilOffset = 0x2D
>----- dump exception/fault tree (TryConvertToFaultExceptionInternal: before) -----
>>>>>> EXCEPTION: 0
>Type: Microsoft.Crm.CrmException
>ErrorCode: 0x80044150:
>Message (18): Generic SQL error.
>StackTrace: present: 2EA15F28
>no PluginTrace
>>>>>> EXCEPTION: 1
>Type: Microsoft.Crm.CrmException
>ErrorCode: 0x80044150:
>Message (18): Generic SQL error.
>StackTrace <null>
>no PluginTrace
>>>>>> EXCEPTION: 2
>Type: System.Data.SqlClient.SqlException
>Message (57): Could not continue scan with NOLOCK due to data movement.
>StackTrace: present: 77A24B11
>PluginTrace <null>
>InnerException <null>
><<<<< EXCEPTION: 2
>

Urgent help required.

Thanks in advanced.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    David Jennaway Profile Picture
    David Jennaway 14,065 on at

    This looks like a SQL problem more that a CRM one. I'd run a DBCC CHECKDB on the organisation database to see if that flags anything

  • Suresh Sorde Profile Picture
    Suresh Sorde 1,077 on at

    Hi David,

    Thanks for reply.

    How can i check this for ms crm 2013 with sql server  2012 ?

    Thanks

  • Suggested answer
    CU21020959-0 Profile Picture
    CU21020959-0 2,601 on at

    Are the versions of CRM and SQL exactly the same from where you restored the old backup from?  

    If they are then I would suggest running a data check DBCC on the database as David Jennaway suggests.

  • Verified answer
    Alessandro Graps Profile Picture
    Alessandro Graps 2,664 on at

    Hi,

    I had the same problem and I resolved with this

    www.mssqltips.com/.../error-601-could-not-continue-scan-with-nolock-due-to-sql-server-data-movement

    and that blogs.msdn.microsoft.com/.../finding-corruption-could-not-continue-scan-with-nolock-due-to-data-movement

    maybe these can help you.

    Thanks

    A.G.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans