ADI Refreshing Failing Post 8.1 Upgrade (Doc ID 2724754.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Symptoms

On : 8.1.0 version, METADATA_OFSS

When attempting to execute ADI refresh,
the following error occurs.

ERROR
-----------------------
ADI.log
--------------
[10-09-20 11:20:57.959][INFO ] [DSEntityUtils][createTargetDs]Persisting Datastore
[10-09-20 11:21:00.876][ERROR] [ADIRefresh][trigger]Error occured while creating ADI Repo
java.lang.Exception: Error occured while creating ADI Repo
at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:85) ~[dih-adiref.jar:8.1.0.0.0_10375210451974]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:148) [dih-adiref.jar:8.1.0.0.0_10375210451974]
at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:88) [dih.jar:8.1.0.0.0_10375210451974]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
Caused by: java.lang.Exception: Error occurred while creating DataStore for given Infodom : INFODOM
at com.ofss.fsgbu.dihref.util.DSEntityUtils.createTargetDs(DSEntityUtils.java:55) ~[dih-adiref.jar:8.1.0.0.0_10375210451974]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:77) ~[dih-adiref.jar:8.1.0.0.0_10375210451974]
... 3 more
Caused by: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170) ~[com.bea.core.datasource6.jar:12.2.1.4]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.executePS(QueryRunnerUtils.java:261) ~[dih-core.jar:8.1.0.0.0_10375210451974]
at com.ofss.fsgbu.dihref.util.DSEntityUtils.createTargetDs(DSEntityUtils.java:26) ~[dih-adiref.jar:8.1.0.0.0_10375210451974]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:77) ~[dih-adiref.jar:8.1.0.0.0_10375210451974]
... 3 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to perform ADI refresh

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform ADI refresh successfully.

Cause

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