Skip to content
Contact us Go to Customer Portal
  • There are no suggestions because the search field is empty.

Oracle - Parallel degree and hash group size values (Business Rule)

Applies to
Platform: Oracle

These business rules check the Oracle properties Parallel Degree of Statistics Calculation and Hash Group Size. Each must be empty or a whole number of at least 1; other values raise an error, which blocks generation in the client. The rule IDs are ID-20005 and ID-20006 for the parallel degree, and ID-33003 and ID-33004 for the hash group size.

Messages

Each message names the model object and its type in place of <model object name> and <type>. The details name the properties by their identifiers StatisticParallelDegree and HashGroupSize. The Generate Artifacts page lists the messages without the rule ID.

Parallel degree is not a number

The client shows an error with this text:

Model object '<model object name>' of type '<type>' has property
'StatisticParallelDegree' set to a non numeric value. Only numeric
values are allowed.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-20005.

Cause: Parallel Degree of Statistics Calculation holds a value that is not a whole number.
Fix: enter a whole number of at least 1, or clear the value.

Parallel degree below 1

The client shows an error with this text:

Model object '<model object name>' of type '<type>' has property
'StatisticParallelDegree' set to a value smaller than 1. Only values
greater than or equal to 1 are allowed.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-20006.

Cause: Parallel Degree of Statistics Calculation is 0 or negative.
Fix: enter a whole number of at least 1, or clear the value.

Hash group size is not a number

The client shows an error with this text:

Model object '<model object name>' of type '<type>' has property
'HashGroupSize' set to a non numeric value. Only numeric values are
allowed.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-33003.

Cause: Hash Group Size holds a value that is not a whole number.
Fix: enter a whole number of at least 1, or clear the value.

Hash group size below 1

The client shows an error with this text:

Model object '<model object name>' of type '<type>' has property
'HashGroupSize' set to a value smaller than 1. Only values greater
than or equal to 1 are allowed.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-33004.

Cause: Hash Group Size is 0 or negative.
Fix: enter a whole number of at least 1, or clear the value.

Check the result

The error icon is gone from the model object, and generation is no longer blocked by it.

Example

In a Data Vault project on Oracle, the Hub common_employee gets Parallel Degree of Statistics Calculation 0. The client shows:

Model object 'common_employee' of type 'Hub' has property
'StatisticParallelDegree' set to a value smaller than 1. Only values
greater than or equal to 1 are allowed.

Release differences

  • Generator 2.0: checks of Parallel Degree of Statistics Calculation (ID-20005, ID-20006).
  • Generator 2.3: checks of Hash Group Size (ID-33003, ID-33004).

Related articles