Oracle RMA 13.3.x Upgrade Process Is Failing On Odi_import.ksh Step (Doc ID 2075378.1)

Last updated on APRIL 08, 2021

Applies to:

Symptoms

In the process of upgrading RMA Retail Merchandising Analystics from 13.3.0 base to 13.3.1 and also while upgrading from 13.3.1 to 13.3.6 encountering a lot of issues with the odi_import.ksh script.
It is failing every 30 sec with a error database connection timeout and need to restart it.

Error:

OracleDI: Starting Command : OdiImportObject -file_name=/apps/Installers/RMA/13.3.1/CDROM/ora/installer/ora13/mmhome/odi-patches/13.3.0.0_13.3.1.0/PACK/PACK_SIL_RetailPromotionBudgetFact.xml -import_mode=SYNONYM_Insert_Update ...
oracle.odi.oditools.OdiToolException: This ODI Tool needs to be connected to the repository but repository connection failed
at oracle.odi.oditools.OdiAbstractToolRunner.executeCoreTool(OdiAbstractToolRunner.java:136)
at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:50)
at oracle.odi.ToolRunner.main(ToolRunner.java:74)
Caused by: oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:100)
at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
at oracle.odi.core.OdiInstance.(OdiInstance.java:544)
at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
at oracle.odi.ToolRunner.initInstance(ToolRunner.java:35)
at oracle.odi.oditools.OdiAbstractToolRunner.executeCoreTool(OdiAbstractToolRunner.java:131)
... 2 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376)
at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
... 7 more
Caused by: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:117)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 17 more
----------------------------------------------------------------
./odi_import.ksh ERROR: There was a problem during the ODI import of /apps/Installers/RMA/13.3.1/CDROM/ora/installer/ora13/mmhome/odi-patches/13.3.0.0_13.3.1.0/PACK/PACK_SIL_RetailPromotionBudgetFact.xml.
  You may fix the root cause and re-run this script. The import
  process will resume with this file. Files which have loaded
  successfully will not be re-loaded into ODI.
----------------------------------------------------------------

Cause

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