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?