ECC - Data Load Failing When Using the ECC_FRAMEWORK_AGENT Profile With Errors - 'Http/1.1 Service Unavailable' and ORA-22828, ORA-06512, ORA-00904
(Doc ID 3015354.1)
Last updated on APRIL 22, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
When attempting run a Full Data Load Concurrent Program on an ECC environment, that failed with these errors:
* In the Concurrent Program request log(s) exported from UI:
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: https://[HOSTNAME]:[PORT]
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:po_pcc]
Parameter [name:pDataSetKey, value:]
Parameter [name:pLoadType, value:FULL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:]
Parameter [name:pLogLevel, value:ERROR]
...
Concurrent request ID is 367243661
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> po_pcc
Load Type -> FULL_LOAD
DataSet Key ->
Language ->
Trace Flag ->
Force Create Flag ->
Last Run Date Identifier ->
Log Level -> ERROR
INFO: Language parameter is not specified. Hence defaulting to base language US
Running Full Load
JobId -> -1
data load concurrent program failed
<html><body><b>Http/1.1 Service Unavailable</b></body> </html>
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
* Furthermore, in some of the child request logs under $ECC_BASE/Oracle/quickInstall/logs - these errors were also found :
2024-03-07 07:51:08.359 [pool-5-thread-1] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code: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 33,310 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 33,310 exception details:
java.sql.SQLSyntaxErrorException: ORA-00904: "CUM_WEIGHTAGE": invalid identifier
and
2024-03-06 21:43:23.574 [pool-5-thread-3] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:There is Exception while applying load rule for dataset ar-trx for job 33,163 There is Exception while applying load rule for dataset ar-trx for job 33,163 exception details:
java.sql.SQLException: ORA-22828: input pattern or replacement parameters exceed 32K size limit
ORA-06512: at "APPS.AR_ECC_UTIL_PVT", line 2385
ORA-06512: at line 1
The steps to replicate the problem were:
1. Run that Data Load concurrent program;
2. Monitor its execution;
3. See the errors reported.
Changes
ECC_FRAMEWORK_AGENT profile was used.
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 |
| Changes |
| Cause |
| Solution |
| References |