Clarity

 View Only
  • 1.  PMO (csk) installation getting stuck (PPM v15.1)

    Posted Jan 09, 2017 03:12 PM

    Hi, folks.

    I found many similar problems like this on the forum, but none of them was exactly like mine.

     

    I'm trying to run this command

    sudo ./admin content csk

     

    The script is getting stuck in the same step,

     

    Loading DBDriver file: /opt/ca/ppm/database/content/csk/driver.xml

     

    and it stays like that for several hours until I ctrl+c it.

     

    Here is the console text:

    [ppm@ppm002 bin]$ sudo ./admin content csk
    [sudo] password for ppm:

    Current product version: 15.1.0.149

    The minimum product version(s)
    that are supported: 15.1.0

    Validating the current product version against
    the minimum supported version: 15.1.0

    The product version has been validated as supported
    Installation properties for CA PPM Accelerator: Program Management Office
    ID: csk
    reports.apply=false
    package.addin.release=15.1.0
    package.addin.version=15.1.0.0001
    force=false
    Removing obj_alignment attribute...
    Getting view information...
    Total execution time: 0H:0M:8.277S
    Content Pack csk version 0.0.0.0 has been deployed
    Installing content... csk
    Installing content items that do not already exist or have the force option set to true
    ==========================================
    DBTools Log - Mon Jan 09 18:04:51 BRST 2017
    ==========================================
    Command: install database schema from driver file
    To URL: jdbc:clarity:oracle://localhost:1539;SID=ORA12C;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
    As user: clarity
    For vendor: oracle
    Loading DBDriver file: /opt/ca/ppm/database/content/csk/preupgrade-driver.xml
    Loading DBDriver file: /opt/ca/ppm/database/content/csk/preupgrade-driver.xml
    Current database version is database_csk_15.1.0.0001-preupgrade
    DBDriver for database_csk_15.1.0.0001-preupgrade
    DBDriver has already been installed!
    Total time: 0H:0M:3S
         Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_PARAM.xml
         Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_PARENT_PARAM.xml
         Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_CHILD_PARAM.xml
         Applying objects/cop_idea_prj_map.xml
         Applying objects/cop_addin_lookup_map.xml
         Applying objects/cop_prj_statusrpt.xml
         Applying lookups/OBJ_IDEA_PROJECT_CATEGORY_PARAM.xml
         Applying objects/inv.xml
         Applying objects/project.xml
         Applying objects/idea.xml
         Applying objects/task.xml
         Applying objects/benefitplandetail.xml
         Applying objects/glallocation.xml
         Applying objects/resourcecredit.xml
         Applying objects/risk.xml
         Applying objects/pfm_investment.xml
         Applying objects/pfm_portfolio.xml
    Loading registered objects for custom attribute bootstrap...
    Loading registered objects for object mappings bootstrap...
    Loading registered objects to bootstrap...
    Loading registered objects for view bootstrap...
    Loading registered objects for object action bootstrap...
    Loading registered objects for data warehouse attributes bootstrap...
    Loading registered objects for building blocks bootstrap...
    Total bootstrap time: 0H:2M:16.693S
    ==========================================
    DBTools Log - Mon Jan 09 18:09:01 BRST 2017
    ==========================================
    Command: install database schema from driver file
    To URL: jdbc:clarity:oracle://localhost:1539;SID=ORA12C;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
    As user: clarity
    For vendor: oracle
    Loading DBDriver file: /opt/ca/ppm/database/content/csk/driver.xml
    Loading DBDriver file: /opt/ca/ppm/database/content/csk/driver.xml

     

    Have anyone ever had this problem? How should I try to solve it?

     

    Tks,

    Gustavo



  • 2.  Re: PMO (csk) installation getting stuck (PPM v15.1)
    Best Answer

    Posted Jan 09, 2017 04:48 PM

    Hi Gustavo.de.Almeida-DATAPREV

     

    This is due to your DB parameters. Ensure they are set as in the installation guide.

     

    CA PPM 15.1  is very sensible to db parameters. If they are not 100% correct, csk (PMO) hangs on "driver.xml" when installing.

     

    https://docops.ca.com/ca-ppm/15-1/en/installing-and-upgrading/set-up-the-ca-ppm-database 

     

    Set the Required Oracle Database Parameters

    Set the required parameters in the following table for your new database:

    NameValue
    Character SetAL32UTF8
    National Character SetUTF8/AL16UTF16
    nls_date_formatYYYY-MM-DD HH24:MI:SS
    nls_sortBINARY
    nls_compBINARY
    query_rewrite_enabledtrue
    Cursor_sharingFORCE

    Set the following parameter values to optimize performance when running CA PPM Release 15.1 with Oracle 12.1.0.2.

    • optimizer_adaptive_features=false 
    • optimizer_inmemory_aware=false 
    • optimizer_adaptive_reporting_only=true

    InitNIKU.ORA Parameter File Samples with Recommended Settings

    The following initNIKU.ora file uses Automatic Memory Management (AMM). The following samples are the recommended parameter settings. However, you can adjust the settings according to your environment.

    Windows

    *.audit_file_dest='C:\apps\oracle\admin\niku\adump'  *.audit_trail='db'  *.compatible='11.2.0'  *.control_files='C:\apps\oracle\oradata\niku\control01.ctl','C:\apps\oracle\oradata\niku\control02.ctl'  *.cursor_sharing='FORCE'  *.db_block_size=8192  *.db_domain=''  *.db_name='niku'  *.diagnostic_dest='C:\apps\oracle'  *.job_queue_processes=20  *.memory_max_target=16G  *.memory_target=12G  *.nls_comp='binary'  *.nls_date_format='YYYY-MM-DD HH24:MI:SS'  *.nls_sort='binary'  *.open_cursors=1000  *.processes=1000  *.remote_login_passwordfile='EXCLUSIVE'  *.sessions=1000  *.session_cached_cursors=1000 *.sga_max_size=0  *.sort_area_size=0  *.streams_pool_size=512M 

    Linux (Non-Windows)

    *.compatible='11.2.0'  *.control_files='/niku/oracle/oradata/niku/control01.ctl','/niku/oracle/oradata/niku/control02.ctl','/niku/oracle/oradata/niku/control03.ctl'  *.core_dump_dest='/niku/oracle/admin/niku/cdump'  *.cursor_sharing='FORCE'  *.db_block_size=8192  *.db_cache_size=16777216  *.db_domain=''  *.db_file_multiblock_read_count=16  *.db_name='niku'  *.diagnostic_dest='/niku/oracle/admin/niku/udump'  *.filesystemio_options='SetAll'           *** for non ASM instances.  *.job_queue_processes=20  *.memory_max_target=16G  *.memory_target=12G  *.nls_comp='binary'  *.nls_date_format='YYYY-MM-DD HH24:MI:SS'  *.nls_sort='binary'  *.open_cursors=1000  *.processes=1000  *.remote_login_passwordfile='EXCLUSIVE'  *.sessions=1000 *.session_cached_cursors=1000 *.sga_max_size=0  *.sga_target=0  *.sort_area_size=0  *.streams_pool_size=512M  *.undo_management='AUTO'  *.undo_tablespace='UNDOTBS1'  *** The memory target and tablespace sizes can be adjusted depending upon the customer implementation. If customers are using Linux Huge pages, the DBA can disable AMM and use SGA and PGA instead, until Oracle supports AMM and Linux Huge pages.    SQLNET.ora parameters: NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) SQLNET.INBOUND_CONNECT_TIMEOUT = 0 SQLNET.SEND_TIMEOUT = 600 (Applicable for Oracle 11.2.0.4, Oracle Bug 18841764)


  • 3.  Re: PMO (csk) installation getting stuck (PPM v15.1)

    Broadcom Employee
    Posted Jan 10, 2017 01:34 AM

    Hi Gustavo,

     

    Can you please check the database optimizer version.

     

    Regards
    Suman Pramanik 



  • 4.  Re: PMO (csk) installation getting stuck (PPM v15.1)

    Posted Jan 17, 2017 12:04 PM

    Well, you were right, Aurora_Gaimon.  That did the trick.
    Some parameters were incorrect.

     

    I ran:

    ALTER SYSTEM SET CURSOR_SHARING='FORCE' SCOPE=SPFILE;
    ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES=FALSE SCOPE=SPFILE;
    ALTER SYSTEM SET OPTIMIZER_INMEMORY_AWARE=FALSE SCOPE=SPFILE;
    ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_REPORTING_ONLY=TRUE SCOPE=SPFILE;

     

    Then, Shutdown and Startup and the script ran without problems.

     

    Thank you for this!!



  • 5.  Re: PMO (csk) installation getting stuck (PPM v15.1)

    Posted Jan 17, 2017 12:06 PM

    Glad that it's now solved