Removed default processing sequence

The default processing sequence is removed from SCV table Registry and SCV BOI definitions. The SCV programs now generate a dynamic processing order based on the inter-dependencies between SCV tables and BOIs, providing optimal utilization of resources when SCV programs process multiple tables or BOIs.

The dependencies between SCV tables are identified using the Foreign Key constraints. The dependencies between SCV BOIs are identified using the REF_TABLE, REF_QUERY, REF_FILTER and SOURCE_FILTER tags in the BOI XML. The tables or BOIs with no dependencies are processed first, the tables and BOIs that have dependencies on the first group are processed to next. Tables and BOIs are processed in parallel, if possible.

SCV programs can analyze the dependencies and generate the processing sequence at run-time, only if there are no circular references between tables or between BOIs. If a program encounters a circular reference, the SCV programme stops running and returns with error.

Four utility programs are available, as macros, to simulate the generated processing sequence:

  1. SCV - Generate Dependency Tree for Inbox Tables
  2. SCV - Generate Dependency Tree for Core Tables
  3. SCV - Generate Dependency Tree for User Data Tables
  4. SCV - M3 Generate Dependency Tree for Import BOIs

The macros can also be used to detect any circular references between SCV tables or between SCV BOIs.

Note: 
  • By default, this feature is enabled, however the noted macros are available after applying the base template (base.zip) for this release.
  • A new role or privilege is not required to access this feature. The macros are accessible to the SCV Main System Administrator role after loading templates.