Solved

CRM 2011 SQL error

Posted on 2011-09-08
10
3,619 Views
Last Modified: 2012-05-12
Hi

I've recently been reciving an error on CRM everytime I try and save contacts to the system on all machine using crm 2011. I get the following error details.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>Generic SQL error.</Message>
  <Timestamp>2011-09-08T12:24:00.5092456Z</Timestamp>
  <InnerFault i:nil="true" />
  <TraceText i:nil="true" />
</OrganizationServiceFault>
0
Comment
Question by:Everymancomputers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 36502362
I'm not sure that there is enough detail in the error message to work out what it wrong. Have you looked at the Windows application logs on the CRM and SQL Servers?  There may be more clues there.
0
 

Author Comment

by:Everymancomputers
ID: 36709657
Nothing which pops out at the moment but I will keep my eye open. Seems to be fine one moment then ramdomly not working the next
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 36709805
Perhaps it is do with how busy SQL Server is and you are getting occasional timeout errors.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:Everymancomputers
ID: 36709853
That could be possible seems strange why it would be busy as there's only 3 people using the system not all at the same time
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 36709881
I agree that 3 users is not a lot.
0
 

Author Comment

by:Everymancomputers
ID: 36902468
I have noticed this poping up in the error logs "The SQLBrowser service was unable to process a client request."
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 36902628
Not one I've seen. What version of SQL Server are you using and is it 64-bit?
0
 

Author Comment

by:Everymancomputers
ID: 37023556
it's a 64bit SQL
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 37024709
I'm sorry but I can't remember why asked about SQL. It's obvious that it has to be 64-bit because you are using CRM 2011. I'm afraid I have no new ideas to add.

0
 
LVL 27

Accepted Solution

by:
Chinmay Patel earned 500 total points
ID: 37024780
I have recently seen such a scenario but it was due to excessive load on a SQL server. The box that was running entire setup in a VM had 8GB of RAM and core i3 Processor. Could you tell me what kind of hardware is powering your setup? Also is it possible that maybe your SQL server is used by other users as well and it was doing some heavy duty processing?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question