Generic sql error

• Remove From My Forums

• Вопрос

• From BizTalk application I do sending Execute request to CRM for create/update. But sometimes(not all times) CRM throw error with this content.In my application implemented
  «Resource Dispenser» pattern and all messages are sending to CRM  by different ports(there are 5 ports for CRM).  Who can explore me cause of this error ?
  

  
  I couldn’t found any useful information about this.

  Error Context:
  

  This XML file does not appear to have any style information associated with it. The document tree is shown below.
  <s:Fault xmlns:s="http://www.w3.org/2003/05/soap-envelope">
  <s:Code>
  <s:Value>s:Sender</s:Value>
  </s:Code>
  <s:Reason>
  <s:Text xml:lang="en-US">Generic SQL error.</s:Text>
  </s:Reason>
  <s:Detail>
  <OrganizationServiceFault xmlns="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
  <Message>Generic SQL error.</Message>
  <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true"/>
  <InnerFault>
  <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
  <Message>Generic SQL error.</Message>
  <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true"/>
  <InnerFault>
  <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
  <Message>Generic SQL error.</Message>
  <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true"/>
  <InnerFault>
  <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
  <Message>Generic SQL error.</Message>
  <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true"/>
  <InnerFault>
  <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
  <Message>
  System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #45288ED5
  </Message>
  <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true"/>
  <InnerFault i:nil="true"/>
  <OriginalException i:nil="true"/>
  <TraceText i:nil="true"/>
  </InnerFault>
  <OriginalException i:nil="true"/>
  <TraceText i:nil="true"/>
  </InnerFault>
  <OriginalException i:nil="true"/>
  <TraceText i:nil="true"/>
  </InnerFault>
  <OriginalException i:nil="true"/>
  <TraceText i:nil="true"/>
  </InnerFault>
  <OriginalException i:nil="true"/>
  <TraceText i:nil="true"/>
  </OrganizationServiceFault>
  </s:Detail>
  </s:Fault>

  ---

  Regards Edgar Tadevosyan

Код:

 
#region Create quotedetails
if (_newQuoteProp != null)
{
 
try
{
foreach (DictionaryEntry cDe in _newQuoteProp)
{
if (cDe.Value.ToString() == "")
{
continue;
}
else
{
quotedetail existProduct = new quotedetail();
 
//add product & unit
LookupProperty uomid = Factory.GetUnitLookup(service);
LookupProperty productid = Factory.GetProductLookup(service, cDe.Key.ToString());
 
if (uomid != null && productid != null)
{
existProduct.uomid = uomid.Value;
//existProduct.uomid.name = uomid.Name;
existProduct.productid = productid.Value;
//existProduct.productid.name = productid.Name;
// for dynamic entity
//existProduct.Properties.Add(uomid);
//existProduct.Properties.Add(productid);
}
 
//DynamicEntity existProduct = new DynamicEntity();
//existProduct.Name = "quotedetail";
//existProduct.Properties.Add(new StringProperty("quantity", "1"));
//existProduct.Properties.Add(quoteId);
//Microsoft.Crm.Sdk.StringProperty p = new StringProperty("priceperunit", cDe.Value.ToString());
//existProduct.Properties.Add(p);
//CrmBoolean c = new CrmBoolean(true);
//CrmBooleanProperty cPrice = new CrmBooleanProperty("ispriceoverridden", c);
//CrmBooleanProperty cProduct = new CrmBooleanProperty("isproductoverridden", c);
//existProduct.ispriceoverridden = cPrice.Value;
//existProduct.ispriceoverridden.name = cPrice.Name;
//existProduct.isproductoverridden = cProduct.Value;
//existProduct.isproductoverridden.name = cProduct.Name;
 
 
//CrmNumber n = new CrmNumber(lineNumber);
//CrmNumberProperty N = new CrmNumberProperty("lineitemnumber", n);
//existProduct.lineitemnumber = N.Value;
LookupProperty quoteId = new LookupProperty("quoteid", new Lookup("quote", quoteGUID));
existProduct.quoteid = quoteId.Value;
//existProduct.quoteid.name = quoteId.Name;
 
CrmDecimal dec = new CrmDecimal(1);
CrmDecimalProperty quant = new CrmDecimalProperty("quantity", dec);
existProduct.quantity = quant.Value;
 
 
CrmMoney money = new CrmMoney(Convert.ToDecimal(cDe.Value.ToString()));
CrmMoneyProperty priceperUnit = new CrmMoneyProperty("priceperunit", money);
existProduct.priceperunit = priceperUnit.Value;
existProduct.description = cDe.Key.ToString().Remove(0, 3);
 
//existProduct.productdescription = cDe.Key.ToString().Remove(0,3);
//existProduct.owninguser = new UniqueIdentifier(context.UserId);
 
 
// create of transactioncurrencyid not allowed!!!
//LookupProperty taci = new LookupProperty("transactioncurrencyid", new Lookup("transactioncurrency", new Guid(((Lookup)entity.Properties["transactioncurrencyid"]).Value.ToString())));
//existProduct.transactioncurrencyid = taci.Value;
//existProduct.transactioncurrencyid.name = taci.Name;
 
//TargetCreateQuoteDetail target = new TargetCreateQuoteDetail();
////TargetCreateDynamic target = new TargetCreateDynamic();
//target.QuoteDetail = existProduct;
//CreateRequest create = new CreateRequest();
//create.Target = target;
//CreateResponse responce = (CreateResponse)service.Execute(create);
 
 
Guid quotedetailId = service.Create(existProduct);
 
//Guid k = service.Create(existProduct);
//KeyProperty k = new KeyProperty("quotedetailid", new Key());
//existProduct.quotedetailid.Value = k;
//Guid quotedetailId = responce.id;
lineNumber++;
 
// Don't forget check if quotedetail exist!
}
}
}
catch (System.Web.Services.Protocols.SoapException e)
{
throw new Exception ("Wrong plugin execution!n" + e.Message + "n" + e.StackTrace + e.Data);
}
}
 
#endregion Create quotedetails