Error when clicked on Rule Preview (Doc ID 2582724.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

When clicked on preview option in Rule window getting error page.

Below error in PR2Service.log 

 [GENERICRULEQUERYDAO][insertRuleQuery] Qry: INSERT INTO PR2_RULE_QUERY (V_RULE_ID, V_INFODOM_NAME, V_SELECT_HINT, V_MERGE_HINT, V_TARGET_TABLE_NAME, V_TARGET_COLUMN_NAME_1, V_TARGET_COLUMN_NAME_2, V_TARGET_COLUMN_NAME_3, V_TARGET_COLUMN_NAME_4, V_TARGET_COLUMN_NAME_5, V_DS_FROM, V_DS_JOIN, V_DS_FILTER, V_RULE_FILTER, V_PRE_SCRIPT, V_POST_SCRIPT, F_USE_ROWID, V_RC_2, V_RC_3, V_RC_4, V_RC_5, V_QUERY_CONDITION_1, V_QUERY_EXPRESSION_1, V_QUERY_CONDEXP_1, V_QUERY_CONDITION_2, V_QUERY_EXPRESSION_2, V_QUERY_CONDEXP_2, V_QUERY_CONDITION_3, V_QUERY_EXPRESSION_3, V_QUERY_CONDEXP_3, V_QUERY_CONDITION_4, V_QUERY_EXPRESSION_4, V_QUERY_CONDEXP_4, V_QUERY_CONDITION_5, V_QUERY_EXPRESSION_5, V_QUERY_CONDEXP_5, V_RC_1) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[PR2LOG]  : [GENERICRULEQUERYDAO][insertRuleQuery] Exception has occured

java.sql.SQLException: Could not execute sql command - Original message: ORA-01461: can bind a LONG value only for insert into a LONG column

at com.ofs.aai.database.OFSAAPreparedStatementDecorator.executeUpdate(OFSAAPreparedStatementDecorator.java:889)

at com.ofs.aai.pr2.dao.impl.GenericRuleQueryDAO.insertRuleQuery(GenericRuleQueryDAO.java:329)

at com.ofs.aai.service.rule.engine.GenericRuleEngine.buildRuleQuery(GenericRuleEngine.java:537)

at com.ofs.aai.service.rule.engine.GenericRDBMSRuleEngine.build(GenericRDBMSRuleEngine.java:1574)

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.