Additional Issues With The Db2irules.pl Script (Doc ID 1936440.1)

Last updated on MARCH 08, 2019

Applies to:

Symptoms

After applied the patch 19428842

1. When execute the db2irules.pl script with the -u option the generated output file does not match the ST_CIBER_VAL.xml file that was loaded in the pipeline database.

2. When execute the db2irules.pl script with the -d option the CIBER validation rules are not deleted from the pipeline database.

  We believe that the validation rules are not deleted because the pattern in the delete SQL queries is not correct.

  We can see that the delete SQL queries executed by the db2irules.pl script are as follow:
  DELETE FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL%'
  DELETE FROM IFW_RULESET WHERE RULESET = 'CIBER_VAL%'
  DELETE FROM IFW_RULEITEM WHERE RULE_ID = 'CIBER_VAL%'
  DELETE FROM IFW_RULE WHERE RULE_ID = 'CIBER_VAL%'

  These delete SQL queries should be as follow:
  DELETE FROM IFW_RULESETLIST WHERE RULESET like 'CIBER_VAL%'
  DELETE FROM IFW_RULESETLIST WHERE RULESET like 'CIBER_VAL%'
  DELETE FROM IFW_RULEITEM WHERE RULE_ID like ‘CIBER25.ASS_CIBER_EXT%’
  DELETE FROM IFW_RULE WHERE RULE_ID like ‘CIBER25.ASS_CIBER_EXT%’

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.