This documentation supports releases of BMC Helix Continuous Optimization up to December 31, 2021. To view the latest version, select the version from the Product version menu.

Troubleshooting the data refresh issue in capacity views

After you run the relevant ETLs, data is not updated in the capacity views.

Issue symptom

The capacity views do not display the latest data.

Resolution

When you run the relevant ETL modules, the capacity views are populated with the latest data after the Data Mart Materializer task is run. This task runs according to the configured schedule. It might take up to the next run of Data Mart materializer task to see the updated data in capacity views. You can add a custom property to force materialize the task and see the latest data in capacity views.

Perform the following steps:

  1. Navigate to Administration ETL & System Tasks, and select System tasks.
  2. Click the required Data Mart Materializer task name in the task summary table. The task details page is displayed.
  3. In the Run configuration table, click edit this run configuration.
  4. On the Edit run configuration page, click the You can manually edit ETL properties from this page link.
  5. In the Add new property field, type the new custom property as er.materializer.force, and click Add.
  6. Locate this new property in the list of properties, and then type a value as true.
  7. Click Save.
  8. On the System tasks page, locate the updated Data Mart Materializer task and click Run the active run configuration.

The Data Mart Materialization task is run and the latest data is updated in the views.

Was this page helpful? Yes No Submitting... Thank you

Comments