4 Replies Latest reply: Jan 7, 2013 5:35 AM by AMSI RSS

    Error when running Upgrade Assisitant

    AMSI
      hi,
      when i run the ua.bat. after sucessfull upgrade the all reporsitory it throws the error on only one reporsitory................kindly guide me

      Upgrade: Upgrading Repository Data...
      [2012-12-26T11:56:10.423+05:00] [ODI] [ERROR] [UPGCMP-00334] [upgrade.ODI] [tid: 103] [ecid: 0000JjLzD9kFg4K6yVbe6G1Gqd5300000B,0] Unknow error happened.
      [2012-12-26T11:56:10.423+05:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: 103] [ecid: 0000JjLzD9kFg4K6yVbe6G1Gqd5300000B,0] Cause: Unknow error happened. Action: Restory Work Repository from Backup and try to upgrade again.
      [2012-12-26T11:56:10.423+05:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: 103] [ecid: 0000JjLzD9kFg4K6yVbe6G1Gqd5300000B,0] [[
      oracle.odi.setup.RepositorySetupException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EDW_TRAINING.PK_TXT_HEADER) violated

           at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:481)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:186)
           at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:39)
           at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:382)
           at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:153)
           at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeWork(RepositoryUpgradeServiceImpl.java:57)
           at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:136)
           at oracle.ias.mrua.plugin.odi.ODIPlugin.doUpgrade(ODIPlugin.java:462)
           at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:3576)
           at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:2357)
           at oracle.ias.mrua.MRUA.driver(MRUA.java:1621)
           at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:390)
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EDW_TRAINING.PK_TXT_HEADER) violated

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
           at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:712)
           at com.sunopsis.dwg.dbobj.generated.GeneratedSnpTxtHeader.insertAction(GeneratedSnpTxtHeader.java:370)
           at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3288)
           at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3316)
           at com.sunopsis.dwg.dbobj.SnpTxtHeader.setString(SnpTxtHeader.java:409)
           at com.sunopsis.dwg.dbobj.SnpTxtHeader.setString(SnpTxtHeader.java:571)
           at com.sunopsis.repository.manager.oldupgrade.UpgradeUtils.treatMigrationParams(UpgradeUtils.java:243)
           at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.migrateToLongTextText(Pre04_03_03_02Upgrader.java:885)
           at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.workUpgradePre04_03_03_02(Pre04_03_03_02Upgrader.java:710)
           at com.sunopsis.repository.manager.RepositoryManager.workRepositoryPatch(RepositoryManager.java:4743)
           at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:466)
           ... 11 more

      Regards,
      AMSII