Clarity

Hello,

I'm performing an upgrade from CA PPM 14.2 to 15.2 and it seems as though the installer is hung at a pre-upgrade step. 

Previous schema directory: /ca/clarityapp/upgrade/infrastructure/previousSchema
Option: filtering on type "^pre-upgrade$"
Option: -updateHistory=false - update history will not be recorded for this session.
Loading DBDriver file: /ca/clarityapp/upgrade/database/schema/driver.xml
Loading DBDriver file: /ca/clarityapp/upgrade/database/schema/driver.xml
Current database version is database_20150912_1039
DBDriver for database_20150912_1039
Resume installation of DBDriver ...

Current database version is database_20150728_1609
Note: Foreign Keys have been disabled
Process - pre-upgrade: PREGRADE_CREATE_CURRENCY_CONVERSION_FLAG.xml

It hangs at this point for +1 hour or until the terminal session becomes disconnected. Has anyone else experienced this? 

Ask DBA to monitor at database while executing PREGRADE_CREATE_CURRENCY_CONVERSION_FLAG.xml file. 

Thanks

Senthil

Hi Tony,

What is the database you are using and ensure you have the correct database parameters based on the document below

https://docops.ca.com/ca-ppm/15-2/en/installing-and-upgrading/install-ca-ppm#InstallCAPPM-ConfigureaDatabasewithOracle 

Regards
Suman Pramanik

Hi Suman,

We have just upgraded the DB to Oracle 11.2.0.4.0 from 11.2.0.3.0 in order to meet the DB compatibility needed to support CA PPM 15.2. We are currently on CA PPM 14.2 which works fine with Oracle 11.2.0.4.0.

It looks like once I edited the NLS_LANG variable in the user profile of our application server to  NLS_LANG=AMERICAN_AMERICA.AL32UTF8, the script continues to run past the original hanging point.

I made it 3+ hours into the upgrade where 14.3, 14.4, and 15.1 completed successfully. I then received the following error in the 15.2 build which caused the upgrade to fail:

8/15/17 1:27 PM (ExecTask) Process - post-upgrade: POSTUPGRADE_ACTIVATE_DWH_JOBS.xml
8/15/17 1:27 PM (ExecTask) Process - post-upgrade: POSTUPGRADE_API_HTTP_RESPONSE_HEADERS_FEATURE_TOGGLE.xml
8/15/17 1:27 PM (ExecTask) Process - post-upgrade: POSTUPGRADE_CMN_OPTIONS_HTML_PATTERNS.xml
8/15/17 1:27 PM (ExecTask) Process - post-upgrade: POSTUPGRADE_CMN_OPTIONS_XSS_VALUES.xml
8/15/17 1:27 PM (ExecTask) Process - post-upgrade: POSTUPGRADE_CRV_SQL_CURVES.xml
8/15/17 1:27 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-24344: success with compilation error
8/15/17 1:27 PM (ExecTask) ORA-06512: at line 7
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.l(Unknown Source)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.a(Unknown Source)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.executeBatch(Unknown Source)
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask) SQL Text:
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)   
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)   DECLARE
8/15/17 1:27 PM (ExecTask)    V_CNT INT := 0;
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)   BEGIN
8/15/17 1:27 PM (ExecTask)    SELECT COUNT(*) INTO V_CNT FROM ALL_OBJECTS WHERE OBJECT_NAME = 'CRV_RAW_SEGMENT' and object_type = 'TYPE BODY' AND STATUS = 'INVALID';
8/15/17 1:27 PM (ExecTask)    IF( V_CNT > 0 ) THEN
8/15/17 1:27 PM (ExecTask)     EXECUTE IMMEDIATE 'ALTER TYPE CRV_RAW_SEGMENT COMPILE BODY';
8/15/17 1:27 PM (ExecTask)    END IF;
8/15/17 1:27 PM (ExecTask)     END;
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
8/15/17 1:27 PM (ExecTask)  at java.lang.reflect.Method.invoke(Method.java:498)
8/15/17 1:27 PM (ExecTask)  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
8/15/17 1:27 PM (ExecTask)  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$b2a08f3.executeBatch(<generated>)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2738)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.DriverApp.apply(DriverApp.java:1502)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:722)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.run(Utilities.java:1864)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.main(Utilities.java:977)
8/15/17 1:27 PM (ExecTask) Note: Foreign Keys and Triggers have been enabled
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask) DBDriver failed to install!
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask) Total time: 0H:3M:9S
8/15/17 1:27 PM (ExecTask) Exception in thread "main" java.lang.Exception: DBDriver failed to install
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:920)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.run(Utilities.java:1864)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.main(Utilities.java:977)
8/15/17 1:27 PM (ExecTask) Caused by: com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-24344: success with compilation error
8/15/17 1:27 PM (ExecTask) ORA-06512: at line 7
8/15/17 1:27 PM (ExecTask)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.l(Unknown Source)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.a(Unknown Source)
8/15/17 1:27 PM (ExecTask)  at com.ca.clarity.jdbc.oraclebase.dde3.executeBatch(Unknown Source)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
8/15/17 1:27 PM (ExecTask)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
8/15/17 1:27 PM (ExecTask)  at java.lang.reflect.Method.invoke(Method.java:498)
8/15/17 1:27 PM (ExecTask)  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
8/15/17 1:27 PM (ExecTask)  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$b2a08f3.executeBatch(<generated>)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2738)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.DriverApp.apply(DriverApp.java:1502)
8/15/17 1:27 PM (ExecTask)  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:722)
8/15/17 1:27 PM (ExecTask)  ... 2 more
8/15/17 1:27 PM (ExecTask) ERROR: Upgrade failed for tenant 

Has anyone seen this error before? Will I have to roll back the upgrade completely?

Thanks,

Tony

Hi Tony

Looks like you will have to do full rollback yes. Going around this failure is not supported.

Once you rollback, ensure the object CRV_RAW_SEGMENT is compiled on database level as mentioned below by Senthil. You can ask the DBA to do that for you or run the command admin db compile. Ensure it is showing valid and then proceed with the upgrade.

Regards -Nika

Another part you need to check is to ensure you disable your custom database content if you have like triggers which interfears with the upgrade

Hey Nika,

When I run the admin db compile command, there are several objects that were returned as invalid.

Compiling database objects...
==========================================
DBTools Log - Wed Aug 16 14:33:26 EDT 2017
==========================================
Command: compile
Compiling the database....
        Following object(s) are invalid:
                CRV_AGGR_SUM_BLOB_FCT
                CRV_AGGR_SUM_BUCKETS_BLOB_FCT
                CRV_AGGR_SUM_BUCKETS_FCT
                CRV_AGGR_SUM_FCT
                CRV_AGGR_SUM_SLICES_FCT
                CRV_AVERAGE_FCT
                CRV_AVERAGE_ROW_FCT
                CRV_AVERAGE_SLICES_FCT
                CRV_AVERAGE_SLICES_ROW_FCT
                CRV_AVERAGE_SLICES_TABLE_FCT
                CRV_BLB_CALENDAR_FCT
                CRV_CALENDAR_FCT
                CRV_DATE_FROM_JULIAN_FCT
                CRV_DATE_TO_DAY_OF_WEEK_FCT
                CRV_DATE_TO_JULIAN_FCT
                CRV_DEFAULT_CALENDAR_FCT
                CRV_DEFAULT_RATE_FCT
                CRV_DEFAULT_RATE_ROW_FCT
                CRV_FINISH_DATE_FCT
                CRV_FINISH_DATE_ROW_FCT
                CRV_FISCAL_CALENDAR_FCT
                CRV_NBI_CALENDAR_FCT
                CRV_PARSE_OPTION_FCT
                CRV_RAW_SEGMENT
                CRV_RAW_SEGMENTS_FCT
                CRV_RPT_CALENDAR_FCT
                CRV_SEGMENTS_FCT
                CRV_SEGMENTS_ROW_FCT
                CRV_SEGMENTS_TABLE_FCT
                CRV_SEGMENT_SLICES_FCT
                CRV_SEGMENT_SLICES_ROW_FCT
                CRV_SEGMENT_SLICES_TABLE_FCT
                CRV_SQL_CURVE_PKG
                CRV_SQL_CURVE_PKG
                CRV_START_DATE_FCT
                CRV_START_DATE_ROW_FCT
                CRV_SUM_BLOB_FCT
                CRV_SUM_BUCKETS_BLOB_FCT
                CRV_SUM_BUCKETS_FCT
                CRV_SUM_BUCKETS_ROW_FCT
                CRV_SUM_BUCKETS_TABLE_BLOB_FCT
                CRV_SUM_BUCKETS_TABLE_FCT
                CRV_SUM_BUCKETS_TBLS_BLOB_FCT
                CRV_SUM_FCT
                CRV_SUM_GROUPS_BLOB_FCT
                CRV_SUM_ROW_FCT
                CRV_SUM_SLICES_BLOB_FCT
                CRV_SUM_SLICES_FCT
                CRV_SUM_SLICES_ROW_FCT
                CRV_SUM_SLICES_TABLES_BLOB_FCT
                CRV_SUM_SLICES_TABLES_FCT
                CRV_SUM_SLICES_TABLE_BLOB_FCT
                CRV_SUM_SLICES_TABLE_FCT
                CRV_SUM_TABLE_FCT
                DWH_CMN_PERIOD_V
                DWH_SETUP_SLICEREQUESTS_SP
                PFM_BUCKETS_TABLE_FCT
                PFM_CALENDAR_FCT
                PFM_DEFAULT_CALENDAR_FCT
                PFM_FISCAL_CALENDAR_FCT
                PFM_INV_BUCKETS_FCT
                PFM_INV_PH_SUM_FCT
                PFM_INV_SLICES_FCT
                PFM_INV_SUM_FCT
                PFM_NBI_CALENDAR_FCT
                PFM_PORT_INV_BUCKETS_FCT
                PFM_PORT_INV_PH_SUMS_FCT
                PFM_PORT_INV_SLICES_FCT
                PFM_PORT_INV_SUMS_FCT
                PFM_PORT_PH_SUM_FCT
                PFM_PORT_SLICES_FCT
                PFM_PORT_SUM_FCT
                PFM_PORT_TOTAL_ROLE_FTE_FCT
                PFM_PORT_TOTAL_ROLE_PH_SUM_FCT
                PFM_PORT_TOTAL_ROLE_SLICES_FCT
                PFM_PORT_TOTAL_ROLE_SUM_FCT
                PFM_QUERY_FCT
                PFM_RANKED_CONSTRAINT_SUMS_FCT
                PFM_RPT_CALENDAR_FCT
                PFM_SEGMENTS_FCT
                PFM_SLICES_FCT
                PFM_SLICES_TABLE_FCT
                PFM_SUM_FCT
                PRJ_BLB_SLICES_INS_SP
                RPT_CALENDAR_SP
                RPT_SETUP_SP

Tony

Hi

Can you please check whether CRV_RAW_SEGMENT object type and table type is valid or not?, if the object is not valid then compile the both object.

which environment are you currently upgrade?, if non production, then you can try to upgrade on force method.

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = 'CRV_RAW_SEGMENT'

Follow the below steps:

1. Stop the clarity services, if started

2.  Rename clarity folder to clarity_old

2. Rename Clarity_prev folder to Clarity.

3. Start the upgrade activity. ( The upgrade will start from clarity 15.1 to clarity 15.2)

Thanks

Senthil

Hey Senthil,

Attached are the results I get when I query the ALL_OBJECTS table for CRV_RAW_SEGMENT

What statement would I need to run to compile the two? This is a non-production environment. The current clarity folder is what was being built as part of the upgrade. Do I rename this to clarity_old? From there, do I re-run the install.sh script with sh ./install.sh or is it a different command?

Thanks,

Tony

You need to compile CRV_RAW_SEGMENT Object Type and ensure the object is valid

before execute install.sh or install.bat

 Yes. Please Follow the below steps:

1.  Stop the clarity services, if services already started

2.  Rename clarity folder to clarity_old

2. Rename Clarity_prev folder to Clarity.

3. Start the upgrade activity. (The upgrade will start from clarity 15.1 to clarity 15.2)

Thanks

Senthil

Hi guys,

I have a simmilar problem when i try to save one project in OWB; the system just return me the next message:

Unable to save project CA PPM/PRJ00000113. An error ocurred while trying to save your project: java.lang.Exception. Summary task "Project name" cannot have assignments.

Is this related the same problem named on first comment.

Thanks for your help.

Daniel Naranjo.

Hi Daniel,

This thread was for upgrade issue, can you open a new thread.

Regards

Suman Pramanik