This content has been marked as final. Show 2 replies
This is likely due to there being an issue with the data. Most likely there is a string value in a field for which the query is expecting a number. So, when it attempts to convert that field value to a number type, it errors out.
Since you cannot edit the built-in dashboards, what I do in these situations is clone the dashboard. When cloning the dashboard, I make sure to clone the data source as well. Then you can view the underlying query and data type conversions. Once you determine where the failure is, you can begin to correct it in your database.
the screen shows only very generic error messages but the Windows Event log (Start >> eventvwr) shows usually several GoldMine errors and one of them should contain much more information which then indicates either a data problem or a configuration problem of MS SQL .
I hope this helps.