EAM Enterprise Command Center Data Load Fails with Exception Error (Doc ID 2766505.1)

Last updated on JULY 18, 2024

Applies to:

Symptoms

The Enterprise Asset Management Command Center Data Load fails with the following error.

ERROR

ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset eam-asset for job 34,206java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "APPS.EAM_ECC_ASSETS_UTIL_PVT", line 1893ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) ~[ojdbc8.jar:12.2.0.1.0] at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) ~[com.bea.core.datasource6.jar:12.2.1.3] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:1748) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:655) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:928) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:540) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForDatasetWorkFlowSourceSystem$27(IRDataLoadServiceImpl.java:2270) [ecc-ir-1.0.0.jar:na] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]Caused by: oracle.jdbc.OracleDatabaseException: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "APPS.EAM_ECC_ASSETS_UTIL_PVT", line 1893ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0] ... 23 common frames

STEPS

The issue can be reproduced at will with the following steps:
1. Run Job = Enterprise Asset Management Command Center Data Load
2. Job fails on 2 of the 6 spawned jobs :
   EAM Data Load for dataset eam-asset-attrs (ECC Run Data Load)
   EAM Data Load for dataset eam-asset (ECC Run Data Load)

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.