通用SQL错误。 [英] Generic SQL error.

问题描述

从BizTalk应用程序我发送执行请求到CRM进行创建/更新。但有时（并非所有时间）CRM都会抛出此内容的错误。在我的应用程序中实现
"资源分配器"模式和所有消息都发送到CRM 通过不同的端口（有5个CRM端口）。  谁可以探究我这个错误的原因？

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 ?

我找不到任何有用的信息。

错误上下文：

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>

关于Edgar Tadevosyan

Regards Edgar Tadevosyan

推荐答案

您好Edgar，

Hi Edgar,

感谢您在 MSDN 论坛上发帖。

我认为CRM团队可以解释为什么以及何时产生这些类型的错误。我建议包括它们并检查它们是否可以帮助你。

I think this is something CRM team can explain you why and when these type of errors generated. I would suggest to include them and check if they can help you.

谢谢

Kamlesh

这篇关于通用SQL错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！