Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

UDA-SQL-0564 [Microsoft SQL Native Client]Protocol error in TDS stream (SQLSTATE

#1

Hi,

i’m creating a framework. My fact table has several dates (9 to be exact). So in my last layer of the framework (the report layer), i’m trying to add 9 time dimensions. I’m able to add 6 time dimensions, but if I try to add the 7th time dimension, I get the following error:

BMT-MD-0003 UDA-SQL-0564 [Microsoft SQL Native Client]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft SQL Native Client]Protocol error in TDS stream (SQLSTATE=HY000, SQLERRORCODE=0)

RQP-DEF-0177 Er heeft zich een fout voorgedaan tijdens het uitvoeren van bewerking ‘sqlPrepareWithOptions’ status=’-121’.
UDA-SQL-0564 [Microsoft SQL Native Client]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft SQL Native Client]Protocol error in TDS stream (SQLSTATE=HY000, SQLERRORCODE=0)

Does anyone know what this error means? Is my server not strong enough?