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

Last updated on NOVEMBER 06, 2015

Applies to:

Oracle Retail Merchandising Analytics - Version 13.3.1 and later
Information in this document applies to any platform.

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.
----------------------------------------------------------------
[rmaprd@wmrmaappd01 13.3.0.0_13.3.1.0]$

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms