Issues with Db2irules.pl Script (Doc ID 1924480.1)

Last updated on MAY 02, 2024

Applies to:

Symptoms

The db2irules.pl script gives the error on the field RULE:

Opening file ./CIBER_VAL_2014-07-17_10-07-30.xml
DBD::Oracle::db prepare failed: ORA-00904: "RULE": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>RULE, RANK FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL' ORDER BY RANK') [for Statement "SELECT RULE, RANK FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL' ORDER BY RANK"] at db2irules.pl line 560.
ERROR: Unable to prepare SQL statement: SELECT RULE, RANK FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL' ORDER BY RANK: ORA-00904: "RULE": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>RULE, RANK FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL' ORDER BY RANK')

ERROR: Unable to delete existing Ruleset from the database

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.