Historical Data collection database query failed on the Perfomance Analyzer.

[Views and opinions are my own and not of my employer ]

Troubleshooting tips on the Performance Analyzer


This is an error you get if the ODBC connection is not configured right.
I found this on Windows and below are some details.
tested on : ITM 623fp1

See, the Usernameand schema - and the last Error - there is some error.




To resolve this.
Go to the MEMS console and Performance Analyzer and I had to change it to the appropriate user.


test the connection and restart the Performance Agent.
This should resolve the issue.