Parent Child Hierarchy Creation issue

Question

Hi.,

Getting the below error while executing data population script created by wizard when creating parent child hierarchy in obiee 11.1.1.7.1

Error report -

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at line 41

06502. 00000 -  "PL/SQL: numeric or value error%s"

*Cause:    An arithmetic, numeric, string, conversion, or constraint error

occurred. For example, this error occurs if an attempt is made to

assign the value NULL to a variable declared NOT NULL, or if an

attempt is made to assign an integer larger than 99 to a variable

declared NUMBER(2).

*Action:   Change the data, how it is manipulated, or how it is declared so

that values do not violate constraints.

FTisiot · Answer

Basically reading the error You should verify that the source column definition in your Closure Table has:

- Not Nullable columns where you're trying to push a null

- Numbers defined as NUMBER(2) where the query is trying to push a number greater than 99.

Compare the datatype with the result of the SQL generated by OBIEE and you'll understand where the error is.