Solved

CRM 2011 SQL error

Posted on 2011-09-08
10
3,580 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
  • 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

813 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now