Fail to refresh a metric (Object was open error message)
I have created a job to refresh various metric items. Most of the metrics were refreshed successfully. However certain jobs fail to refresh certain metrics.
When I try to refresh the metric manually, it appears that that the refresh is not successful.
The name of my metric is called Sum of QTD Regional Forecast on NA East.
Here is the detail status report on the job that serves to refresh a metric
Error: Cannot create query on repository for probe Sum of QTD Regional Forecast on NA EAST : [Microsoft OLE DB Provider for SQL Server] : Object was open.