DQ Rule Execution with Many Conditions Failed with ORA-06502 (Doc ID 1595304.1)

Last updated on OCTOBER 25, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 to 7.3.3.0.0 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 7.3.2 version, Unified Metadata Manager

When attempting to run a Data Quality (DQ) Rule with many conditions, the following error occurs.

Error:
6502-ORA-06502: PL/SQL: numeric or value error : character string buffer too small -> DQ Batch Execution- Failed.


Steps:

1. Create a DQ rule with 15 and more conditions.
2. Executed the rule in the Data Quality Group Summary interface the single DQ rule fails with the above error.
3. If a condition is removed from the rule then the rule runs without any errors.


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