Clarity

Expand all | Collapse all

Upgrade from 14.2 to 15.2 appears to be hung

  • 1.  Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-11-2017 06:21 PM

    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? 



  • 2.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-11-2017 11:20 PM

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

     

    Thanks

    Senthil



  • 3.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-14-2017 12:41 PM

    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



  • 4.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 10:45 AM

    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.



  • 5.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 12:35 PM

    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.



  • 6.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 01:51 PM

    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



  • 7.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 04:42 PM

    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



  • 8.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-16-2017 01:10 AM

    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



  • 9.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-16-2017 02:36 PM

    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



  • 10.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 02:13 PM

    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



  • 11.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 02:27 PM

    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



  • 12.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-15-2017 02:37 PM

    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



  • 13.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-28-2017 02:57 PM

    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.Error java.lang



  • 14.  Re: Upgrade from 14.2 to 15.2 appears to be hung

    Posted 08-29-2017 03:08 AM

    Hi Daniel,

     

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

     

    Regards

    Suman Pramanik