Microsoft Dynamics CRM (Archived)

Microsoft Dynamic CRM : 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:

Everything was working fine earlier however by mistake I uninstall the CRM 2013 from the system.I started getting this error after re-installation of MS CRM 2013.

Problems we are facing:

Our workflows ( Sync and Async both workflows ) are badly affected.

Step1: while assign Account record to another user or team

8308.CRM-Error01.jpg

0652.CRM-Error02.jpg

Step2: workflow scenario: assign record to another user

3010.CRM-Error03.png

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

Error Log :

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>

We have checked the below options:

1.Disc space but we have enough free space available

2.Even we have checked event logs and SQL profile check unfortunately no success

3. Verified if the indexes of CRM Database are fragmented and rebuild them

Thanks in advance

Best Regards

Swap

*This post is locked for comments

All responses (11)

Answers (3)

Swap 122 on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hello Aric,

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
Verified answer

Aric Levin 30,188 Moderator on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

That is an email router issue (you should first deal with the server issue).

Without logs there is not much that you can do.

The event viewer is not the CRM logs.

Hence, my last answer still stands.

If you are not able to run CRM traces, you can try running SQL traces (using SQL Profiler) and see if you get any CRM related errors there.
Swap 122 on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hello Aric,

Thanks for your valuable responses.

That "Decompressed data too big" error is not populating now.

The most reoccurring error is as

#27938 - An error occurred while checking for email messages to process in mailbox nameabc@abcd.ca .Crm.Tools.Email.Providers.EmailException: Error: The specified object was not found in the store., The process failed to get the correct properties. at Microsoft.Crm.Tools.Email.Providers.ExchangeWSConnector.LogEwsResponseErrorWarning(String message, ResponseClassType responseClassType) at Microsoft.Crm.Tools.Email.Providers.ExchangeWSConnector.RetrieveMessage(ArrayList ids, Int32 index, ServiceLogger serviceLogger) at Microsoft.Crm.Tools.Email.Providers.ExchangePollingMailboxProvider.RetrieveNextMessageInternal() at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.RetrieveNextMessage() at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.Run()

Please suggest some path forward here.

Thanks in advance

Best Regards

Swap
Aric Levin 30,188 Moderator on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hi Swap,

Sorry for the late response.

Since the log files are not being generated, most likely due to file size (as the event log error says), it is hard to pinpoint the issue.

I have not seen previously the "Decompressed data too big! Please make sure that the uncompressed data is within 100 MB", so I am not sure what resolution to provide...

Please repost the last error with screenshots that you posted in order to get more responses (Since this is a verified answer, not a lot of forum experts check the thread).

If you don't get any response that assists you with this case, I would suggest opening a support case with Microsoft.

Sorry for not being able to help more.
Swap 122 on at

Like (0)

Report
RE: Microsoft Dynamic CRM : Generic SQL Error

Hello Aric,

Please find my response as given below :

Backend CRM server:

1.In event viewer error log:.

Host PACRM13PRODAPP: error while processing organization d446d503-202a-e411-96eb-00155d00018a. Exception: Microsoft.Crm.CrmArgumentOutOfRangeException: Decompressed data too big! Please make sure that the uncompressed data is within 100 MB ---> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.

Parameter name: Decompressed data too big! Please make sure that the uncompressed data is within 100 MB

   --- End of inner exception stack trace ---

   at Microsoft.Crm.CrmCompress.Decompress(Byte[] compressedData)

   at Microsoft.Crm.Asynchronous.AsyncOperationQueueDataAccess.DecompressData(String data)

   at Microsoft.Crm.Asynchronous.AsyncOperationQueueDataAccess.<>c__DisplayClass5.<SelectEvents>b__1(Object[] values)

   at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor, Guid inputOrganizationId)

   at Microsoft.Crm.Asynchronous.AsyncOperationQueueDataAccess.<>c__DisplayClass5.<SelectEvents>b__0(IServiceOperation operation)

   at Microsoft.Crm.Asynchronous.Operations.OrganizationOperation.<get_EventAction>b__0(IServiceOperation operation)

2. Trace file is generating but there is no content i.e. empty.

Front end server:

Event viewer error log:

At trace location file: no error logs generate( File is empty)

Awaiting your response.

Best Regards

Swap
Aric Levin 30,188 Moderator on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Got it,

Didn't know you had front and back end servers.

So, you uninstalled the backend server only and reinstalled it.

Can you please follow the instruction here to enable tracing:

support.microsoft.com/.../how-to-enable-tracing-in-microsoft-dynamics-crm

You can enable tracing using Powershell as well. I would set the categories for the tracing to Errors only.

Since you are getting both Synchronous and Asynchronous errors, you can try this on both Front and Backend CRM Server.

Let me know what results you get.
Swap 122 on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hello Aric,

Please find my response as given below :

1. How did you uninstall the CRM from the system ?

Ans: From Control panel in CRM Server ( Selected Microsoft Dynamic CRM Server 2013 --> Right click and Uninstall )

2. How did you attach the CRM database to the CRM environment. Did you select it as the default during installation?

Ans: We followed the steps mentioned in below link and done the installation

https://blogs.msdn.microsoft.com/niran_belliappa/2013/11/05/step-by-step-installing-dynamics-crm-2013-on-windows-server-2012/

Step9 : Selected only backup server and Deployment Administrator server(We have 2 servers Front end server and Backend server ) CRM is installed on both the servers.

Step10: Selected “connect to an“

waiting for your response.

Thanks in advance

Best Regards

Swap
Aric Levin 30,188 Moderator on at

Like (1)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hi Swap,

Can you explain the following:

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

- How did you uninstall the CRM from the system?

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

- How did you attach the CRM database to the CRM environment. Did you select it as the default during installation?

Regarding the error that I see above, seems like traciing is not running properly? Some sort of access denied error.

It is possible that the C:\Program Files\Microsoft Dynamics CRM\* does not have the proper access.

Can you check the CRM installation guide if the CRM directory has the correct permissions:

technet.microsoft.com/.../hh699706.aspx (navigate to linked files if necessary).

Let us know.
Verified answer

Swap 122 on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

Hello Aric,

Thanks for your inputs, please find my comments as given below

Did you install the same version of CRM 2013 that you had before you uninstalled it (Service Pack and Update Release)? Yes ( Installed same version)

Did you reimport CRM database to the new CRM 2013 instance that you re-installed? Any errors there?-- We have not done this step, can you please suggest whether it is mandatory or not. If yes please let me know the steps to be followed.

Also, are you able to run CRM Tracing and SQL Tracing, and check for errors?-- Done CRM tracing but I am getting below errors.

Thanks in advance

Best Regards

Swap
Suggested answer

Aric Levin 30,188 Moderator on at

Like (0)

Report

RE: Microsoft Dynamic CRM : Generic SQL Error

In addition to Goutam's answer, a couple of thing that I would like to verify:

Did you install the same version of CRM 2013 that you had before you uninstalled it (Service Pack and Update Release)?

Did you reimport CRM database to the new CRM 2013 instance that you re-installed? Any errors there?

Also, are you able to run CRM Tracing and SQL Tracing, and check for errors?

This might help with pinpointing the location of the problem.

The bottom line is that Generic SQL Errors are hard to troubleshoot, but seems like you have a more complex problem.

If none of these helps, I would recommend opening a support ticket with Microsoft.

Hope this helps