CA PPM 15.1.0.10 and Jaspersoft Patch README Files

The latest cumulative patch for cappm 15.1 is 15.1.0.10. Jaspersoft patches are also available with updates. Before you apply a patch, review the README file for important details.
ccppmop151
The latest cumulative patch for 
CA PPM
 15.1 is 15.1.0.10. Jaspersoft patches are also available with updates. Before you apply a patch, review the README file for important details.
2
SaaS administrators can contact CA Support to request patch installation. On-premise administrators can visit the CA Download Center.
CA PPM
 Cumulative Patch Summary
CA PPM
Patch:
Release Date:
Apr 11, 2018
Jan 17, 2018
Oct 11, 2017
Aug 16, 2017
June 21, 2017
: Patch 15.1.0.6 fixed legacy online help issues including DE34361, DE33696, CLRT-80474, and CLRT-81485.
  • CA PPM SaaS Online Help
    : Typically, a user must register at ca.com before they can view restricted administrative or competitive documentation at docops.ca.com. However, with 15.1.0.6 or higher,
    CA PPM
    SaaS users enjoy seamless access. Registered users, users already logged in, and even unregistered new users all go directly to the matching docops page when they click
    Help
    from the application.
  • CA PPM On-Premise Online Help
    : For on-premise customers, you get reliable immediate online help for most application pages; however, users will see a login page for restricted content and must register to log in and view those special pages. The same statement is true for support, community, and other ca.com content. For on-premise administrators, the 15.1.0.6 or higher patch does not automatically remove the local offline help pages introduced in 15.1.0.2. After installing the 15.1.0.6 or higher patch, you can safely delete the old offline help pages from your application server.
 
CA PPM 15.1.0.10 Cumulative Patch README
Version #: 15.1.0
Patch #: 10
4
3
**** NOTE *************************************************************
Patches are intended to be timely fixes and are not fully regression or integration tested, and are only tested against the issues listed below. CA feels confident that this patch will resolve the addressed problems, but customers should be aware that a patch could have adverse side effects to the function of their CA PPM application. Customers should not apply patches directly to production systems without first verifying in a test environment. If any issues arise in the installation or use of this patch, please contact CA Support Services.
**************************************************************************
Included Files:
README.txt -> This file
install.sh -> Unix installer
install.bat -> Windows installer
install.xml -> Ant install script
------------------------
Prerequisites:
Install only on systems running the version stated above.
Additional Notes:
Patch 15.1.0.6 introduced support for Oracle 12c R2 databases.
-------------------------
How to Install the Patch:
------------------------
  1. Back up all files and the database on the target system.
  2. On the CSA server, copy the installer into a temp directory.
  3. Navigate to the temp directory and enter the following command to extract the contents:
      jar xvf <patch_jar_file>
  4. Stop all local nsa, app and bg services:
      service stop nsa app bg 
    Note: Allow databases and reports to continue running.
  5. From the temp directory, enter the following command to execute the installer script:
      install.bat
      or
      install.sh
  6. Follow the remaining on-screen instructions to complete the installer script.
  7. Start all services: 
      service start all
  8. If you are running multiple servers in a cluster:
    1. Log in to the CSA and go to the All Services page to shut down any remote app and bg services.
    2. Go to the Distribute All page, select remote servers, and click Distribute.
    3. Return to the All Services page to restart services when the distribution is complete.
    IMPORTANT: If you currently use or want to use the new Jaspersoft Reports and Data Warehouse, choose Step 9 or Step 10. If you do not use these features, skip Steps 9 and 10
  9. If you are applying this patch and you have already configured Jaspersoft Reports and the Data Warehouse:
    1. From <install_dir>/bin directory command prompt, enter the following command to generate keystore:
      admin jaspersoft keystore
    2. Copy the keystore files generated in <install_dir>/config directory to <Jaspersoft Tomcat Instance Directory>/webapps/<jaspersoftContext>/WEB-INF/config
    3. Enter the following command to upgrade the report content:
      admin content-jaspersoft csk -userName <superuser> -password <password> upgrade -retryCount 50
       
    4. Restart all PPM services.
    5. Run the Load Data Warehouse Access Rights job.
  10. If you are applying this patch and you want to use the new Jaspersoft Reports and Data Warehouse but have not yet configured them:
    1. From <install_dir>/bin directory command prompt, enter the following command to generate keystore:
      admin jaspersoft keystore
    2. Copy the keystore files generated in <install_dir>/config directory to <Jaspersoft Tomcat Instance Directory>/webapps/<jaspersoftContext>/WEB-INF/config
    3. Enter the following command to install the release content:
      admin content-jaspersoft csk -userName <superuser> -password <password> -retryCount 50
      This command imports jaspersoft_csk.zip followed by the file that has patch content (file name for patch content contains jaspersoft_csk_upgrade)
    4. If you encounter any error during the import of the patch content, enter the following command to re-import the patch content:
      admin content-jaspersoft csk -userName <superuser> -password <password> upgrade -retryCount 50 force
    5. Configure the Data Warehouse section in CSA. See CSA: CA PPM System Administration at docops.ca.com/ppmop.
    6. Enter the following command from the <install_dir>/bin directory command prompt to apply the Data Warehouse patch content:
      admin db dwh-upgrade -Dupgrade.phase=maintenance
    7. Restart all PPM services.
    8. Run the Load Data Warehouse Access Rights job.
--------------------------
How to Uninstall the Patch:
--------------------------
  1. Stop all local nsa, app, and bg services:
      service stop nsa app bg
  2. Restore the installation files and database from the backups above.
  3. Start all services:
      service start all
  4. If running multiple servers in a cluster:
    1. Log in to CSA and go to the All Services page to shut down any remote app and bg services.
    2. Go to the Distribute All page, select remote servers and click Distribute.
    3. Return to the All Services page to restart services when the distribution is complete.
 
--------------------------------------------
Issues Fixed in 15.1.0.10
--------------------------------------------
DE31677: In the 'Review and Approve' tab of the New UX Timesheets, there's a long loading period to display all resources
Steps to Reproduce:
1. Define a user with sufficient access rights and at least 5,000 team members with submitted timesheets that this user can review and approve. The minimum required access rights for this user are
Timesheets - Navigate
and
Timesheets - Approve All
.
2. Log in to the CA PPM New User Experience as that user.
3. Click Timesheets in the main menu on the left.
4. Click Review & Approve at the top of the page.
Expected results: Reasonable performance and load times.
Actual results: The timing of the new UI takes about 2.4 minutes to load 5k users.
DE35701: The Detailed Timesheet section does not display for submitted timesheets
Steps to Reproduce:
1. Log in to CA PPM.
2. Open the CA PPM New User Experience.
3. Click Timesheets in the main menu on the left.
4. Click Review & Approve at the top of the page.
5. Navigate to a time period that has a submitted timesheet (for example, the May 22- 28, 2017 time period).
6. From the 'Showing' dropdown, select All.
7. On the 'Open' button, deselect it so the button is no longer blue and all open timesheets are no longer displayed (thus leaving only the submitted resource timesheets).
8. Click on one of the resources with the submitted timesheet (this will open a small pop-up window on the bottom right with the timesheet tasks of the resource).
9. Click on the Detailed Timesheet button.
Expected results: For the Detailed Timesheet to open, it is displayed as an overlay window that pops up when it does work.
Actual results: The Detailed Timesheet does not open and does not display, nothing ever shows.
DE38186: Securability Fix
DE33955: In the Resource Finder, using the ENTER key trigger the filter action of the portlet
Steps to Reproduce:
1. Go to the Resource Finder in CA PPM.
2. In the filter section, click the browse icon next to Skills in order to search for skills.
3. Type in some characters.
4. Press the ENTER key.
Expected results: A search should be executed for the entered values.
Actual results: The search is not executed and it appears the ENTER key does not trigger it.
DE33564: In the Microsoft Project Interface - New Driver, the Priority is changed to 1,000 on all tasks
Steps to Reproduce:
1. Create a new project in CA PPM.
2. Create 1 task called 'T1'.
3. Export the project to Microsoft Project.
4. The Task Priority is exported as the value it is given (for example, 972).
5. Save the project back to PPM without making any changes.
6. Without having made any changes to the project in PPM, export the project to Microsoft Project.
Expected Results: The Task Priority is exported as its value from PPM, 972.
Actual Results: The Task Priority is exported as 1000.
DE38652: CA PPM 15.1. Patch 8 causes the Load Data Warehouse Job to fail on DWH_LKP_TRANSLATION if a language other than English is enabled (i.e. Spanish)
Steps to Reproduce:
1. Login to CA PPM 15.1.
2. Go to Administration > System Options > add the Spanish language to Data Warehouse. 
3. Save that change.
4. Run the Load Data Warehouse job - Full. 
5. Upgrade the system to 15.1.0.8
6. Run Load Data Warehouse - Full.
Expected Results: The job completes successfully, as it had prior to the upgrade.
Actual Results: The jobs fails with the below error message "[CA Clarity][Oracle JDBC Driver][Oracle] ORA-12899: value too large for column "PPM1510_DWH"."DWH_LKP_TRANSLATION"."TRANSLATION" (actual: 1428, maximum: 255)"
DE34900: Action in Gantt View doesn’t reflect checkbox selection
Steps to Reproduce:
1. Administration -> Jobs -> click on ‘New’ button to create a new job.
2. Fill in these fields (the below values are just examples):
Job Definition Name: m_ZZZ
Job Definition ID: m_zzz
Content Source: Customer
Description: xx
Active: Checked on
Executable Type: SQL Stored Procedure
Executable Name: m_zzz_job
Enable Log: Checked on
Enable Output: No
3. Go to the ‘Parameters’ tab and click on ‘New’ and fill in these fields:
Parameter Label: Task ID
Bind Parameter Code: task_id
Type: Text
Click on the ‘Save and Return’ button > click on ‘Return’
4. Go to ‘Administration’ -> ‘Objects’ -> ‘Task’ object -> ‘Actions’ tab -> click on ‘New’ button and fill in these fields:
Action Name: m_zzz_action
Action ID: m_action
Type: Job
Select job: m_ZZZ
Scope: Instance-specific
Click Save and Return.
5. Click on the ‘Views’ tab
6. Click on the ‘Actions Menu for ‘Task List’ > click on ‘General’ > move ‘m_zzz_action’ from ‘Available Actions’ column to ‘Selected Actions’ column > click on ‘Save And Return’ button -> click on ‘Return’ button
7. Again click on ‘[Actions Menu] for ‘Gantt’ > click on ‘General’ > move ‘m_zzz_action’ from ‘Available Actions’ column to ‘Selected Actions’ column > click on ‘Save And Return’ button -> click on ‘Return’ button
8. Home > Projects > select a project > ‘Tasks’ tab -> select some tasks > click on ‘Actions’ and select ‘m_zzz_action’
9. You will receive a message saying ‘ALERT Please confirm you want to run the job m_ZZZ’ > click on ‘Yes’
10. Then receive a message saying ‘m_ZZZ has been scheduled successfully. Click Yes to view the status of this job; click No to stay on the current page.’ > click on ‘Yes’
11. Then see the ‘Jobs: Scheduled Jobs’ popup screen 
12. Go to the ‘Gantt’ view > select some tasks including a sub task -> click on ‘Actions’ and select ‘m_zzz_action’
Expected Results: For the ‘Jobs: Scheduled Jobs’ popup screen to appear
Actual Results: An error is shown indicating ‘Unable to schedule the job please contact the administrator’
DE31694: Capacity vs. Demand by Resource Report highlights incorrect
Steps to Reproduce:
1. Configure the Data Warehouse 
2. Create a new resource with date of hire in 2016 and Resource OBS as Resource Pool\External
3. Create a project and a task both starting on Jan/1/2017 and finishing on Dec/31/2017
4. Add the resource to the project team and assign to the task
5. Configure Datamart and run Datamart jobs
6. Change ETCs for each month to be more than the resource availability. For example, if availability is 176 hours assign 180 ETC hours. Do it for all months except Jun 2017. Under-allocate the resource in June. (The order is important because the issue occurs in the 5th and 6th columns of the report.)
7. From the team tab check the resource and select the Allocate from estimates action
8. Navigate to the resource allocation detail and make sure the resource is over allocated for 12 months starting on Jan/2017, except Jun/2017. In Jun/2017 the resource should be under-allocated.
9. Run the Load Data Warehouse jobs
10. Navigate to Advanced Reporting
11. Run the report Capacity vs. Demand by Resource using the following filter options:
Resource: select the resource previously created
Start Date 2017-01-01
Type of Hours: Allocated
12. Run it again this time with Type of Hours= Assigned
Resource: select the resource previously created
Start Date 2017-01-01
Type of Hours: Assigned
Expected Results: The negative numbers in the Grand Total are highlighted in red, and the positive in green
Actual Results: The negative number is highlighted in green, and the positive in red
DE35921: Capacity vs. Demand by Role report doesn't show the unstaffed role when only one role is selected
Steps to Reproduce:
1. Create a new role with an availability of 7 hours
2. Allocate the new role to 2 or 3 projects as a team member, no assignments to tasks and keep the role unstaffed
3. Run the Load Data Warehouse - Full job. 
4. Run the Capacity vs. Demand by Role report filtering by the following:
a. Select the role previously created
b. Checked include Unstaffed roles, leave all other filter options as default
Expected Results: For the report to return data matching the role.
Actual Results: The message "No matching records found" is displayed instead.
--------------------------------------------
Issues Fixed in 15.1.0.9
--------------------------------------------
DE32412: Portlet Page Filter Results Set is Lost When Scrolling Through the Time-Scaled Value Grid With Left/Right Arrows
Steps to Reproduce:
1. Create a page filter portlet with a string attribute.
2. Create a Grid portlet using System Data Provider 'Team Allocations'. Add columns and also create an Allocation virtual (TSV) field.
3. In the PPM Home page > General page, create a tab and add the grid portlet created in Step 2.
4. Click to open the tab created in Step 3 and click on the 'Personalize' icon. Click on 'Page Filters' and add the page filter portlet created in Step 1.
5. Click on the toolbar icon and select 'Resource Manager' in the Mapping Field for the attribute created in Step 1 and then 'Save and Return'.
6 Click Save and Return to exit the tab content page
7. Configure the portlet created in Step 2 and populate various fields including the 'Resource Manager' field.
8. Use page filter to filter for resource manager. Data is filter as expected.
9. Use the arrow bar on the TSV section to scroll forward to another period and and return back to original period.
Expected Result: The filtered result set on the portlet to remain intact
Actual Result: The filtered result set on the portlet is lost and all data is displayed, even though page filter still has the filter for Resource Manager applied
DE28435: The Error 401 Unauthorized shows on the portfolio targets tab if a user with limited access rights tries to sync the portfolio
Steps to Reproduce:
1. Create a user with the following access rights:
Global: Portfolio - Navigate
Instance: Portfolio - Edit to a specific portfolio
2. Create a portfolio and assign the user above created as manager
3. This grants the user the Portfolio - Owner (Auto) access right
4. Logout and login as the user created
5. Navigate to portfolios. You can now see the portfolio where you are the manager
6. Edit the portfolio and go to the contents editor tab
7. Click Sync now and the portfolio gets synchronized
8. Go to the targets tab and click Sync now
Expected Result: The software synchronizes the portfolio.
Actual Result: The error message "Error 401 - Unauthorized. You are not authorized to view the page" occurs. However, the portfolio is still synchronized.
DE28433: Portfolio waterlines defaults to the system partition even if the portfolio belongs to a specific partition
Steps to Reproduce:
1. Create a partition if none are present. Otherwise, use any partition. 
2. Click Administration, Studio, Objects, and open the Portfolio object. Link it to the partition model from the previous step.
3. Note that the following object partition association has cascaded down: Portfolio Investment, Portfolio Investment Role Demand, Portfolio Plan
4. Go to Portfolio Investment views > Portfolio Waterlines list view.
5. Go to the partition view and add an attribute to the view.
6. Create a portfolio and choose a partition.
7. The portfolio is created on the right partition.
8. Go to the waterlines view.
Expected Result: To see the view as configured for the partition
Actual Result: The view defaults to the one configured for the system partition
DE31177: When a custom subobject is created for the Project object, after it is deleted and recreated, ODF-20000 error occurs
Steps to Reproduce:
1. Create a subobject under the Project object.
2. Create an attribute on the subobject.
3. Create an instance for the subobject.
4. Delete the subobject.
5. Try to create a sub object under the Project object again, with the same Object Name and Object ID.
Expected Result: The creation of the subobject, that has the same Object Name and Object ID as the previous one, succeeds.
Actual Result: The creation of the subobject fails with the error ODF-20000.
DE35454: In Microsoft Project, the Elapsed Duration is not retained after the project is saved
Steps to Reproduce:
1. Log in to CA PPM and create a project.
2. Create a task with a Start Date of May 1, 2017 and a Finish date of June 5, 2017.
3. Save the project and then open it in Microsoft Project.
4. Change the Duration from 27 days to 5 weeks.
5. Save the project back to CA PPM.
6. Insert a new column in the project view. Select the % Complete field and set it to 70%.
7. Save the project back to CA PPM and close Microsoft Project.
8. Open the project in Microsoft Project.
9. Re-insert the % Complete column and note the value.
Expected Result: The % Complete value is saved as 70%.
Actual Result: The % Complete value is no longer 70%, and subsequent roundtrips of the project schedule, without making any changes, reduces the % Complete even further. This behavior also occurs when an assignee is attached to the task.
DE37219: Summary Task Duration is incorrect in PPM after saving the project back from Microsoft Project
Steps to Reproduce:
1. Set the Base Calendar in PPM to 7 hours per day:
a. In PPM go to Administration > Base Calendars
b. Click on the Base calendar
c. Select the check boxes next to each of the work days (Mon, Tues, Wed, Thurs, Fri)
d. Click the Set Shifts button
e. Set the shifts as:
   Shift 1: 08:00 AM - 12:00 PM
   Shift 2: 01:00 PM - 4:00 PM
f. Click Save and Return
2. Create a new project in Microsoft Project
3. Create a Summary task with 2 sub tasks
a. Set up the tasks with the below dates
Summary Task:
Duration 10.71 days (In Microsoft Project, the default number of work hours per day are set to 7)
Start: 10/20/17
Finish: 11/2/17
Sub tasks:
Task 1
Duration 5 days
Start: 10/20/17
Finish: 10/26/17
Task 2
Duration 5 days
Start: 10/27/17
Finish: 11/2/17
Ensure there is a Start No Earlier constraint of 10/27/17
b. Task type for each of the tasks: Fixed Units
4. Save the project back to PPM (at this point, the issue occurs if your work hours are set to 7 hours in Microsoft Project, but if your work hours in Microsoft Project for the project are set to 8 hours, it will take an additional round trip through Microsoft Project for the issue to occur)
5. Go into the Gantt view in PPM and check the duration of the Summary Task
Expected Result: The duration of the Summary Task matches the value in Microsoft Project
Actual Result: The Duration in PPM for the Summary Task has changed. In the above example, it changed to 9 days
 
DE33575: In the Data Warehouse, multiple PPM_DWH views show as invalid objects in the Oracle database
Steps to Reproduce:
1. Connect to a PPM environment which uses Oracle as its database system and has an already configured Data Warehouse
2. Run the Load Data Warehouse Job
3. Now connect to the Oracle database as a system user
4. Run the following query (set the owner name to be the exact schema name):
select owner c1, object_type c3, object_name c2 from dba_objects where status != 'VALID' and owner like '%PPM_DWH%' order by owner, object_type, object_name
Expected Result: The objects are all valid objects
Actual Result: The objects are all invalid objects
DE35299: Inserting a new task on the Project Gantt page with more than 20 tasks or lines does not correctly position the line for the newly entered task
Steps to Reproduce
1. From the Home page, select a project with more than 20 tasks or lines
2. Open the Gantt chart for the project
4. Navigate to a task located somewhere in the middle of the list
3. Click on one of the cells, such as the task name, to make an edit
5. Click on another cell to make a second edit
Expected Result: The cursor keeps its current position so that the next change can be made
Actual Result: Cursor loses the position of the cell its currently in and the page is scrolled to the top of the list
DE32844: Page scrolls when trying to view the Gantt chart
Steps to Reproduce:
1. Find a project with several project-level tasks
2. Open the Gantt chart for the project
3. Scroll on the page until the scroll-bar on the right side of the page reaches a position in the middle of the bar
4. Select a task and change either the Start or Finish Date, then press Enter to save the change.
Expected result: The page should remain in the same position it was in when the change was entered
Actual result: The page view scrolls all the way to the top of the page, but the scroll-bar remains in that same middle position
DE33811: Jaspersoft content migration sets an incorrect theme
Steps to Reproduce:
1. Install Jaspersoft 6.2.1 and verify the default root level theme is set to
ca_ppm_tealgrey
.
2. Start a migration from Jaspersoft 5.6.1 or 6.1 to Jaspersoft 6.2.1.
3. Log into the Jaspersoft console and check the root level theme.
Expected Result: The content should be migrated with no change in the root level theme.
Actual Result: The content migration is successful, but root level theme is set to
ca_ppm_default
.
----------------------------
Issues Fixed in 15.1.0.8
----------------------------
DE29521: Notification that are generated after creating a Risk (with any category is selected) have blank values
Steps to Reproduce:
1. Login into CA PPM as an Administrator user.
2. Navigate to Home > Projects
3. Open any Project
4. Navigate to Risks/Issues/Changes tab
5. Click on the New button to create a new Risk
6. Enter all mandatory fields and select any value for the Category drop-down list 
7. Save the details.
8. Navigate to Home > General
9. Click on Risks in Notification portlet
10. View the Notification message
Expected Result: In the message, values should appear for each of the available fields.
Actual Result: In the message, blank values are instead shown for each of the available fields.
DE33331: CA PPM is not exporting Assignment Max % Load to Microsoft Project when Windows Regional Setting are set to the Portuguese language (New Driver)
Steps to Reproduce:
1. Go Administration > Project Management > Settings
2. Make sure the checkbox "MSP Assignment Units Mapping with PPM Assignment Max % Load'' is checked
3. Go to Home > Projects
4. Select any project
5. Create a task and assign any resource
6. Instead of 100%, set the Max % Load to 50%
7. Export to Microsoft Project
Expected Results: The Microsoft Project Interface receives the Max % Load in the project 
Actual Results: The Microsoft Project Interface does not receive the Max % Load in the project 
 
DE34026: Portfolio values are incorrect
Steps to Reproduce:
1. Navigate to the Home page > Portfolio Management > Portfolio and open a Portfolio 
2. Click on the Contents Editor and under the Individual Investments section, add a project and click on the Sync Now button 
3. Once that completes, click on the Investments tab to display the Investments portlet and note the Planned Cost, Budgeted Cost, and Actual Cost values
Expected Results: The Planned Cost, Budgeted Cost, and Actual Cost values should display same values as they did in Step 3 above.
Actual Results: The Planned Cost, Budgeted Cost, and Actual Cost values displayed are multiplied by 10.
DE35628: ETC/ETC Cost is reduced in Microsoft Project
Steps to Reproduce:
1. In PPM, create a rate matrix with a rate of $1 for all resources from 1/1/2016 to 2/31/2017
2. Create a project, open it for time, and set the Track Mode to None
3. Financially enable the project by setting the Financial Status to Open, and associate the project with the material rate matrix from Step 1
4. Add a material resource to the Team (ensure this resource's track mode is set to none)
5. Run the Rate Matrix Extraction job with the first 3 options checked
6. Export the project to Microsoft Project
7. Add % Complete, Remaining Cost, and Actual Cost to the view in Microsoft Project
8. Create a fixed unit task (that is auto scheduled) with a duration of 20 days
9. Assign the material resource to the task and change the units to 20,000, so that the cost is now 20,000
10. To change the units, double-click on the task and go to the Resources tab. In there, change the value under units for the resource to 20,000 and click OK
11. Save the project plan back to PPM and close out the project 
Note: If you continue to change the % Complete, the ETC will continue to be reduced. Once the ETC is 0 in PPM, the duration reduces, then after exporting the project to Microsoft Project with the 0 ETC, it changes the % Complete of the task to 100%.
12. Open the project in Microsoft Project and change the % Complete of the task to 50%, then save and close the project. At this point everything is correct if you view the task assignment details in PPM
13. Open the project in Microsoft Project, and change the % Complete of the task to 60%
Note: At this point, since the task is 60%, remaining cost has been correctly changed to 8,000 and actual cost has been changed to 12,000 in Microsoft Project
14. Save the project back to PPM and then navigate to the task to view the ETC at the task assignment level
Expected Results: The ETC has not changed from what is shown in PPM.
Actual Results: ETC is reduced which causes the ETC Cost to be reduced as well. In this example, the ETC Cost was reduced from $8,000 to $6,000, causing a difference of $2,000.
DE28868: Securability Fix
DE34742: The Actual Cost is incorrect on tasks that are assigned to material resources
Steps to Reproduce:
1. In PPM, create a rate matrix with a rate of $1 for all resources from 1/1/2016 to 12/31/2017
2. Create a project with dates of 1/1/2017 - 3/31/2017, set it open for time entry, and set the Track Mode to None
3. Financially enable the project and associate the project with the material rate matrix from Step 1
4. Add a material resource to the Team tab (ensure this resource's track mode is set to None)
5. Run the Rate Matrix Extraction job with the first 3 options checked
6. Export the project to Microsoft Project
7. Add the % Complete, Actual Work and Actual Cost to the view in Microsoft Project
8. Create a new task
9. Assign the material resource to the task with 60,000 Units
  a. Double-click on the task
  b. Go to the Resources tab
  c. Select the material resource under the Resource Name column
  d. Type 60,000 under units next to the resource
  e. Click OK
10. Mark the task as 100% Complete – here you'll see that the Actual Cost is increased to $60,000 while the Actual Work is 0
11. Save the project back to PPM
12. In PPM, navigate to the Tasks tab and click on the task created in Step 8 to view the Actual Cost for the material resource under the Assignments section
Expected Results: The Actual Cost should show as 60,000
Actual Results: The Actual cost has increased to 216,000,000 and appears to be multiplied by 3600. This is the same value shown in PPM for Actuals even though the task does not have any Actual Work in Microsoft Project
DE33055: The Time Compliance Detail Report does not allow to filter out inactive resources
Steps to Reproduce:
1. Create a new OBS Unit under Resource Pool/All Groups – for example, Compliance
2. Create two resources and add them to the Resource Pool/All Groups/Compliance and ensure both resources have their Track Mode set to PPM and are open for time entry
3. Mark one of the resources above to inactive
4. Configure the Data Warehouse and run the Load Data Warehouse jobs
5. Run the Time Compliance report with the following parameters:
OBS Type = Resource Pool
OBS Unit = All Groups/Compliance
Time Period = Previous Time Period
Leave all other filter options as their default
From here, the report should show 1 timesheet related to the active resource
What actually happens is that the report shows 2 timesheets, one for the active resource and one for the inactive resource
6. Click the OBS Unit Name to drill down to the Time Compliance Detail View
Expected Result: The report lists only the active resource.
Actual Result: The report lists both resources, the active and the inactive resource.
DE32719: MSP XML Driver changing posted non-labor actuals upon export
Steps to Reproduce:
1. Create a rate matrix with a rate of $1 for all resources for 1/1/2016 - 12/31/2017
2. Create a project with dates of 1/1/2017 - 3/31/2017
3. Financially enable the project, and associate the project with the material rate matrix from Step 1
4. Add a material resource to the team
5. Create a new task with dates of 1/1/2017 - 3/31/2017
6. Assign the material resource to the task
7. Give 90,000 of ETC to the Material Resource
8. Run the Rate Matrix Extraction job with the first three options checked
9. Go to Home > Transaction Entry > New > Voucher Other
10. Post a transaction for 5,000 with a date of 1/5/2017
11. Post to WIP
12. Run Import Financial Actuals Job
13. Check the task assignment and verify that 5,000 hours of actuals and a $5,000 actual cost are showing on the task
14. Export the project to Microsoft Project with the new driver
Expected Results: Microsoft Project shows 5,000 hours of actuals and a $5,000 actual cost for the material resource assignment.
Actual Results: Microsoft Project shows 1.39 hours (5000/3600) of actual hours. Since the actual hours are wrong, the actual cost also has a wrong value of $1.39.
DE32568: Process Start from the Action Menu results in a Error 401 - Unauthorized message
Steps to Reproduce:
1. Create a CA PPM resource from Administration > Resources
2. Provide the following access rights to this user
Instance Access right:
Process - Start
Process - Autostart
Global Access right:
Process - View all instances
Process - View all Definition
Project - Navigate
Project - Edit Management All
3. Create a basic On-Demand process on the Project object, with only one action. For example, updating the project description field with some text
4. Create an Action on the Project object, in order to run a process and associate the above process with the action
5. Add the above action to the Actions menu, available under the Project properties view
6. Login as the above user and navigate to a project
7. From the Action menu, run the process. At this point, a popup dialog box will appear
8. Click on the Yes button to view the status of the process
Expected Result: The initiated process page should appear, displaying the initiated process
Actual Result: The initiated process does not display and the following error message appears 
"Error 401 - Unauthorized. You are not authorized to view the page. If you are sure you have access, try logging in again or contact your system administrator"
DE33555: Load Data Warehouse Job intermittently deadlocks with itself and fails with error "Transaction (Process ID XXX) was deadlocked"
Steps to Reproduce:
  1. Create Multi-Value Lookup Attributes on any object (for example, Investment or Portfolios).
    1. Some of the MVL lookups should be not be localized. For example, "Manager" so that the "lookup key" and lookup value" columns get created in the DWH_INV_INVESTMENT dimension table.
    2. Some of the MVL lookups should be localized. For example, "Status" so that the "lookup key" column gets created in the DWH_INV_INVESTMENT dimension table and the "lookup value" column gets created in the DWH_INV_INVESTMENT_LN language extension table.
  2. Schedule the Load Data Warehouse - Incremental job to run on a regular basis.
Expected Result: The job always to complete successfully each time.
Actual Result: The job intermittently fails with error "[SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction".
----------------------------
Issues Fixed in 15.1.0.7
----------------------------
DE35165: Error Populating Timesheet with the 'Copy From Previous' Option in the New User Experience
Steps to Reproduce:
1. In the CA PPM New User Experience, open a timesheet.
2. Select Copy From Previous.
Expected Result: The application creates a new timesheet with task and time entries copied from the previous timesheet.
Actual Result: If there is a duplicate timesheet in the database, then they will receive the error  "Error encountered populating timesheets from PopulateCreatedTimesheetwithOptionOverides".
DE33379: Locale Settings are not the same in the Timesheets Section of the New User Experience
Steps to Reproduce:
1. Go to Account Settings.
2. Change the Locale to any locale which supports using commas as a separator character. For example, set the locale to Danish.
3. Logout.
4. Log back in.
5. Navigate to the New UX.
6. Click on Timesheets.
7. Create a timesheet.
8. Enter hours as 8,5
Expected Result: The hours remain as 8,5.
Actual Result: The hours change to 85.00.
DE34161: Staff Member Properties page now requires a resource manager to have the
Project - View Management - All
 global access right
Steps to Reproduce:
1. Create a Resource Manager with rights such as the following:
- Resource - Approve Ideas - All
- Resource - Create
- Resource - Document Manager
- Resource - Document Manager 
- Resource - Edit - All
- Resource - Edit Financial - All
- Resource - General - All
- Resource - Edit Ideas - All
- Resource - External Access
- Resource - Hard Book - All
- Resource - Navigate
- Resource - Soft Book - All
- Resource - Update Skills - All
- Resource - View - All
- Resource - View Book - All
- Resource - View Financial - All
- Resource - View Ideas - All
- Resource Management - Navigate
- Timesheets - Navigate
2. Set up a resource and make the resource manager from Step 1 the resource manager of this resource.
3. Create a project and add the resource from Step 2 to the Team .
4. Create a task in the project and assign the resource to the task
5. Login as the resource manager
6. Click on the Resources link
7. Click on the Resource Allocation icon for the resource in Step 2
8. Click on the Properties icon for the resource
Expected Result: You are shown the properties of the resource
Actual Result: You are unable to access the page and are shown "Error 401 - Unauthorized. You are not authorized to view the page. If you are
sure you have access, try logging in again or contact your system administrator"
DE29665: The status of an Action Item can be updated by both the resource assigned to it and the process initiator on the Collaboration Tab
Steps to Reproduce:
1. Create a user (in this example, resource A and resource B)
2. Create a process based on Project Object
3. Create an Action Item in the Start Step with 'Done' and put resource B under Assignees
4. Add the post condition in the Start Step (such that the number of assignees with a status of done are greater than 0 )
5. Validate and activate the process
6. With user A, create a project and then initiate the process created in Step 2
7. Go to Processes and click under the process ID. Make sure that it's notifying the user that you selected in Step 2
8. Go to the Collaboration Tab / Action Items
9. On the Status column, change the Action Item from Open to Done
10. Click on Save
11. Go back to Processes tab, and the process should be completed
Expected Result: The initiator should not be able to change the Status of the Action Item if they are not assigned to the step
Actual Result: The Initiator is able to change the Status of the Action Item
DE31441: Actions that reference internal links do not function in PPM 15.1
Steps to Reproduce:
1. Create a custom object and label it Custom Object.
2. Create a sub-object and label it Custom Sub-Object, set its Master Object to Custom Object (from Step 1).
3. Create a sub-object and label it Custom Sub-Object1, set its Master Object to Custom Sub-Object (from Step 2).
4. Create an attribute on the Team object and label it team_custom.
5. Create a link by navigating to the Team object > Linking tab and create a link:
    Give the link name and the ID a value of 'C'
     Set the action as Custom Sub-Object Custom Sub-Object1 List Link
     Set the internal ID to team_custom
6. Create an action from the Team > Action tab > Create a new action:
    Give the Action name and id values of link_team
    Set the Type to Internal Link
    Set the Link to team_link
7. Navigate to the Team object and select Actions > Properties of the view - Resource Allocation Detail and add the action created in Step 6.
8. From the column layout of the Team object > Resource Allocations - Detail, add the team_custom attribute.
9. From the Custom Object page, create data for the Custom Object, Custom Sub-Object, and Custom Sub-Object1 pages
    For example, Custom Object: Project 1 and Project 2
    From Project 1,  create custom sub-objects > team_11 and team_12 > create sub-object1 > task_11 and task_12
    From Project 2> create custom sub-objects > team_21 and team_22> create sub-object1 > task_21 and task_22
10. Open up the Custom Object Project 1 and Project 2, note the parent ID's from the URLs (i.e. 5000000 and 5000002)
11. Now find a resource with 2 or more allocations. Go to the Allocations tab and from the Allocation pull down menu, open the Details page
     Enter the values in 5000000 and 5000003 against any two allocations
12. Make the team_custom column linkable, go to the Configure button on the Resource Allocations portlet > List Column Section > Fields > choose team_custom> from the Link menu assign it to the link team_link created in Step 5
13. Choose any allocation for the values 5000000 and 5000002 (from Step 10). Click the action link_team from the Actions Menu.
Expected Result: The custom object list page opens and displays the respective custom sub-objects (from Step 9 in this example)
Actual Result: The custom object list page appears blank and does not load the respective sub=objects
DE32471: Pages do not display correctly for the Cost Plan List Pages
Steps to Reproduce:
1. Create a financially active project that is associated with a financial entity (or use an existing one).
2. Navigate to the Financial Plans tab.
3. Click on 'New Manual Plan' to create a Cost Plan.
4. Navigate back to the Cost Plans list, select the previous plan and use the Actions menu to select 'Copy Cost Plan' to create a duplicate (give it a unique ID).
5. Repeat Step 4 until you have at least 12 Cost Plans (I tested with 22 but 12 should work).
6. Click on the Settings icon for the portlet > List Column Section > Options > set the Rows Per Page value to 10.
Expected Results: To see the first 10 rows of Cost Plans listed, then navigation arrows to navigate to the next set of 10, and for the bottom right indicator to show "Displaying 1 - 10 of 12", or however many total Cost Plans are in this project.
Actual Results: Only the first 10 rows of Cost Plans are shown, no navigation arrows exist to navigate forward to the next set of 10, and the bottom right indicator shows "Displaying 1 - 10 of 10" instead of "Displaying 1 - 10 of 12" which is the correct amount.
DE33956: Sections expand on some views after clicking the Save button
Steps to Reproduce:
1. Go to the Task List of a Project and open a Task.
2. Collapse the sections except for Assignments section.
3. Make changes in the Assignments section and Save
Expected Results: The changes are saved successfully and the sections are collapsed.
Actual Results: All sections expand after the save and it is not possible to close them again.
DE32783: The Timesheet Detail Report displays incorrect totals values
Steps to Reproduce:
1. Navigate to the PPM Classic UI
2. Create a Timesheet.
3. Add several tasks and enter hours for those tasks.
4. Add Other Work Items and enter hours.
5. Approve the timesheets and run the Post Timesheets Job to have them posted.
6. Run the Load Data Warehouse - Full Job.
7. In Advanced Reporting, run the Timesheet Detail Report.
8. Select the OBS information for the resource and select the correct timesheet period.
Expected Result: Total hours match the timesheet and the detailed hours on the report.
Actual Result: The report shows incorrect hours. The total appears to be the Other Work hours and only the last line of the task group. 
DE32782: Timesheet Detail Report displays incorrect daily values
Steps to Reproduce:
1. Navigate to the PPM Classic UI
2. Enable Timesheet Notes
3. Enable Note Dates
4. Create a timesheet add 1 task
    Add 7 hours to Monday and 7 hours to Tuesday
    Add 2 notes on the same Task (not at the timesheet level) using the same Note Category and the same Note. Use the same Monday and Tuesday dates for the notes.
    For example, set the Category to Note and the Note Text to "note1" and one line for Other Work as well.
5. Approve the timesheets and run the Post Timesheets Job to have them posted
6. Run the Load Data Warehouse - Full Job
7. In Advanced Reporting, run the Timesheet Detail Report
    Select the OBS information for the resource and select the correct timesheet period.
Expected Result: The report shows 7 hours on Monday and 7 hours on Tuesday
Actual Result: The report shows 14 hours on Monday and 14 hours on Tuesday
DE32126: Issues in the Resource Time Review by Manager report
Steps to Reproduce:
1. Go to Administration > Time Reporting Periods and set the time periods to start in different intervals. For example, one to start on a Wednesday, another one to start on a Sunday, like the below
     6/1/16 - 6/4/16
     6/5/16 - 6/11/16
2. Create a new project
3. Add one team member to the project on the Team tab
4. Ensure the project, resource, team member, and task are all open for time entry, and the track mode of the project and resource is set to PPM
5. Create a task with a Start Date of 6/1/16 and Finish Date of 6/30/16 and assign the resource in Step 3 to the task
6. Go to Home > Timesheets and filter for all open timesheets for the resource assigned to the task in Step 5. For both the time periods of 6/1/16 - 6/4/16 and 6/5/16 - 6/11/16, compare the differences
     a. Click the Timesheet icon next to the 6/1/16 - 6/4/16 Timesheet
     b. Click on Add Task, select the task created above and click Add to add the task to the Timesheet
     c. Enter 4 hours for 6/1, 8 hours for 6/3
     d. Submit the timesheet for approval and then Approve it
     e. Click the timesheet icon next to the 6/5/16 - 6/11/16 Timesheet
     f. Click Add Task and select the task created in Step 5. For 6/6, enter 6 hours, and for 6/9/16, enter 9 hours
     g. Submit the timesheet for approval, then approve it
7. Wait 5 minutes, then run the Post Timesheets job. Once the job completes, check to make sure actuals are posted at the task level
8. Run the Load Data Warehouse job in incremental mode and Load Data Warehouse Access Rights job
9. In PPM go to Home > Advanced Reporting and search for the Resource Time Review by Manager Report
10.Under Options:
     a. Select the Populate Resource checkbox and select the resource that time was submitted for above.
     b. Under Time Period, select the following:
     6/1/2016 - 6/4/2016 and 6/5/2016- 6/11/2016
     c. For Timesheet Status, make sure Posted is selected
     d. Click Apply to generate the report data
Expected Result: Hours displayed in the report match what was submitted on the timesheet (For the 6/4/16 row: 4 hours show for Wednesday, and 8 hours show for Friday. For the 6/11/16 row: 6 hours show for Monday and 9 hours show for Thursday)
Actual Result: Hours displayed for the 6/4/16 row are in the wrong days. 4 hours show on Sunday instead of Wednesday and 8 hours show for Tuesday instead of Friday
 
----------------------------
Issues Fixed in 15.1.0.6
----------------------------
The 15.1.0.6 patch introduced support for Oracle 12c R2 databases. See the CA PPM 15.3 Change, Impact, and Upgrade 
Known Issues
 for details about a possible performance issue and recommended workaround.
DE33790: MSP New Driver: Task Durations are incorrect if the PPM Base Calendar is not set to 8 hour days | TEC1518734
Steps to Reproduce:
1. Launch Microsoft Project by itself, close all opened projects including "Project 1", then go to Options > Schedule > set hours per day to 7 hours and hours per week to 35. Close MSP
2. Set the PPM Base calendar to 7.5 hours per day:
     a. Log in to CA PPM > Administration > Project Management > Base Calendars > locate the site calendar marked as "Base calendar"
     b. Go to "Edit Calendar Exception" tab
     c. Select all weekdays by clicking on the checkbox on the weekday columns: Mon, Tue, Wed, Thu, Fri
     d. Click 'Set Shifts'
     e. Change the shifts so that there are 7 hours for a day. For instance, set the first shift to start from 8:30 AM instead of 8 AM
     f. Save and Return
3. Create a project in PPM
4. Create a one day task on the project
5. Open the project in MSP
Expected Result: Task has a 1 day duration matching PPM
Actual Result: Task has a duration of 1.07, finishing at 9AM the following day
DE32353: Issue with 'Accept Pending ETC for the selected task' in Open Workbench
Steps to Reproduce:
1. Create a project with a schedule from 13/02/17 to 13/06/2017 (dates are not important)
2. Add a team member
3. Create two tasks 'A' and 'B' and assign the same resource to both
4. Open a timesheet for that resource and add the two tasks above
5. Add some actuals to both tasks
6. Modify the total ETC so the box is yellow (meaning there is pending ETC)
7. Open the project in OWB > Project tab > Select task A and on the Pending Estimates option, click on Accept Pending ETC for the selected task
8. Save and close OWB
9. Look at task A in PPM
Expected Result: The Pending ETC figure to be accepted at timesheet level as well as at task level
Actual Result: When looking at the task in PPM, the Pending ETC (Proposed ETC) is still there. If you check the timesheet itself, the Pending ETC figure is still there as well. On the Pending Estimates Review portlet, this task does not appear
DE29606: Since PPM 14.4, clicking on the Browse icon of departments on a new project or NPIO instance requires administration rights | TEC1021783
Steps to Reproduce:
1. Install/upgrade to PPM 14.4
2. Give your 'admin' user the access right'Financial Maintenance - Financial Organizational Structure'
3. Create another user ('PM') with only the access right to create new projects
4. Create an entity and some basic department/location data 
5. Logout from admin
6. Log back in as admin (necessary to flush global permissions for the session)
7. Navigate to Projects and create a new project
8. Find the Department OBS field and click on the browse icon
9. Close the OBS browse window after confirming it displays as expected.
10. Logout as admin and login as the other user ('PM')
11. Navigate to and create a new project
12. Find the Department OBS field and click on the browse icon
Expected Result: The OBS Browse window popup should show without error
Actual Result: The OBS Browse window pops up and immediately displays a '401 Not Authorized' error message
DE29610: If an aggregation row is present on a list view, when on a page greater than 1, the save of any edit returns you to Page 1
Steps to Reproduce 1:
1. On a system that has more than one page of projects create an aggregation row on the project list page
2. Navigate to any page past the first page (for example, page 2), edit a row and save
Steps to Reproduce 2:
1. Go to a Project with many Team members
2. Go to the Team - Staff page
3. Go to any page past the first page (for example, page 2)
4. Make an edit in the grid to a resource on that page (update a field such as the start, finish, etc.)
5. Click Save
Expected Results: After completing the save, you remain on that page
Actual Results: After completing the save, you are redirected to page 1
DE32651: XOG of a resource to an NPIO takes a large amount of time to complete
Steps to Reproduce:
1. Create an example resource from the Home > Resources
2. Go to a project or NPIO that has 7500 resources
3. Add the created resource from Step 1 to the team
4. This will complete in less than 5 seconds
5. Remove the created resource from the team
    This will complete in less than 5 seconds.
6. XOG in 1 team resource record to the NPIO or project
Expected Result: XOG should take reasonable amount of time to complete
Actual Result: XOG takes over 30 minutes to complete for this 1 resource
DE29587: Default values are not populated in filter portlet fields when persist checkbox is enabled on more than one tab
1. Navigate to Administration > Portlets and create a new Grid portlet with instance type 'General' and Data provider 'Project'
2. In the List column layout select the following: Investment ID, Investment type, Manager, Status, Track mode
3. Save the portlet
4. Create another Grid portlet with instance type 'General' and Data provider 'Investment'
5. Select same columns same as in Step 2
6. Create one more Grid Portlet with instance type 'General' and Data provider 'Project'
7. Select same columns same as in Step 2
8. Create a New Filter portlet with instance type 'General'
9. Add fields like 'Track mode, Manager, Name, Status, Investment Type' values that have a display type of 'Pull down' and provide a  filter default value 
Track mode - Lookup name is "prTrackMode"
Manager - Lookup name is Browse Resource
Status- Lookup name is Investment Object State
Type - Lookup name is Investment Types
10. Create a portlet page with tabs, then create Tab1  and add the first grid portlet
11. Navigate to the page filters and add the filter portlet created in Step 8 
12. Select the 'Persist' option 
13. Click on Filter Mappings and only map 2 fields. (for example Track Mode and Manager)
14. Create Tab 2 and add the second grid portlet 
15. Navigate to the page filters and add the filter portlet created in Step 8 
16. Select the 'Persist' option 
17. Click on Filter Mappings and only map 2 fields. (for example Track Mode and Manager)
18. Create Tab 3 and add the third grid portlet 
19. Navigate to the page filters and add the filter portlet created in Step 8 
20. Do not select the 'Persist' option 
21. Click on Filter Mappings and only map 2 fields (for example Track Mode and Manager)
22. Change the Layout for all tabs by moving the filter portlet upward 
23. Navigate to the Menu Manager > Application menu and click on Add page link
24. Map the Portlet page created in Step 10 
25. Navigate to portlet page from the Home menu
26. Click on Tab 1, verify the filter fields, and verify the list displayed as per the filters applied 
27. Click on Tab 3, verify the filter fields, and verify the list displayed is correct
28. Now navigate to Tabs and verify the default filters displayed
Expected Results: Filter fields should populate with default values
Actual Results: Filter fields populated with the first value in dropdown list
DE32407: Inserting a new task from the Gantt page into a project with more than 20 tasks or lines does not position the line for the new entry box
1. Login to the application
2. Open a project with more than 20 tasks and go to the Gantt page
3. Select the last task in the page and click on Insert key to add a new task
Expected Result: Task insert should position cursor on the entry box
Actual Result: The system moves to the top of Gantt and the new entry box does not appear
DE32441: New UI: Timesheets issues
Steps to Reproduce:
1. Go to the classic UI and create a time period for a week with 3 days (Wednesday, Thursday and Friday)
1. Create a time period for Feb -24-2017 to Feb-27-2014
2. Make sure the newly created time period is open for time entry
2. Go to the new UI and login as any user who has time entry access rights
3. From the 'Menu' icon select 'Timesheets'
4. Select the newly created time period
1. If there are no tasks in the selected time period, add a few tasks
2. Enter time for the newly created tasks and submit
5. Now logout from that user and login as the administrator, or any other user who has rights to approve time sheet
6. Go to Review and Approve Tab
7. From the filters select All
8. Click on the team member that submitted time entry
9. A popup window will open with two tabs – Timesheet and Notes
10. Navigate to the Timesheet tab
Expected Result: The Timesheet tab should show all the tasks with the total number of hours entered for that time period
Actual Result: The Timesheet tab is empty
DE32458: Capacity vs Demand by Role report is missing the Demand label on the results when exported to Excel
Steps to Reproduce:
1. Go to Home > Advanced Reporting
2. Run the ‘Capacity vs. Demand by Role’ report with the Type of Hours filter option as "Allocated"
3. Click on the Export Icon at the top of the report results, select either of the following four options: As Excel, As Excel (Paginated), As XLSX, As XLSX (Paginated)
4 Run the ‘Capacity vs. Demand by Role’ report with the Type of Hours filter option as "Assigned"
5. Click on the Export Icon at the top of the report results, select either of the following four options: As Excel, As Excel (Paginated), As XLSX, As XLSX (Paginated)
Expected Result: On the excel file, you see the ‘Demand’ label for every role (between the Capacity and Remaining Capacity labels)
Actual Result: On the excel file, the ‘Demand’ label is missing
DE29593: Cannot Delete Attachments for a Custom Object Where the User has Sufficient Create, Edit All, and Navigate Global Access Rights
Steps to Reproduce:
1. Create a custom object with an attachment attribute.
2. Create an instance for this custom object. Add an attachment.
3. Add the Create, Edit All and Navigate global access rights for this custom object to a user.
4. Log in as the user and navigate to the instance.
5. Attempt to delete the attachment in the instance.
Expected Result: The user can delete the attached file.
Actual Result: The user cannot delete the attached file and receives the following error:
Error 401 - Unauthorized. You are not authorized to view the page...
 
DE28835: Time Zones Are Missing from the TimeZoneConstants.properties file
Steps to Reproduce:
1) Setup a PPM server with time zone set to US/Pacific
2) Install PPM 14.4
3) Enable the new UI
4) Log in to the New UI
5) Log in to the classic PPM UI - the server timezone reverts to a default time zone setting.
It is unknown what side-effects this will cause for the end user as the record in PPM includes a time zone setting. Users cannot login into the classic UI because of this.
Expected Result: The new UI allows users to login with the correct server timezone
Actual Result: The new UI login screen throws an error message and the user cannot log in
DE33976: NEW UX UTC TIMEZONE - Unable to log in to the new UI after upgrading to PPM 15.1
Steps to Reproduce
1. Upgrade to 15.1 from 14.2
2. Have the server data time set to GMT
3. Ensure all the prerequisites are met for new UI to work
4. Navigate to the URL to access the CA PPM 15.1 new UIpm5. Provide the user name and password through which you are able to log in to old UI
Expected Results: User should be able to log in to the new UI
Actual Results: User is getting an error when logging into the new UI
DE30494: Emails are not being sent from the Process "Notifications" sections
Steps to Reproduce:
1. Connect the PPM Application Server to a Mail Server
2. Create a Process
a. On the "Start" step, under the "Notifications" section, check all the attributes, and enter a name
b. Make sure to connect the "Start" step to the "Finish" step
3. Trigger the Process
Note 1: The above steps are to reproduce whether emails are triggered or not from "Notifications" sections. Action Items will still send emails and it is not the objective of this bug. Emails are also sent from Gel Scripts.
Note 2: The number of "Process Steps" do not matter. All "Notifications" sections exhibit this behavior. The steps are where the "Notifications" section is easily accessible. "Notifications" sections on Action Items can also be used.
Note 3: Notifications must be enabled to send Emails, under "Account Settings".
Expected Result: An email is received when the Process enters and goes out of the Start Step
Actual Result: No email is received
----------------------------
Issues Fixed in 15.1.0.5
----------------------------
DE33307: Only one predecessor task is downloaded from CA PPM to Microsoft Project
Steps to Reproduce:
To reproduce this problem, you must have installed the MSP new driver and have MSP 2010 or 2013 in the Portuguese Language.
1. Go to Home > Projects.
2. Choose a project that has dependencies on its tasks.
3. Export the project to MSP.
Expected Result: All of the predecessor and successor relationships are exported to Microsoft Project.
Actual Result: Not all of the dependencies are exported to Microsoft Project.
DE32192: Duplicated notifications after rejection of a resource requisition
Steps to Reproduce:
1. Go to 'Home' -> 'Projects' -> select a project
2. Click on 'Team' tab -> select 'Staff'
3. Create a resource (for example, 'TEST TM 1, Petr')
4. Go to 'Actions' at the top right corner and select 'Create Requisitions'
5. Select 'Request Resources' for 'Requisition Type'
6. Change the Booking Manager from one resource (for example, 'TEST RM 3, Eduard') to another (in this example, 'TEST RM 1, Barbora') then -> Click on 'Create and Open' button
7. Log out of PPM and log in as the new booking manager (here it would be 'TEST_RM1')
8. Go to 'Home' and select 'Resource: Requisitions' page
9. Select a requisition (i.e. 'TEST TM 5, Zan') and click on 'Reject' button -> the Status for that requisition changes from 'Open' to 'Rejected'
10. Go to requisition 'TEST TM 1, Petr' and changed 'Status' from 'Open' to 'Rejected' -> click 'Save And Return'
Expected Result: To receive one email for each person.
Actual Result: Received one notification for Petr and two notifications for Zan.
DE31529: Securability Fix
DE33275: Securability Fix
DE33237: Securability Fix
DE33311: Securability Fix
DE32333: Associating a portfolio page tab with resource/group/obs access granted results in inability to access the portfolio when using the Default Tab action from the portfolio list page
Steps to Reproduce:
1. Create a custom tab for a new Portfolio page.
2. On the tab, assign access to the tab to a resource, group or obs. This is done on the 'Access to this Tab' tab. Select 'Page - view' and then the item being granted access. (Note: any of the available rights should cause the same problem)
3. Assign this tab as the default tab for the page
4. Go to a portfolio and assign this new page layout as the one to use for the portfolio
5. The server may need to be restarted due to caching
Expected Result: For the right check to be correct and access to the tab granted accordingly
Actual Result: Even with full access to the tab it cannot be accessed and a 401 error is encountered on screen. No errors are seen in the logs. On screen error:
'Error 401 - Unauthorized. You are not authorized to view the page. If you are sure you have access, try logging in again or contact your system administrator'
DE33080: Not able to add/book any resource from the team tab of a project
Steps to Reproduce:
---- Project Manager-----
1. Login as Admin
2. Create a Resource as "Project Manager" who has the below access rights
Instance Level: All project access rights, Resource - Hard Book, Resource - Soft Book
Global: Project - Navigate
3. Login as the Project Manager
4. Navigate to any one of the available projects
5. From the opened project, navigate to Team tab
6. Try to add resources by using the "Add" button
---- Resource Manager-----
1. Login as Admin
2. Create a Resource as "Resource Manager" who has below access rights
Instance Level: Resource - Hard Book, Resource - Soft Book
Global: Project - Navigate, Project - Edit Management - All
3. Login as the Resource Manager
4. Navigate to any one of the available projects
5. From the opened project, navigate to Team tab
6. Try to add resources by using the "Add" button
Expected Result: The resource list should come up for selection
Actual Result: Error 401 - Unauthorized. You are not authorized to view the page. If you are sure you have access, try logging in again or contact your system administrator.
 
DE32327: Team Availability Start and Finish dates are no longer blank after two roundtrips with MSP using New Driver
Steps to Reproduce:
1. Create a 1 day duration project
2. Add a new resource to the team with 0% default allocation. Start and Finish dates appear blank when clicking in the "Staff Member Properties" (The Team tab will display Investment Start and Finish dates instead in the grid)
3. Open the project in MSP, create 4 tasks, 10 days each, cascaded (1->2->3->4)
4. Assign the resource (It will appear as over-allocated)
5. Save to PPM
6. In PPM, go to Team, select the resource and then Actions > Allocate from Estimates. 80h ETC will now match 80h Allocation (The Start Date and Finish Date are still empty in the "Staff Member Properties")
7. Assign the resource to tasks 2, 3 and 4
8. Save to PPM
9. Go to Team tab, open Staff Member Properties
Expected Result: Start and Finish dates are still blank (as this is the result observed in PPM 13.3 and PPM 15.1 with the legacy driver)
Actual Result: Start and Finish dates are no longer blank, and both show the start/finish dates of Task 1
DE32167: Clicking on New button on Task list page displays the properties page of a previously opened task | TEC1223655
Steps to Reproduce:
1. Log in to 
CA PPM
.
2. In the classic user interface, open a project. 
3. Add at least one resource to the Team tab.
4. Create a new task and assign the resource to the task.
5. Scroll down to the Assignments section, and click the '<' or '>' buttons in the ETC BY Period section (Time Scaled Value section)
6. Click Return to leave the current task.
7. Click 'New' to create a new task.
Expected Result: The create task view is shown to create a new task
Actual Result: A pre-existing task's details are displayed.
DE32194: Empty notifications when a project manager uses "Create and open" resource requisition
Steps to Reproduce:
1. Click
Home
,
Projects
and open a project.
2. Click the
Team
tab and select
Staff
.
3. Select a resource.
4. Go to 'Actions' at the top right corner and select 'Create Requisitions'
5. Select 'Request Resources' for 'Requisition Type' -> Click on 'Create and Open' button
Expected Result: To receive an email notification that is populated with content
Actual Result: Received a blank email saying it prepared the request for the allocation of resource and waiting for a decision
The requested resource:
No. requirements:
Project title:
Request prepared:
Required start date:
Required completion date:
 
DE32794: Rally synchronization job passed successfully even after agile integration owner status is deactivated
Steps to Reproduce:
1. Log in to CA PPM and ensure Agile addin and Integration setup with rally is present
2. Create a user with the following global rights:
API -Access
Project - Edit Management - All
Resource - Hard Book - All
Resource - Navigate
Resource - View - All
3. Navigate to Administration -> Project Management-> Settings.
4. Select the above created user as a 'Agile Integration owner'
5. Now Navigate to Administration-> resources and mark the above user as inactive
6. Go to Home-> jobs and run the 'Rally synchronization' job
7. Observe that the job completes successfully, which is not expected
Expected Result: Rally synchronization job should fail as 'Agile Integration owner' is in an inactive state
Actual Result: Rally synchronization job completes even after deactivating the agile integration owner, which should not be occurring
DE32807: Rally Synchronization job fails when portfolio item types include spaces in their names
Steps to Reproduce:
1. As an Agile Central Administrator, navigate to a workspace/project and change a portfolio item type to include spaces. For example, instead of "Feature", change it to "PPM Feature"
2. Create an integration record mapping the "PPM Feature" item
3. Create a dummy project and mark it to be synchronized. Link the Agile System to the project
4. Run the Rally Synchronization job
Expected Result: The Rally Synchronization job runs and creates the project as an initiative in Agile Central
Actual Result: The Rally Synchronization job fails because of the space. The workaround is to remove the space from the title
DE32860: Proxy Server support for Agile Central Integration
Steps to Reproduce:
1. Log in to CA PPM and try to configure a proxy in Integration
Expected Result: There is an option to configure a proxy
Actual Result: There is no option to configure a proxy
DE31898: Autoschedule does not complete for some projects
Steps to reproduce:
1. Remove any non- working days from the Standard Calendar for the months of Dec2016-Jan2017 (leave the shifts the way they are to make up 8 hour days)
2. Create a US Calendar, using the Standard Calendar as the Base Calendar
3. On the US Calendar, mark only 12/26/2016 and 12/27/2016 as non-workdays
4. Create 2 resources to use the US Calendar
Jane Doe
John Smith
5. Create a project with the following dates: 12/6/2016 - 1/10/2017
6. Add the above 2 resources to the team. Jane allocated 100% and John allocated 50%
7. Create the following 15 tasks: (All of the assignments are Uniform)
Summary1 (12/6/2016-12/15/2016)
--Task1.1 (12/6/2016-12/15/2016) – Fixed Duration – Assign Jane (64 ETC)
--Task1.2 (12/6/2016-12/8/2016) – Fixed Duration – Assign Jane (24 ETC) and John (12 ETC)
--Task1.3 (12/6/2016-12/7/2016) – Fixed Duration – Assign Jane (16 ETC)
Summary 2 (12/6/2016-12/19/2016)
--Task2.1 (12/6/2016-12/19/2016) – Fixed Duration – Assign Jane (80 ETC)
--Task2.2 (12/6/2016-12/8/2016) – Fixed Duration – Assign Jane (24 ETC)
--Task2.3 (12/6/2016-12/7/2016) – Fixed Duration – Assign Jane (16 ETC)
--Task2.4 (12/6/2016-12/6/2016)
--Summary2.5 (12/6/2016-12/19/2016)
----Task2.5.1 (12/6/2016-12/12/2016) – Fixed Duration – Assign Jane (40ETC) and John (20ETC)
----Task2.5.2 (12/6/2016-12/19/2016) – Fixed Duration – Assign John (40 ETC)
----Task2.5.3 (12/6/2016-12/9/2016) – Fixed Duration – Assign Jane (32ETC) and John (16ETC)
----Task2.5.4 (12/6/2016-12/6/2016) – Fixed Duration - Assign John (4 ETC)
----Task2.5.5 (12/6/2016-12/9/2016) – Fixed Duration – Assign John (16 ETC)
8. Add the following dependencies, all with 0 day lag:
Task1.1 PREDECESSOR of Task1.2
Task1.2 PREDECESSOR of Task1.3
Task2.1 PREDECESSOR of Task2.2
Task2.2 PREDECESSOR of Task2.3
Task2.4 PREDECESSOR of Task2.5.1
Task2.5.1 PREDECESSOR of Task2.5.2
Task2.5.2 PREDECESSOR of Task2.5.3
Task2.5.3 PREDECESSOR of Task2.5.4
Task2.5.4 PREDECESSOR of Task2.5.5
9. From either the Gantt or Home > Jobs, Autoschedule the project (with options)
Autoschedule Date: 12/6/2016
Resource Constraints: Checked
Everything else is either left blank or unchecked
Expected Result: The project is autoscheduled and task dates change to meet the dependencies and resource constraints
Actual Result: Either Autoschedule is stuck processing until it is manually cancelled or Autoschedule almost immediately shows as completed (the words [Tentative Schedule] show at the top of the Gantt page), but no changes were done to the project dates
----------------------------
Issues Fixed in 15.1.0.4
----------------------------
CLRT-81758: Securability Fix
CLRT-81759: Securability Fix
CLRT-81416: Securability Fix
CLRT-81720: Securability Fix
CLRT-81296: Securability Fix
CLRT-81379: Securability Fix
CLRT-81380: Securability Fix
CLRT-81415: Securability Fix
CLRT-81123: "Value is too large" error displayed when trying to save changes at the staff member properties view, if the resource manager field is visible and the full name contains more than 32 characters
Steps to reproduce:
1. Go to Home > Resource Management > Resources
2. Create a resource with
first name: qwertyuiopqwertyuiopqwertyuiopqw (32 characters. Maximum allowed)
last name: qwertyuiopqwertyuiopqwertyuiopqw (32 characters. Maximum allowed)
3. Edit any other existing resource (let say resource called Jose) and add the above created resource as Res0urce Manager
4. Create a project or edit an existing one and add Jose to the team tab
5. Go to studio > team object > views > Staff Member Properties view and add the Resource Manager field to be displayed
6. Edit the team member properties of Jose on the project team
7. You now see the full name of the resource manager as: qwertyuiopqwertyuiopqwertyuiopqw, qwertyuiopqwertyuiopqwertyuiopqw
8. Make a change on the page and save
Expected Result: Changes to be saved
Actual Result: Error is received: "Value is too large". Changes are not saved
CLRT-81011: Load Data Warehouse job fails with database lock ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Steps to Reproduce:
1. Schedule an Incremental Load Data Warehouse job a few times per day
2. Check the job status in the Jobs - Log page
Expected Result: The job to complete successfully every time
Actual Result: The Load Data Warehouse job fails intermittently (sometimes once per month) with error ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. Any Full or Incremental Load after this will also fail until the lock is removed
CLRT-81589: Restore Domains as a PPM job
CLRT-81736: Provide an option to monitor Application Health
CLRT-81737: Provide an option to perform an analysis on the nature of all customizations in a customer environment
CLRT-80614: CA PPM is not exporting dependencies to MSP predecessors column when is setting to Spanish language (New Driver)
Steps to Reproduce:
To reproduce this problem you must have installed the MSP new driver and have MSP 2010 or 2013 in Spanish Language.
1. In PPM, go to Home > Projects
2. Create a new project with at least three tasks
3. Setup a task dependency of 'Finish-Start' and then one task dependency relationship of 'Finish-Finish'
4. Export the project to MSP
Expected Result: MSP shows dependencies in Predecessors column. (In Spanish, it is called Predecesoras.)
Actual Result: MSP only shows 'Finish-Finish' dependencies in Predecessors (Predecesoras) column; all others are missing.
CLRT-81658: Resource termination date cannot be removed via XOG
Steps to Reproduce:
1. Go to Home > Resources and create a new Labor resource
2. Set a termination date (e.g.: 12/31/2016)
3. Export using XOG a resource that has a termination date. "rsm_resources_read.xml" template can be used
4. Modify the terminationDate="2016-12-31" attribute to terminationDate="null"
5. Import the modified resource using XOG.
Expected Results: The termination date is removed
Actual Results: XOG returns FATAL Error - This record has not been inserted. java.text.ParseException: Unparseable date: "null" [...]. // The termination date stays unmodified
CLRT-81083: 'Financial Budget vs. Forecast by Period Detail' report only returns data for Project Investments
Steps to Reproduce:
1. Create an Financially enabled Idea (1/1/2017-12/31/2017)
2. Add a Financially enabled Resource to the team (100% allocated)
3. Go to the Financial Plans tab > Cost Plans > Actions > New from Investment Team > Fill in the required information to create a new cost plan (Monthly, Grouped by Resource)
4. Complete Steps 1-3, but with a project, instead of an Idea, with a different Financially enabled Resource
5. Run the Load Data Warehouse Job
6. Go to Home > Advanced Reporting > Library
7. Run the 'Financial Budget vs. Forecast by Period Detail' report, for the Investments select both the Idea and Project created in Step 1 and 4
8. Also, run the 'Financial Budget vs. Forecast by Period' report with Financial Plan Group By 1 as Resource
Expected Result: The Idea and the Project are both included in the report results. Both resources are included in the parent report
Actual Result: Only the Project is included in the report results. Only one resource is included in the parent report
CLRT-81445: Project Storyboard Report shows Equipment Actual Qty in Labor Hours
Steps to Reproduce:
1. Use a financially enabled project
2. Add 3 separate resource types (Labor, Material, Equipment)
3. Make sure each resource is financially enabled
4. Create 3 separate tasks, one for each type resource
5. Assign resources to their respective tasks
6. Create 3 financial transactions - 1 for each resource type
- If no rate matrix is associated, add costs for each transaction
7. Post to WIP
8. Run the Import Financial Actuals job
9. Run the Load Data Warehouse job
10. Run Project Storyboard report for your project
Expected Result: Only Labor hours show on the top of the report
Actual Result: Labor and Equipment type Resource hours show on the report
CLRT-80333: Capacity vs Allocation by OBS - Demand does not match the data in Capacity Overview portlet
1. Install PMO Accelerator and PMO Sample Data 
2. Set up Datamart (Currency, Entity as Corporate, Project OBS as Organizational/All Groups and Resource OBS as resourcePool/All Groups
3. Configure Data Warehouse options (Entity as Corporate and Include Weekly, Monthly and Fiscal Period Data checked)
4. Navigate to Services (Home / IT Service Management / Services). Write down the earliest service start date; next steps will require it
5. Navigate to Administration / Time Slices and configure the following daily time slices (not flagged by the DWH) to start the same day from the previous step:
- DAILYRESOURCEACTCURVE - Daily 400
- DAILYRESOURCEALLOCCURVE - Daily 400
- DAILYRESOURCEAVAILCURVE - Daily 400
- DAILYRESOURCEBASECURVE - Daily 400
- DAILYRESOURCEESTCURVE - Daily 400
- DAILYRESOURCEHARDALLOC - Daily 400
6. Run the Time Slicing job
7. Add two new OBS units to the Organizational/All Groups/Business Technologies parent unit as Unit A and Unit B
8. Navigate to the Automated Security Enhancements (PR1016) project, Team tab and change the Staff OBS Unit for Jason Berry to Corporate Department OBS/IT/Development
9. Change Valerie Childers booking status to Hard keeping the current allocation (Team Detail shows 136.00 / 40.00)
10. Change Organizational OBS Unit for the Automated Security Enhancements (PR1016) project to Organizational/All Groups/ Business Technologies/Unit A
11. Create a Labor Role as follows:
- Role Name / Role ID: DBAnoResourcePool
- Category: IT, Availability: 8.00, Booking Manager: Miller, Rosie, Active: checked
- Resource Pool: leave it blank
12. Set the primary role for Nicole Chasen (resource) as DBAnoResourcePool
13. Navigate to the BYOD Management (PR1037) project, Team tab and change the Staff OBS Unit for all roles to Corporate Department OBS/IT/Shared Services
14. Still on the BYOD Management project, add the DBAnoResourcePool role to the team. Change the Staff OBS Unit to Corporate Department OBS/IT/Shared Services.
15. Assign the DBAnoResourcePool to the Identify Infrastructure Requirements task with ETC as 72 hours.
16. Change Organizational OBS Unit for the BYOD Management (PR1037) project to Organizational/All Groups/ Business Technologies/Unit B
17. Run the Datamart Extraction job
18. Run the Datamart Rollup - Time Facts and Time Summary job
19. Run the Update Estimates from Allocation job
20. Run the Investment Allocation job
21. Navigate to the Capacity Planning Overview portlet and change the portlet options to display Hours (by default it displays FTE)
22. Filter the Capacity Planning Overview portlet by the following:
- Resource OBS: Resource Pool:All Groups, Unit and descendants
- Investment OBS: Organizational/ Unit A
- Booking Status, Resource Type, Employment Type and Approved = All
23. Compare the Allocation total to the Team - Detail information from the same project (PR1016):
Result -> Note that total amounts do not match. Jason Berry is not included in the Capacity Overview portlet results.
360 (portlet) + 104 (Jason) = 464 (total from Team tab)
420 (portlet) + 52 (Jason) = 472 (total from Team tab)
24. Filter the Capacity Planning Overview portlet by the following:
- Resource OBS: Corporate Department OBS/IT, Unit and descendants
- Investment OBS: Organizational/ Unit B
- Booking Status, Resource Type, Employment Type and Approved = All
25. Compare the Allocation total to the Team - Detail information from the same project (PR1037):
Result -> Note that the allocation total amounts match the Team tab. We are filtering by the Staff OBS. Roles belong to a different OBS than the OBS used to filter and are linked to the same Staff OBS.
26. Run the Load Data Warehouse (Full mode) job
27. Run the Load Data Warehouse Access Rights job
28. Navigate to Advanced Reporting and run the Capacity vs Allocation by OBS report using the following filter options:
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit A
- Investment Status: do not select any
- Start Date: first day of the current month
- Unit Type: Hours
- Include Unstaffed Roles: checked
29. Run the Capacity vs Booking Status by OBS report using the following filter options:
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit A
- Investment Status: do not select any
- Start Date: first day of the current month
- Unit Type: Hours
- Include Unstaffed Roles: checked
30. Run the Capacity vs Allocation by OBS report using the following filter options:
- Resource OBS Type: Corporate Department OBS
- Resource OBS Unit: IT
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit B
- Investment Status: do not select any
- Start Date: first day of the current month
- Unit Type: Hours
- Include Unstaffed Roles: checked
31. Run the Capacity vs Booking Status by OBS report using the following filter options:
- Resource OBS Type: Corporate Department OBS
- Resource OBS Unit: IT
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit B
- Investment Status: do not select any
- Start Date: first day of the current month
- Unit Type: Hours
- Include Unstaffed Roles: checked
Expected Result: Demand total amounts in reports match Demand amounts in the Capacity Overview portlet when similar filter criteria is applied. Please refer to the attachment for more details
Actual Result: Demand total amounts in reports do not match Demand amounts in the Capacity Overview portlet when similar filter criteria is applied. Unstaffed roles in projects are not included
CLRT-80493: Advanced Reporting OOTB Input controls (Investment Status) have non-intuitive default selections in various OOTB Jaspersoft reports
Steps to Reproduce:
  1. Connect to PPM UI 
  2. Go to Advanced Reporting - Reports - View List
  3. Select a report, for example Capacity vs. Allocation by OBS, click to open
  4. In the left pane with the Input controls, scroll down to Investment Status
Expected Result: The default selection should be that all 4 options are selected
Actual Result: The default option is set to "Unapproved"
----------------------------
Issues Fixed in 15.1.0.3
----------------------------
CLRT-81533: Securability fix
CLRT-80971: XOG Error: Some values are not allowed for XOG In
Steps to Reproduce:
1. Navigate to Administration -> Data Administration -> Lookups
2. Click on New
3. Fill in "Lookup Name", "Lookup ID". Choose "Dynamic Query" for Source
4. Click on Save and Continue
5. In the Query - give an NSQL query that will return a large data set. Must return more than 50 thousand (default governor limit) records
6. Create a custom Object
7. Create an Attribute with Data Type as "Multi Valued Lookup" in the object created in Step 6. And attach the above created dynamic lookup to the attribute
8. Display the attribute in the "Layout:Edit" view
9. Create an Instance of the object created in Step 6
10. Browse for a few values that are beyond the governor limit (default 50K) on the mvl attribute created above. Choose a few values sand save the change
11. XOG out the custom object instance or manually create a Custom Instance XOG in file and provide IDs of values picked in Step 10 to the attribute mentioned above
12. XOG-in the file from Step 11
Expected Result: XOG In happens successfully
Actual Result: XOG In fails with an error
CLRT-80541: Time Compliance report not grouping by correctly
Steps to Reproduce:
1. Enter time in a previous time period for the following resource:
Project: Executive Dashboard Visibility
Task: Identify Infrastructure Requirements
Resource: Garcia, Alex
2. Approve and post the timesheet (Post Timesheet job)
3. Run the 'Load Data Warehouse Access Rights' and 'Load Data Warehouse' jobs
4. Navigate to Home => Advanced reporting and filter to 'Time Compliance' report
5. Select the following 'Resource OBS Type' and 'Resource OBS Unit' and all time periods
Resource OBS Type: Corporate Location OBS
Resource OBS Unit: Chicago
6. Set 'Compliance % Yellow Threshold' to 90
7. Set 'Compliance % Red Threshold' to 0 (zero)
8. Set 'Number of OBS Levels' to 2
9. Click Apply.
Expected Result: The OBS at level 3 should be grouped together
Actual Result: The OBS at level 3 is moved to Level 2
CLRT-81032: Resource Time Summary and Detail report not showing correct hours
Steps to Reproduce:
1. Find a resource with several posted timesheets which have different hours, or post several weeks of timesheets for a resource and make sure they have different hours for each week
2. Make sure the Load DW job has run
3. In Advanced Reporting go to Resource Time Summary and Detail Report
4. Do not enter an OBS.
5. Populate the resource input control and select the resource with the timesheets from step 1
6. Choose the time periods which match posted time in PPM
7. Choose posted timesheets only
8. Click Apply
Expected Result: The report shows correct hours on each line of the summary report
Actual Result: The report shows the same hours for each line of the summary report
CLRT-81113: Investment Hierarchy not populating after 2 levels of hierarchy
Steps to reproduce:
1. Create 5 Projects
2. Create a Hierarchy out of these 5 Projects
a. That is, make Project 1 sub-project of Project 2
b. Project 2 sub-project of Project 3 and so on
3. Run the "Load Data Warehouse" job on "Full Mode"
4. Check DWH_INV_HIERARCHY table (in the DWH Schema) for the Hierarchies created in Step 2
a. Note that, they are present in the DWH Schema
Expected Result: Shows hierarchy levels 1 to 5
Actual Result: Shows only levels 1 and 2
CLRT-81068: Microsoft Project (new driver) replaces non-Latin characters with question mark characters when importing the project
Steps to reproduce:
1. Create a project with a task in Japanese alphabet (or Chinese, Russian...)
2. Open it in MSP using the new driver
Expected Result: Task shows in Japanese characters
Actual Result: Task will show as ??????. If the project is saved, those ?????? will be saved as well overwriting the original task name
CLRT-81494: Long Hyphen is Removed in Microsoft Project (MSP)
Steps to reproduce:
1. Open Microsoft Word Document.
2. Copy Aa <a non UTF-8 long hyphen> aa.
3. Login to CA PPM.
4. Create a New project
5. Create a New task and paste 'Aa <a non UTF-8 long hyphen> aa' in the task name (or, enter the task name, press Alt+0151 to enter a long hyphen—also known as an em dash).
6. Save and Return.
7. Open Project in MSP.
Expected Result: Project is opened in MSP successfully and task name would be 'Aa <some non UTF-8 long hyphen> aa'
Actual Result: Project opens in MSP however, the long Hyphen and everything that follows it is removed
CLRT-81543: Process definition for project subobject that is linked to the project object which is linked to another object through a lookup fails
Steps to reproduce:
1. Create a sub-object from the Project object
2. Create a dynamic lookup linked with Incident object
3. Create lookup attribute in project object of Lookup type and link with previous lookup
4. Create a process (Name: whatever / ID: whatever), click at 'Save and Continue'
5. Click on 'Add Primary Object' and select the custom object created in the first step, then click on 'Save and Return'
6. Select 'Objects' Tab in the custom process and select the left checkbox of object and click at 'Add Linked Object'
7. Attribute: 'Parent' / Object Key: thisProject and click at 'Save and Return'
8. Select 'ThisProject' check box in 'Objects' Tab and click again at 'Add Linked Object'
9. Attribute: Select the attribute created in step #3 and Object Key: thisIncident
10. Start option of the process select: Create
11. Process from start to finish, validate and activate
12. Create a Project
13. Create an instance of custom sub-object
14. Check the process state
Expected Result: That the process runs to completion
Actual Result: The process fails with an error
CLRT-81135: Integration Adaptor - Resource manager field not getting updated through OTB integration file loader
Pre-Requisite:
Integration Adaptor setup for customer (SaaS editions only)
Steps:
1. Place the file in the specified location
2. Run the Integration data loader Job
Expected Result: All the details mentioned in the file should get updated for the resource.
Actual Result: Resource manager field not getting updated through OTB integration file loader, even when the file has value in 'managerUserName' value
CLRT-81350: Material and Expenses roles change their ETC when opened in MSP
Steps to reproduce:
1. Create a project and a task (e.g.: from 10/4 to 11/3)
2. Allocate 4 roles: Labor, Equipment, Material and Expense types
3. Allocate the roles onto the task, with 70h ETC each
4. Open the project in MSP using the new driver
Expected Result: ETC for all roles is 70
Actual Result: ETC for Material and Expenses is 69
CLRT-80429: Incorrect Job Schedule link in Email notification
Steps to reproduce:
1. Login to CA PPM -> Advanced Reporting -> Library
2. Right Click on a Report and choose Schedule a Report in Jaspersoft
3. In the Notification Tab - select option:
Include reports as repository links in email body
Expected Result: Customer should be able to click on the link and it will bring them directly to the report
Actual Result: Link doesn't work
----------------------------
Issues Fixed in 15.1.0.2
----------------------------
CLRT-81414: Securability fix
CLRT-81298: Securability fix
CLRT-81485: CA PPM SaaS New UX users using SSO cannot view CA PPM documentation
Steps to reproduce:
1. Login to the CA PPM OD Portal or SaaS Link
2. Access the New UX
3. Click on the pull-down lookup next to the avatar image and select the "Help" link
Expected Result: The CA PPM Help page appears from the offline CA PPM documentation staged in the OD environment.
Actual Result: The CA PPM Help doesn't appear or requires a login at docops.ca.com
CLRT-81268: Generate Invoice Job creating GL transactions with null invoice id
Steps to reproduce:
1. Create huge number of transactions posted (for example, 50K)
2. Create adjustments for those transactions
3. Run Generate Invoice Job.
Expected Result: CBK_GL_TXNS table should not have any null invoice ids
Actual Result: CBK_GL_TXNS table has null invoice ids
CLRT-81353: security.logs does not display app-ca.log file
Steps to reproduce:
1. Login to CA PPM as an admin or equivalent user
2. Modify the URL to have /niku/nu#action:security.logs
3. Browse to app-ca.log.1 or .2, etc
Expected Result: The entire page will refresh
Actual Result: The app-ca.log will not be displayed
CLRT-81429: The Beacon service throws a ClassNotFoundException upon upgrade
Steps to reproduce:
1. Upgrade to CA PPM 14.4 from CA PPM 14.2
2. Start the beacon service
Expected Result: The Beacon Service should start without any error
Actual Result: The ClassNotFoundException is thrown and the service is not starting
CLRT-81330: Timesheet displaying dates in US format instead of UK format
Steps to reproduce:
1. Go to Administration -> Resources -> go to the resource and change the Locale to 'English(United States)'
2. Log out of CA PPM and then log back in.
3. Go to a timesheet and you will see that the Date format for each day of the week to the right side of the screen is showing up as US date format mm/dd
4. Go to Administration -> Resources -> go to the resource and change the Locale to 'English(United Kingdom)'
5. Log out of CA PPM and then log back in
Expected Result: Go to a timesheet and see that the date format for each day of the week to the right side of the screen has changed to UK date format yy/mm
Actual Result: Go to a timesheet and you will see that the date format for each day of the week to the right side of the screen is still showing up as US date format mm/yy - which is incorrect
CLRT-80768: Timeslicing rollover for odf slice requests from DWH can take many hours to rollover on MSSQL
Steps to reproduce:
1. Time a rollover on a dataset with a large number of assignments before setting the Data Warehouse entity
2. Set the Data Warehouse entity and allow the initial timeslice to run
3. Time the next rollover
Expected Result: The rollover should not be extraordinarily longer
Actual Result: The rollover is potentially ten's of hours longer (After analysis it was noted that a large amount of time was spent processing the assignment actcost_curve and etccost_curve)
CLRT-81346: MSP - Project does not save back into CA PPM from MSP
Steps to reproduce:
1. Create two projects, p1 and p2
2. Make p2 a subproject of p1
3. Create a resource, r1, based on the Standard 8h Calendar
4. Create a task on p2, assign r1 to the task
5. Open p1 with MSP
6. At this stage, without any modification, the project can be saved successfully. This can be repeated twice.
7. Go to Home > Resources and open r1 Calendar
8. Change the shift for November 24th and 25th (for example) so that the resource only works from 8 to 12 (no afternoon)
9. Open p1 with MSP and then try to save the project back to CA PPM without any modifications
Expected Result: The Project saves back to CA PPM successfully
Actual Result: MSP hangs while saving back the project to CA PPM
CLRT-81427: MSP XML Driver does not honor task dates for a fixed duration task with 0hrs work
Steps to reproduce:
1. Create a project in CA PPM and add a resource to the team
2. Create a fixed duration task with 10 days duration.
3. Assign the resource to the task.
4. Change the Work to 0h. Duration will still say 10 days in CA PPM
5. Open the project in MSP
Expected Result: Fixed duration task of 10 days with 0h Work in MSP
Actual Result: Fixed duration task of 1 day and 0h Work in MSP
CLRT-80899: Timesheet process with linked resource object ignores post condition on Resource availability rate
Steps to reproduce:
1. Log into CA PPM as a user with all rights
2. Create a User on the admin side of CA PPM with sufficient rights to be assigned to a task on a project and to fill out and submit their own timesheet
3. Go to Home > Resources, locate your user and click on them to open the properties page
4. Click on the down arrow next to Properties and choose Settings. Make sure the track mode is set to PPM and Open for Time entry is checked
5. Click on the down arrow next to Properties and choose Financials. Make sure the Financially enabled box is checked and that all required fields are filled in
6. Click on the down arrow next to Properties and choose Main. On the properties page, make sure the Availability (or Availability Rate) field is filled out
7. Add the user to a project team
8. Add a task to the project and assign your user to the task
9. Go to Administration, Processes and create a process that meets the criteria in the description or XOG in the process using the attached file (test_resource_availability_process.xml)
10. Validate and Activate your process
11. Go to Home > Timesheets. Locate and open a timesheet for your user
12. Click the Populate button
13. Add some hours for your user
14. Click the Submit for Approval button
Expected Result: The process will go down the correct path based on the availability or availability rate set for the resource
Actual Result: The process always goes down the path of the <= 0 condition
CLRT-80841: Gel Script process fails to validate when &amp;&amp is utilized and comment present in the script
Steps to Reproduce:
1. Login to CA PPM as an Administrator
2. Navigate to Administration->Processes
3. Open and existing process in Draft or create a new one
4. Create or go an existing Step
5. Create Custom Script
Expected Result: The process will be validated
Actual Result: Process does not validate and gives error. BPM-0703: Custom script syntax error at line 11, column 22:
CLRT-81086: OBS XOG performance decreased after upgrading to 14.3 and above causing CPU to spike on application server
Steps to Reproduce:
1. Create a large OBS XOG file that has a unique code value for every unit in the same OBS type
2. Using 14.2 or earlier, XOG this file in
3. Note how long it takes to complete and monitor CPU utilization on the app
4. Upgrade to 14.3 and above
5. Repeat the XOG file in operation
6. Note how long it takes to complete and monitor CPU utilization on the app
Expected Result: The duration of the two XOG attempts will not be precisely the same, but the overheads should not more than double the original efforts
Actual Result: The duration of the second XOG attempt is many times the duration of the first and the CPU is maxed out for most of the duration
CLRT-80474: CA PPM 14.3 SaaS Should Not Force Users to Log Into Public DOCOPS.CA.COM Pages When They Click Help
Steps to Reproduce:
1. Log in to the CA PPM OD Portal or a CA PPM SaaS link.
2. Click Help from any application page.
Expected Result: Help page appears as seen at docops.ca.com.
Actual Result: CA Login or Register page appears.
CLRT-80417: DWH_PROJECT_V does not get updated for new attributes when ODF_PROJECT_V cannot be recreated, which fails the Load Data Warehouse job with invalid column name message
Steps to Reproduce:
1. Use a CA PPM system with many attributes on Project, that go over the 1024 column limit
2. Go to Administration - Objects - Project - Attributes
3. Select a custom attribute and enable it for Data Warehouse
4. Note a warning in app-ca.log that the view limit is exceeded
5. Now run the Load Data Warehouse job - Full Load
Expected Result: The Load Data Warehouse job to run successfully, DWH_PROJECT_V to be recreated as the number of DWH enabled attributes is within limits
Actual Result: The Load Data Warehouse job is failing with error Invalid Column, when you check DWH_PROJECT_V, you see that the newly added to DWH attribute is not there, no error message is thrown in the app-ca log
CLRT-81172: Task List in New UX gets removed when navigating away from the task list page or collapsing and expanding the task list
Steps to reproduce:
1. Login to the New User Experience for 15.1
2. Under the Project Tiles page, create a new project or select an existing project
3. Click on "Tasks" link to display all the assigned tasks
4. Select the checkmark to mark a few tasks from the list as "Completed"
5. Click on "Status" tab and then return back to the "Tasks" tab
6. The tasks that were marked "Completed" in step 5 are no longer checked and are blanked out
7. The behavior is also experienced when the list is collapsed and expanded again
Expected Result: The tasks should remain selected
Actual Result: The selected task is blanked out
CLRT-80987: Exception in parent calendar are not shown in Parent calendar of MS Project interface
Steps to reproduce:
1. Login into CA PPM
2. Create one MSP project
3. Add a resource under team & have the parent calendar attached to the resource
4. Open the created project in MSP, we could see the 2 additional "Non-working days" in MSP calendar
5. For the same resource, now attach the child calendar & save the details
6. Open the project in MSP, and verify the child calendar in MSP
Expected Result: Additional "Non-working days" in for the child calendar in MSP should be seen
Actual Result: Additional "Non-working days" are missing for the child calendar in MSP
---------------------------------------------
Issues Fixed in 15.1.0.1:
--------------------------------------------
CLRT-81389: NSA bind address is not working
Steps to Reproduce:
1. Have bindAddress as public IP (non system IP address)
2. And start the beacon,bg and app services
Actual Result : All services should bind to same ip address
Expected Result : Some of the services are bind to local IP address
CLRT-81099: Securability Fix
CLRT-80393: Securability Fix
CLRT-81096: Securability Fix
CLRT-81100: Securability Fix
CLRT-79804: Financial status of project can be opened even when the project is inactivated
Steps to Reproduce:
1. Login to the CA PPM application and navigate to an active and financially open project
2. Change the financial status to closed
3. Now the active check box becomes editable
4. Uncheck the check box and make the project inactive. On the same page before saving, change the project financials to open
Expected Result: The system should throw an error because an inactive project should not have Open financial status
Actual Result: The system allows an inactive project to have an open financial status. The financial status drop-down menu with Open as the set value shows a Not Available option
CLRT-80681: In MSP new driver, when exporting a project from CA PPM to MSP, incorrect settings in File-> Options are being exported
Steps to Reproduce:
1. Open Microsoft Project
2. Close all projects in MSP, including any blank projects such as 'Project 1' so settings made are applied for all new projects
3. Go to File -> Options -> Schedule and set the following (make sure all settings are for "All New Projects")
a. Week starts on: Monday (this should be pulling from a PPM Setting, but this change is to show that it is not pulling from MSP Settings as well)
b. Fiscal year starts in: February
c. Default Task Type: Fixed Duration
d. Auto link inserted or moved tasks: Checked
e. New scheduled tasks have estimated durations: Unchecked
f. Under Calculation options for this project:
i. Inserted projects are calculated like summary tasks: Unchecked
ii. Actual costs are always calculated by Project: Unchecked
4. In MSP Options, go to 'Advanced' and make the following changes:
a. Edits to total task % complete will be spread to the status date: Checked
b. Calculate multiple critical paths: Checked
5. Click OK to set these changes for All New Projects
6. In PPM, In Administration -> Project Management -> Settings:
a. Change 'First Month of Financial Quarter' to 'Mar'
b. Change 'First Day of Work Week' to 'Tue'
7. Click Save
8. Create a new project in PPM (no tasks/team members needed)
9. Export the project to MSP
10. Go to File -> Options -> Schedule and then File -> Options -> Advanced and observe results
Expected Result: All settings made for new projects in MSP are reflected in project exported from CA PPM (with the exception of Week starts on: that should be pulling from CA PPM in Project Management Settings)
Actual Result: Some settings are exported incorrectly and do not match the changes made in MSP Options.
CLRT-62402: You do not get an error when you attempt to xog-in a resource with date of termination that is earlier than the date of hire
Steps to Reproduce:
1. Create a resource with a date of hire 6/27/2011 and a date of termination of 12/31/2011
2. Xog the resource out
3. Edit the terminationDate="2011-06-01"
4. Xog in the file you edited
Expected Result: To get an error indicating the date of termination is before the date of hire
Actual Result: You do not get an error and the bad date is imported
CLRT-80617: Time-scaled values (TSV) fields do not align with the key column
Steps to Reproduce:
1. Open a portlet that has TSV
Issue has been observed with at least the portlet from Home > Resources > Allocations, and also in Home > Projects > [project] > Team > Staff
2. Click on the configure button
3. Go to the List Column Section > Fields > Add, then add a new TSV
4. Add a new TSV with many fields. See screenshots for reference, but in general, the more attributes selected, the higher chance to observe the issue
Expected Result: All TSV and its legend label are aligned, regardless of having empty (zero-values)
Actual Result: Some TSV are not aligned with the legend and/or with columns that contain zero-values
CLRT-81244: Task deletion via new user experience causing API-1004 error
Steps to reproduce:
1. Login to CA PPM via the classic UI
2. Go to Projects and create a new one from template
3. Navigate to the new user experience
4. Click on project name header
5. Click on the Tasks option and create a new task, and click on 'Add'
6. The Task is created, now select it and then click on the remove icon
7. The message error received is: "API-1004: Invalid resource identifier"
Expected Result: The task is deleted without the message error
Actual Result: API-1004: Invalid resource identifier
CLRT-80647: Portlets developed using Portfolio System provider (portfolio provider) are very slow
Steps to reproduce:
1. Login to a system with 100+ portfolios, and at least 50 of them having 100 investments. The planned cost and budget cost should be set for those investments
2. Navigate to Administration - portlets
3. Create a chart portlet with the below details
Portlet Name: Portfolio Test
Portlet ID: portfolio_test
Content Source: PMO Accelerator
Category: Productivity
Base Size: Small
Instance: General
Data Provider: Portfolio Provider
Chart Type: Column
Source Data: In the primary Axis Metrics, select Target Total Cost, Investment Budget Cost, Investment Planned Cost
Under Options
Show Legend: checked
Sub Type: Clustered
Link: Portfolio Waterlines
Mouse over Labels: Label and Value
Label Attribute: Portfolio Name
Metrics: Series Type: columns (Select column type for all the three selected metrics)
4. Configure this portlet to show in the Home page by creating a new tab under GENERAL
5. Navigate back to the page where the portlet is configured
Expected Result: The portlet loads in less than 5 seconds in a performance environment
Actual Result: The portlet takes more than 14 seconds to load
CLRT-80941: MSP New Driver does not respect Standard Calendar when having resources using mixed Calendars
Steps to reproduce:
1. In an environment with resources using two calendars (Standard, the actual standard calendar), and another one, with different shift (7.5h), "7.5 Calendar"
2. Create a project in PPM
3. Add resources that have both the "Standard" (standard) calendar and the "7.5 Calendar"
4. Create tasks and assign one resource to each task
5. Open the project in MSP
6. Check MSP > Project > Properties > Project Information
Expected Result: Calendar shows as "Standard"
Actual Result: Calendar shows as "7.5 Calendar"
 
Minimum Jaspersoft Patch for 
CA PPM
Jaspersoft Server Cumulative Patch 6.2.1_5.2.1.4 for CA PPM 14.3, 14.4, 15.1, 15.2, and 15.3 is the minimum supported Jaspersoft cumulative patch through June 28, 2018. Customers are encouraged to upgrade to JasperReports Server 6.4.2 for CA PPM available in March 2018.
: Effective June 28, 2018, CA no longer supports Jaspersoft 6.2.1. If you are installing Jaspersoft for the first time or upgrading, you must install 6.4.2. The CA download center no longer includes 6.2.1.
Jaspersoft Server Cumulative Patch 6.2.1 README
----------------------------------------------------------------
Base Version #: 6.2.1
Patch Version #: 5.2.1.4
----------------------------------------------------------------
6
5
**** NOTE *****************************************************
Patches are intended to be timely fixes and are not fully regression or integration tested, and are only tested against the issues listed below. CA feels confident that this patch will resolve the addressed problems, but customers should be aware that a patch could have adverse side effects to the function of their application. Customers should not apply patches directly to production systems without first verifying in a test environment.
! Stop Jaspersoft Tomcat services before applying this patch.
Known Issues and Workarounds:
Java Exception
: If you encounter "java.io.IOException: CreateProcess error=206, The filename or extension is too long" while applying the patch, shorten the path length of the installation directory. For example, the recommended path for the patch installation directory appears as follows:
Windows:
C:\6.2.1_5.2.1.x.x
Unix, Linux, or OS X:
/fs0/6.2.1_5.2.1.x.x
Please Wait Message
: If users encounter a ‘Please Wait’ message that does not disappear when attempting to access the 
CA PPM
 Advanced Reporting page after installing Jaspersoft Server Cumulative Patch 6.2.1_5.2.1.4, clear the browser cache on the client machine for each user attempting to access Advanced Reporting.
If any issues arise during the installation or use of this patch, contact CA Support.
****************************************************************
INCLUDED FILES:
----------------------------------------------------------------------
README.txt -> This file
bin/install.sh -> Unix installer
bin/install.bat -> Windows installer
bin/install.xml -> Ant install script
PRE-REQUISITE - ADDITIONAL NOTES:
----------------------------------------------------------------------
- CA PPM customers with Jaspersoft Report Server v6.2.1 can apply this patch.
----------------------------------------------------------------------
HOW TO INSTALL THIS PATCH:
-------------------------
1. Stop the application server (Apache Tomcat Server), on which JRS is deployed.
2. Find the root web application folder (e.g. c:\apache-tomcat\webapps\reportservice\).
3. Make a back-up copy of that folder to a new, separate location.
4. Extract the CA PPM Jaspersoft Patch zip file to a location (<patch_dir>).
5. Install the patch: Go the <patch_dir> --> bin folder. The bin folder contains installer scripts, that you need to run on the OS command prompt.
5.1. Interactive Installation
  5.1.1. Run command 'install.bat/sh interactive' based on the OS.
5.2. Silent Installation
  5.2.1. Run command 'install.bat/sh' based on the OS. 
  5.2.2. Make sure all the property values in 'install.properties' file, have proper values in it. 
    5.2.2.1. patch.deploy.tomcat : Tomcat Server base folder absolute path.
    5.2.2.2. patch.deploy.jrs.webapp.name : Deployed JRS webapp name.
    5.2.2.3. patch.deploy.capb.name : Value should be always 'clarity'.
    5.2.2.4. patch.install.mode : Values can be 'standalone' or 'cluster', based on the node your installing the patch. Specify 'standalone' for primary node and 'cluster' for secondary nodes.
APPLICABLE ONLY FOR AZURE ENVIRONMENT:
5.2.2.5. jaas.deploy.environment : By default the value is 'op'. If deploying in azure environment, specify the value of the property as 'azure'.
5.2.2.6. jaas.deploy.environment.compliance.level : By default the value is 'standard'. If deploying in azure environment and for FedRAMP compliance, specify the value of the property as 'fedramp'.
6. Clear the application server (Apache Tomcat Server) 'temp' directory.
7. Clear the application server (Apache Tomcat Server) 'work' directory.
8. Start the Apache Tomcat Server, on which JRS is deployed.
9. Clear browser cache on client.
HOW TO UNINSTALL THIS PATCH:
-----------------------
1. Stop the application server (Apache Tomcat Server), on which JRS is deployed.
2. Find the root web application folder (for example, C:\apache-tomcat\webapps\reportservice\).
3. Restore the all the files under /reportservice from backup.
4. Restart Tomcat instance.
-------------------------
Additional Functionality Delivered in 5.2.1.4:
-------------------------
Korean Language Support is now available with this patch for Jaspersoft Server 6.2.1
This will be applicable only with CA PPM 15.3 and above versions.
Upgraded Jaspersoft Server Enterprise License to Unlimited Expiration Date
This license file is also bundled along with patch zip artifact (<patch-unzipped-folder>\resources\license\jasperserver.license). After applying the patch, the expected behavior is that the expiration date should change on the server. However, if the expiration date is still not changed on the server, replace the jasperserver.license file in the file-system with the license file provided in this patch.
TIBCO Security Updates for CSRF, XXS, XXE, and Related Vulnerabilities
TIBCO has identified CSRF, XXS, XXE, and related security vulnerabilities in JasperReports Server 6.2.1 and has provided fixes in JasperReports Server 6.2.3. Fixes for these security vulnerabilities have been backported to JasperReports Server 6.2.1 through this patch.
-------------------------
Issues Fixed in 5.2.1.4:
-------------------------
DE35172: Adhoc views fails to open in Jaspersoft 6.2.1 when there is condition Divisor is equal to zero error
Steps to Reproduce:
1. Created an Ad Hoc View, selecting the Resource Management domain.
2. Selected all fields and click OK.
3. Drag and drop Weekly Start Date to the view’s columns.
4. Drag and drop the Weekly Periods -- Resource -- Available FTE measure to the view’s columns.
5. Drag and drop Resource Name to the rows.
6. Create the first calculated measure by copying and pasting "Available FTE" - Round("Time FTE", 0) into the formula field, calling Measure name Open, validating it then finally click the Create Measure button.
7. Create the second calculated measure, copy and paste Round("Time FTE", 0) into the formula field and call the measure name Complete. 
8. Create the third calculated measure, copy and paste ("Complete" % ("Open" + "Complete")) into the formula field and call the measure name % Comp. Create the measure.
9. Drag and drop the newly create % Comp measure to the view’s columns. This step works in Jaspersoft 6.1 and screen shot is attached
Measures created
Open: "Available FTE" - Round("Time FTE", 0) 
Complete: Round("Time FTE", 0) 
% Comp: ("Complete" % ("Open" + "Complete")) 
Expected Results: It should fetch the data. 
Actual Results: The adhoc view crashes and error in log ORA-01476: divisor is equal to zero error.
DE32148: Scheduled Report are blank after Jaspersoft migration from 6.1 to 6.2.1
Steps to Reproduce:
1. Login to CA PPM 14.3 or 14.4 which is linked to Jaspersoft 6.1 
2. Go to Advance reporting and schedule few reports 
3. Set up a Jaspersoft 6.2.1 and migrate the content from 6.1 tenant wise
Expected Results: The scheduled report should run and give the proper data 
Actual Results: The schedule report run but it returns blank data
DE33063: Advanced Reporting missing Login As User Functionality
Steps to Reproduce:
1. Log into CA PPM as user with the Jaspersoft ROLE_ADMINISTRATOR role. 
2. Select the Home tab then Advanced Reporting.
3. Once in Advanced Reporting select Manage -> Users. 
4. Once the list of users display click on a user.
5. View the properties of the user.
Expected Results: Three buttons are visible, Edit, Login as User and Delete User. 
Actual Results: Only two buttons are visible Edit and Delete User.
DE33934: Adhoc Views are corrupted with Null Pointer Exception
Steps to Reproduce:
1. Create a new Adhoc view with Resource Management Domain 
2. Select Resource Name, investment name, Month Start Date from Calendar Periods, Available hours measure 
3. Create a cross tab by adding investment name to rows, month start date & Available Hours to Columns 
4. Add Investment name to Filter and select any Project which displays data and apply filter 
5. Right Click on Month Start Date and delete Column Summary (This Step is Key as all the views with no Column Summary are having this issue) 
6. Save Adhoc View with the results 
7. Now change the name of the investment in CA PPM which is used in the filter 
8. Run Load Data warehouse job in CA PPM to update investment name in DW 
9. And navigate to Advanced Reporting and navigate to saved Adhoc view 
10. Try to Open Adhoc view
Expected Results: The Adhoc view should open 
Actual Results: The Adhoc view is corrupted and shows null pointer error
-------------------------
Issues Fixed in 5.2.1.3:
-------------------------
DE30551: Jaspersoft - Please wait message disappears when report run in same session by changing the parameter
Steps to Reproduce:
1. Run a report with around 10 parameters click on apply. 
2. Report will start generating the data in the report with a message ‘Please wait’ till it fetches the data on the first page. 
3. Change the filters by selecting more values to the existing filter options or reducing already added filter values and then click on apply button to generate the data
Expected Result: Please wait message should be there on screen till the first page of report loads completely.
Actual Result: Please Wait message disappears so quickly that user feels the report is completely generated but actually it’s not.
DE32538: When scheduling a Jaspersoft report, Argentina Time zone is not available
Steps to Reproduce:
1. Log into CA PPM as a user with Advanced Reporting access
2. Select Home -> Advanced Reporting
3. Select Reports -> View list
4. Right Click the desired report and select Schedule.
5. On the Create Schedule tab, expand the Time Zone drop down.
Expected Result: Argentina Time Zone available in the list. 
Actual Result: Argentina Time Zone is not available in the list.
DE32714: Jasperadmin & Joeuser (two users created by default on creating a new tenant) with Full Admin permissions are having their password set to default for the new tenants
Steps to Reproduce:
1. Execute the command to import tenant from bin folder of CA PPM installation - "admin content-jaspersoft csk -userName superuser -password xxxxxx -fileName jaspersoft_csk.zip"
2. This would create a tenant on Jaspersoft v6.2.1 server with default users as Jasperadmin & Joeuser.
3. Login into Jaspersoft v6.2.1 server, try to login with Jasperadmin/Joeuser credentials from the login page. 
Expected Result: Login should not be successful. 
Actual Result: Both Jasperadmin/Joeuser are able to login with default password.
IMPORTANT! Please notice after applying this patch, on creating a new tenant, 
A) Jasperadmin user will be created with an unknown password. Jaspersoft administrator can update the password. 
B) Joeuser will NOT be created by default. 
NOTE: Both the above points does not apply for tenants that are getting migrated.
DE30205: Full project list not displayed in Adhoc view if static lookup from project sub object is added as a field to be displayed
Steps to Reproduce:
1. Create a Project sub object. 
2. Add an attribute to the sub object that uses a static lookup. 
3. Add the sub object to data warehouse by selecting the 'Include the sub object in Data Warehouse' checkbox. 
4. In both the Create and Edit view of the sub object General page add the static lookup attribute created in step two. 
5. Create an instance of the sub object in say 5 projects and populate the name of the instance as well as lookup value. 
6. Execute ‘Load Data warehouse’ job by selecting ‘Full Load’ option. 
7. Create an Ad Hoc view under Advanced Reporting section using Project Management domain. 
8. On the 'Domain: Project Management' page, drag and drop the Project name from 'Fields' section on the left into 'Rows' section on the right. All project names get displayed. 
9. In the 'Fields' section expand 'Custom' to display the sub object created in step one. Expand the sub object to display attributes. Drag and drop 'Name' attribute into 'Rows' section. All project list still get displayed.
10. In the 'Fields' section under 'Custom' drag and drop the sub object lookup attribute into the 'Rows' section.
Expected Result: The list of projects to remain intact.
Actual Result: The list of projects is truncated to display only 5 projects which are ones with sub object instances
DE32737: Enable JavaScript functions on the Jaspersoft server
Steps to Reproduce:
1. Create a Jaspersoft Studio Report and publish the same to Jaspersoft v6.2.1_5.2.1 server. This report should have some JavaScript functions.
2. Run the report on Jaspersoft v6.2.1 server, once successfully published. 
Expected Result: Report should successfully execute. 
Actual Result: Report execution fails.
Note: With this Jaspersoft Server Cumulative Patch, 'Permission Prefetcher' is auto-enabled. This will make the Jaspersoft server repository navigation comparatively faster.
-------------------------
Issues Fixed in 5.2.1.2:
-------------------------
CLRT-81493: Output locale in Jaspersoft scheduling options is always set to default
Steps to Reproduce:
1.Login as CA PPM user who has advance reporting rights 
2.Navigate to Home->Advanced reporting 
3.Schedule a report and check output locale option in scheduling options
Expected Result: Report output locale should be corresponding to the language set for the logged in user in CA PPM.
Actual Result: Report output locale is not set according to the language set in CA PPM
CLRT-81492: All locales present in CA PPM are not present in Jaspersoft scheduling output locale
Steps to Reproduce:
1. Login to CA PPM with user who has advanced reporting access rights 
2. Navigate to Home->Advanced reporting 
3. View reports list 
4. Schedule any report 
5. Navigate to scheduling options and observe output locales
Expected Result: Locales present in CA PPM should be supported in Jaspersoft as well.
Actual Result: Only few locales are present in jaspersoft report scheduling options.
CLRT-81491: CA PPM user with ‘Advanced Reporting - Administer’ access right should be able to update the domain schema via Jaspersoft
Steps to Reproduce:
1. Login as a CA PPM user with ‘Advanced Reporting - Administer’ access right.
2. Navigate to Home->Advanced reporting 
Expected Result: As a tenant administrator I should get an option to update domain schema from Jaspersoft UI.
Actual Result: No mechanism to update the domain schema from jaspersoft UI.
 
CLRT-81490: Import and Export capability for tenant administrator in Jaspersoft
Steps to Reproduce:
1. Login as a CA PPM user with ‘Advanced Reporting - Administer’ access right.
2. Navigate to Home->Advanced reporting. 
Expected Result: As a tenant administrator I should get an option to export and import selected resources from Jaspersoft UI.
Actual Result: No mechanism to export and import selected resources from Jaspersoft UI.
Steps to Reproduce:
1. Using IE11, login to CA PPM. Make sure there is at least one active desktop application that is not minimized, and make sure there are no other open IE windows or tabs. 
2. Click on Advanced Reporting 
3. Observe that Jaspersoft screen is either minimized or in background now 
4. Click on IE icon in tray to bring screen to forefront or maximize 
5. Under Reports, click on View List and observe that Jaspersoft screen is either in background or minimized again 
6. Click on IE icon in tray to bring screen to forefront or maximize 
7. Click on any stock report and observe that Jaspersoft screen is either in background or minimized again
Expected Result: IE 11 browser should not minimize.
Actual Result: IE 11 browser minimizes.
-------------------------
Issue Fixed in 5.2.1.1:
-------------------------
CLRT-79518: When setting date filters in ad hoc views, the system changes the selected date (for example, filter projects with a finish date >= 1/1/15, the system changes that date to 12/28/14
Steps to Reproduce:
1) Login into CA PPM 
2) Click on Home->Advanced Reporting 
3) From the main menu, click on Create Ad Hoc Views 
4) From Select Data Menu... Select Investment Managements 
5) From the Source window, Expand Investment 
6) Select the following " Investment Name, Investment ID, Start Date, Finish Date, Click ok 
7) Ad Hoc View change "Crosstab to Table" 
8) Drag and Drop the following " Investment Name, Investment ID, Start Date, Finish Date from Filed Menu to Columns 
9) Right Click on the header of "Finish Date", click on add filter 
10) Click on the calendar and select the Date 
11) Click on Apply 
12) The data will populate correctly, but the "Date will change from 2015-12-18 To 2015-12-16" 
13) The Apply Tab will highlight again and if we click again then it will change the date from "2015-12-16 To 2015-12-14"
Expected Result: The Date should not change.
Actual Result: Date changes.
 
JasperReports Server 6.4.2 for CA PPM README
JasperReports Server 6.4.2 is a maintenance release that includes security updates and improvements requested by customers. 
This update resolves a number of security vulnerabilities associated with 6.2.1, supports same-database upgrades from the previous 6.2.1 release, and introduces new dashboard improvements.
Highlights of this release include:
  • New Supported Platforms
    : The following components included in the installer are updated: Apache Tomcat 8.5.20, Oracle JDK 8 version 1.8.0_144 (8u144), PostgreSQL 9.3.18 (not supported), and Spring Framework 3.2.18 (not supported).
  • Directory Access Control
    : The improvements include a new option to deny access to directories in the file system of the JasperReports Server host using the ResourceForwardingServlet servlet. The servlet forwards requests from, for example, /runtime/<hex-code>/<my-resource> to the /<my-resource> URL to handle browser caching. Access to the WEB-INF and META-INF directories is always denied. In some circumstances, you may want to deny access to other directories. For example, if you restrict access to certain directories using the security-constraint tag in web.xml, you should also restrict access to those directories using the forwardForbiddenDirectories parameter of the ResourceForwardingServlet servlet. To do so, edit a configuration file.
  • Dashboard Enhancements
    : Dashboards can now be scheduled (limited support). Dashboard export enhancements are also included. Dashboards support hyperlinks for dashlets that can replace the current dashboard with a web page, report, dashboard, or ad hoc view. New formatting options for text dashlets are also available. New Undo, Redo, and Undo All buttons on the dashboard toolbar allow you to undo and redo recent changes made to the dashboard, including changes to input control values. You will also see new Time-Date wildcards for dashlets.
  • Import-Export Enhancements
    : Tenant-level exports show a new Include Dependencies option Organization admins can now export individual resources or entire folders from the repository page. Superusers also have new options to export resources and folders without full paths or dependencies, so that the resulting catalog can be imported by organization admins. A new 
    Include Dependencies
     option is available when exporting. In Jaspersoft 6.2.1, the export.zip contained all the dependencies.
    image2018-2-28 10:53:55.png
  • PhantomJS library upgrade to 2.2.
  • New Cross-Site Request Forgery (CSRF) protection mechanism.
  • Out-of-Memory fixes for compressed class exceptions.
  • Performance improvements for ad hoc view crosstabs
 
 
 
HARDWARE AND SOFTWARE REQUIREMENTS
------------------------------------------------
See the CA PPM Release Notes and TIBCO Documentation.
CA PPM 14.3 and higher on-premise customers must use the CA PPM Jaspersoft installer, a customized wrapper written on top of the original third-party installer.
Only the CA installer can be used to install Jaspersoft and integrate it with CA PPM for reporting. Do not install software, download patches, or apply hot fixes directly from TIBCO. See CA Download Center.
: Install or upgrade your reporting environment using the installer provided by CA. On-premise customers can decide among the following options: upgrade the same database from 6.2.1 to 6.4.2, perform a fresh install with 6.4.2 (and optionally migrate reporting content), or defer (that is, remain on 6.2.1 temporarily until you upgrade CA PPM). For example, you plan to upgrade to CA PPM 15.4 which includes JasperReports Server 6.4.2. Due to security fixes, we recommend that you upgrade to 6.4.2 as soon as possible. JasperReports Server 6.2.1 will be End of Service as of June 28, 2018.
 
IMPORTANT
------------------------------------------------
JasperReports Server can be deployed as a standalone application or in a cluster for high concurrency. Clustered JasperReports Server Instances will use thread-safe access to their private repository database. As a result, any number of JasperReports Server instances can share the same repository thus present the same environment to users.
When JasperReports Server is deployed in a cluster, it is advised to dedicate one or more JasperReports Server instances in the cluster to process the execution of scheduled reports. These dedicated instances will share the same repository but will not be part of the load balancer to serve web requests, such as executing reports through the UI and/or exploring data through ad hoc views.
For standalone deployment where only a single instance of JasperReports server is available, the instance will process report scheduling as well serve normal web requests, such as report execution through the UI and/or exploring data through ad hoc views.
We are providing a mechanism to make dedicated JasperReports server instances as scheduler instances, and the instances that are part of the load balancer to serve web requests as non-scheduler instances.
During installation of the CA PMM Jaspersoft 6.4.2_5.4.2, user will be prompted whether the user is opting for a separate scheduler instance.
  • If the answer is 'yes', then the user will be prompted about whether the user is willing to make the current instance on which the installer is being applied a scheduler instance.
    • If the answer is 'yes', the installer will perform the necessary configuration changes to make the current instance a scheduler instance.
    • If the answer is 'no', the installer will perform the necessary configuration changes to make the current instance a non-scheduler instance. To get full advantage of this configuration, ensure the non-scheduler instances are part of the load balancer.
Note that the user must select the appropriate option during installation to make the said instance a scheduler or a non-scheduler instance.
If running only a single instance of JasperReports server, then select 'no' when being prompted on separating the scheduler instance as a dedicated instance.
PREREQUISITES
----------- -------------------------------------
- Set the JAVA_HOME environment variable and ensure the correct Java8 executable is present in the PATH environment variable.
- Create a new Jaspersoft Database/Schema before starting the installation and upgrade.
For Upgrades: 
- Export the Jaspersoft content to a zip file (exported from Jaspersoft UI only).
- Take a backup of the existing Jaspersoft instance (the Webapp) and database (Database/Schema).
INSTALLATION/UPGRADE
------------------------------------------------
1. Download the installer from the CA Download Center. Unzip ca_ppm_jaspersoft_<Jaspersoft Version>_<CA PPM Jaspersoft Version>.zip to a folder. For example, ca_ppm_jaspersoft_6.4.2_5.4.2.15.zip. Unzip the installer in the root directory to avoid a long path exception.
2. Run the installer:
a) If on Windows:
Run install.bat
b) If on Linux:
Run chmod u+x install.sh
Run install.sh
------------------------------------------------
Select Installation Type
1) New : This installs Jaspersoft as a brand new installation
2) Upgrade : This upgrades the existing Jaspersoft installation
Enter Apache Tomcat 8.5 Directory: Location on the machine where Tomcat 7 is installed
Enter Jaspersoft Web App Name: The name of the folder where Jaspersoft is being deployed (for example, reportservice).
Enter Jaspersoft Web App Port: The JasperReports server port. The default is 8080.
Email configuration
1) Y : To setup email configuration
a) Enter Mail Server Hostname: Hostname of the mailserver (for example, mail.localhost.com).
b) Enter Mail Server Port: Port number of mailserver (for example, 25).
c) Enter Sender Email Protocol : Protocol that mail server supports. Jaspersoft currently supports smtp and smtps.
d) Enter Sender Email Username: Username of the Mail Sender (for example, test).
e) Enter Sender Email Password : Password of the Mail Sender (for example, password123).
f) Enter Sender Email Address: Sender Mail Address (for example, [email protected]).
2) N : To skip email configuration
Select the Installation Mode
1) Standalone: For standalone servers
2) Cluster: For cluster-based deployments
If you selected cluster mode:
1) Primary Node: Same as standalone installation
2) Additional Node (Web-app deploy only): Just deploys the web app only and uses primary node database/schema
Do you need a dedicated Jaspersoft instance as a report scheduler instance?
1) Yes: Choose this option if you want to have a separate scheduler instance.
2) No: Choose this option if you do not want a separate scheduler instance.
If Yes is selected in the previous step: Do you want to make the current instance as a report-scheduler-only instance?
1) Yes : Choose this option to have the installer perform the necessary configuration changes and make the current instance a scheduler instance.
2) No : Choose this option for instances that are part of the load balancer. The installer performs the necessary configuration changes and makes the current instance a non-scheduler instance.
Select DB Server type:
1) MSSQL
2) Oracle
If MSSQL is selected:
MSSQL Server Hostname: Enter MSSQL server hostname (for example, HOSTNAME)
Do you want to use a named instance?
a) Yes: Choose this if you are using a MSSQL server named instance for the Jaspersoft installation.
b) No: Choose this if you are using a default MSSQL server with a static port number.
If Yes is selected: 
  • Enter the MSSQL Server Instance Name: The named instance configured on the MSSQL server
  • Enter the Jaspersoft Database Name: Jaspersoft database name - default: PPM_JASPERSOFT
  • Enter the Jaspersoft Database Username : Jaspersoft Username - e.g.: PPM_JASPERSOFT
  • Enter the Jaspersoft Database Password : Jaspersoft Password 
If No is selected:
  • Enter the MSSQL Server Port Number : Database port on which MSSQL server is running - E.g.: 1433
  • Enter the Jaspersoft Database Name : Jaspersoft database name - default: PPM_JASPERSOFT
  • Enter the Jaspersoft Database Username : Jaspersoft Username - E.g.: PPM_JASPERSOFT
  • Enter the Jaspersoft Database Password : Jaspersoft Password
If Oracle is selected
1) Oracle Standalone
2) Oracle Cluster (RAC)
If Oracle Standalone is selected:
a) Enter the Oracle Database Hostname : The Oracle server hostname - E.g.: HOSTNAME
b) Enter the Oracle Database Port Number : Database port on which oracle is running - E.g.: 1521
c) Enter the Jaspersoft Database Username : Jaspersoft database - E.g.: PPM_JASPERSOFT
d) Enter the Jaspersoft Database Password : Jaspersoft password
e) Enter the Oracle SID Name: Oracle SID (for example, <ORACLESID>).
If Oracle Cluster (RAC) is selected:
a) Enter the Oracle Database Hostname: The Oracle server hostname - E.g.: HOSTNAME
b) Enter the Oracle Database Port Number : Database port on which oracle is running - E.g.: 1521
c) Enter the Jaspersoft Database Username : Jaspersoft database - E.g.: PPM_JASPERSOFT
d) Enter the Jaspersoft Database Password : Jaspersoft password
e) Enter the Oracle Service Name : Oracle SERVICENAME - E.g.: <SERVICENAME>
3. Confirm the properties that you entered and wait until the installation completes.
4. After the Tomcat service starts, log in to http://<MACHINE_NAME>:<PORT>/<JASPERSOFT_WEB_APP_NAME>. For example, http://jaspersoftserver:8080/reportservice/ using the credentials superuser/superuser.