SYMPTOM:
A multipass report executes in Strategy Developer and Web 10.x+ versions, but sometimes fails to execute and the following error occurs:
Status: Execution failed
Error: SQL Generation Complete
Index out of range
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Intra-query parallelism caused your server command (process ID #51) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
Error in Process method of Component: QueryEngineServer, Project 4, Job 6258, Error Code= -2147212544.
CAUSE:
This problem occurs because SQL Server detected a deadlock that involves the threads that are used by the same parallel query.
ACTION:
Strategy is working as designed. For more information on intra-query parallelism, refer to the following Microsoft article:
http://support.microsoft.com/?kbid=837983 14316
