Limiting validation logs

The EXECUTE_VALIDATION program can generate multiple validation log records when records are validated. This program uses these configuration parameters to determine what is logged and whether the logs are limited:

SCP_VALIDATION_LOG_LEVEL

This SCV parameter defines what is logged as follows:

When the SCP_VALIDATION_LOG_LEVEL parameter is set to Failure, log records are generated only for each rule that has Failed. Log records are not generated for validation rules that were evaluated to Success.
When the SCP_VALIDATION_LOG_LEVEL parameter is set to All, log records are generated for each evaluated validation rule, regardless of the outcome (Success or Failure).

SCP_VALIDATION_MAX_NUMBER_LOGS

This SCV parameter defines whether the number of log records is limited as follows:

When the SCP_VALIDATION_LOG_LEVEL parameter value is greater than 0, the program limits the number of log records to the specified value. This applies to all log records.
When the SCP_VALIDATION_LOG_LEVEL parameter value is less than 0 or empty, the program does not limit logs.

This table lists examples of parameter values, the number of generated log records, and the corresponding actions:


SCP_VALIDATION_LOG_LEVEL	SCP_VALIDATION_MAX_NUMBER_LOGS	No of Generated Log Records	Action
Failure	1000	< 1000	EXECUTE_VALIDATION program: Starts validating records. Confirms that the number of failed records is fewer than 1,000. Inserts generated log records into SZ_VALIDATION_LOG. Sets records that fail a rule to Invalid. Sets all valid records to Valid. Stops the EXECUTE_VALIDATION program after validation. All data records are validated, and inbound processing in SCV can proceed.
	1000	>= 1000	EXECUTE_VALIDATION program: Starts validating records. Confirms that the number of failed records exceeds 1000. Inserts the 1000 log records into SZ_VALIDATION_LOG. Sets records that fail a rule to Invalid. Sets all valid records to Valid. Stops the EXECUTE_VALIDATION program after validation. Not all data records are validated. Data must be corrected and validated again.
	Empty or 0	-	EXECUTE_VALIDATION program: Starts validating records. Limit on number of log records is not considered. Inserts all generated log records into SZ_VALIDATION_LOG. Sets records that fail a rule to Invalid. Sets all valid records to Valid. Stops the EXECUTE_VALIDATION program after validation. All data records are validated, and inbound processing in SCV can proceed.
All	1000	< 1000	EXECUTE_VALIDATION program: Starts validating records. Confirms that the number of generated logs (Success or Failure) is below 1000. Inserts the generated log records into SZ_VALIDATION_LOG. Sets the validation result for each data record based on the evaluated rule to Valid or Invalid. Stops the EXECUTE_VALIDATION program after validation. All data records are validated, and inbound processing in SCV can proceed.
	1000	>= 1000	EXECUTE_VALIDATION program: Starts validating all records. Confirms that the number of generated logs (Success or Failure) exceeds 1000. Inserts the 1000 log records into SZ_VALIDATION_LOG. Sets the validation result for each data record based on the evaluated rule to Valid or Invalid. Clears the validation results on the remaining data records. Stops the EXECUTE_VALIDATION program after validation. Note: The records that are marked as Valid or Invalid depend on the processing order. The processing order can change for each run of EXECUTE_VALIDATION. Not all data records are validated. You must correct the data and validate again.
	Empty or 0	-	EXECUTE_VALIDATION program: Starts validating records. Limit on number of log records is not considered. Inserts all generated log records into SZ_VALIDATION_LOG. Sets the validation result for each data record based on the evaluated rule to Valid or Invalid. Stops the EXECUTE_VALIDATION program after validation. All data records are validated, and inbound processing in SCV can proceed.