SSAS Cube Processing fail with 'Communication Link Failure' error

  • Hello,

    we have our cubes in Server A and SQL DB resides on Server B (we are on SQL 2014), from last couple of days are cube started failing due to below error:

    OLE DB or ODBC error: Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host.

    ; 08S01

    I have been going through some blogs to understand the error but don't find any specific yet. Could you please help if you come across with the same problem.

    Thank You!

  • Were you able to resolve this issue?  If yes, may I ask how?  I have been experiencing the same issue.

  • Does anyone know what is causing this and how to resolve this error?

    I have same error with similar sounding setup - SQL on ServerA and SAS (cubes) on ServerB.

    Any help much appreciated.

     

    Srinivas or Carol - any feedback?

  • I had the same problem and found bad data (blank or null) on my dimension. After fixing them everything ran fine.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply