Microsoft Dynamics CRM (Archived)

Generic SQL Error

(0) Share

Report

Posted on by Swap

122

Hello experts,

Kindly put some light in the darkness as I am getting below mentioned error :

I started getting this error after re-installation of MS CRM 2013.

Everything is working fine except " Assign Functionality in CRM " Below error is populating when I am trying to Assign account to another user or team "

we have checked the Disc space but we have enough free space available, even we have checked event logs and SQL profile check unfortunately no success.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #208EC0B2Detail:

<Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #208EC0B2</Message>

<Message>Generic SQL error.</Message>

</InnerFault>

</OrganizationServiceFault>

*This post is locked for comments

All responses (9)

Answers (0)

Temmy Wahyu Raharjo 2,914 on at

Like (0)

Report

RE: Generic SQL Error

Hi,

You need to activate the CRM Diagnostic Log to enable the log. Try to reproduce, get the log, then you need to analyze the result. There are 2 tools you can used CrmDiagTool.exe & CrmTraceReader.exe. Both are hosted on Codeplex and now already archieved. So if you don't have those tools. You can contact me.
Swap 122 on at

Like (2)

Report

RE: Generic SQL Error

Hello Pedro,

I would like to thank you for all your inputs regarding this issue.

Yes we have solved this issue by following the below mentioned steps:

Cause: Based on the traces found that the stored procedure ‘Cascade collect ’ had two unwanted columns.

Resolution: Logged in to the DB of the organization -> programmability -> stored Procedure -> Cascade collect. Removed the columns from the Stored Procedure and executed the query which fixed the issue.

Thanks again for all your help.

Best regards

Swap

Reply
Swap 122 on at

Like (0)

Report

RE: Generic SQL Error

Hello Pedro,

Yes My Microsoft Dynamic CRM 2013 Server Service pack 1 updates are in Sync with the previous updates.

Please note while performing the below steps I am getting this errors:

Step1: while assign Account record to another user or team

Step2: workflow scenario: assign record to another user

I hope above screen shots will help you understand my issues.

Best regards

Swap
Community Member on at

Like (0)

Report

RE: Generic SQL Error

Hello Swap,

If you only re-installed CRM, databases should not be affected, so it might not be a sql issue, either way, you can verify the indexes: technet.microsoft.com/.../ms187874(v=sql.105).aspx

Since you re-installed the CRM, verify if you have the same updates that you had before.

Cheers!

Pedro Pisco
Swap 122 on at

Like (0)

Report

RE: Generic SQL Error

Hello Pedro,

Thanks for your reply.

Requesting you to kindly let me know the steps to be followed to do " Verify if the indexes of CRM Database are fragmented and rebuild them. You can do it directly on CRM Database."

Yes you are right due to this error my workflows( Sync and Async both workflows ) are badly affected.

Note : Everything was working fine earlier however by mistake I uninstall the CRM 2013 from the system.

After that when we reinstall CRM 2013 I started getting this errors.

Awaiting your response

Best Regards

Swap
Swap 122 on at

Like (0)

Report

RE: Generic SQL Error

Hello Pedro,

Thanks for your reply.

Requesting you to kindly let me know the steps to be followed to do " Verify if the indexes of CRM Database are fragmented and rebuild them. You can do it directly on CRM Database."

Yes you are right due to this error my workflows( Sync and Async both workflows ) are badly affected.

Note : Everything was working fine earlier however by mistake I uninstall the CRM 2013 from the system.

After that when we reinstall CRM 2013 I started getting this errors.

Best Regards

Swap
Suggested answer

Community Member on at

Like (0)

Report

RE: Generic SQL Error

Hello Swap,

Usually, the "Generic SQL Error" means a deadlock on Database.

Verify if the indexes of CRM Database are fragmented and rebuild them. You can do it directly on CRM Database.

And check if you have any plugin or synchronous workflow that are new that could be executed during this action.

Cheers!

Pedro Pisco
Swap 122 on at

Like (0)

Report

RE: Generic SQL Error

Hello Tomas,

Thanks for your inputs we tried the above option however still the problem persist.

Can you suggest anything more.

Thanks in advance

Best Regards

Swap
Suggested answer

Tomas Prokop 590 on at

Like (0)

Report

RE: Generic SQL Error

Hi,

this could be broken full text indexes.

Try this:

Settings > Administration > System Settings

You can enable it after few days and let it rebuild.