When saving model back to mart, status is showing as Pending or Updating - why? (4289656)

Description:

When trying to save model in model mart repository, the report status is showing as pending; could you please let me know what is happening here?

Solution:

In the Workgroup Edition, the model data and model report data are stored in separate internal tables. The model report data table (m9ReportData) includes only those columns that are required to generate model-specific reports. When you update a model and save the changes, both the tables are updated. Although erwin® Data Modeler displays a message that the model is saved, the corresponding model report data table is still being updated in the background. In this scenario, if you try to generate a report, the report may not include the details that you have just updated. This means, there is a delay in the synchronization of model data and the model report data tables.

You can synchronize the tables dynamically or schedule the synchronization for a later time. Typically such synchronizations are scheduled for a time when there is minimum traffic on the server. The default is dynamic synchronization.

Dynamic Synchronization
Specifies that the model report data table is updated as and when the
corresponding model is updated. You can see the reporting status of the source
models in the Report Status column of the Mart Open dialog.

Scheduled Synchronization
Specifies that the model report data table is updated at the scheduled time. You
can see the reporting status of the source models in the Report Status column of
the Mart Open dialog.

For scheduled Synchronization, you can refer to
https://support.erwin.com/hc/en-us/articles/115004576647-How-to-change-the-mart-report-automated-caching-synchronization-schedule-