I have a report running against a SQL Analysis Services Cube that basically just sits there anywhere from 10 or more minutes and eventually just says "Error Retrieving Results...." When I run the MDX query that is generated by the report directly on the Analysis Server it runs in 6 seconds, so it's a valid query that should execute properly. The query is a rather long query because it is doing an exclude from a long list of selected items from a list box, but that's the only abnormal thing about the query that I see.

Checking the log files, these are some of the errors that are reported:

2014-09-09 13:52:08 ERROR: [223084] Connection[1] checkout timeout exceeded
2014-09-09 13:52:08 ERROR: [223084] Connection[1] was checked out at 2014-09-09 13:41:46
2014-09-09 13:52:08 ERROR: [223084] at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:253)
2014-09-09 13:52:08 ERROR: [223084] at com.hof.mi.olap.XMLAAction.(XMLAAction.java:149)
2014-09-09 13:52:08 ERROR: [223084] at com.hof.mi.process.ReportRunner.D(ReportRunner.java:745)
2014-09-09 13:52:08 ERROR: [223084] at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:242)
2014-09-09 13:52:08 ERROR: [223084] at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:114)
2014-09-09 13:52:08 INFO: [223084] Connection[1] successfully reopened
2014-09-09 13:56:30 WARN: [223084] Connection[1] could not be found. Possibily forcibly removed from connection pool.

Any help is much appreciated.

Regards,
Steve