Everymancomputers
asked on
CRM 2011 SQL error
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.FaultE xception`1 [[Microsof t.Xrm.Sdk. Organizati onServiceF ault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad3 64e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147204784</Er rorCode>
<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2011-09-08T12:2 4:00.50924 56Z</Times tamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault >
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.FaultE
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147204784</Er
<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2011-09-08T12:2
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault
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.
ASKER
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
Perhaps it is do with how busy SQL Server is and you are getting occasional timeout errors.
ASKER
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
I agree that 3 users is not a lot.
ASKER
I have noticed this poping up in the error logs "The SQLBrowser service was unable to process a client request."
Not one I've seen. What version of SQL Server are you using and is it 64-bit?
ASKER
it's a 64bit SQL
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.