We have a custom job that is using NBI tables (such as nbi_dim_obs ). We observed that our custom extract fetches blank columns when the custom job interferes with Datamart Extraction during execution.
How does the Datamart Extraction job work and what files does it use?
Release : 15.8.1, 15.9.1, 15.9.2
Component : CA PPM DATAMART
The datamart is a series of stored procedures invoked by Clarity’s job scheduler.
The main stored procedure is NBI_EXTRACT_SP which in turn call other stored procedures.
NBI_EXTRACT_SP => NBI_EXTR_PCF_SP => NBI_PROJECT_CURRENT_FACTS => NBI_PROJECT_FORECAST_SP
Some of these procedures in the course of execution truncates and repopulates some tables.
Do avoid interrogating the Datamart tables when the job is executing as this can also cause an undesired results.