This discussion is archived
4 Replies Latest reply: Jan 7, 2013 3:35 AM by AMSI RSS

Error when running Upgrade Assisitant

AMSI Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points