ECC ECCRUNDL: ECC Run Data Load Errors (Doc ID 2681760.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

On :  12.2.8 version, ECC Purchasing

The concurrent program PO ECC Strategic Sourcing Data Load is ending
with error reported below

ERROR
-----------------------
Reading server response
17:28:44.809 [pool-4-thread-1] ERROR 1.o.e.i.u.s.i.IRDataLoadServiceImpl
- mAuditRequest.getApplication().getApplicationShortName() pon, datasetKey
null loadtype FULL_LOAD17:29:26.528 [pool-4-thread-1] ERROR
1.o.e.i.u.s.i.DataLoadControllerServiceImpl - getSingleResult() did not
retrieve any entities.; nested exception is
javax.persistence.NoResultException: getSingleResult() did not retrieve
any entities.org.springframework.dao.EmptyResultDataAccessException:
getSingleResult() did not retrieve any entities.; nested exception is
javax.persistence.NoResultException: getSingleResult() did not retrieve
any entities
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:392) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:491) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) ~[spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
...

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run ECCRUNDL: ECC Run Data Load with the following parameters:
PARAMETERS LIST :
     SystemId -> EBS
     Application Short Name -> pon
     Load Type -> FULL_LOAD
     DataSet Key ->
     Language ->
     Trace Flag ->
     Log Level -> ERROR

2. Submit concurrent request and it completes in error

Changes

Cause

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