CA PPM System Health Report

The health report shows system configuration status for the application, database, data warehouse, and report server. Available in the 14.4.0.7 and 15.1.0.4 patches, this report appears as an application page with five tabs. The health report is also available as an XLS spreadsheet you can view in Microsoft Excel. The report also detects any non-compliant governor settings (maximum data limits).
ccppmod151
The health report shows system configuration status for the application, database, data warehouse, and report server. Available in the 14.4.0.7 and 15.1.0.4 patches, this report appears as an application page with five tabs. The health report is also available as an XLS spreadsheet you can view in Microsoft Excel. The report also detects any non-compliant governor settings (maximum data limits).
Required Access Rights
  • To run the Health Report, verify that you have the Administration - Access and 
    Administration - Application Setup
     global access rights.
  • To run the tomcat access log import/analyze job, verify that you have the 
    Jobs - Access
     right. Also verify that you have the following instance level job definition access right: 
    Job - Run
     on 
    Tomcat access log import/analyze
    .
View or Download a 
CA PPM
 System Health Report
System health including the 
CA PPM
 application servers, database, and data warehouse is important. As an administrator, application support engineer, or help desk technician, you want to maintain operations and minimize downtime. Before contacting other support professionals or engaging with the online community, you want a quick assessment of 
CA PPM
 system health. 
  1. Log in to 
    CA PPM
     with administrative access rights.
  2. Click the 
    Administration
     menu. Under 
    Security and Diagnostics
    , select 
    Health Report
    .
  3. Select one of the following tabs:
    • Summary
      : This tab lists the health status and completion percentage for the application, database, and data warehouse. The
      % Completed
      column calculates the total number of settings that require a value during a new install or upgrade. The health report summary shows you what portion those required settings have a value. For example,
      88% Complete
      indicates that you are still missing valid values for the remaining 12 percent of all settings. When the report shows
      Setup Complete
      and a green status icon, the health for that category is good. When setup is not complete, a red icon appears. Click
      Details
      to view more information.
    • Application
      : This tab shows application server details. Settings include file locations, URLs, Java version, JVM, LDAP, SSO, SSL, ports, and instance-specific configurations for CSA, background (bg), and beacon services. 
      • To verify settings for the 
        New User Experience
        , expand Application Instance (app), New User Experience. The ppm-ux attribute appears with a red icon when a newer version is available but is not deployed. The 
        New User Experience
         features are delivered and updated through a separate Java WAR file. WAR files should have a META-INF folder.
      • To verify settings for governor limits, expand Governor Limits.
      • To toggle the status of the real-time RateMatrix property, click
        Enable
        or
        Disable
        . When enabled, the application applies the PRJ_RT_RATES_EXTRACTION rate matrix options. This setting is disabled by default.
    • Database
      : This tab provides information about database connectivity, table spaces, database options, and server parameters.
    • Data Warehouse
      : This tab provides information about data warehouse connectivity, table spaces, data warehouse options, and server parameters. Settings include JDBC URL, database timezone mismatch, database size, and ETL job timeout for the Load Data Warehouse job. This tab also includes setup information for time slices and other application settings for the data warehouse. Click the Fix It link to navigate to the application page where you can fix the non-compliant setting. For example, a red icon and Fix It link appear to help you set up entities or time slices.
    • Reporting
      : This tab identifies the health status of the Jaspersoft report server.
  4. If available, the Recommended column provides the suggested values to achieve compliance and improve system health. If no exact value is recommended, the field remains empty.
  5. Hover your mouse over the Status icon to view a recommendation to fix the listed item.
  6. This step applies only to the Data Warehouse tab for Oracle database administrators. You might have permissions to V_$PARAMETER. If you do, expand Database Parameters to view the health of your database and data warehouse parameters. If you do not have permissions, hover over the status icon to show the command to grant access.
  7. To export the complete health report to Excel, click the Download Health Report button on the Summary tab. Open the HealthReport.xls.zip file to view the HealthReport.xls file.
  
Command Line Health Report
To run the health report from a command line, enter the following command:
admin healthreport
Health Report Exclusions
In SaaS and FedRAMP environments, the health report database and data warehouse tabs do not list the following items:
  • JDBC URL
  • Database Parameters
  • SQLNET parameters
Governor Settings (Maximum Data Limits)
Governor settings optimize performance by enforcing maximum limits on specific data. For example, the maximum size allowed for an uploaded document is 20 megabytes and the maximum number of rows you can export to Excel is 25,000. These limits help prevent a minority of users from degrading the performance of all other users.
The following table lists the recommended and enforced governor settings for this release:
Governor Setting
Default Value
Units
Maximum file size for a document. (Only applies during initial upload. Any pre-existing documents that exceed the setting are not affected.)
20
MB
Maximum number of rows that you can export to Excel.
25,000
rows
Maximum number of rows that can be fetched in a list view or grid portlet. (Only applies if you configure aggregation on the list view or grid portlet.)
50,000
rows
Maximum number of query rows that you can retrieve using a GEL script. (Only applies to select queries that run in GEL scripts.)
100,000
rows
Maximum number of tasks in a timesheet.
250
tasks
Maximum number of nodes that you can read or write through XOG.
150,000
nodes
Maximum number of attributes in a portfolio.
700
attributes
Maximum number of roles in a portfolio.
75
roles
Maximum time for an export to Excel before ending the export.
600
seconds
Maximum number of to do items for a task.
25
to do items