Issues With The Db2irules.pl Script (Doc ID 1924480.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

db2irules.pl script with 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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms