Error: Cannot create query on repository… when attempting to refresh a metric or group of metrics
| The information in the article applies to |
| Synopsis |
"Error: Cannot create query on repository for probe
The following actions have been performed to troubleshoot the issue:
The universe was refreshed in Performance Manager. The measure objects show in the Available Objects box. Its SQL statement is correct.
The universe integrity has been validated showing no problems.
Clicking Setup > Tools > Check & Cleanup stated that the metric has expired and was never refreshed. After deleting and recreating it, performing this step returns the same result.
A query with the metric universe using the metric measure was done successfully in Web Intelligence.
| Solution |
1. Check that the native connectivity is working properly. For example, if the Performance Manger repository is on SQLServer, verify that the OBDC connection is properly defined.
2. Open Designer. Add a secure connection using the datasource name defined in step 1.
3. Go to Performance Management. Click Setup > System Setup > Repository.
4. Click Change. Navigate to the connection defined in step 2.
5. Confirm the selection.
The metric can now be refreshed successfully.
If the metric cannot be refreshed successfully, recreate the metric. The metric was not sent to the CI_PROBE table due to the corrupted Performance Manger repository connection.
Have a question for our trainers?
Click here to send your questions!