CA PPM 15.2.0.0 Resolved Defects

The following customer-reported defects were resolved in cappm Release 15.2.0.0.
ccppmop152
The following customer-reported defects were resolved in
CA PPM
 Release 15.2.0.0.
 
CLRT-62402 (S3): No Error When You XOG in a Resource with Date of Termination Before Date of Hire
When you XOG in a resource with a date of termination (DOT) earlier than the date of hire (DOH), you do not get an error.
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. Make the following edit: terminationDate=2011-06-01.
4. XOG in the file you edited.
Expected: To get an error indicating the DOT is before the DOH.
Actual: You do not get an error and the system allows XOG in with the bad date.
Workaround: Manually edit the resource record so the DOT comes after the DOH.
CLRT-78012, DE31167 (S3): Resource Allocations and Assignments report line graphs do not indicate periods when there are zero values
The Resource Allocations and Assignments report line graphs do not indicate periods with zero values. For example, you have monthly allocation data for a resource from January 2015 - December 2015. In the month of August and September, you have zero values. The allocation line graph does not indicate these values but skips those periods. On the X-axis, you find that those month labels are skipped too. This observation also applies to the Assignment line graph.
Steps to Reproduce:
1. Create a Project and Task with duration from 1 Jan 2015 - 31 Dec 2015.
2. Allocate a labor resource to project and task
3. Populate ETC and Allocation for each month except for August and September which should have zero values specified
4. Run the Timeslice and Load Data Warehouse jobs (in the case where you are using Jaspersoft).
Expected: The Line graphs in the report should indicate those periods where the data is zero
Actual: The Line graphs in the report skips those periods where the data is zero just like they do not exist
CLRT-78996, DE31169 (S3): From the Project - Benefit Plans Filter section, the Select Time Period filter doesn't have the Time Period lookup
A lookup that was available in 13.x is not in place for 14.2. The Select Time Period dialog does not have a lookup available to select Period Type. This condition is similar to the New button for benefit plans.
Steps to Reproduce:
1. Open a project.
2. Click Financial Plans tab.
3. Click Benefit Plans link.
4. Expand the Filter section.
5. Click the binocular for the "Start Period" lookup. The look should be like it is when creating a "New" benefit plan. Notice that "Period Type" is available here.
Expected: In addition to "Start Date", "End Date", the "Period Type" should be available to select
Actual: The Period Type isn't available, so it will return all time periods for the Start Date.
CLRT-79209 (S3): When creating a new project based on template, risk tasks associations are not copied over
When creating a new project based on template, risk task associations included in the template are not copied over. The risk is copied over correctly from the template, but its associations to tasks are not. The tasks are copied. No error is seen.
Steps to Reproduce:
1. Create a project.
2. Within the project, create a risk.
3. Within the risk create some tasks
4. Save the project as template
5. Create a new project based on this template
6. The risk is seen as created but the risk tasks are not copied over
Expected: The template risk tasks to be copied over when creating project from template.
Actual: The template risk tasks are not copied over when creating project from template.
Workaround: Add the tasks manually through the button "Add existing tasks"
CLRT-79341, DE28386 (S3): OBS of the project template overrides the Idea OBS when a process converts that idea into a project via a template
Steps to Reproduce:
1. Create an OBS (OBS test) and associate the Project and Idea objects
2. Create a Project template (PROJ Template A) and keep that 'OBS test' value NULL
3. Create an Idea instance with a value on 'OBS test' then 'Submit for Approval'
4. Approve and convert that Idea to a project using 'PROJ Template A'
Expected: Project will be created with 'OBS test' having the same value of the originating Idea
Actual: Project was be created with 'OBS test' having the same value of the originating Idea
5. Create a process that will convert an idea into a project via a template (PROJ Template A) when the Idea Status is 'Approved'
6. Validate and activate that process.
7. Create another Idea instance with a value on 'OBS test' then 'Submit for Approval'
8. Approve the Idea
Expected: Process will create the Project with 'OBS test' having the same value of the originating Idea
Actual: Process created the Project with 'OBS test' having the same NULL value as the project template (PROJ Template A)
Workaround: none
CLRT-79518 (S2): When setting date filters in AdHoc Views, the system changes the selected date
When setting date filters in AdHoc Views, the system changes the selected date. For example, when filtering for projects with a finish date >= 1/1/15, the system will change that date to 12/28/14.
Steps to Reproduce:
A) Login into Clarity
B) Click on Home / Advanced Reporting
C) From the Main Menu, Click on Create Ad Hoc Views
D) From Select Data Menu... Select Investment Managements
E) From the Source window, Expand Investment
F) Select the following " Investment Name, Investment ID, Start Date, Finish Date, Click ok
G) Ad Hoc View change "Crosstab to Table"
H) Drag and Drop the following " Investment Name, Investment ID, Start Date, Finish Date from Filed Menu to Columns
I) Right Click on the Header of "Finish Date", click on add filter
j) Click on the Calender and select the Date
K) Click on Apply
L) The data will populate correctly, but the "Date will change from 2015-12-18 To 2015-12-16"
M) 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: The Date should not change.
Actual: The Date is changing
Workaround: None.
CLRT-79609, DE28428 (S3): Jaspersoft keystore .properties file does not generate on Non-Windows systems when Uppercase or Mixed case is used in Tenant Name
When generating the keystore file, the following messages might appear:
WARN: Keystore not generated in META-INF/reporting/store directory.Error in saving keystore files in Database Generated keystore and its information for organization Name : coprime : orgnaization Id : Coprime in the following location: /app/clarity/config/ , Make them available in Jaspersoft installation in the following directory: <Jaspersoft Tomcat>\webapps\<jasperwebcontext>\WEB-INF\config\
When running Create and Update Jaspersoft Users job:
ERROR 2016-01-07 10:12:08,456 Dispatch pool-1-thread-1 : [email protected](tenant=clarity)niku.njs (clarity:admin:###_ID:Create and Update Jaspersoft Users) Error executing job: 5000128 com.ca.jasper.restAdapter.JasperException: Please pass valid key store details
Steps to Reproduce:
1. On a UNIX system, configure CSA - Reporting to have the Organization Name and ID with Upper case or Mixed case
2. Save
3. Run the command to create Jaspersoft keystore:
admin jaspersoft keystore
Expected: Two copies of keystore files : tenant.jks and tenant.properties to be generated in both $clarityppm/config and $clarityppm/META-INF/reporting/store
Actual: Both tenant.jks and tenant.properties are generated in $clarityppm/config but only one file, tenant.jks is generated in $clarityppm/META-INF/reporting/store. tenant.properties is missing
Workaround:
1. Go to CSA, enter the Organization name and ID fully in lowercase, save.
2. Re-run the admin Jaspersoft keystore command
CLRT-79712, DE28941 (S4):
Basic Group for User Access
 is not getting added when creating the user in the XOG
When a user is created via CA PPM the user will by default get added to the group "Basic group for user access" and will have bare minimum rights, however when user is created via xog the group is not getting added.
This affects all On Demand customers who are behind the portal since the portal adds users to CA PPM via XOG, all users who use the LDAP Synch job to add users as well as anyone that decides to xog new users in via a process, WSDL, or manually.
Steps to Reproduce:
  1. Create an input XML file to create a user via XOG. For example:
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd"> <Header action="write" externalSource="NIKU" objectType="user" version="14.3.0.298"/><Users><User externalId=" " isLDAP="false" uiThemeDefaultPartitionCode=" " userLanguage="English" userLocale="en_US" userName="xoggroup" userStatus="ACTIVE" userTimezone="Europe/London" userType="INTERNAL" userUid="xoggroup"> <PersonalInformation emailAddress="[email protected]" firstName="xoggroup" lastName="xoggroup"/> <Resource resourceId="xoggroup"/><BusinessObjects/><Company/><General addedBy="admin" addedDate="2016-01-25"/> <OBSAssocs complete="false"/> <Groups> </Groups><GlobalRights/> <InstanceRights> <Right id="ResourceEnterTime"> <InstanceObject id="xoggroup" name="Capgemini6, Test6" type="SRM_RESOURCES"/> </Right></InstanceRights><InstanceOBSRights/> </User></Users></NikuDataBus>
  2. XOG in the sample input file
  3. Ensure Group "Basic group for user access" is active in the system
Expected: The user should be created and added to Group "Basic group for user access"
Actual: The user is created but not added to Group "Basic group for user access"
Workaround: Add the group explicitly in the input.xml
However, this will not work for XOG operations where the user has no control of the XOG file like LDAP Synch job users, On Demand Portal users and users who use the GD Resource Adaptor job to create users directly in CA PPM. In these cases, write a GEL script process to locate all new users since the last time it ran and XOG the group in for those users. You can run this script as a job after your job that runs the XOG or on a regular basis.
CLRT-79804 (S3): Financial Status of project can be opened even when the project is inactivated
Close the project for financials and the active check box becomes editable and the project can be deactivated. After deactivating the project, change the status of the financials and only then save the page.
Steps to Reproduce:
1. Log in to
CA PPM
 and navigate to an active and financial open project
2. Change the financial status to closed
3. Now the Active check box becomes editable.
4. Uncheck the box and make the project inactive and on the same page before saving, change the project financials to open
Expected: The system should throw an error because inactive project should not have open financial status
Actual: The system allows to have the financials open even when the project is inactive. The financial drop down says OPEN is NOT AVAILABLE though.
CLRT-79913, DE29580 (S3): User with only project view rights can change the skills for a team role
Users with only view permissions to a project should not be able to make any changes to it. However, navigating to the project team/staff pages and clicking the properties icon for a Role then allows you to make and save changes to the skills. The same is not permitted for any resource on the same project.
Steps to Reproduce:
1. Create a new user, e.g. 'bob'
2. Create a new role, e.g. 'developer'
3. Create a new project, e.g. 'test'
4. Add the 'developer' role to the 'test' project
5. Grant 'bob' project view rights to the 'test' project. Optionally grant the projects navigate right too, or else just copy the URL for the project properties page.
6. Login as 'bob'
7. Navigate to the project properties page (depending on your method from step 5).
8. Go to the Team tab and list the staff members
9. Click on the properties icon beside the role 'developer'
10. Make changes (additions, deletes, etc.) to the skills for 'developer' and save them.
11. Confirm the changes have been made.
Expected: The user should not have been able to edit the team role's skills.
Actual: The user changed the team role's skills.
Workaround: None. Audit Trail does not cover these attributes or pages, so you also cannot monitor for unintended changes.
CLRT-80084, DE29621 (S3): Gantt System Default Filter does not apply automatically when a filter attribute has default Filter value on the View
Gantt filter does not work when a filter attribute has default value on the Gantt Filter View. You have to click Filter in order to apply the Filter.
Does work if you save a filter as a "default filter" that has custom filter settings and access the Gantt. The saved filter is applied when you access the Gantt.
Steps to Reproduce:
1. Login as admin
2. Go to Task object, Views, Gantt Filter, Fields
3. Select All from the Display menu.
4. Select "Task for Actuals" attribute and Click on the Properties icon (Note: You can also use the Milestone attribute which is already on the Filter View.)
5. Set "Default" as "No", check the "Required in Filter" option
6. Click Save and Return twice to come back to the "Views" tab again
7. Now go to Gantt Filter, Layout and add the "Task for Actuals"
8. Click Save and return
9. Now also add the "Task for Actuals" attribute in the Task Properties Edit view
10. Click "Publish" and confirm the changes by clicking "Yes"
11. Go to Home, Projects and open any of the existing projects that have a mixture of tasks that meet the filter you set (if using Milestone, make sure some tasks are milestones and some are not)
12. Go to the Task tab and create a couple of Tasks called "Task 1" and "Task 2"
13. For Task 1, check the "Task for Actuals", and uncheck the same for "Task 2"
14. Save both the changes and Open the project in the PPM Gantt Scheduler
Expected: As per the default filter value for "Task for Actual" attribute, Task 2 should not be visible
Actual: PPM Gantt, does not apply the default filter setting and displays both "Task 1" and "Task 2"
Workarounds:
  • Expand the PPM Gantt filter section, click on filter and then the filter will apply properly and "Task 2" will disappear. (But then there is no point of keeping a default filter.)
  • Define a saved filter with the settings that you want and select the "Default" flag. The saved filter is applied when you access the Gantt.
CLRT-80102, DE30742 (S3): Schema Name Info in DWH_INTERNAL_MD Table Rows Causes Load Data Warehouse Job to Fail if PPM_DWH Database is Refreshed from Another Environment
Full error message from the logs (the attribute list was removed):
ERROR 2016-03-22 15:18:18,744 Thread-2902 dwh.event dwh_db_check_ - An error occurred executing this job entry : Couldn't execute SQL: DECLARE TYPE DIM_REC IS RECORD (...OPEN l_cursor FOR V_SQL_TEXT; 
LOOP FETCH l_cursor BULK COLLECT INTO l_data LIMIT 50000;
FORALL i IN 1..l_data.COUNT
INSERT INTO DWH_INV_PROJECT (ALTERNATE_SCH_REASON_KEY, ...
COMMIT; EXIT WHEN l_cursor%NOTFOUND;
END LOOP; CLOSE l_cursor;
CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_INV_PROJECT','CREATE'); END;
CA ClarityOracle JDBC DriverOracleORA-00942: table or view does not exist ORA-06512: at "PPM_DWH_2.CMN_SAVEDROP_CREATE_INDEXES_SP", line 27 ORA-06512: at line 27
Information in the DWH_INTERNAL_MD table if we run SELECT ddl_statement FROM DWH_INTERNAL_MD WHERE TABLE_NAME='DWH_INV_PROJECT'
CREATE UNIQUE INDEX "PPM_DWH"."DWH_INV_PROJECT_U1" ON "PPM_DWH"."DWH_INV_PROJECT" ("INVESTMENT_KEY") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "DWH_PPM_INDX_DIM"
There is no easy way to recover from this kind of scenario, and provided that the recommended refresh is to refresh both PPM and PPM_DWH, we may run into this problem frequently.
Steps to Reproduce:
1. Run Load Data Warehouse job on one environment, make sure it fails mid-way or cancel it
2. Look in DWH_INTERNAL_MD table
3. Note that most of the records have the schema name hardcoded, example:
CREATE UNIQUE INDEX "PPM_DWH"."DWH_INV_PROJECT_U1" ON ...
4. Take a backup copy of this database, restore on another PPM environment with different schema name, for example PPM_DWH2
5. Query the table DWH_INTERNAL_MD, note the records are exactly the same as in step 3.
6. Run Load Data Warehouse job - Full Load
Expected: Load Data Warehouse job should complete successfully
Actual: Load Data Warehouse job fails with ORA-00942: table or view does not exist, or similar, as it is looking for PPM_DWH schema name, which does not exist anymore
CLRT-80125, DE28835 (S3): Time Zones Are Missing from TimeZoneConstants.properties file
During early ORT testing in the On Demand data center, the SaaS Hosting Team enabled the new UI on one of their testing servers. After entering login credentials and hitting ENTER, the user immediately gets an error "Error during Login". Upon examination of the app log, the Rest API is getting "null" for the server's Time Zone setting.
Below is a comparison of the Time Zone settings
ORT environment:
A. Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
B. TimeZone.getDefault().getId :US/Pacific
Local Test ENV:
A. Java(TM) SE Runtime Environment (build 1.8.0_40-b27)
B. TimeZone.getDefault().getId :America/Los_Angeles
Clarity Uses timezone constant bundle at following location : globdev/src/resource/gwtconstants/TimeZoneConstants.properties
The property file has entry of America/Los_Angeles but not US/Pacific.
So, while getting server timezone, we lookup inside this resource bundle and load our transitioning string for timezones.
Since, ORT environment JRE has sending US/Pacific and not finding a matching entry in the resource bundle , it sending it back as NULL timezone.
Workaround: Change System Time Zone Setting as Americas/Los_Angeles instead of US/Pacific timezone.
A long-term solution might involve updating the resource bundles in
CA PPM
 with new timezone entries.
Steps to Reproduce:
  1. Setup a PPM server with time zone set to US/Pacific
  2. Install PPM 14.4
  3. Enable the 
    New User Experience
     and log in to verify.
  4. Login to Classic PPM. The server timezone will fall back to a default time zone setting. It is unknown what side-effects this will cause for the end user as the user record in Clarity includes a time zone setting. User can login into Classic Clarity.
Expected: New UI allows user to login with correct server timezone
Actual: New UI Login screen throws error message and user cannot login in
Workaround: Change System Time Zone Setting to one of the supported time zones (For example: as Americas/Los_Angeles instead of US/Pacific timezone).
CLRT-80333, DE30782 (S3): Capacity vs Allocation by OBS - Demand does not match the data in Capacity Overview portlet
This issue is intermittent and doesn't happen on every environment.
Steps to Reproduce:
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: Demand total amounts in reports match Demand amounts in the Capacity Overview portlet when similar filter criteria is applied.
Actual: 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-80333, DE30652 (Major Problem): Capacity in Default Reports not returning data (no matching records found)
Continuation of CLRT-80333 work for the rest of the Resource Management reports.
Steps to Reproduce:
 
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 a new OBS unit to the Organizational/All Groups/Business Technologies parent unit as Unit A.
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 Jason Berry's booking manager to Paul Martin.
10. Change Valerie Childers booking status to Hard keeping the current allocation (Team Detail shows 136.00 / 40.00)
11. Change Organizational OBS Unit for the Automated Security Enhancements (PR1016) project to Organizational/All Groups/ Business Technologies/Unit A
12. Run the Datamart Extraction and Datamart Rollup - Time Facts and Time Summary jobs
13. Run the Update Report Tables job and Update Resource Skills Index
14. Run the Update Estimates from Allocation job
15. Run the Investment Allocation job
16. Navigate to the Capacity Planning Overview portlet and change the portlet options to display Hours (by default it displays FTE).
17. 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
18. 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.
19. Run the Load Data Warehouse (Full mode) job
20. Run the Load Data Warehouse Access Rights job
21. 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
22. 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
Expected: Demand total amounts in reports match Demand amounts in the Capacity Overview portlet when similar filter criteria is applied.  
Actual: 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.
After going through the steps described above, the following reports were reviewed:
Capacity vs. Demand by Resource
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit A
Expected: Jason Berry is included
Actual: Jason Berry is included
Capacity vs. Demand by Role
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Investment OBS Type: Organizational
- Investment OBS Type: All Groups/Business Technologies / Unit A
Expected: Jason Berry is included
Actual: Jason Berry is not included
Over/Under Allocation by Resource
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Resource: Berry, Jason
Expected: Jason Berry's allocation in Automated Security Enhancements is included in the remaining capacity calculation and the amounts tie to the remaining capacity amounts in the Capacity vs. Demand by Resource report when we drill down
Actual: Jason Berry's allocation in Automated Security Enhancements is included in the remaining capacity calculation and the amounts tie to the remaining capacity amounts in the Capacity vs. Demand by Resource report when we drill down
Over/Under Allocation by Role
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
- Resource Role: Developer
- Investment Status: Unapproved (Automated Security Enhancements is unapproved)
Expected: Jason Berry's allocation in Automated Security Enhancements is included in the remaining capacity calculation and the amounts tie to the remaining capacity amounts in the Capacity vs. Demand by Resource report when we drill down
Actual: Jason Berry's allocation in Automated Security Enhancements is not included in the remaining capacity calculation and the amounts do not tie to the remaining capacity amounts in the Capacity vs. Demand by
Resource report when we drill down
Resource Allocations and Assignments
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
Expected: Jason Berry's allocation in Automated Security Enhancements is included
Actual: Jason Berry's allocation in Automated Security Enhancements is not included
Resource Assignments by Task
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
Expected: Jason Berry's allocation in Automated Security Enhancements is included
Actual: Jason Berry's allocation in Automated Security Enhancements is not included
Resource Availability - not applicable as it only shows capacity
Resource Baseline vs. Plan by Employment Type
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
Expected: Jason Berry's allocation in Automated Security Enhancements is included
Actual: Jason Berry's allocation in Automated Security Enhancements is included
Resource Forecasted Utilization and Resource Forecasted Utilization Detail
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
- Investment Status: Unapproved (Automated Security Enhancements is unapproved)
Expected: Jason Berry's allocation in Automated Security Enhancements is included
Actual: Jason Berry's allocation in Automated Security Enhancements is included
Resource Skills - not applicable as it does not show capacity/demand/remaining capacity
Resource Skills and Remaining Capacity and Resource Skills and Remaining Capacity Detail
- Resource OBS Type: Resource Pool
- Resource OBS Unit: All Groups
- Booking Manager: Paul Martin
- Investment Status: Unapproved (Automated Security Enhancements is unapproved)
Expected: Jason Berry's allocation in Automated Security Enhancements is included in the remaining capacity calculation and the amounts tie to the remaining capacity amounts in the Capacity vs. Demand by Resource report
Actual: Jason Berry's allocation in Automated Security Enhancements is included in the remaining capacity calculation and the amounts tie to the remaining capacity amounts in the Capacity vs. Demand by Resource report
 
CLRT-80417, DE29846 (S3): MSSQL DWH_PROJECT_V not updated for new attributes when ODF_PROJECT_V cannot be recreated, Load Data Warehouse job fails with Invalid column name message
Load Data Warehouse job error example:
2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - Couldn't execute SQL: MERGE INTO DWH_INV_PROJECT TGT 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - USING 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - ( 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - ... 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - ; 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - 2016/04/05 19:12:45- User Defined Java Class.0- 2016/04/05 19:12:45 - dwh_db_check_ - CA ClaritySQLServer JDBC DriverSQLServerInvalid column name 'DA_IBS_BFA7'.
 
Steps to Reproduce:
1. Use a CA PPM system with many attributes on Project, that go over the 1024 column limit (or use the provided system below with 386 attributes)
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 (full example below)
5. Now run the Load Data Warehouse job - Full Load
Expected: 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: The Load Data Warehouse job is failing with error Invalid Column, when we check DWH_PROJECT_V, we see that the newly added to DWH attribute is not there, no error message is thrown in the app-ca log.
CLRT-80429, DE30421 (S2): Job Schedule Email Link Incorrect
When a customer schedules any default Jaspersoft report and chooses the I
nclude reports as repository links in email body
option on the Notification tab, the link in the email is incorrect and the report doesn't open.
Steps to Reproduce:
1. Login to Clarity PPM -> Advanced Reporting -> Library
2. Right Click on a Report and choose Schedule a Report in Jaspersoft
3. On the Notification Tab, select the Include reports as repository links in email body option.
4. When the email comes in it will have an incorrect link, for example:
  • https://<server>.ondemand.ca.com/reportservice/fileview/fileview/ca_ppm/reports/Custom_Reports/PPM_Clarity_Project.pdf?cappm_standalone=true
  • http://<server>/reportservice/fileview/fileview/ca_ppm/reports/project_management/CSK_PRJ_ProjectStoryboard.xlsx?cappm_standalone=true
The link incorrectly appends ?cappm_standalone=true to the link. If you remove this it works.
Expected: Customer should be able to click on the link and it will bring them directly to the report
Actual: Link doesn't work
Workaround: Remove the ?cappm_standalone=true from the link, or perform the following alternate workaround:
1. Login to Clarity PPM -> Advanced Reporting -> Library
2. Right Click on a Report and select Schedule a Report in Jaspersoft
3. In the Notification Tab - include report files as attachments or ZIP file attachments.
CLRT-80446, DE29618 (Minor Problem): CLRT-80446: After deleting the custom subobject with Parent Object Investment, users receive 500 error when trying to save a project or idea.
Steps to Reproduce
:
1) Create New Subobject with ID=nt_sub_inv and Parent Object = Investment
2) Change ID to field autonumber
3) Create Text field (2000 character max)
4) Add Field to Create/Edit view
5) Open Project
6) Go to new custom object list
7) Create an instance with id=sub1 and save
8) Go to Admin --> Objects
9) Delete Subobject that was just created. You get the Alert: Do you want to delete the objects and items listed below? In Associated Items it shows the instance sub1 (nt_sub_inv). Click on YES
10) Go to the Project (or any other project)
11) Click Save Note: Project Object doesn't have Partition associated.
Expected: User should not receive 500 Error and should be able to Save Projects
Actual: 500 Error message appears. Can not Save any Project
CLRT-80541, DE28628 (S3): Jaspersoft - Time Compliance Report Not Grouping by Correctly
Jaspersoft - Time Compliance Report Not Grouping by Correctly and 3 level OBS is grouped in between.
Steps to Reproduce:
(Using PMO Sample Data)
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: The OBS at level 3 should be grouped together as this was done in BO report
Actual: The OBS at level 3 is moved to Level 2, in this customer case Germany is moved under France which is incorrect.
CLRT-80580, DE28862 (S3): Time Compliance report summary level does not reflect the color coding parameter when running report with two or more OBS levels
The Time Compliance report highlights the compliance column with a colour determined by the compliance threshold parameter. If the report is run for a single level OBS, this appears to work.
If the report is run for two or more levels of OBS, the summary level color does not reflect the color coding parameter or the lower levels.
Steps to Reproduce:
1. Add a labor resources to an OBS unit.
2. Run the Datamart job.
3. Enter Time for the resource and run the Post Timesheet job.
4. Run the 'Load Data Warehouse Access Rights' and 'Load Data Warehouse' jobs.
5. Navigate to Home => Advanced reporting and filter to 'Time Compliance' report.
6. Select the appropriate 'Resource OBS Type' and 'Resource OBS Unit' as well as the Time period.
7. Set 'Compliance % Yellow Threshold' to 90
8. Set 'Compliance % Red Threshold' to 0 (zero)
9. For 'Number of OBS Levels' specify 1
10. Click on 'Apply' button.
11. Report gets displayed with 'Compliance %' value set at 0.11 and 'compliance %' column color is yellow. Value
is greater than zero so display is Correct behavior.
12. Now For 'Number of OBS Levels' specify 2 and Click on 'Apply' button.
Expected: 'compliance %' column color should be set to Yellow
Actual: 'compliance %' column color on the summary level does not reflect the color coding. It show as Red instead of Yellow
CLRT-80614, DE30476 (S2): CA PPM is not exporting dependencies to MSP predecessors column when set to Spanish language (New Driver)
When you have a project in CA PPM with dependencies and you export that info to MSP it's only showing 'Finish-Finish' dependencies in Predecessors column, all others dependencies disappear.
This is happening with MSP 2010-2013 with the new driver and Spanish language.
Steps to Reproduce:
  1. Install the new MSP driver and have MSP 2010 or 2013 in Spanish Language.
  2. In CA PPM, choose Home, Projects.
  3. Select a project with task dependencies.
  4. Export to MSP.
Expected: MSP show dependencies in Predecessors column (In Spanish is called Predecesoras)
Actual: MSP only show 'Finish-Finish' dependencies in Predecessors column (In Spanish is called Predecesoras), all others are missing
Workaround: Work with English language in MSP.
CLRT-80617 (S4): Time-scaled values (TSV) fields do not align with the key column
Although the issue CLRT-79504 has been fixed in 14.3.0.7, there are still some cases (not all) where the TSV does not align properly with the patch installed. See screenshots.
This has been tested in both Teal and gray and Navy blue default UI themes.
Steps to Reproduce:
1. Open a portlet that can contain a TSV. For example, portlets available in Home, Resources, Allocations, or Home, Projects, Project, Team, Staff.
2. Click Configure.
3. Go to 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: All TSV and its legend label are aligned, regardless of having empty (zero-values) or not
Actual: Some TSV are not aligned with the legend and/or with columns that contain zero-values
CLRT-80647 (S3): Portlets developed using Portfolio System provider (portfolio provider) are very slow when there are large number of portfolios when running class file com.ca.clarity.pfm.odf.PortfolioRetrieveService - function PFM_PORT_INV_PH_SUMS_FCT
The portlets which are created using Portfolio Provider as the Data Provider is very slow when there are 100+ portfolios and especially when there are several investments attached to these portfolios.
It takes more than 15 seconds but purely depends on the data.
Steps to Reproduce:
1. Login to a system with 100+ portfolios and at least 50 of them having 100 investments in it and planned cost and budget cost 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
Mouseover Labels: Label and Value
Label Attr: Portfolio Name
Metrics: Series Type: All of them columns
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: The portlet loads in less than 5 seconds in a performant environment
Actual: The portlet takes more than 14+ seconds to load.
CLRT-80663 (S3): ETL incremental job failing with error: {Oracle JDBC Driver]OracleORA-12801: error signaled in parallel query server P007,cannot CREATE UNIQUE INDEX; duplicate keys found
Similar to CLRT-80316, update cost plan multiple times and run Load Data warehouse incremental job. At one point job started to fail with the below error:
ClarityDB - isOracle? - An error occurred executing this job entry : Couldn't execute SQL: BEGIN DWH_FIN_PLAN_PER_FACTS_LOAD( P_DBLINK => 'PPMDBLINK', P_LAST_LOAD_DATE => to_date('2016/06/09 07:25:12', 'yyyy/MM/dd HH24:mi:ss'), P_CURRENT_DIM_LOAD_DATE => to_date('2016/06/09 07:39:15', 'yyyy/mm/dd HH24:MI:SS'), P_ARRAY_SIZE => 50000 ); END; CA ClarityOracle JDBC DriverOracleORA-12801: error signaled in parallel query server P007 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at "PPM_DWH.CMN_SAVEDROP_CREATE_INDEXES_SP", line 27 ORA-06512: at "PPM_DWH.DWH_FIN_PLAN_PER_FACTS_LOAD", line 84 ORA-06512: at line 2
Steps to Reproduce:
1) Create multiple cost plans and run incremental job. - Plans data is updated in dwh dimension and facts tables.
2) Run incremental job and update plan details.
3) Run incremental job and update header.
Expected: Job to Pass
Actual: Job fails when Plan header is updated.
CLRT-80681 (S3): In MSP New driver, when exporting a project from PPM to MSP, incorrect settings in File-> Options are being exported
When exporting a project from
CA PPM
 to MSP, some default settings are not exporting based on what is set for New projects in MSP->File->Options. They appear to be instead exporting from the Microsoft Project system default settings. Settings that do not export correctly (if changed from the out of the box settings) include:
  • In Schedule: Week starts on (should be pulled from PPM, In Administration->Project Management->Settings), Fiscal year starts in, Default task type, Autolink inserted or moved tasks, New scheduled tasks have estimated durations, Inserted projects are calculated like summary tasks, Actual costs are always calculated by project is checked.
  • In Advanced: Edits to total task % complete will be spread to the status date and Calculate multiple critical paths. Example: If you set 'Default task type' to 'Fixed Duration' in MSP Options, if you export a new project from MSP to PPM and create a new task, the task type will incorrectly be set as Fixed Units. This doesn't occur for all settings, some that do retain the information set for new projects include: Updating Task status updates resource status. If you uncheck this setting, it will remain unchecked when exporting a project to PPM.
  • New Tasks created: If you change this to Autoscheduled, it will be retained when opening new projects
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 it 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. Autolink 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: All settings made for new projects in MSP are reflected in project exported from PPM (with the exception of Week starts on: that should be pulling from PPM in Project Management Settings)
Actual: Some settings are exported incorrectly and do not match the changes made in MSP Options (See Description section for full list of incorrect settings)
Workaround:
1. If the project is first created in PPM, export the project from PPM to MSP and update all the settings in MSP-Options. Save the project back to PPM, then each time you export the project after that from PPM to MSP, the settings will be correct.
2. Create the project first in MSP and use Save As to create a new project in PPM. The settings will be correct each time you export the project from PPM.
CLRT-80694, DE29647 (S3): Orphaned records after object deletion
Before it was resolved, this issue was reproduced in 14.4.0 with MS-SQL and in 14.2 with Oracle.
Steps to Reproduce:
1) Create a custom object (primary object)
2) Create a boolean attribute
3) Run this query:
select * from cmn_lookup_types order by created_date desc
4) You will have two records based in custom object / attribute
5) Now delete the custom object
6) Once deleted, execute same query described in step #3
7) Restart CA PPM services
Expected: Records related should be removed
Actual: Records remains after object deletion
CLRT-80715, DE30206 (S2): Invalid Cookie Error Causing Blank White Page in IE post upgrade
After you upgrade (for example, from 13.3 to 14.4), try to access CA PPM without clearing the browser cache or cookies. You will see blank white page unless you clear out the cache and cookies.
Steps to Reproduce:
1. Access CA PPM 13.3 in IE 11.
2. Don't clear browser cookie, cache, or temp files.
3. Upgrade CA PPM from 13.3 to 14.4.
4. Try to access CA PPM 14.4.
Expected: The CA PPM login page opens.
Actual: Blank white screen in IE.
Workarounds:
  • Clear out the cookie and caches in IE.
  • Use Chrome or Firefox.
  • Change the application URL.
CLRT-80768, DE28885 (S3): Timeslicing rollover for odf slice requests (assignment::etccost_curve::dwh_month ) from DWH can take many hours to rollover on MS SQL, even if most of the assignments our outside the slice request range
Currently some timeslicing requests that are added with the DWH can extend the monthly (and weekly) rollover times to many more hours. For example, running the odf_blb_slice_reset_all_sp against prtimeentry with 14 million rows on a very large dataset might take over 20 minutes to complete. Also remember that there is time necessary to change selected statuses to 2 and then back to null.
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: The rollover should not be extraordinarily longer
Actual: 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-80841, DE28873 (S3): GEL Script Process Fails to Validate when &&amp is utilized and comment present in the script
When editing any GEL script, the error messages you see might not suggest that the comment is the trigger or cause; it is possible that you could spend time trying to debug code in a script which has no actual problem.
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 and paste the following test GEL script:
<gel:script xmlns:core="jelly:core" xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" > <!-- --> <core:set var="test" value="hello&world" /> </gel:script>
 
Expected: The process is validated.
Actual: Process does not validate and gives error. BPM-0703: Custom script syntax error at line 11, column 22.
Workaround: Remove the <!-- comment -->
CLRT-80899, DE29320 (S3): Timesheet process with linked resource object ignores post condition on Resource.availability rate
If you create a process with Primary Object: Timesheet, Linked Object: Resource, autostart on update with a start condition of Status = Submitted, and then set up a step with post conditions like:
Resource.thisResource Availability Rate > 0
Resource.thisResource Availability Rate <= 0
The process always goes down the resource.thisResource Availability Rate <= 0 path no matter what the availability rate is. The order of the post conditions does not matter.
This worked in Clarity 13.2.
Steps to Reproduce:
1. Log into Clarity as a user with all rights.
2. Create a User on the admin side of Clarity with sufficient rights to be assigned to a task on a project and to fill out and submit their own timesheet. I gave mine all rights.
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. 
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: The process will go down the process will go down the correct path based on the availability or availability rate set for the resource.
Actual: The process always goes down the path of the <= 0 condition
CLRT-80941, DE28385 (S3): MSP New Driver does not respect Standard Calendar when having resources using mixed Calendars
When having a project with resources using multiple calendars, the Standard Calendar is not loaded as the Project Calendar with the Microsoft Project integration New Driver.
Steps to Reproduce:
In an environment with resources using two calendars (Standard, the actual standard calendar), and another one, with different shift (7.5h), "7.5 Calendar".
1. Create a project in PPM
2. Add resources that have both the "Standard" (standard) calendar and the "7.5 Calendar".
3. Create tasks and assign one resource to each task
4. Open the project in MSP
5. Check MSP > Project > Properties > Project Information
Expected: Calendar shows as "Standard"
Actual: Calendar shows as "7.5 Calendar"
CLRT-80962, DE29521 (S3): Notification Generated after creating a Risk (when any category is selected) has blank values
Notification which gets generated after creating a Risk (when category is selected) has blank values.
Steps to Reproduce:
1. Log in to
CA PPM
 as an administrator. 
2. Navigate to Home-->Projects
3. Open any Project
4. Navigate to Risks/Issues/Changes tab
5. Click on "New" button , to create new Risk
6. Enter all mandatory fields, also select any of the values for "Category" dropdown list.
7. Save the details.
8. Now navigate to Home--> General
9. Click on "Risks" in Notification portlet
10. View the Notification message
Expected: In Message, Respective values should be displayed for all the available fields
Actual: In Message, Blank values are shown for all the available fields
Workarounds:
  • In the listed steps, skip selection of the value for category to see a notification message with appropriate values.
  • A better workaround is to save the Risk after creating it, and then while the user is on the same page select Category value as well and then click on Save or Save and Return. This way users don't have to skip the Category value which means all the necessary values are in place just by using one additional click on Save.
CLRT-80964, DE29590 (S3): The assignment role gets blanked out in PPM when the Update button is used in OWB
The assignment role gets blanked out in PPM when the Update button is used in Open Workbench (OWB).
Steps to Reproduce:
1. Create a project
2. Add a team member
3. Create a task and assign the resource
4. At assignment level associate a role to the resource
5. Open the project in OWB
6. On the project tab, click on the Update button
7. Select options like Status or New Tasks and Assignments and click OK
8. Save the project back to PPM
9. Check the task assignment and check the role field
Expected: The role we associated to be present
Actual: The assignment role has been blanked out
CLRT-80971, DE30489 (S2): XOG Error: Some values are not allowed for XOG-in
The error is noticed when:
1. A dynamic query lookup is coupled to a multi-valued lookup attribute
2. And the dynamic query fetches large amounts of data, typically greater than 50,000 rows
The Xog In, when such an attribute is included in the file, errors out as follows:
<ErrorInformation> <Severity>FATAL</Severity> <Description>com.niku.union.odf.exception.ODFValidationException: CMN-0009: Attribute 'Attribute for Case 00460063 Mark 6' has invalid Lookup Value '18642338'</Description> </ErrorInformation>
And the app-ca.log warns as follows: 
WARN 2016-08-01 07:37:25,575 http-server80-exec-178 persistence.PersistenceResponse (clarity:jeevan:5366061__37EE44A8-5A19-4E56-AF0F-AB31376D10E6:XOG::customObjectInstance::write) Rownum limit of '50000' detected. Attempted to return '1845668'. WARN 2016-08-01 07:37:25,577 http-server80-exec-178 nsql.NSQLQuery (clarity:jeevan:5366061__37EE44A8-5A19-4E56-AF0F-AB31376D10E6:XOG::customObjectInstance::write) Rownum limit reached for NSQL query with id = '5052003' and code = '5052003'.
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. Save with the following Query:
select
@select:id:[email protected],
@select:name:[email protected],
@select:table_name:[email protected]
from cmn_captions_nls
where
6. Create an Object
7. Create an Attribute with Data Type, "Multi Valued Lookup"
a. Couple the above created Lookup to the Attribute
8. Display the attribute in the "Layout:Edit" view
9. Create an Instance of the object
10. Browse for a value with ID such as "18642338", "18644900" etc. on the attribute created above
11. Create a Custom Instance Xog In file. Provide Values picked in step 10 to the attribute mentioned above
12. Xog In
Expected: Xog In happens successfully
Actual: Xog In Fails with an error
CLRT-80987 (S2): Non-Working days Missing in Calendar in MS Project interface
The "Non-Working days" in a Calendar what we see in PPM end are missing when we see the same calendar in MSP.
Steps to Reproduce:
  1. Have one parent calendar with some (say, 2) additional non-working days apart from the available weekends.
  2. Create a child calandar, having base calendar as the parent calendar what we have referred above.
  3. Log in to 
    CA PPM
     as an administrator.
  4. Create one MSP project.
  5. Add a resource under team and have the parent calendar attached to the resource. 
  6. Open the created project in MSP, we could see the 2 additional "Non-working days" in MSP calendar.
  7. For the same resource, attach the child calendar and save the details.
  8. Open the project in MSP, and verify the child calendar in MSP..
Expected: We should see the 2 additional "Non-working days" in for the child calendar in MSP.
Actual: 2 additional "Non-working days" are missing for the child calendar in MSP.
CLRT-80992 (S3): Default values are not populated in filter portlet fields when persist checkbox is enabled on more than one tab
This issue can occur when you configure the same filter on different tabs and each tab shows different filter fields. When on one tab, only Filter Fields in that tab are read into temporary session and rest of the values are not populated in to session. And when we navigate to next tab, it check in the temporary session for this filter and any values configured as it is available it doesn't make an attempt to read from DB. Hence as it is a lookup it tries to populate the top most value that is shown in the list.
Steps to Reproduce:
1. Navigate to Portlets and create a new Grid portlet with instance type 'General' and Data provider 'Project'
2. In List column layout select: 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 of Display type : Pull down and with 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, Create Tab1 and add 1st Grid Portlet
11. Navigate to page filters and add Filter portlet created in step 8.
12. Select 'Persist' option.
13. Click on Filter Mappings and only map 2 fields. (Ex: Track mode, manager)
14. Create Tab2 and add 2nd Grid portlet.
15. Navigate to page filters and add Filter portlet created in step 8.
16. Select 'Persist' option.
17. Click on Filter Mappings and only map 2 fields. (Ex: Investment type, status)
18. Create Tab3 and add 3rd grid portlet.
19. Navigate to page filters and add Filter portlet created in step 8.
20. Do not select 'Persist' option.
21. Click on Filter Mappings and only map 2 fields. (Ex: status, Manager)
22. Change Layout for all tabs by moving filter portlet upwards.
23. Navigate to 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 home menu
26. Click on Tab 1 and verify the filters fields and verify list displayed as per the filters applied.
27. Click on Tab 3 and verify filters and list displayed are correct.
28. Now navigate to Tabs and verify the default filters displayed.
Expected: Filter fields should populate with default values
Actual: Filter fields populated with first value in dropdown list
Workarounds:
  • Specify a user-defined default filter on the filter portlet. The end-user can select the preferred filter options on the filter portlets under each tab that the defaulting is not working correctly. The end-user will need to create a saved filter on the filter portlet and make that saved filter the default filter, so the proper defaulting will be applied for the filter portlet when you access that tab.
  • For the tab that is access when you enter the page, display all of the filter attributes so it gets cached. If you place all of the filter attributes on the filter portlet for the default tab when entering the page, all of the filter attributes will get cached so if you go to the other tabs on the page, the defaulting should work properly.
CLRT-81009, DE28865 (S2): Some Jaspersoft permissions get overwritten when content is upgraded to a higher clarity version
During release upgrades to 14.4 or 15.1, csk content upgrade might overwrite permissions set in advanced reporting. Only those permissions that were set back to the default/inherited permission will be lost.
Steps to Reproduce:
1. In 14.4, with the csk content import, clarity sets
No Access
permission to ROLE_USER on the
CA PPM
folder
2. Change this permission to
Read Only
(an inherited permission)
3. Migrate the tenant to 15.1 and run csk content upgrade
Expected: After migration, permission for ROLE_USER on "CA PPM" folder should be
Read Only
Actual: After migration, permission for ROLE_USER on "CA PPM" folder is "No Access"
CLRT-81011, DE28864/DE30696 (S2): Load Data Warehouse job fails with database lock ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
This is an intermittent issue that most often occurs on Incremental Load. You might see the following error on DWH_RES_RESOURCE_LN but we have seen other tables too:
Couldn't execute SQL: ALTER TABLE DWH_RES_RESOURCE_LN ENABLE VALIDATE CONSTRAINT DWH_RES_RESOURCE_LN_FK1 CA ClarityOracle JDBC DriverOracleORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Once we get this issue, it's impossible to fix unless the DBA manually removes the lock. Sometimes during the night as it runs off peak hours, and that means one day with no updated data in DWH). The job shouldn't be locking itself. Any subsequent Incremental or Full will fail until the locked session is removed.
Steps to Reproduce:
1. Schedule an Incremental Load Data Warehouse job few times per day
2. Check the job status in the Jobs - Log page
Expected: The job to complete successfully every time.
Actual: 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.
Workarounds:
  • Contact the DBA to manually remove the lock from the specified table, then run Load Data Warehouse job - Full Load
  • To avoid the locks from happening in future ask the DBA to run the following script on the DWH database:
    BEGIN FOR J IN (select INDEX_NAME from USER_INDEXES where INDEX_NAME like 'DWH%') LOOP EXECUTE IMMEDIATE 'ALTER INDEX '|| J.INDEX_NAME || ' NOLOGGING NOPARALLEL'; END LOOP J; END;
CLRT-81032, DE29309 (S3): Jaspersoft Resource Time Summary and Detail Report Issues
Jaspersoft Report: Resource Time Summary and Detail Report has two separate issues.
1) The summary report repeats the latest timesheet hours for each line in the report. For instance, if you select 3 periods of posted timesheets with hours chronological by date as 25,35,40. Each line of the summary report will show 40 hours.
2) Clicking on entry on the summary report to bring up detail then requires you to enter an OBS on the detail report. This is not a required field on the summary report and all parameters should automatically pass from the summary to the detail.
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
For Issue #2
  1. Click on the link for one entry to bring up the detail report.
  2. Observe that parameters are not passed and OBS is required on this report.
Expected: The report shows correct hours on each line of the summary report.
Actual: The report shows the same hours for each line of the summary report.
CLRT-81039, DE29670 (S3): The Clear button in filter section of Resource Instance Access Right does not clear the value of Description field
The Filter of Description field in Resource Instance Access Right is working, but the Clear button does not clear the value of Description field.
Steps to Reproduce:
1. Go to Administration/Resource/select any resource/Resource's Access Right/Instance
2. Set any value to description field in Filter section. For example, set "ABC" to description field.
3. Click Clear button in filter section. The value of description field will not be cleared.
Expected: Clear button clears Description field value.
Actual: Clear button does not clear Description field value.
Workaround: Clear the description field value.
CLRT-81046, DE29583 (S3): Timesheet Period Page filter does not work if the Display Type is Browse on the Timesheet Overview Page
Steps to Reproduce:
1. Go to Home > Timesheet Overview
2. Click on the binoculars on the Timesheet Period page filter at the top of the page
3. Select any period and click on Add
Expected: The period shows on the filter field
Actual: No Period is shown on the filter field
4. Ignore the fact that it is blank (as this behavior so far is similar to the behavior on the portlet filter on PMO-1057)
5. Click On Filter
Expected: The 'Investment Timesheet Summary' and 'Timesheet Details' only show results for the Timesheet Period selected in Step 3.
Actual: The portlets are not filtered. The results remain the same as before we selected a Timesheet Period to filter on the page filter.
Workaround: Change the Display Type of the Filter to Pull-Down. (The out of the box Display Type for this filter field is Browse.)
CLRT-81068, DE29232 (S3): Microsoft Project (new driver) replaces non-latin chars with question mark characters when importing the project
If using non-Latin alphabets (such as Japanese, Chinese, or Russian) in task names in MSP (new driver), when the tasks are imported to MSP the characters are replaced with question marks (???). If the project is saved, those question mark characters are saved as well overwriting the original task name.
If the task was created in MSP using non-Latin chars, the task is saved correctly. The problem only occurs during import, not during save.
Steps to Reproduce:
1. Create a project with a task in Japanese, Chinese, or Russian alphabet.
2. Open it in MSP using the new driver
Expected: Task shows in Japanese characters
Actual: Task will show as ??????. If the project is saved, those ?????? will be saved as well overwriting the original task name.
CLRT-81072, DE29683 (S3): Unable to filter by FilterByCustomInfo when XOGing out projects if Using more than One FilterByCustomInfo
When attempting to use custom attributes to filter a XOG data pull, the filter conditions seem to get ignored past the first condition. The first <FilterByCustomInfo> tag is considered in the read but the remaining ones ignored.
Steps to Reproduce:
1. Login to CA PPM as administrator.
2. Navigate to Administration->Objects and open the project object.
3. Create 2 custom attributes, one of type number and another one boolean.
4. Place them on the project list so you can easily see which projects are expected to come back.
5. Run a test using the prj_projects_read_custom.xml XOG file.
6. Notice that only projects that come back are the ones from the first line FilterByCustomInfo and any other criteria after that is being ignored.
Expected: All criteria with FilterByCustomInfo should be taken into consideration
Actual: Only first like with FilterByCustomInfo is used for filtering
CLRT-81073, DE29685 (S3): When we select task and click Save and Exit button on schedule dashboard portlet then the window does not close
When we select task and click save and exit button on schedule dashboard portlet, the window does not close. We can use ' save' and 'close' button.
Steps to Reproduce:
1. Login to PPM and go to Project Dashboard. Locate the tasks under projects.
2. Click one of task and we can see the task window. This window shows 'Save and Close' and 'Close' and 'Save' button.
3. When we click 'Save and Close' button then the window does not close.
Expected: When we click 'Save and Close' button then the window closes.
Actual: When we click 'Save and Close' button then the window does not close.
Workaround: Click 'save' button and after that click 'close' button.
CLRT-81081, DE28534 (S2): Upgrade to 14.4 and higher Checkinstall fails on MSSQL 2012 SP3 and higher as Unsupported version
Full error message:
check-db-version.xml ERROR The database version could not be validated as a member of the supported versions. Current database info: Microsoft SQL Server 2012 (SP3-CU3) (KB3152635)
11.0.6537.0 (X64) Apr 28 2016 17:57:34 Copyright (c) Microsoft Corporation Enterprise Edition:
Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Check the checkinstall.log for connection errors. Refer to the Product Architecture Stack (PAS) for supported database versions
In the scripts we can see it checks for:
value="11.0.5*ENTERPRISE EDITION*||12.
ENTERPRISE EDITION
||11.0.5*DEVELOPER EDITION*||12.
DEVELOPER EDITION
"/>
Steps to Reproduce:
1. Take PPM 14.2. with MSSQL 2012 SP3 (which is a supported version)
2. Make sure all the upgrade prerequisites are met
3. Start the upgrade to 14.4 and higher
Expected: Upgrade to execute successfully
Actual: Checkinstall fails with error message: check-db-version.xml ERROR The database version could not be validated as a member of the supported versions.
Workaround:
1. Open the file check-db-version.xml with a text editor
2. On Line 16 correct the value from:
value="11.0.5*ENTERPRISE EDITION*||12.
ENTERPRISE EDITION
||11.0.5*DEVELOPER EDITION*||12.
DEVELOPER EDITION
"/>
to:
value="11.0.6*ENTERPRISE EDITION*||11.0.5*ENTERPRISE EDITION*||12.
ENTERPRISE EDITION
||11.0.6*DEVELOPER EDITION*||11.0.5*DEVELOPER EDITION*||12.
DEVELOPER EDITION
"/>
3. Save the file and re-run the upgrade
CLRT-81083, DE29308/DE30695 (S3): Financial Budget vs. Forecast by Period Detail report only returns data for Project Investments
The documentation states that "The investment must have at least one financial plan for the investment to display in the report." Nowhere on this report description does it specify that the only investments that this should work for are the projects.
Steps to Reproduce:
1. Create an Financially enabled Idea (1/1/2016-12/31/2016)
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 step 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 Step1 and 4
8. Also, run the 'Financial Budget vs. Forecast by Period' report with Financial Plan Group By 1 as Resource
Expected: The Idea and the Project are both included in the report results. Both resources are included in the parent report.
Actual: Only the Project is included in the report results. Only one resource is included in the parent report.
CLRT-81086, DE29318 (S2): OBS XOG performance decreased after upgrading to 14.3 and above causing CPU to spike on application server
Fixes in Clarity 14.3 and above to carry out tests during the updating of the OBS by XOG to avoid problems such as orphaned records or circular references can create a processing overhead on a large OBS that costs much more than the original operation pre-upgrade.
For example, an OBS with 100k units (possible and reasonable for example, if your OBS is an org chart) that took 0.75 to 2 hrs pre-upgrade can now take 8 to 12+ hours post-upgrade to XOG in.
Post-upgrade the operation will max out the application server CPU as the tests cause the performance to become CPU-bound. Since this lasts for many hours, the performance can potentially impact other users and operations during the same timeframe too.
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: 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: The duration of the second XOG attempt is many times the duration of the first and the CPU is maxed out for hours
CLRT-81104, DE29582 (S3): No hierarchical filtering for Roles
The meaning of the filter mode for the Primary role can be confusing. Some users expect it to work similar to the OBS filter, where
unit and descendants
would show all resources with child roles of the selected primary role. The standard filter can throw an error 500 when selecting
unit and ancestors
.
Steps to Reproduce:
1. Create Role A
2. Create Role B with parent role "Role A".
3. Create some resources which have Role A or Role B
4. Go to the Resource list
5. Configure the Primary Role to the filter.
6. Filter for Primary Role "Role A" and select "Selected and descendants"
Expected: All resources with primary role "Role A" and "Role B" are displayed.
Actual: Resources with "Role A" as primary role are shown.
CLRT-81113, DE29158 (S3): Incremental Load Data Warehouse Job deleting all hierarchical levels above 2, from DWH_INV_HIERARCHY table
Data above Hierarchy Level 2, is deleted from DWH_INV_HIERARCHY table when Load Data Warehouse job is run in Incremental Mode.
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
5. Now, run the "Load Data Warehouse" job in "Incremental Mode"
6. Check DWH_INV_HIERARCHY table (in the DWH Schema) for the Hierarchies created in Step 2
Expected: The Hierarchies are still present
Actual: The Hierarchies above level 2 are deleted
CLRT-81134, DE29132 (S3): New UX - Can't change the project banner color
When trying to change the project banner color in the New UX, the color changes on the project, but it doesn't save. When you go out of the project, the color reverts back to the original color.
Steps to Reproduce:
1. Log in to the
CA PPM
 
New User Experience
 as a project manager.
2. Open a project in which you are the project manager.
3. Go to Project Details and scroll down to project banner color.
4. Change the color. Verify that you see color change on banner.
5. Go to Home or project list.
6. See that color has reverted back to the original color.
Expected: Color should be saved when it is changed.
Actual: Color looks like it changes, but it is not saved when you exit the project.
Workaround: Add the access rights for the Status Report object. The banner color gets saved.
CLRT-81135 (S3): Integration Adaptor resource manager field not getting updated through integration file loader
Not able to update the resource manager field through integration file loader. The file has value in managerUserName, but the Integration file loader is not updating the resource manager field in
CA PPM
. We can verify the updates do occur correctly using the XOG.
Steps to Reproduce:
  1. Integration Adaptor setup for customer.
  2. Referencing the documentation for the integration adapter, provide managerUserName as one of the fields to be applied.
Expected: All the details mentioned in the file should get updated for the resource.
Actual: resource manager field not getting updated through OTB integration file loader, even when the file has value in 'managerUserName' value
Workaround: Use XOG or set the field through the user interface.
CLRT-81152, DE30384 (S3): Attributes with default values that are xogged in cannot have their default values edited or deleted
If you XOG in an attribute with a default, that default value cannot be deleted or edited on the target server.
Steps to Reproduce:
1. Create a custom object
2. Create a string attribute on that custom object with a default value
Attribute Name: test_default
Attribute ID: test_default
Data Type: String
Default Value: default
Maximum Size: 100
3. Xog out that object
4. Xog it into another environment or in the same environment.
5. Go back to that attribute that you created in the custom object
6. Edit or delete the Default Value
Expected: Default Value is edited or deleted accordingly
Actual: Default value cannot be edited or deleted accordingly
Workaround: Execute and commit the following statement on the database
delete from odf_default_overrides where object_code='<object>' and attribute_code='<attribute>'
CLRT-81172, DE29890 (S2): Task List in New UX gets removed when navigating away from task list or collapsing and expanding the task list
The following errors might occur in the
CA PPM
 
New User Experience
.
  • Could not update task property
    error even when the changes are getting reflected in the task.
  • Selected tasks from the list are removed when navigating away from task list or collapsing and expanding the task list.
Steps to Reproduce:
1. Log in to the
New User Experience
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 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: The tasks should remain selected.
Actual: Selected task is blanked out.
CLRT-81205 (S2): When using IE 11 the cursor does not get automatically placed on the first editable field
When using IE 11 the cursor does not get automatically placed on the first editable field.
Steps to Reproduce:
1. Log in to 
CA PPM
.
2. Go to studio > objects > project object > views > projects (list filter) layout.
3. Set the Default Filter State to expanded.
4. Log out.
5. Using Chrome or Firefox log in and get to the project list.
6. The cursor gets placed on the first available field on the project list.
7. Do the same using IE11.
Expected: The cursor gets placed on the first available field on the project list.
Actual: The cursor is not placed anywhere and you need to click on it.
Workaround: Click on the element you want to edit in the filter.
CLRT-81212, DE29104 (S2): ODF Object Creation/Save fails with a system error when an attribute based on the investment object that is being audited on another investment based object is deleted
It appears that since attributes cannot be directly set for auditing on the Investment object itself, the attribute deletion code is not checking to see if the field in question is being auditing on any other investment based object.
Once this broken for one object, none of the investment based objects can be saved or created in the system until the audit is cleared. Regardless of which object is actually auditing the field, this affects projects, ideas, assets, applications, other work, services, and products.
The software introduced a check not to allow deletion of any attribute as long as the attribute name could be found among audited attributes. This meant that if an attribute with the same name was audited in any object, deletion would be prevented. This check was too restrictive. We widened the check to only prevent deletion of attributes where the attribute name and object code matched. This made the check too narrow as it would not take into account object extension. We would like to amend the check against odf_audited_attributes to include usage of attributes of objects that extend the object that we try to delete the custom attribute from.
Steps to Reproduce:
1) Create a custom attribute on Investment
2) Add the custom attribute for audit for Project and Asset objects
3) Create and Save a Project and Assert. Ensure both operations are successful
4) Try and Delete the custom attribute. Verify that attribute can't be deleted.
5) Remove the custom attribute from auditing from both Project and Asset
6) Create and Save a Project and Assert. Ensure both operations are successful
7) Delete the attribute from investment object and verify that the attribute can be successfully deleted.
8) Create and Save a Project and Assert. Ensure both operations are successful
Expected: The object to be created/updated
Actual: The action fails: System error: Contact system administrator
Workaround:
  1. Check on the log files the trigger that is causing the issue
  2. Clear out the audit of the affected object: project on this case 
  3. Drop the trigger that is causing the issue on the DB 
  4. Re-enable the audit in the project object
CLRT-81244, DE29155 (S2): Task deletion via new user experience causing API-1004 error
Steps to Reproduce:
1 - Login to CA PPM.
2 - Go to Projects and create a new one from template, using CO-Tire Project Template
3 - Eg: NICO CAMSO Project
4 - Click at Home / Link to New User Experience
5 - A new popup is opened and click at header project name
6 - Click at TASKS option and create a new task and click at 'Add'
7 - Tasks is created, now select it and click the Remove icon
8 - The message error received is: "API-1004: Invalid resource identifier 5053009
Expected: delete the task without message error
Actual: API-1004: Invalid resource identifier 5053009
CLRT-81264, DE29229 (S3): Lookup Value Weighting option at Portfolio Ranking Rules displays all values of Lookup
The issue can be replicated with any lookup (use any lookup where you can create new items and also deactivate items for test purpose).
This case could be controlled if in 'Lookup Value Weighting' page at Portfolio can exist a filter for filter by 'inactive' or 'active' status
Steps to Reproduce:
1) Create a Portfolio
2) Go to Waterlines Tab
3) Click at 'Define Ranking Rules'
4) Primary Constraint: 'Planned Cost'
5) Click at 'Add' button
6) Filter by 'Portfolio Capacity Unit Type' (could be other lookup attribute)
7) Click at 'Add'
8) At the right side click at 'Lookup Value Weighting' link/option
9) After that all values from this lookup will be displayed, no matter if are inactive
10) Navigate at Lookups and access to this lookup (Lookup ID: PMA_CAPACITY_UNIT_TYPE)
11) Click at 'Values' Tab, and create new items and inactive others repeat these steps and always all values will be displayed
Expected: Displays only active values at lookups
Actual: Displays all values no matter if the value is inactive
CLRT-81293, DE29504 (S3): Capitalization % Not Using Default Value
After setting the Capitalization % to a Default Value in the Team object, that default value is not being defaulted when a resource is added to a Project Team through Transaction Entry. It does get defaulted correctly when manually adding a Resource to a Project Team.
Steps to Reproduce:
1. In the Team object, set the Capitalization % attribute to "100%".
2. Choose a Project and a Resource that are Financially enabled.
3. Make sure the selected Resource is not already in the Team tab of the selected Project.
4. Add a Transaction through Transaction Entry using the selected Project and Resource.
5. Run the Post to WIP job.
6. Run the Import Financial Actuals job.
Expected: The selected Resource is added to the Team tab of selected Project with a default Capitalization % of "100%".
Actual: The selected Resource is added to the Team tab of selected Project with a Capitalization % of "0%".
Workaround: Capitalization % can be manually set to
100 percent
.
CLRT-81296, DE29165 (Major Problem): CLRT-81296: Privilege escalation in POST projmgr.resourceObjectSelectionList
This security issue was resolved.
CLRT-81328, DE29526 (S3): Jaspersoft Missing Time Report's Calculate Missing Time Based on Timesheet Status input control does not appear change the report output
Jaspersoft Missing Time Report's Calculate Missing Time Based on Timesheet Status input control does not appear change the report output. When running the report and getting output then selecting this input control nothing appears to happen.
Steps to Reproduce:
1. Log into Clarity
2. Select Advanced Reporting
3. Click View List for the reports.
4. Click on the Missing Time report
5. Enter sufficient information into the input controls that will bring back data while leaving the Jaspersoft Missing Time Report's Calculate Missing Time Based on Timesheet Status unticked.
6. Click the Apply button to get output.
7. Once the output is displayed tick the Calculate Missing Time Based on Timesheet Status input control
8. Click the Apply button again
Expected: The Missing Timesheet output should be based on the TimeSheet status
Actual: Nothing happens the report output remains the same.
CLRT-81330, DE29509 (S2): Timesheet displaying dates in US format instead of UK format (or vice-versa)
The timesheet date format for each day of the week shows up as US format (mm/dd) rather than UK format (dd/mm) despite changing the Locale to English (United Kingdom). 
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.
6. Open a timesheet.
Expected: 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: 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.
CLRT-81346, DE29476 (S2): MSP - Project does not save back into clarity from MSP
When a project is opened in MSP and saved back into clarity, MSP hangs and the project never gets saved.
Steps to Reproduce:
  1. Login to Clarity
  2. Create a top level project - Top Level Project
  3. Create a subproject under this project - Subproject
  4. Add resources to this Subproject (make sure to add the resource which is financially active)
  5. Create a Task under the Subproject - Task to test MSP
  6. Assign this Task to the resource
  7. Go back to the Top Level Project and Click on "Open in Scheduler" open this project in MSP in read/write mode. 
  8. With or without making any changes to the project in MSP, click on CA PPM Integration Tab and Save the project.
Expected: The project should save and Project Saved Successfully Message should be displayed
Actual: MSP keeps trying to save the project with and stays at "Sending XML data to PPM" and eventually hangs and needs to be killed.
CLRT-81350, DE29511 (S2): Material and Expenses roles change their ETC when opened in MSP
Material and Expenses roles ETC is changed when opened in Microsoft Project. Labor and Equipment is not affected by the same. When saving the project, the new ETC values from MSP will also be saved in PPM.
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 project in MSP using the new driver
Expected: ETC for all roles is 70
Actual: ETC for Material and Expenses is 69.
CLRT-81351, DE29514 (S2): "Select Fiscal Time Period" from GL Allocation Details returns 401 Unauthorized error unless resource has "Financial Maintenance - Financial Organizational Structure" right
Trying to select a Fiscal Time Period on GL Allocation Details returns an 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.
If the right "Financial Maintenance - Financial Organizational Structure" is added, this does not happen, but this right is administrative and allows modifications to several aspects of PPM.
Steps to Reproduce:
1. Create a new resource.
2. Create a new project and make resource from Step 1 the Project Manager. Make the project Financially Open.
3. Assign the resource the following instance rights for the project:
3a. Project - Edit Chargebacks Information
3b. Project - Edit Financial
3c. Project - Edit Management
4. Assign "Projects - Navigate" global right
5. Go to the project > Chargebacks > Debit Rules, and create a new Debit Rule
6. Open the debit rule to get to the "GL Allocation Detail List", click "New"
7. Click the Fiscal Date Picker from Start or Finish attributes in the Percentage section
Expected: The available Fiscal Periods are shown.
Actual: Error 401 - Unauthorized is show.
Workaround: Grant "Financial Maintenance - Financial Organizational Structure" right, but this right is too wide and allows other administration tasks to be performed.
CLRT-81355, DE29513 (S3): The word 'to' is missing between dates of an attribute that is configured as a date range within a filter view
the word "to" is missing between dates in Date Range Filter
Steps to Reproduce:
1. Log into CA PPM the go to Home > Projects
2. Go to Options > Configure
3. List Filter Section tab then Layout
4. Move the 'Start' attribute from Available to Selected
5. Save
6. List Filter Section tab then Fields
7. Click on Properties icon for Start attribute
8. Change Display Type to Date Range
9. Save and Return button
10 Click again on Save and Return button
11. Refresh the project list page
Expected: You see the word 'to' in between the Start attribute date range
Actual: The word 'to' is missing.
CLRT-81389 (S2): NSA bind address is not working
Bind address is not properly picked so causing some side effects
  • Config changes not reflecting
  • Security right changes are not reflecting
  • Messages are not picked on event
Steps to Reproduce:
1> Have bindAddress as public IP (non system IP address)
2> And start the beacon,bg and app services
Expected: All services should bind to same ip address
Actual: Some of the services are bind to local IP address
CLRT-81402, DE29674 (S3): Incorrect Start Schedule % on Key Task & Milestone Status Report
The "Start - Schedule %" field is not being calculated correctly on the Key Task & Milestone Status report in Jaspersoft. The "Start - Schedule %" is correct when the Status of the Task is "Not Started". When the Status of the Task is "Started", the Start Days Late is "0", but the Schedule % is showing Red or Yellow, but it should be Green since the Task is not late (Days Late = 0).
The Schedule % is calculated correctly on the Business Objects version of the Key Task & Milestone Status report.
Steps to Reproduce:
1. Create a project without a Baseline and with at least one task.
2. Make sure the Task Status is "Started" and the Task Start Date should be any date in the past. The Finish Date can be in the past or future.
3. Run the Load Data Warehouse job with Full Load.
4. Run the Key Task and Milestone Status report with only the one project selected.
5. Test with a project with and without baseline.
Expected: The "Start - Schedule %" indicator is green for all tasks that have "Started" and the Start Date is in the past.
Actual: The "Start - Schedule %" indicator is either red or yellow for all tasks that have "Started" and the Start Date is in the past.
CLRT-81413, DE29676 (S2): Trusted Publisher Certificate for CA PPM MSP Interface is Expired
The Trusted Publisher certificate that is packaged with the CA PPM MSP Interface is expired. This appears to affect versions of PPM 14.3/14.4 and we have been unable to verify if 15.1 if affected. This is being seen in the new driver.
The dates noted on the certificate are that it is valid from 10/2/2014 up until 10/3/2016. The certificate is also being designated as "This certificate has expired or is not yet valid" when viewed during the installation of the CAClarityAddIn.VSTO component of the interface. This may be an issue when the certificate is being verified for a valid digital signature during the installation process..
Steps to Reproduce:
1) Install the CA PPM MSP Interface to a workstation
2) Verify the three components have installed
3) Remove the CAClarityAddIn from the Programs and Features list
4) Reinstall the CAClarityAddIn by running the setup.exe within the addIn folder (The path will look something like C:\CA\PPM\CA PPM MSPInterface\addIn)
5) Upon being prompted with "Are you sure you want to install this customization?", click on the CA, Inc. publisher link
Expected: The displayed certificate is valid and non-expired.
Actual: The certificate is expired and invalid. However, the add-in installs correctly.
CLRT-81421, DE29852 (S3): PPM 15.1 PMBOK spanish language: process action item notification subject not translated to spanish for several processes
PMBOK Spanish language: process action item notification subject not translated to Spanish
For the notification of an action item message within a process, a "translation" icon is seen for the subject but when clicking on this only English text is seen for all languages.
Steps to Reproduce:
1. Install the PMBOK add-in.
2. Go to Process: In this example: "Lessons Learned Review" | Step: Notify PM Review - Manual Action Properties
3. Click on translate Icon of Action Item Message - Subject
Expected: Subject name to be translated for each language, specifically spanish for example.
Actual: Subject name shown in English for all languages
Workaround: Translate the text manually.
 
CLRT-81422 (S3): PPM Log Descriptions
We need a description for the logs and what process creates the log file. The existing product documentation is missing many of the log types. When we look at the logs created by CA PPM we don't know what some of them are for or from what process. The documentation gives an explanation for a few of the CA PPM logs, but we are looking for all to be listed.
Steps to Reproduce:
  1. Search for PPM Log descriptions.
Expected: We should have a document that lists all the Log Descriptions.
Actual: We don't have all the PPM Log Descriptions.
: To view the log descriptions, see CSA: Maintain and Monitor CA PPM.
CLRT-81429, DE30027 (S2): Beacon service throwing ClassNotFoundException
This issue occurs when a properties migration is required during the initial start of the service.
Steps to Reproduce:
  1. Upgrade from release 14.2 to 14.4.
  2. Service start beacon
Expected: Beacon Service should start without any error
Actual: ClassNotFoundException thrown and service is not starting
CLRT-81445, DE29851 (S3): Project Storyboard Report shows Equipment Actual Qty in Labor Hours
On the top section of the Project Storyboard report where it says Labor Hours, the Actuals include QTY from Equipment type resources. If this is truly Labor Actual Hours as the heading suggests, Equipment Resources should not be included. If this should show all actual QTY (not just hours) it should also include Material and Expense type resources.
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 Import Financial Actuals job
  9. Run Load Data Warehouse 
  10. Run Project Storyboard report for your project
Expected: Only labor hours show on the top of the report
Actual: Labor and Equipment type Resource hours show on the report.
CLRT-81494, DE30535, DE30876, DE31582 (S3): LONG HYPHEN IS REMOVED IN MSP (Issues saving projects back to Microsoft Project)
Long hyphen character or em dash (—) copied from Microsoft Word and pasted into a CA PPM task is removed when exported into MSP. Sometimes when this character is exported into MSP, hyphen is replaced with '#x4'
Steps to Reproduce:
1. Open Microsoft Word Document
2. Copy and Paste Aa - aa
3. Login to Clarity
4. Create a New Project
5. Create a New Task by pasting 'Aa - aa' in task name
6. Save and Return
Expected: The letters are successfully saved in Clarity
7. Open Project in MSP
Expected: Project opens successfully.
Actual: Project opens in MSP however, the long Hyphen is removed and everything that follows it.
Workaround: Use short hyphen – and not a long hyphen —.
CLRT-81498, DE30203 (Major Problem): CLRT-81498: Authentication Error in the New UX that blocks the user from logging into the New UX
Old UserContext is still in user's local storage, and this is passing the wrong api-next-string to the login call. We are getting 401 error with payload, meaning that the api-next-string validation is failing. Credentials are correct.
Steps to reproduce
:
  1. Login as a valid user.
  2. Close the browser tab or browser window.
  3. Wait until the ppm session times out.
  4. Open the same browser, and navigate to /pm
  5. Login page appears, but POST login is failing
Workaround: Clear browser cache, refresh page, login works normally.
CLRT-81533, DE30545 (S2): A Security Vulnerability
This security issue was resolved in this release.
CLRT-81547, DE30551 (S2): Jaspersoft - Please wait message disappears when report run in same session by changing the parameter
Please wait message disappears when report run in same session by changing the parameter. A fix is provided by Jaspersoft. See also KB TEC1356347.
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 1st page
3. Change the filters by selecting more or reducing the data and then click on apply button to generate the data
Expected: Please wait message should be there on screen till the 1st page of report loads
Actual: The problem is since the Please Wait message goes so quick user feels the report is generated but actually its not.
Workaround:
1. Navigate back to Repository
2. Go to reports and run it again with different set of parameters
CLRT-81595, DE30649 (S2): Project XOG allows creation of duplicate tasks by ExternalID
A project xog containing a <Task> entry with a "taskID" attribute value equal to an existing task (or another task in the XOG) but WITH A DIFFERENT CASE, allows the task to be created. This results in multiple tasks on the project with the same taskID (externalID) but with different case. This is blocked in the UI (case insensitive match).
Steps to Reproduce:
  1. Create a project in Clarity and add a task:
    name = T1
    ID = T1
  2. Create a project input xog for the project. For the task, change the taskID=t1
  3. XOG in the document
Expected: An error (in xog output and app log) and NOTHING is updated or inserted (for example, rollback)
Actual: A second task is created on the project with ID = "t1"
CLRT-81630, DE30926 (S3): Microsoft Project (new driver) replaces non-latin chars with question mark characters when importing the project
CLRT-81640, DE31299 (S3): Two additional equal (=) signs on Portfolio Properties and List pages from 15.1
Two additional equal (=) signs on Portfolio Properties and List pages from PPM 15.1
Steps to Reproduce:
1. Login to CA PPM 15.1.
2. Go to Home --> Portfolio Management --> Portfolios
3. In the portfolio list page, there is a note below: = Currency = USD
4. From the List page, open any of the Portfolios.
5. In the Properties page, scroll down and see the notes below.
Expected: Currency = USD and WorkEffort = Hours
Actual: '= Currency = USD and = WorkEffort = Hours
CLRT-81641, DE31179 (S2): Via XOG I Can not update Attribute: Platform of Application instance with a User-defined values.
I am able to add the User-defined values in the OOTB Lookup: Platform (ID: INVESTMENT_APP_PLATFORM). I am able to change the value of OOTB Attribute "Platform" of an Instance of Object "Application" to a User-defined value. However, via XOG I am unable to change the value of OOTB Attribute "Platform" of an Instance of Object "Application " to a User-defined value .
XOG output shows:
<Severity>FATAL</Severity> <Description>Error :0:0: attribute "platform" has a bad value: the value is not a member of the enumeration. Invalid attribute in input document. Please remove all instances of attribute from document elements and try again.Application, Attribute : platform.
 
Steps to Reproduce:
Object: Application
OOTB Attribute: Platform
Data Type: Lookup - Number
Lookup: Platform
OOTB Lookup: Platform
ID: INVESTMENT_APP_PLATFORM
Hidden Key: LOOKUP_ENUM
1. Admin side - Lookups. Open OOTB Lookup: Platform
  Add some User-defined values
2. Home - Application. Open or create a new instance.
For Lookup: Platform Select a User-defined value
3. XOG out the Application instance
4. XOG it in (without changing anything).
Expected: You should be able to change the value of OOTB Attribute "Platform" of an Instance of Object "Application" to a User-defined value .
Actual: XOG fails with FATAL error. When you add the User-defined values in the OOTB Lookup: Platform, you must enter a numeric value in the ID. When you try to enter a text in the ID (like the system values), you get an Error: Incorrect number format.
XOG output:
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd"> <Object type="application"/> <Status elapsedTime="0.0 seconds" state="FAILURE"/> <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/> <ErrorInformation> <Severity>FATAL</Severity> <Description>Error :0:0: attribute "platform" has a bad value: the value is not a member of the enumeration. Invalid attribute in input document. Please remove all instances of attribute from document elements and try again.  Application, Attribute : platform.  </Description> <Exception type="java.lang.Exception">Invalid xml data</Exception> </ErrorInformation> </XOGOutput>
 
CLRT-81658, DE31174 (S2): Resource termination date cannot be removed via XOG
Termination date cannot be removed using XOG by adding a null in the termination date attribute. Earlier releases such as 13.3 allowed it.
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. XOG-out 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"
Expected: Work the same as in 13.3: the termination date is removed
Actual: XOG returns FATAL Error - This record has not been inserted. java.text.ParseException: Unparseable date: "null" .... // The termination date stays unmodified
CLRT-81720, DE31993 (S3): PPM CORS
This security issue was resolved in this release.
DE28388 (Major Problem): CLRT-79338: IE 10 and 11 do not allow print view in Jaspersoft
See also KB TEC1188322.
Steps to Reproduce:
1. Home
2. Advanced Reporting
3.Create Dashboard
4.Expand organization
5.Expand CA PPM
6. Ad hoc views
7. Ad hoc reports
8. Drag and drop Ad hoc view
9. Expand ''Special Content'
10. Expand Dashboard controls
11. Drag and drop ''print view''
12. Save.
13. On dashboard select ''View list''
14. Select a dashboard
15. click on 'print view'
Expected: The print view is displayed
Actual: The print view page is not displayed.
DE28435 (Major Problem): CLRT-79492 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: The portfolio to be synchronized
Actual: Error 401 - Unauthorized. You are not authorized to view the page. Still the portfolio is synchronized
Workaround: Give the user the Portfolio - Edit All access right
DE28532 (Major Problem): CLRT-80393: XSS Vulnerability found when creating/saving a task on the gantt page.
This security issue was resolved in this release.
DE28533 (Major Problem): DE28533: A Platform Security Issue
This security issue was resolved in this release.
DE28625 (Major Problem): CLRT-81099: A Platform Security Issue
This security issue was resolved in this release.
DE28626 (Major Problem): CLRT-81096: A Platform Security Issue
This security issue was resolved in this release.
Steps to Reproduce
:
1. Using IE11, login to 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 OOTB report and observe that Jaspersoft screen is either in background or minimized again
Expected: Jaspersoft does not minimize browser window automatically or hide behind open screens on your desktop
Actual: Jaspersoft minimizes browser window automatically or hides behind open screens on your desktop
 
DE28960 (Major Problem): CLRT-81012: Patch 15.1.0.1 SSO OD Portal User does not get redirected to Portal Staging Login screen after logging out
This issue was resolved as part of other work.
DE29166 (Major Problem): CLRT-81297: Securability - Privilege escalation
This security issue was resolved.
DE29167 (Major Problem): CLRT-81298: Securability - XOG
This security issue was resolved.
DE29168 (Major Problem): CLRT-81299: Securability - Privilege Escalation
This security issue was resolved.
DE29578 (Crash/Data Loss): CLRT-81414: Jaspersoft syncPPMContext command 
This integration security issue was resolved.
DE29579 (Major Problem): CLRT-79899: Cost Plan Time Scale Settings cause TSV data to appear in the wrong cells first time accessing the a cost or budget plan
When configuring the TSV to use a Rolling Date, a non-zero Time Period Offset causes data to appear in the wrong TSV cells. When configuring the TSV to use the Cost Plan's Start date, a non-zero Time Period Offset is ignored and not used at all, however when initially configuring and saving this type of configuration, you may see a yellow alert message if trying to use a negative Time Period Offset.
Customers using regular calendar dates for their Monthly Fiscal Time Periods might have many investments that start more than 1 year into the past. They have configured the Time Scale settings so that the plan shows current TSV Cells for reviewing data on submitted Budget Plans. These are executives and when they log into the application and they go into the Plan's Detail List they see numbers that appear to be incorrect, because the numbers are shifted and appearing in the wrong periods
Prerequisites:
Entity with Monthly Fiscal Time Periods that use regular calendar dates that span over a couple of years
For demonstration purposes, I created a set of Fiscal Monthly periods From Jan 2015 thru Dec 2017
For demonstration purposes, the STR references the Cost Plan Detail List Time Scale Settings, however you can replicate the same behavior for Budget Plans as well because the Budget Detail List uses the same Time Scale Settings configuration as the Cost Plan Detail List
Steps to Reproduce
:
1. Create a Project
Set the Dates of the Project to span dates like SEPT 2015 thru OCT 2016
Pick a Department OBS Unit associated with the Entity
Set up Financial properties for Rates
2. Add some Team Members to the Project
3. Make sure the Cost Plan Detail TSV is using the stock TSV Configuration settings for now so you can set up your Cost Plan
Default TSV Settings :
Start Date = Other Date : Cost Plan's Start Date
Time Scale = Other Time Scale : Period Type
Number of Time Periods = 6
Time Period Offset = 0
4. Create a new cost plan and enter in meaningful numbers that are easy to see the issue demonstrated
For example in my tests, I created a cost plan that spans from SEPT 2015 thru OCT 2016
In the TSV Cells for period 1 (SEP 2015) I entered in 100, for period 2 = 200, period 3 = 300 and on to the end
This makes it easy to see the issue reproduced
5. Take screenshots so you can use this to compare to the data seen when the TSV configuration changes
6. Change the 'Configuration' of the Time Scale Virtual Attribute (do not change the session settings)
Start Date = Rolling Date : Current Month
Time Scale = Other Time Scale : Period Type
Number of Time Periods = 6
Time Period Offset = 0
Click 'Save and Return' button
Return to the Detail List and it looks good - take a screenshot of this page
7. Log out and Log in again and navigate back to this Project, Cost Plan Detail page (do not use a bookmark)
Everything looks good
8. Change the 'Configuration' of the Time Scale settings
Start Date = Rolling Date : Current Month
Time Scale = Other Time Scale : Period Type
Number of Time Periods = 6
Time Period Offset = -1 or any negative number
Click 'Save and Return' button
Return to the Detail List --- The numbers do not look like they are in the right cells
9. Log out and Log in again and navigate back to the cost plan ; the data does not appear as expected
10. Click the CA PPM 'Refresh' icon in upper right navigation bar or alternatively go to the Cost Plan Properties Tab and then back to the Detail tab and the TSV cells are refreshed as expected
- Now the data appears correctly
11. Change the 'Configuration' of the Time Scale settings
Start Date = Rolling Date : Current Month
Time Scale = Other Time Scale : Period Type
Number of Time Periods = 6
Time Period Offset = 1 or any positive number
Click 'Save and Return' button
Return to the Detail List --- The numbers do not look like they are in the right cells
12. Repeat the steps with any non-zero Time Period Offset when the Start Date is using any type of 'Rolling Date' - the issue can be reproduced
13. Repeat the steps with any non-zero Time Period Offset when the Start Date is using the Other Date Cost Plan's Start Date and the Time Period Offset is ignored
Expected: Initial Financial Plan display should show data in the correct periods
Actual: Initial Financial Plan display is showing data in the WRONG period and to correct this, the user has to click 'Refresh' or navigate off the list and then back onto the list
Workaround: Do not use attribute references for the start and time period if you want to use an offset. Use the date macro or a specific date and specify a specific period (Year/Month/Quarter) and then the offset works as expected.
DE29603 (Major Problem): CLRT-80873: XOG writes Project's "Investment Class" in UPPERCASE instead of actual (upper/lower/mixed) case
Steps to Reproduce
:
1. Go to Administration > Financial > Setup > Classifications > Investment Classes
2. Create a new Investment Class with "Investment Class" = "Standard" (respect uppercase and lowercase characters)
3. Create a new Project or open an existing one
4. Go to Properties > Settings > Financial > Investment Class
5. Choose "Standard"
6. Run the following query:
SELECT class FROM pac_mnt_projects WHERE id = xxx (use the Project's Internal ID instead of xxx)
It will return: Standard
7. XOG out the Project
8. XOG in the Project - unmodified
6. Run the following query:
SELECT class FROM pac_mnt_projects WHERE id = xxx (use the Project's Internal ID instead of xxx)
Expected: It will return: STANDARD. From now on, transactions will complain that "No rate was found for this transaction" (even if the rate exists, due to STANDARD != Standard comparison)
Actual: It will return: Standard
Workaround:
1. Re-choose the Investment Class from PPM UI after updating the project via XOG.
or
2. UPDATE pac_mnt_projects SET class = 'Standard' WHERE id = xxx (use the Project's Internal ID instead of xxx
DE29640 (Minor Problem): CLRT-80596: Unable to save a project from MSP (legacy driver) when the subprojects share the same role
Steps to Reproduce
:
1. Create a project called sub1
2. Add the architect role as a team member
3. Create a project called sub2
4. Add the architect role as a team member
5. Create a master project and add the above two projects as subprojects
6. Open the project in MSP using the legacy driver. Note there are duplicated roles
7. Save the project back to Clarity
Expected: The project to be saved successfully
Actual: The project can not be save and it throws an error: Invalid Role {XXX} on assignment for task XXX
DE31300 (Major Problem): CASUP-662: Input controls loading page gets stuck intermittently
To resolve this issue, information was provided to CA Support.
DE31418 (Major Problem): PPMSAAS_14.4_CASUP: Creating a new Risk on a project does not generate a notification. 
Steps to Reproduce
1- Login to PPM as an admin user
2- Home > Portfolio Management > "Projects / SE / LODO"
3- Select any project.
4- Navigate to the "Risks/Issues/Changes" tab.
5- Click "New" button to create a new risk.
Fill out the required fields. Save.
6- Navigate to the Home menu > Organizer > "Notifications" tab
Note: there are no Risk notifications.
7- app-ca.log will show the following exception:
ERROR 2017-01-09 04:53:41,851 [pool-10-thread-5] notification.Notification
(clarity:admin:58691374__E43E68D5-1EEA-2F3109CF2395:none)
java.lang.NullPointerException at com.niku.union.notification.Notification.sendAutoNotification(Notification.java:192)
Expected: Notification is generated when creating a Risk without exception.
Actual: Notification is NOT generated and exception is thrown.
DE31488 (Major Problem): CLRT-81123: "Value is too large" error when saving changes in staff member properties view, if resource manager field is visible and 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: Changes to be saved
Actual: Error is received: "Value is too large". Changes are not saved
Workaround: Hide the Resource Manager field on the view
DE32410 (Major Problem): CLRT-81411: Proposed ETC at Assignments list - display in Hours, but input treated as Days
  1. Go to 'Administration' -> 'Settings'
  2. Set the 'Default Display Unit for Work Effort' to 'Days'
  3. Click 'Save'
  4. Logout of CA PPM and log back into CA PPM.
  5. Click on 'Home' -> 'Projects' -> Go to a project i.e. project name: 'm_Test Project'
  6. Click on 'Tasks' tab -> go into a task i.e. task name 'Task 1' 
  7. Click on 'Options' icon -> 'Configure' -> make sure you have 'Proposed ETC' in the 'Selected Columns' under 'List Column Layout' menu.
  8. Go to 'List Options' and set the 'Work Effort of Unit of Measure' to 'Hours'
  9. Click 'Save And Return'
  10. Log out and log back into CA PPM
  11. Go back into task name 'Task 1' Properties screen
  12. You will see the following displayed at the bottom of the screen: 'Work Effort=Hours' 
  13. Enter 1 hour for the 'Proposed ETC'
  14. Click Save.
Expected: For 'Proposed ETC' to display 1 (as in 1 hour)
Actual: 'Proposed ETC' displays 8, this is misleading, this means 8 hours but it should display 1 hour as 1 hour is configured for the 'List Options' and the Work Effort displays Hours on the bottom of the screen too.
DE29834 (Major Problem): CLRT-81416: Securability: XML External Entity
This security issue was resolved.
DE29835 (Major Problem): CLRT-81380: Privilege Escalation
This security issue was resolved.
DE30229: XOG Developer Guide WSDL FlushCaches and FlushAllCaches Options are not supported and should not be listed
This defect has been fixed in the documentation source for XOG going back to 14.3 and all higher releases.
Steps to Reproduce
:
  1. In docops.ca.com, locate the XML Open Gateway Developer Guide section on WSDL.
  2. Under the InvokeAction section, FlushCaches, FlushAllCaches, and FlushObjectCViews options are listed even though they are not supported because of problems using these actions can cause.
  3. The same thing is true of the page for WSDL under Invoke Actions, for example: http://<servername>/niku/wsdl/InvokeAction?
Expected: These options should be removed from the documentation because they are no longer supported.
Actual: Listed in documentation.
DE29836 (Major Problem): CLRT-81379: Privilege escalation
This security issue was resolved.
 
DE29839 (Major Problem): CLRT-81427: MSP XML Driver does not honor task dates for a fixed duration task with 0 hrs work
Steps to Reproduce: 
1. Create a project in 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 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.
 
DE29925 (Major Problem): CLRT-81479: CA PPM 14.3 SaaS Should Not Force Users to Log Into Public DOCOPS.CA.COM Pages When They Click Help
See also CLRT-80474.
Steps to Reproduce
:
1. Login to CA PPM OD Portal or SaaS link with federated, enterprise or standard portal SSO.
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.
Workaround: Each user can create a basic ca.com user account with username and password. A CA account preserves SSO. Another option is to navigate to docops.ca.com/ppmod before logging in to CA PPM through the CA On Demand portal.
Note
: This bug has been resolved for 15.2 and higher. All PPM SaaS users with SSO are provided access to docops.ca.com/ppmod when they click Help or open a new browser tab after already logging into the CA On Demand portal. 
DE30047 (Major Problem): CLRT-81353: Security.logs does not display app-ca.log.# files
This was caused when invalid xml characters end up in the logs. The cause of this issue for the customer is very likely com.niku.union.gel.XMLOutputBuffer. To resolve the reported issue, we added protection in the log viewer to strip out invalid XML characters.
Steps to Reproduce:
The following steps are valid only if one of the log files being accessed has invalid XML characters in it.
1- Login to 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...
  The entire page will refresh.
  The app-ca.log.# will not be displayed.
  The following error will be displayed in the app-ca.log file:
Expected Result: app-ca.log.# files are all view-able in the UI through security.logs
Actual Result: app-ca.log.# files are NOT all view-able in the UI through security.logs
Alternate steps to reproduce:
1- Login to PPM as admin
2- Access the security.logs.
3- Select app-ca.log.2
4- Select the "Max Size" as "1m"
5- Click "Go"
Result: the log file will not be displayed.
You will receive a popup error:
PPM X : ! ERROR
[en - Unable ro process request - Server or
Network error] [Close]
6- Click Close on the popup.
7- Click Download to download the admin.log.zip.
8- Select "Log File" as "app-ca.log.3", Max Size "1m"
Click "Go"
Result: Same error popup as above.
9- Click "Download"
Result: Wrong log file is downloaded. It downloads the admin log again.
Steps to Reproduce
:
1. Take back of one DWH Schema from Production
2. Restore the DWH schema to Test
3. Compile the schema
Expected: All views should be compiled
Actual: Around 14 views are not compiled. 
Workaround: For every refresh, the DBA needs to correct the view manually. Edit the views and update the DB link to the correct DB links.
DE30218 (Major Problem): CLRT-80986: APM Aggregated Calculated Attributes do not work on the portfolio
Steps to Reproduce
:
1. Add the APM ACAs to the portfolio investment attribute registry - Value Score, Technical Score, Risk Score
2. Go to an application portfolio and add the three ACAs to the waterlines view.
3. Sync portfolio
4. Check waterlines. The fields are there but the values are not populated.
5. re-create one or more of the ACAs exactly and then add that new ACA to the portfolio attribute registry
6. Add new ACA to portfolio waterlines view and sync.
7. Check waterlines, the values populate for the new ACA but still not for the existing ACAs.
Expected Result: Values should populate for the existing APM ACAs
Actual Result: They do not, but they do populate for an exact copy.
Workaround: Create copies of the ACA
DE30477 (Major Problem): CLRT-81543: Unable to fetch parentId for null running a process
Steps to Reproduce
:
1) Create a sub-object from Project
2) Create a dynamic lookup linked with Incident object. Use this query:
SELECT @SELECT:ii.id:[email protected] from IMM_INCIDENTS ii where @[email protected]
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 at' Add Primary Object' and select the custom object created in first step, click at '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' checkbox 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) Verify that each process has an error to execute
Expected Result: Run successfully
Actual Result: The process displays a message error
DE29006: After you create an attribute, you cannot remove it from the object. You can only deactivate it.
An error appeared in the CA PPM Studio documentation.
Steps to Reproduce
:
  1. Open the CA PPM Studio Developer content on docs.ca.com.
  2. Navigate to the Prerequisites for Custom Object Development section.
Expected: Documentation states that you can remove a custom attribute from an object.
Actual: Documentation states "After you create an attribute, you cannot remove it from the object. You can only deactivate it."
This error was resolved in the CA PPM Studio Development pages on docops.ca.com.
 
DE30494 (Major Problem): CLRT-81170: Emails not sent from Process Notifications sections
Steps to Reproduce
:
  1. Connect Application Server to a Mail Server
  2. Create a Process 
    1. On the "Start" step, under "Notifications" section, Check all the attributes, and put your name there 
    2. Please make sure to connect "Start" step to the "Finish" step 
  3. Trigger the Process
    1. The above steps are to reproduce whether emails are triggered or not from "Notifications" sections. Action Items still send emails and it is not the object of this bug. Emails are also sent from Gel Scripts.
    2. The number of "Process Steps" do not matter. All "Notifications" sections exhibit this behavior. Steps is where the "Notifications" section is easily accessible. "Notifications" sections on Action Items can also be used.
    3. Notifications must be enabled to send Emails, under "Account Settings"
Expected Result: Email is received when the Process enters and goes out of the Start Step
Actual Result: Email is not received
DE30518 (Minor Problem): CLRT-81529/ CLRT-81135: Integration Adaptor - resource manager field not getting updated through OTB integration file loader
Steps to Reproduce
:
  1. Integration Adaptor setup.
  2. Refer to the documentation for the integration adapter on docops.ca.com/ppmod.
  3. Provide managerUserName as one of the fields to be applied.
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
Workaround: Use xog or set the field through the UI
DE30734 (Major Problem): DEFECT for CASUP-561: Stale data in Fiscal slices on the PPM side - 00350608
Steps to Reproduce
:
  1. prj_fiscal_blb_slices only
  2. Create a entity to use for DWH
  3. Create a set of fiscal periods for 8/1/2016 - ...
  4. Create a set of fiscal periods for ... to 8/1/2016
    This step puts the pk of biz_com_periods out of order.
  5. Create a project for 6/1/2016 - 8/31/2016.
  6. Create an allocation for same time frame
  7. Query the slices for that team id
  8. Move the allocation using staffing properties to 8/1/2016 - 10/31/2016
    The grid shows the allocations have moved to the correct location.
  9. Run time slice and query the fiscal slices.
Expected: The first 2 periods should be deleted.
Actual: The first 2 periods are still there.
Alternate Steps to Reproduce
:
1. Assign some resources to a project.
2. Check the value on Top Down Planning of Resource Planning.
3. Run Load Data Warehouse job.
4. Check the value on Jasper adhoc report.
Select Create -> Adhoc View and choose Resource management under Domains.
Select Resource from Source and move to selected fields.
And click the Crosstab button.
I can see the New Adhoc View.
Drag and drop  "Fiscal Month" to Columns field.
Drag and drop  "Investment Name" to Rows field.
Drag and drop  "Resource Name" to Rows field.
Drag and drop  "Team Allocated FTE" under Measure to Columns field.
Click the Measures.
Right click Investment name and select Create Filter.
And select the project name on the filter.
Right click Staff OBS Unit and select Create Filter.
Select "equals" on Staff OBS Unit Filter and select "is one of ".
Click Apply button.
I can see FTE value for each user on a project.
This is same as the value on Top Down Planning of Resource Planning.
5. Change the allocation term for a resource. For example: 
Before 
From 2016/06/01 - TO 2016/08/31
After
From 2016/08/01 - TO 2016/10/31
6. Check the value on Top Down Planning of Resource Planning.
I can see that the value is removed for the term of deletion or changing.
7. Run Load Data Warehouse job.
8. Check the value on Jasper adhoc report with same steps.
Expected: The deleted allocation shows the correct value (0.00). The changed allocation shows the correct value (0.00) and not the same value (1.00).
Actual: The deleted allocation shows the correct value (0.00) but the changed allocation does not show the correct value (0.00) and still shows the same value (1.00). 
Workaround: None. Even if you run Load Data Warehouse job with Full Load option then the result is same.
 
DE30906 (Major Problem): CLRT-81600: In MSP New Driver, As Of date is deleted when the project is saved back to PPM
In the new MSP driver, As of Date is deleted in
CA PPM
 when the project is saved back to
CA PPM
Steps to Reproduce
:
1. Add the 'As Of' field to the project list layout:
a. Click the Options icon
b. Click Configure
c. Move 'As Of' from Available Columns to Selected Columns, then click 'Save and Return'
2. Create a project in PPM with required fields
3. Navigate back to the project list and populate the 'As Of' field with a date (in this example, 11/30/16), then click Save
4. Click on the link to the project and navigate to the Tasks tab or Properties tab
5. Go to 'Open in Scheduler' -> 'Microsoft Project [Read-Write]' to open the project in MSP
6. Save the project back to PPM (no changes need to be made to the project in MSP)
7. Navigate back to the Project list page and observe the 'As Of' field for the project (Be sure to refresh the page to see the change post save)
Expected: As Of date of 11/30/16 still shows
Actual: As Of date field is blank
Workaround:
Create a mapping between MSP and PPM for the 'As Of' date field:
1. In PPM, go to Administration->Project Management->MSP Field Mapping
2. Click New to create a new map and add the following information:
- Object Type: Project
- Data Operation: Import And Export
- Clarity Attribute ID: prAsOf
- MSP Field Name: Date10 (or any date field not currently being used)
3. Click Save and Return. When you save projects back, the As of Date remains.
 
DE30971 (Major Problem): Front PORT: CLRT-81533: XSS Vulnerability (Add Documents)
This security issue was resolved.
DE30982 (Major Problem): CLRT-81590: Pre-check Installation fails while executing Check Timezone script if the database server is GMT timezone in MS SQL Server
Steps to Reproduce
:
1. Change the operating system of MS SQL or use an MS SQL Database server in UTC
2. Unzip the 15.1 install.jar on the Clarity Application server
3. Jar xvf install.jar
4. From Checkinstall folder, run checkinstall.bat
5. Follow the prompts, you will receive the error described above.
Expected: Checkinstall can deal with UTC timezone or no GMT offset
Actual: Checkinstall fails
Workaround:
1- Navigate to the <Install Media>\checkinstall\ folder
2- Modify .\checkinstall\checkinstall-config.xml to comment out this line as shown below:
<!-- <checkscript filename="check-timezones.xml" operations="UPGRADE" environments="OP" phases="BEFORE" bypass="false"/> -->
3- Run the install.bat to proceed with the upgrade.
 
DE31039 (Major Problem): CASUP-659: PPM Proxying between different ports breaks Jaspersoft
A manual fix has been identified if you experience this exception when trying to open a report. Information is available to fix this situation until a more complete resolution can be identified, built, tested, and delivered in a future release.
Steps to Reproduce
:
1. You have a URL in DWH attribute longer than 125 chars. It creates an addition ProfileAttribute something like 'dwhDBServerURLAttr1_enc'
<database id="Datawarehouse" useURL="false" jndiDatabaseId="jdbc/DatawarehouseDS" vendor="mssql" serviceName="" serviceId="ppm_dwh" instanceName="" driver="com.ca.clarity.jdbc.sqlserver.SQLServerDriver" url="jdbc:clarity:sqlserver://<name>:<port>;DatabaseName=ppm_dwh;InsensitiveResultSetBufferSize=0;ProgramName=Clarity" host="<host_name>" username="ppmdwh_user" password="xxxxxx" schemaName="ppm_dwh" clarityDBLink="PPMDBLINK" isCustomDBLink="false" upgradeStatus="upgradeNotNeeded"/>
2. Assume for any reason on subsequent updates that the URL is shortened to less than 125 chars. The old additional attribute continued to exist which is getting concatenated.
3. Because of the attribute value being incorrect, the connection is not getting established and report is not running.
Actual: Unable to run the report because of incorrect database connection, on one server this is the problem seen.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "ppm_dwhdicated)))" requested by the login. The login failed. ClientConnectionId:e2663112-3b02-4a08-b0d2-987fb35f259a
Expected: You should be able to run a report without any errors.
Workaround:
This string
dicated
appears because of an additional profile attribute
dwhDBServerURLAttr1_enc
.
  1. Log-in as superuser
  2. Remove that profile attribute.
  3. Restart the reporting server.
Profile attribute maximum length is 125 characters. You might have a database URL longer than 125 characters, for example:
jdbc:clarity:sqlserver://<name>:<port>;DatabaseName=ppm_dwh; InsensitiveResultSetBufferSize=0;ProgramName=Clarity
The application splits the long string into multiple profile attributes
dwhDBServerURLAttr1_enc
and
dwhDBServerURLAttr2_enc
.
DE31112 (Major Problem): CASUP-656: Difference in OBS Filter Mode Option listed in List Pages and OOB Portlets but different in OBS System Lookup
Information is now available to resolve this issue.
Steps to Reproduce
:
  1. Log in to 
    CA PPM
    .
  2. Click Home, Resource Management, Resources.
  3. The filter for OBS Unit has 3 options: 
    1. Unit Only
    2. Unit and descendants
    3. Unit and ancestors
  4. Compare with the lookup. Click Administration, Data Administration, Lookup, Lookup ID for OBS_UNIT_ASSOCIATION.
    1. Unit Only
    2. Unit and descendants
    3. Unit and ancestors
    4. Unit, descendants and ancestors 
Information is available because users were confused by their own perceptions of expected and actual behavior. Consider the following points:
  • The OBS Unit - Filter Mode drop-down is not related to the OBS_UNIT_ASSOCIATION lookup in any way. The OBS_UNIT_ASSOCIATION lookup is used in places like Resource: OBS Unit Access Rights page.
  • The OBS Unit - Filter Mode drop-down alone is not configurable as part of a filter view. Whenever the OBS Unit field is configured to be part of the filter view, this drop-down is automatically added by the view generation XSLs. The options in the drop-down are also hard-coded at XSD level and do not depend on any lookup.
  • If you expect to see this drop-down as part of a filter that you are building, add the OBS Unit field to the filter.
DE31177 (Major Problem): CLRT-81650: When we create a custom sub object for project and delete it and try to create again with same id then we have an error : odf 20000.
A database or metadata change resolved this issue.
Steps to Reproduce
:
1. Create a sub object under project object. Create an attribute on the sub object.
2. Create instance for the sub-object.
3. Delete the sub-object. For example, confirm that you cannot see the sub-object on the object list.
4. Try to create a sub-object under project object with the same object name and object id.
Expected: You can create a sub-object under the project object with the same object name and object ID.
Actual: Error : odf 20000.
Workaround: Create a sub-object with a different object ID.
DE31228 (Major Problem): CLRT-81687: Timesheet notes are not displayed in new user experience UI when the timesheet imported through XOG
In new user experience UI Users are unable to view timesheet notes which are imported through XOG. If timesheet notes are created in the UI they are displayed fine.
Steps to Reproduce
:
1. In the UI I entered:
Time Period= 2016-12-19 - 2016-12-26
Resource Name = Ron DeMedeiros
Timesheet Status= Open
Investment= "Project 1.68"
task Name="Callibrate TrackMan"
"2016-12-19" = 5.00
Enter a Note with Text="xxxx"
2. XOG out the timesheet using prj_timeperiods_read.xml :
<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
<Query>
<Filter name="start" criteria="BETWEEN">2016-12-16, 2016-12-25</Filter>
<Filter name="resourceID" criteria="EQUALS">demre01</Filter>
</Query>
</NikuDataBus>
3. In the UI delete the Note
4. Use the XOG output from step 2 and XOG it in:
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
<Header action="write" externalSource="NIKU" objectType="timeperiod" version="15.1.0.149"/>
<TimePeriods>
<TimePeriod finish="2016-12-26T00:00:00" openForTimeEntry="true" start="2016-12-19T00:00:00">
<TimeSheets>
<TimeSheet ID="5028001" lastModified="2016-12-27T13:18:55" resourceID="demre01" status="0" version="7">
<TimeSheetEntries>
<TimeSheetEntry assignmentEstimate="0" assignmentEstimateAfterTimePeriod="0" assignmentEstimateForTimePeriod="0"
assignmentFinish="2016-08-31T17:00:00" assignmentID="5002000" assignmentPendingEstimate="0" assignmentStart="2016-08-29T08:00:00"
internalTaskID="5004000" projectID="project_168" projectName="Project 1.68" taskID="Trackman" taskName="Callibrate TrackMan" totalActuals="5">
<DailyActuals>
<Actual actualDate="2016-12-19" amount="5"/>
<Actual actualDate="2016-12-20" amount="0"/>
<Actual actualDate="2016-12-21" amount="0"/>
<Actual actualDate="2016-12-22" amount="0"/>
<Actual actualDate="2016-12-23" amount="0"/>
<Actual actualDate="2016-12-24" amount="0"/>
<Actual actualDate="2016-12-25" amount="0"/>
</DailyActuals>
</TimeSheetEntry>
</TimeSheetEntries>
<Notes>
<NoteData category="xxx" createdBy="admin" createdTime="2016-12-27T13:59:19" noteText="xxxx"/>
</Notes>
</TimeSheet>
</TimeSheets>
</TimePeriod>
</TimePeriods>
<XOGOutput>
<Object type="TimePeriods"/>
<Status state="SUCCESS"/>
<Statistics insertedRecords="0" failureRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>
5. In Classic PPM I added a Favorite Link" http://<cappm_server>/niku/nu#action:timeadmin.timesheetBrowserReturn so I can access the timesheet page
Open that timesheet and check Timesheet Notes.
Actual Result: You see the Note with Text="xxxx"
6. Go to Home: Link to New User Experience.
Go to Timesheets
Go to Review & Approve Tab
Find Time Period= 2016-12-19 - 2016-12-26 for Resource Name = Ron DeMedeiros
Notice the it shows a circle in blue with number 1. Click on it.
Notes Tab opens.
Observe Notes
Expected: Timesheet note should be displayed
Actual: Timesheet note is not displayed
 
 
DE31295 (Major Problem): Salt error during login on upgraded environment from 14.4 to 15.2 with FIPS Mode on
While testing FIPS in upgrade mode, securerandom issues with Linux environment occurred (see DE31292 for more details). After fixing via workaround, the nsa and app started successfully without delays. Login prompts you to change the password which is as expected. Hitting save in the password change screen throws Internal Server error. The log expects the salt value to be 128 bits. This is upgrade scenario only. The fresh deploy works fine.
App:  ERROR 2016-12-30 21:30:59,073 [http-nio-8080-exec-2] union.service (clarity:unknown:none:security.changePasswordFirstTimeAction) rollback exception
org.bouncycastle.crypto.fips.FipsUnapprovedOperationError: salt must be at least 128 bits
DE31529 (Major Problem): PPMOP_15.1_DEFECT - Vulnerability issue
This security issue was resolved in this release.
 
DE31615 (Major Problem): CHECKINSTALL :Provide a precheck in the checkinstall to stop the upgrade with proper error message if customer is upgrading from CA PPM v14.3.0.9 to 15.2 or higher
Unable to upgrade PPM from 14.3.0.9 version to higher versions.
Steps to Reproduce
:
1) Install 14.3 PPM and DWH.
2) Install Patch 14.3.0.9
3) Upgrade to any other PPM higher version like 14.4. or 15.1.
Expected: Upgrade successful.
Actual: Upgrade fails.
DE31729 (Major Problem): PPMSAAS_15.1_DEFECT HADNI01 Post Timesheets slow due to on-the-fly
Steps to Reproduce
:
1. Approve a big amount of timesheets on a large dataset with on-the-fly matrix enabled
2. Run Post Timesheets job
Expected results: Timesheets to be posted in a timely manner
Actual Results: Post Timesheets job takes hours to run, and processes usually only 1 timesheet per minute
Workaround:
1. Stop and cancel the Post Timesheets job
2. Ensure the query does no longer run on the database level - if not done, can lead to duplicate transactions.
3. Disable the on-the-fly rate matrix:
update cmn_option_values set value=0
where option_id =
(select id from cmn_options where option_code='PRJ_RT_RATES_EXTRACTION');
commit;
4. Re-run the job again
This issue has been resolved to improve the security of your product.
DE31795 (Major Problem): PPMSAAS_15.1_DEFECT - HTML Injection
This issue has been resolved to improve the security of your product.
DE31833 (Major Problem): CLRT-81620: New UI: Project Start and Finish Dates not Saved
Steps to Reproduce
:
1) Open the new UI and click on a project to open it.
2) On the right side of the UI, click on the Details tab.
3) Change the Start Date and/or Finish Date to a new value.
4) Click on the Tasks, Status, or Team tabs to display a different page.
5) Click on the Details tab again and notice that the date(s) have reverted back to the old value.
Expected: The new UI should save the new values entered into the Project Start Date and Project Finish Date fields.
Actual: The new UI does not save the new values entered into the Project Start Date and Project Finish Date fields.
Workaround: Project Start and Finish Dates can be entered and saved in Classic PPM.
DE31885 (Crash/Data Loss): PPMSAAS_15.1_DEFECT SAAS/OP - INTERNAL - Securability
This Jaspersoft 5.6.1, 6.1, and 6.2.1 issue has been resolved to improve the security of your product.
DE32083 (Minor Problem): PPM Rest actions not reflecting correctly in log analysis portlet
PPM Rest actions not reflecting correctly in log analysis portlet.
Steps to Reproduce
:
1. Log in as some user who have all rights.
2. Navigate to at least 20-30 actions and perform some updates/deletes from Old and New UI.
3. Navigate to Home and then to Jobs.
4. Search for the Job with name Tomcat access log import/analyze
5. Run the job and wait for that completion.
6. Now navigate to Administration, and click Log Analysis under Security and Diagnostics section.
7. In that Log Analysis portlet page, move to tab Dialy Page/XOG views
8. Observe Slow Pages top 20 portlet.
Expected: All the actions in this portlet should log the new UI requests properly. New UI actions should get displayed with proper action names.
Actual: New UI actions are not getting displayed with action names.