SSAS 多維數據集處理隨機失敗，出現 08S01 錯誤

我們有一個立方體，它計劃在每天早上 6:00 處理以在 SSAS 10.50.2500.0 上執行。

有時它確實可以。很多時候，它失敗了。

當它發生時，SQL Server 在日誌中有這個條目（XML 美化）：

[136] Job OLAP_Refresh reported: 
<return xmlns="urn:schemas-microsoft-com:xml-analysis">
   <results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
       <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
           <Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
           <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
               <Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; TCP Provider: The specified network name is no longer available.
; 08S01." Source="Microsoft SQL Server 2008 R2 Analysis Services" HelpFile="" />
               <Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine: An error occurred while processing the '__PARTITION__' partition of the '__MEASURE_GROUP__' measure group for the '__CUBE__' cube from the __OLAP__ database." Source="Microsoft SQL Server 2008 R2 Analysis Services" HelpFile="" />
               <Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2008 R2 Analysis Services" HelpFile="" />
               <Error ErrorCode="3239837698" Description="Server: The operation has been cancelled." Source="Microsoft SQL Server 2008 R2 Analysis Services" HelpFile="" />
           </Messages>
       </root>
   </results>
</return>

哪里__PARTITION__和__MEASURE_GROUP__不總是相同的，偶爾工作完成沒有問題。

msmdsrv.log 有這樣的條目：

($DATE $TIME) Message: OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; TCP Provider: The specified network name is no longer available.
; 08S01. (Source: \\?\P:\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)
($DATE $TIME) Message: OLE DB error: OLE DB or ODBC error: Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An established connection was aborted by the software in your host machine.
; 08S01; Communication link failure; 08S01; TCP Provider: An established connection was aborted by the software in your host machine.
; 08S01; Communication link failure; 08S01; TCP Provider: An established connection was aborted by the software in your host machine.
; 08S01. (Source: \\?\P:\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)

數據中心發誓沒有網路問題。

$TIME 通常在 6:40 左右，但今天它在 8:40 左右失敗。

ExternalCommandTimeout 設置為 50000。

更新不會並行執行，這是每天早上發送的作業：

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
 <ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
   <KeyNotFound>IgnoreError</KeyNotFound>
   <NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed>
 </ErrorConfiguration>
 <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
   <Object>
     <DatabaseID>__OLAP__</DatabaseID>
   </Object>
   <Type>ProcessFull</Type>
   <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
 </Process>
</Batch>'

手動執行作業更可靠（我啟動了 3 次，但失敗了一次並出現相同的錯誤），儘管這可能是因為我在 10:00-14:00 左右啟動它

知道它可能是什麼以及如何解決這個問題嗎？

TCP Provider: The specified network name is no longer available.很清楚。您有 TCP 連接問題。

可能是本地機器或伺服器的配置問題。如果 SSAS 與 SQL Server 在同一台電腦上執行，您可能會看到資源耗盡導致 TCP 丟棄數據包。確認您已為特定機器配置了推薦的 TCP/IP 堆棧設置。

如果您啟用了 TCP 煙囪，這可能會導致問題。

如果兩台機器在物理上位於不同的網路上，您可能會遇到路由問題。

引用自：https://dba.stackexchange.com/questions/187432