AnsweredAssumed Answered

Clarity Upgrade from 14.2 to 14.4 failed with DWH Errors

Question asked by Amruta23 on Apr 24, 2018
Latest reply on May 2, 2018 by Suman Pramanik

Hello Everyone,

I just did an upgrade from version 14.2 on 14.4 and it ended with below errors.

Postcheck-results.xml:

  <result name="check-upgrade-complete.xml" value="ERROR">
    <resultinfo>Upgrade phase for release 14.3.0 was completed, Upgrade phase for release 14.4.0 was not completed</resultinfo>
  </result>
  <result name="check-upgrade-exception.xml" value="ERROR">
    <resultinfo>UPGRADE FAILED WITH THE FOLLOWING EXCEPTION: ${exception.msg} The following error occurred while executing this line:
/appl/lunkt00/app/tmp1/install.xml:538: The following error occurred while executing this line:
/appl/lunkt00/app/tmp1/install.xml:896: exec returned: 1. Please check install.log for more details.</resultinfo>
  </result>


So I did a little research in the install.log and found that its failed while trying to install db driver for DWH.

 

4/24/18 10:48 AM (ExecTask) Start installation of DBDriver ...
4/24/18 10:48 AM (ExecTask)
4/24/18 10:48 AM (ExecTask) Note: Foreign Keys have been disabled
4/24/18 10:48 AM (ExecTask)
4/24/18 10:48 AM (ExecTask) DBDriver failed to install!
4/24/18 10:48 AM (ExecTask)
4/24/18 10:48 AM (ExecTask) Total time: 0H:0M:4S
4/24/18 10:48 AM (ExecTask) Exception in thread "main" java.lang.Exception: DBDriver failed to install
4/24/18 10:48 AM (ExecTask)     at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:911)
4/24/18 10:48 AM (ExecTask)     at com.niku.dbtools.Utilities.run(Utilities.java:1862)
4/24/18 10:48 AM (ExecTask)     at com.niku.dbtools.Utilities.main(Utilities.java:975)
4/24/18 10:48 AM (ExecTask) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error: ORA-02270: no matching unique or primary key for this col
umn-list
4/24/18 10:48 AM (ExecTask) ORA-06512: at "PPM_DWH.CMN_ENABLE_DISABLE_SP", line 67
4/24/18 10:48 AM (ExecTask) ORA-06512: at line 1
4/24/18 10:48 AM (ExecTask) Caused by: /appl/lunkt00/app/lunk/.setup/scripts/db.xml:2477: The following error occurred while executing this line:
4/24/18 10:48 AM (ExecTask) /appl/lunkt00/app/lunk/.setup/scripts/db.macros.xml:2968: The following error occurred while executing this line:
4/24/18 10:48 AM (ExecTask) /appl/lunkt00/app/lunk/.setup/scripts/db.xml:624: The following error occurred while executing this line:
4/24/18 10:48 AM (ExecTask) /appl/lunkt00/app/lunk/.setup/scripts/db.macros.xml:44: Java returned: 1
Caused by: /appl/lunkt00/app/tmp1/install.xml:538: The following error occurred while executing this line:
/appl/lunkt00/app/tmp1/install.xml:896: exec returned: 1
4/24/18 10:48 AM (ExecTask) ------------------------------------------------------------
4/24/18 10:48 AM (ExecTask) Error occurred: /appl/lunkt00/app/lunk/.setup/scripts/db.xml:2797: Upgrade failed

 

I have attached the install log for your reference.

In our case there is no datawarehouse configured.
So can you please suggest how can we proceed by skipping all datawarehouse related checks and upgrades?


Thank you.

Best regards,

Amruta

Attachments

Outcomes