8 Replies Latest reply: Feb 15, 2013 12:59 PM by user10405218 RSS

    Getting error while importing topology,scenarios from 11.3 to ODI 11.5

    776422
      Hi,

      Recently I had installed ODI 11.1.5.
      Now I am importing topology and scenarios exported from my older ODI 11.1.3 via shell script on Linux machine.
      There around 25 topology and around 40 scenarios.When i execute the script out of these some topology and scenarios get imported and for rest i get following error.
      Imported files are not persistent.Sometimes same file got imported and when I execute next time the same file gives error.

      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:133)
           at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:47)
           at oracle.odi.ToolRunner.main(ToolRunner.java:75)
      Caused by: oracle.odi.core.config.MasterRepositoryResourceFailureException: 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 oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:79)
           at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
           at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
           at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
           at oracle.odi.ToolRunner.initInstance(ToolRunner.java:36)
           at oracle.odi.oditools.OdiAbstractToolRunner.executeCoreTool(OdiAbstractToolRunner.java:128)
           ... 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:180)
           at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:374)
           at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:77)
           at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:492)
           ... 6 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)
           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:180)
           at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:375)
           ... 8 more


      Please guide me in this regard.