ECC: Data Load For IProcurment Runs Into An Error DRG-10825: stored query does not exist: icxzb
(Doc ID 2603239.1)
Last updated on AUGUST 11, 2024
Applies to:
Oracle iProcurement - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.8 version,
ACTUAL BEHAVIOR
---------------
ECC: Data Load for iProcurment runs into an error
As per document "Oracle iProcurement Implementation and Administration Guide", page 6-5, client has performed a full load from ECC Developer responsibility.
The full load runs into an error. When running the full log with debug,
Found errors in the log, like "DRG-10825: stored query does not exist: icxzb".
here is the error in log file:
SELECT
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b
09:29:07.272 [pool-4-thread-2] ERROR
1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying
to ingest data for this load rule ICX_ECC_UTIL_PVT.get_ecc_data_load_info
with dataset icx-catalog for job 16,829
java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b
09:29:07.272 [pool-4-thread-2] ERROR
1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying
to ingest data for this load rule ICX_ECC_UTIL_PVT.get_ecc_data_load_info
with dataset icx-catalog for job 16,829
java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb
SELECT
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b;
==>
client ran the query, this is the result:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b;
==>
client ran the query, this is the result:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.
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 |