询问者
CRM2011数据导入功能,导不进去数据?

问题
-
下面是查看系统作业提示报错信息,请高手分析下什么原因?
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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>2012-05-08T07:34:26.2628687Z</Timestamp>
<InnerFault>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d3p1="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: #815B6490</Message>
<Timestamp>2012-05-08T07:34:26.2784691Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
<TraceText i:nil="true" />
</OrganizationServiceFault>windows live Id :hellohongfu@hotmail.com
全部回复
-
可以從這幾個訊息中看出些端倪:
1. Timeout. 這是任務未在時限內完成執行, 或是伺服器未及時反應. "The timeout period elapsed prior to completion of the operation or the server is not responding."
2. Generic SQL error.
3. System.Data.SqlClient.SqlException, error -2147204784, reference number 815B6490.
建議從檢查CRM伺服器與SQL伺服器的連線 (例如能順利的從CRM Server上下達簡單的SQL的指令), 再進一步縮小調查的範圍.
如果能拿到伺服器端記錄的話 (server-side trace) 則可以從時間上 (2012-05-08T07:34:26.2628687Z) 去追查詳細的錯誤內容.
- 已编辑 John Huang [MSFT] 2012年5月16日 1:09 Adding more info