SYMPTOM:
The following error message occurs when executing large reports in both Strategy developer and Web:
(QueryEngine encountered error: Execute Query failed. Disconnected. Error type: Odbc error. Odbc operation attempted:
SQLExecDirect. Communication link failureError in Process
method of Component: QueryEngineServer, Project DW Vicunha - Versao 1.0, Job 8349, Error Code= -2147212544.)
The following entry was created into the C:\Program Files\Common Files\MicroStrategy\Log\DSSErrors.log:
2008-06-17 10:10:15.684-03:00 QueryEngine encountered error: Fetch failed. Error type: Odbc error. Odbc operation attempted: SQLFetch. ConnectionRead (recv()). General network error. Check your network documentation.
CAUSE:
This error is caused by a failure on the database where the Microsoft SQL Server needed to allocate more memory in order to address the requests as expected; however, there was no more memory to be allocated.
ACTION:
Contact the Database Administrator in order to determine how to address this issue properly.
