Clarity

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

We need to have your DWH configured for upgrade. Any reason why you are not having that.

Thanks Suman for your reply.

Client don't need Datawarehouse so we are not using it.

DWH configured means do we need to add oracle database?

Can you please suggest how can we proceed for installation without datawarehouse?

Thank you.

you can just create a schema and you dont need different database 

Try the suggestion of removing the DWH DB parameters from the PPM CSA page, it is currently configured. Along with that ensure there is no entity included for DWH. i.e. PPM UI administration > general settings> system options. 

Install.log:

4/24/18 10:48 AM (ExecTask) To URL: jdbc:clarity:oracle://dbotlunk04t:48850;SID=LUNK04T;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true

Thanks much,

Sanish

Thanks Sanish for solution.

Just 1 more question. In release notes I have read the following:

We recommend that you install patch 14.4.0.2

But in downloaded patch from ca site I can see install.14.4.0.8.12.i.jar
Does it mean that if we install install.14.4.0.8.12.i.jar there is no need to install  patch 14.4.0.2?

Thanks for your reply.

In support site you will have the latest patch and its cumulative. So you are ok to install patch 8 on 14.4 

Regards

Suman Pramanik