My Oracle Support Banner

ECC Iprocurement Data Load Failed With ORA-29902 and ORA-00068 (Doc ID 2695783.1)

Last updated on JULY 30, 2020

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, ECC iProcurement

ACTUAL BEHAVIOR
---------------
ECC Iprocurement Data Load Failed With the following error:

Failed as one of the load rules failed which is [id = 8,204, ICX_ECC_UTIL_PVT.get_ecc_data_load_info]. Please check the load rule audit entry

There is SQLException while applying load rule for dataset icx-catalog for job 24,003. Exception details ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00068: invalid value 1500000000 for parameter _kgl_large_heap_assert_threshold, must be between 0 and 0oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)




Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.