IPA - Error In Rule Execution ##INFODOM##_IPA_Segmentation - Behavioral Segment

(Doc ID 2385955.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Financial Services Institutional Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

1. Following statements in the rule execution log file in the path $FIC_DB_HOME/log/ruleexecution folder
java.lang.Exception: Select clause of merge did not return valid mappings. Please check rule definition.
at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.executeRuleQuery(GenericRDBMSRuleEngine.java:176)
at com.ofs.aai.service.rule.engine.GenericRuleEngine.executeRuleQuery(GenericRuleEngine.java:220)
at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.execute(GenericRDBMSRuleEngine.java:1562)
at com.ofs.aai.service.rule.RuleExecutionService.execute(RuleExecutionService.java:217)
at com.ofs.aai.pr2.cmd.RuleExecution.main(RuleExecution.java:219)
2. There are no mappings for the rule in the rule definition. (Combination mapper section of the rule should show atleast 1 mapping. When the execution fails it shows 0 mapping)

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