Clarity PPM 15.5.1.4 PATCH README Version #: 15.5.1 Patch #: 4 For updates after the publication of this text file, navigate to techdocs.broadcom.com and see the README file. For your convenience, use the following direct links: -README page for all 15.5.1.x on-premise customers: https://techdocs.broadcom.com/bin/gethidpage?hid=HID_clarity_readme&space=ccppmop1551&language=&format=rendered -README page for all 15.5.1.x SaaS customers: https://techdocs.broadcom.com/bin/gethidpage?hid=HID_clarity_readme&space=ccppmod1551&language=&format=rendered --------------------------------- PRE-REQUISITE - ADDITIONAL NOTES: --------------------------------- - Install only on systems running the following versions. **********CONTENTS*********** • Extension of Digital Certificate for MSP and OWB Integrations • SPECIAL INSTRUCTIONS FOR DE46395 • How to Install the Patch • How to Uninstall the Patch • Issues Fixed in 15.5.1.4 • Issues Fixed in 15.5.1.3 • Issues Fixed in 15.5.1.2 • Issues Fixed in 15.5.1.1 **** NOTE ******************************************** Patches are intended to be timely fixes and are not fully regression or integration tested, and are only tested against the issues listed below. We feel confident that this patch will resolve the defects targeted in this patch, but a patch could have adverse side effects to the function of your Clarity PPM application. Do not apply patches directly to production systems without first verifying in a test environment. If any issues arise in the installation or use of this patch, contact Support. ******************************************************** INCLUDED FILES: --------------------------------------------- README.txt -> This file install.sh -> Unix installer install.bat -> Windows installer install.xml -> Ant install script --------------------------------- New! The Clarity Brand is Back With the acquisition of CA Technologies by Broadcom, the Clarity product, formerly rebranded as CA PPM, has been restored in the 15.5.1.x patch branch. The product is now branded Clarity Project and Portfolio Management, or simply Clarity PPM. Tip! Historic references with mixed branding might continue to appear throughout the application and in the online documentation, community content, Support KB articles, videos, and other content. --------------------------------- New! Phoenix UI Theme The 15.5.1.x patch branch also introduces the new Phoenix UI theme designed to invite Classic Clarity PPM users into the new aesthetics and styling of the Clarity Modern UX (formerly introduced with 15.1 as the New User Experience). To learn more about applying UI themes, see Clarity PPM Studio UI Themes in the Reference section of the documentation. --------------------------------- Extension of Digital Certificate for MSP and OWB Integrations The digital signature for optional Clarity PPM integrations with Microsoft Project (MSP) and Open Workbench (OWB) was updated. The original expiration date of April 5, 2019 has been extended until 2020. --------------------------------- SPECIAL INSTRUCTIONS FOR DE46395 (Load DatawareHouse Job fails if we use a Custom Lookup for 'Time Entry User Lookup Field 1') --------------------------------- If Custom Lookup is being used for "User Value 1 Lookup" in "Administration -> Timesheet Options" page and data warehouse is also setup, Ensure that the custom lookup is defined with the required structure for the data warehouse. For more information see the following KB article: https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=22205 If you encounter the defect DE46395, please apply the work-around for DE46395 and sucessfully run the "Load Data Warehouse" job before applying the patch. A "Full Load" of "Data Warehouse" job is required after changing the "User Value 1 Lookup" field. ------------------------ Install the Patch ------------------------ Follow these steps: 1. Back up all files and the database on the target system. 2. On the CSA server, copy the installer into a temp directory. 3. Navigate to the temp directory and enter the following command to extract the contents: jar xvf 4. Stop all local nsa, app and bg services: service stop nsa app bg 5. From the temp directory, enter the following command to execute the installer script: install.bat or install.sh 6. Follow the remaining on-screen instructions to complete the installer script. 7. Start all services: service start all 8. If you are running multiple servers in a cluster: a. Log in to the CSA and go to the All Services page to shut down any remote app and bg services. b. Go to the Distribute All page, select remote servers, and click Distribute. c. Return to the All Services page to restart services when the distribution is complete. IMPORTANT: If you currently use or want to use the new Jaspersoft Reports and Data Warehouse, choose Step 9 or Step 10. If you do not use these features, skip Steps 9 and 10. 9. If you are applying this patch and you have already configured Jaspersoft Reports and the Data Warehouse: a. From /bin directory command prompt, enter the following command to generate keystore: admin jaspersoft keystore b. Copy the keystore files generated in /config directory to /webapps//WEB-INF/config c. Enter the following command to upgrade the report content: admin content-jaspersoft csk -userName -password upgrade -retryCount 50 d. Restart all PPM services. e. Run the Load Data Warehouse Access Rights job. 10. If you are applying this patch and you want to use the new Jaspersoft Reports and Data Warehouse but have not yet configured them: a. From /bin directory command prompt, enter the following command to generate keystore: admin jaspersoft keystore b. Copy the keystore files generated in /config directory to /webapps//WEB-INF/config c. Enter the following command to install the release content: admin content-jaspersoft csk -userName -password -retryCount 50 This command imports jaspersoft_csk.zip followed by the file that has patch content (file name for patch content contains jaspersoft_csk_upgrade). d. If you encounter any error during the import of the patch content, enter the following command to re-import the patch content: admin content-jaspersoft csk -userName -password upgrade -retryCount 50 force e. Configure the Data Warehouse section in CSA. See CSA: CA PPM System Administration at docops.ca.com/ppmop. f. Enter the following command from the /bin directory command prompt to apply the data warehouse patch content: admin db dwh-upgrade -Dupgrade.phase=maintenance g. Restart all PPM services. h. Run the Load Data Warehouse Access Rights job. -------------------------- Uninstall the Patch: -------------------------- Follow these steps: 1. Stop all local nsa, app, and bg services: service stop nsa app bg 2. Restore the installation files and database from the backups above. 3. Start all services: service start all 4. If running multiple servers in a cluster: a. Log in to CSA and go to the All Services page to shut down any remote app and bg services. b. Go to the Distribute All page, select remote servers and click Distribute. c. Return to the All Services page to restart services when the distribution is complete. -------------------------------------------- Issues Fixed in 15.5.1.4 -------------------------------------------- DE49842: XOG remove Association did NOT remove subobject Steps to Reproduce: 1. Login to Clarity PPM. 2. Find a Investment to associate a project with. 3. Associate the Project with an investment using the below XOG structure.     
                                                                                                                                                                                                            4. Navigate to investment PR1037 you will find PR2066 added as a Sub-Project and also in Heirarchy. 5. De-associate it using the below XOG structure.     
                                                                                                                                                                                          6. Navigate to the Parent investment which is PR1037, You see that under Sub-Projects we find the project PR2066, but under hierarchies we don't have PR2066. Expected Result: Project PR2066 should be removed from both hierarchies and subprojects, as that's what happens when you add/remove a child under Hierarchy tab using Clarity PPM UI. Actual Result : Project PR2066 is only removed from hierarchies tab and not subprojects. DE49702: New UX Project Navigation Performance Issue Steps to Reproduce: 1. Login to Clarity PPM. 2. Find a Project which has large number of team,tasks,assignments. 3. Navigate to New UX. 4. Search for the Project identified in Step 2. 5. Click on the Project Tile. Expected Result: Since the landing page of the Project is conversations, the Project should open quickly within 5 secs. Actual Result: Project opens after more than 2 minutes. DE47804: Anonymize Personally Identifiable Information (PII) job not working as expected Steps to Reproduce: 1. Log in as an active user 2. Set up an audit trail for fields that should be anonymized. Example: Project Manager, Change Request Assessor, etc 3. Find a resource to be anonymized 4. Update the fields with the audit trail (ex: Project Manager, Change Request Assessor) so some records contain the resource to be anonymized 3. Inactivate the resource to be anonymized and check the anonymize field 4. Run the PII Anonymization job Expected Result: There should be no evidence that the resource exists. Manually look at cmn_audits table to make sure no evidence exists Actual Result: The Audit table had references to the anonymized resource DE44615: The incremental load data warehouse job long processing time for MSSQL DB Steps to Reproduce: 1. Log in as an active user 2. Set up some cost plans on projects 3. Post actuals on the projects 4. Run incremental load data warehouse Expected Result: Data warehouse load should finish in a reasonable amount of time Actual Result: Data warehouse load takes way too long to finish DE45016: OBS When moving 2 levels LDWH job fails Steps to Reproduce: 1. Define OBS with more than 2 level 2. XOG out the OBS 3. Move 2 levels of the OBS (move to root) 4. Configure and Run DWH job Full Load 5. XOG in the OBS 6. Run DWH job Incremental Expected Result: DWH job should run fine Actual Result: DWH job fails because of duplication of records DE49471:Blank notifications being generated for Risks, Issues and Change Request when they are getting created Pre-requisites: Create custom attribute on the Issue object called "PMO Owner" with attribute ID = r4. Data Type = Multi Valued Lookup - Number Lookup = Resource Browse Value Required is Checked Steps to Reproduce: 1. Create a Risk, Issue or Change Request by going to any existing project or create New one. 2. Assign the Risk, Issue or Change Request to Admin user. Click "Save". 3. Check the notification tab under Organizer. Expected Result: This issue has been assigned to you: Issue Name: ASDFSADF Issue ID: SDFSDFG Investment: DDDD Priority: Low Assigned By: Administrator, CA PPM Created On: 5/31/19 10:10 AM To view the issue, Click Here Note: The same issue occurs with Risks and Change Requests. Actual Result: This issue has been assigned to you: Issue Name: Issue ID: Investment: Priority: Assigned By: Created On: To view the issue, Click Here -------------------------------------------- Issues Fixed in 15.5.1.3 -------------------------------------------- DE42990: Adjusted Timesheet not showing in PPA WIP Steps to Reproduce: Adjustment Timesheet does not post to WIP when financial status is closed when first adjustment posts.Follow these steps: 1. Create and financially enable two (2) projects (Project 1 and Project 2). Select Open for Time Entry and set Track Mode to PPM. 2. Add a financially enabled resource. Open for Time Entry. Make sure the resource is in the rate matrix so transactions will post. Create one task on each project and assign the resource. Timesheet steps: 3. Create a timesheet and add the two tasks from the two projects. 4. Make sure the Charge Code and Input Type code are populated. 5. Add hours for a few days on both projects/tasks. 6. Submit/Approve/Post Timesheet 7. Verify in Invalid Transactions 8. Post Transactions to Financials (Verify gone from Invalid Transactions) 9. Post to WIP - verify transactions are posted. Adjust timesheet: 10. Adjust one line on the timesheet and remove the hours (zero or blank value) from Project 2. 11. Submit and Approve Do not post yet 12. Take off time entry and close financials for Project 2 (you already removed the hours). Not sure if Time Entry is relevant but financial status is. 13. Post Timesheets 14. Check Invalid Transactions - Entries should not be in there as Financial Status is closed. Adjustment timesheet #2: 15. Open the project for time entry. DO NOT Change Financial Status - Remain Closed 16. Adjust the timesheet again and add hours back to Project 2. 17. Submit, Approve, Post again. 18. Check Invalid Transactions - Entries should not be in there as Financial Status is closed. 19. Open Financial Status on Project 2. 20. Post Timesheets again. Expected Result: The two adjustments show in invalid transactions so the original timesheet gets credited. Actual Result: Only Adjustment #2 is in Invalid Transactions. This causes WIP to have the Original Transactions and the #2 Adjustment transactions with no credits inflating WIP. DE46904: On the new timesheet UX, when using the tab key to navigate through populated timesheet cells in order to replace the existing values, the value is not preselected and cursor is placed at the end of the value Steps to Reproduce: 1. Navigate to new UX 2. Go to timesheets > Edit an existing timesheet 3. Populate timesheet 4. Enter values for each one of the days (from Monday to Friday) 5. Go back to the Monday cell and using the tab move along the rest of the days Expected Result: The value in Tuesday is preselected. If a new value is entered, the preselected value is replaced. Actual hours: The cursor is placed at the end of the value. You must delete the existing value before you can enter a new one DE44357: Cost Plan Issue - Non-standard fiscal periods do not follow expected editability rules Steps to Reproduce: 1. Make a non-standard calendar monthly period type (or 13 period type) fiscal periods so they do not start and end on the first/last day of month. 2. Create a Manual MONTHLY cost plan using this entity. I used 3. Note that each period cell is editable 4. Edit the cost plan properties to change End Period to prior period. 5. Go back to cost plan details Expected Result: You cannot edit final period Actual Result: You can edit final period DE42701: Investment specific Charge Codes are not selectable in New UI Financial Plans Steps to Reproduce: 1. Navigate to Administration -> Project Management -> Settings, and make sure that "Enable Investment-specific Charge Codes" is marked as "Yes" 2. Create a project in the Old UI 3. Navigate to Properties -> Charge Code page 4. Create a new charge code here 5. Navigate to the New UI. Open the project created in step 2. Navigate to "Financials" tab 6. Create a Financial Plan here. Group by "Charge Code" 7. Create a new row in the Financial plan. Try to choose the charge code created in step 4 Expected Result: Charge Code created in step 4 is selectable in the New UI Actual Result: Charge Code created in step 4 is not selectable in the New UI. It is however selectable in the Old UI. DE46426: Forecasted Utilization Report does not display FTE's under assignment column Steps to Reproduce: 1. Find someone who has no assignments but has actuals so they have EAC 2. Run the report for hours. - Note the Assignment Hours - It shows EAC instead of ETC - Note this does not have to be the only way to get ETC to be 0 but there has to be posted actuals to the task. 3. Run the report for FTE -Note Assignments FTE shows 0 as there is 0 ETC Expected Result: The calculation should use EAC hours for both. Actual Result: FTE calculation for assignments is incorrect in the report query. When running the report with Unit Type as Hours, the report uses EAC hours column whereas with Unit Type as FTE, the report uses the ETC hours column to calculate FTEs. DE46361: Error 'NPT-0060: Mapping requires name to be supplied' received when trying to set a query attribute display mappings to icon type. Steps to Reproduce: 1. Go to Administration > Studio > Queries 2. Create a new query called "My query" 3. Fill the NSQL tab with nsql query to create attributes (one of them is impact_enum attribute). 4. On the Attributes tab, edit the impact_enum attribute for example 5. Set the Display Mappings to icon 6. Select the Up Arrow - Red icon, or Red - Flag or any other. Add a description (Red) and provide any from to values (0 to 1) 7. Click on Save Expected Result: The display mappings to be set to icon Actual Result: Error received NPT-0060: Mapping requires name to be supplied / NPT-0063: From and To must be specified DE45555: Locale formatting is not correct in the denominator of the Timesheet Review & Approve Row & Fly-out Steps to Reproduce: 1. Login to Classic PPM as an administrator user 2. Home Account Settings - Change the Locale: Italian (Italy) for the logged in administrator user 3. Logout and login again as the administrator user so that the locale settings are updated. 4. Administration, Resources - Create a Resource 5. Go to Home, Resources for this new resource and update the Calendar Shifts so that the Resource has 7,5 daily availability rate 6. Update the Resource settings for PPM Track Mode, Open for Time Entry 7. Navigate to the New UX 8. Click on the Timesheets menu navigation 9. Click on a 'Select Resource' button and select the newly created resource 10. Populate the timesheet and enter in some time so that the total amount of time = 10,5 11. Submit the Timesheet Note the numbers appear correctly here as 10,50 / 37,50 12. Click on Review and Approve 13. Find the Resource with the submitted timesheet 14. See the card on the row for the resource with the submitted timesheet Note the denominator number does not have a comma - it shows 10,50 / 37.50 The 2nd number has a decimal point, not a comma 15. Click on this card for the resource with the submitted timesheet to see the fly-out Note the denominator number does not have a comma - it shows 10,50 / 37.50 The 2nd number has a decimal point, not a comma Expected Result: All numbers where a comma should be show have: "," Actual Result: Numbers are showing with both comma and decimal points (ex. 10,50/37.5) DE40179: MSSQL - Load Data Warehouse Full Load job performance problem on large dataset Steps to Reproduce: 1. Use large MSSQL datasets - only reproducible on large datasets. 2. All jobs are Paused on this environment. 3. Run Load Data Warehouse - Full Load. Expected Result: Load Data Warehouse - Full to take a reasonable amount of time Actual Result: Load Data Warehouse - Full takes large amount of time, big majority of which is on DWH_RES_PERIOD_FACTS -------------------------------------------- Issues Fixed in 15.5.1.2 -------------------------------------------- DE42036: Timesheet hours for Incidents not showing in Capacity Overview Portlet Steps to Reproduce: 1. Create an incident and assign to a resource. 2. Open that resource's timesheet for the current period. 3. Add the incident to the timesheet. 4. Log time to the incident and submit the timesheet. 5. Approve the timesheet and wait till it's posted. 6. Go to Capacity Overview screen 7. Configure the page to display Incident Actuals in the stacked Allocation time scaled value 8. Choose the OBS that contains the resource that tracked time to the incident. Expected Result: The Incident Actuals shows the number of actuals posted by the resource on the incident. Actual Result: The Incident Actuals is blank. DE44896: New UX Staffing - Lag when typing data in cells Prerequisite: Create a project and have multiple resources added to the project in PPM Steps to Reproduce: 1. Log in to the New UX 2. Click on the Staffing icon 3. Switch to the 'Investments to Resources' portlet 4. Expand a project 5. Double click in a cell next to the resource and type a new number (Example: 6) 6. Within a second or two, double click in the next cell and type in a new number (Example: 8) 7. Within a second or two, double click in another cell (example 10) Expected Result: The updated values are reflected immediately (6.00 and 8.00 respectively) Actual Result: There is a lag for the changed values to be reflected of at least a couple of seconds. You can tell this as the 6 entered in the cell may take a few seconds or more to reflect as 6.00. And sometimes, the numbers entered will revert back to the old numbers entered versus taking the new values. DE46829: New UX Timesheet Displays ETC Hours Inconsistently from Task to Task Steps to Reproduce: 1. Create assignment with Fixed Loading pattern 2. Make the assignment be prior week and future a couple of weeks and make sure there is ETC 3. Post a timesheet for the assignment for prior week do 5 hours or so to get an actual thru date so ETC for prior to Actual Thru gets dropped 4. Open timesheet for current week in classic and new UX. Add the Task Expected Result: ETC is the same in both Actual Result: Classic: ETC shows sum of future weeks (after current week) DE44708: Project Allocation Team Audit Trail Last Updated Date is updated, but not Last Updated By Steps to Reproduce: 1. Log in as an active userA 2. Make a change to a team member userB allocation through their calendar 3. Inactivate userB 4. Log in as another active user and run the Time Slicing job Expected Result: When the Time Slicing job re-slices the data it should NOT update the 'Last Updated Date' or 'Last Updated By' fields on the PRTEAM record because this is an indirect update to the allocation data. Actual Result: When a resource calendar is updated, it causes the Time Slicing job to reslice allocation data based on the new resource availability The 'Last Updated Date' field is updated on the PRTEAM record because the Time Slicing job last processed the allocation data. The Time Slicing job does not update the 'Last Updated By' field. Therefore, the user interprets the event as an inactive user changed the record recently. DE46354: After time out of a new UX session that was connected via SSO cannot reconnect Steps to Reproduce: 1. Configure SSO with CA PPM. 2. Navigate to New UX. 3. Allow the new UX session to time out 4. Attempt to log back in. Expected Result: Users can log back in Actual Result: Users are unable to log back with credentials that are valid DE47568: NEW UX - SSO Status report, 'Undefined' error when clicking the 'Report Sub tab' Steps to Reproduce: 1. Login to CA PPM. 2. Navigate to New UX. 3. Open a Project. 4. Navigate to Status Tab. 5. Click on Reports Sub tab. Expected Result: Report gets generated and displayed on screen Actual Result: Server generates the report and user is seen and "undefined" error on top of the screen. DE40836: MSSQL - Load Data Warehouse - Incremental has inconsistent times of execution Steps to Reproduce: 1. Run Load Data Warehouse - Incremental multiple times throughout the day Expected Result: Incremental to run in a certain amount of time Actual Result: Sometimes, especially in the morning, the job runs for 100 min, some other times 15-20 min. DE47625: Security Fix DE45179: Email for action items Steps to Reproduce: 1. Set up a PPM system with email server information and a default sender address so that it can send emails 2. Perform any activity that will generate an out-of-the-box-notification. I tested adding and removing a participant on a project, sending a report completed notification, submitting a timesheet, and a process manual notification. All performed the same way Expected Result: The FROM field will be structured so that "LAST_NAME, FIRST_NAME" or "First_Name Last_Name" in the display portion of the FROM field like most emails. Actual Result: The FROM field in the Email Header contains the user email address in the display name portion. DE46688: Budget reports inconsistent Steps to Reproduce: 1. Create 2 projects with identical cost plans 2. Add the same actual costs to both projects 3. Run a DWH Full Load 4. Add a risk to Project 1  5. Add an actual cost to Project 2 6. Run an incremental load 7. Look at the table dwh_x_inv_sum_facts, Project 1 will have 0 actual costs and Project 2 will be correct Expected Result: Project 1 plan cost and actual cost should be correct Actual Result: The cost is being 0'd out DE47810: Custom multivalued field empty in data warehouse after incremental load Steps to Reproduce: 1. Run a Data Warehouse Full Load so everything is sync'd up. 2. Go to a Project that has Status Reports 3. On a Status Report, delete 1 resource off the custom MVL. Attribute we were using is based on an out of the box resource lookup. 4. Run an incremental DWH Load. 5. The display_value field in the dwh_cmn_mv_lookup table will be null Expected Result: It should not remove display_value after incremental run Actual Result: It removes display_value after incremental run DE48074: MSSQL - Load Data Warehouse Full Load job performance problem on large dataset (DWH_X_RES_AVAIL_PER_FACTS improvement) Steps to Reproduce: 1. Use a large MSSQL customer database - only reproducible on large datasets 2. Run Load Data Warehouse - Full Load - note it runs for 250+ minutes Expected Result: Load Data Warehouse - Full to take a smaller amount of time Actual Result: Load Data Warehouse - Full takes 280-300 minutes for the customer, much of it on DWH_X_RES_AVAIL_PER_FACTS DE41718: Persistent Data Warehouse Incremental error ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys (after all fixes for DE37008 applied) Steps to Reproduce: 1. Apply 15.3 Patch 3 which includes DE37008 or manually by replacing the files  2. Run Load Data Warehouse - Full 3. Then run Load Data Warehouse - Incremental every few hours like 6 times in a day Expected Result: The job to be successful Actual Result: The job fails with: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -------------------------------------------- Issues Fixed in 15.5.1.1 -------------------------------------------- DE45213: "Could not load project" and Login Page Appear When Opening a Project in the New User Experience An additional symptom that you might experience is an API-1018 error when attempting to replace a role with a resource in the New UX. Steps to Reproduce: 1. In a web browser, navigate to http:///niku/nu#action:npt.overview (enter your own values). 2. Log in as an administrative user. 3. Adjust the URL in your browser to http:///pm (on your same server). 4. Log in as an administrative user. 5. Click a project. Expected Result: The project opens. Actual Result: "Could not load project" message appears and the Login page opens. DE45370: New UX Performance Slow in Review & Approve if you have a filter applied and do not have Timesheet - Approve All rights Steps to Reproduce: 1. Navigate to New UX Timesheets in PPM as a user with timesheet approve rights at the instance level for 5 resources, and not Timesheet Approve - All at the global level. 2. Click on the Review & Approve tab. 3. In the Showing section, select a Resource Manager and enter a Resource Manager to filter on. Expected Result: The list of resources appears immediately. Actual Result: It takes about 10-20 seconds to load just 5 resources. DE44807: In the New User Experience, incorrectly able to edit tasks associated with inactive projects on adjusted timesheets Steps to Reproduce: 1. Create a project that is active, open for time, and track mode PPM. 2. Add a resource to the project, also open for time, and track mode PPM. 3. Create a new task on the project (open for time) and assign the resource to the task. 4. Log in as the user and navigate to the New UX Timesheets page. 5. Add the task created in Step 3 to the current timesheet and submit for approval. 6. Approve the timesheet. 7. Run the Post Timesheets job. 8. After the timesheet is posted, go back to the project created in Step 1 and make the project inactive. 9. Navigate back to the posted timesheet for the user. 10. Click the Adjust button. Expected Result: Task associated with the inactive project is read-only; the hours cannot be changed. Actual Result: The task is editable; you are able to change the hours on the task. DE44318: MSP New Driver: Task Start Dates are changed to Actuals Thru date even though no time has been submitted on the task Steps to Reproduce: 1. Create a project in PPM (open for time with track mode PPM) 2. Add one resource to the project team (make sure they are open for time and track mode of PPM) 3. Create 2 tasks: Task1 (Task Start Date is in the past): Fixed Duration with start date 7/1/2018 and finish date 7/13/2018 Assign resource to task (with 10 hours ETC) Task2 (Task Start Date is in the future): Fixed Duration with start date 3/25/2019 and finish date 03/29/2019 Start No Earlier Constraint of 3/25/19 Assign resource to task with 5 hours of ETCs during the time frame of 3/25/19 - 3/29/19 (future time period) 4. For the user added to the team, submit 8 hours of ETC for task1 with the last hours entered on the time sheet Go to the timesheet for 7/9/18 – 7/15/18 in the new UX (Past time period) Ensure Assigned Tasks is selected then click Create Timesheet Enter 2 hours of work for 7/10, 7/11, 7/12, and 7/13 Click Submit Click Approve Wait 5 minutes then run the Post Timesheets job (Note that the actuals thru date on the Team tab is now 7/15/18) 5. Export the project from PPM to MSP. 6. Observe the start date for task 2. Expected Result: Since the task start date and ETCs are in the future, the task start days stays as 3/25/19 Actual Result: The task start date changes to 7/16/18, which is the first working day after the actual thru date for the resource on the project. DE45317: Security Fix This security issue was resolved in this patch. The steps to reproduce the issue are omitted for security reasons. DE46559: Upgrade fails from 15.5 to 15.5.1 Steps to Reproduce: 1. Upgrade to any PPM that includes a change in job definition to introduce a job parameter for the first time (until now the job doesn't have any job parameters). Expected Result: Upgrade is successful. Actual Result: Upgrade fails with error on the XML file. DE46395: Load Data Warehouse Job fails if we use a Custom Lookup for 'Time Entry User Lookup Field 1' Steps to Reproduce: 1. Create a Dynamic Query based test lookup with the below query. SELECT @SELECT:TE.PRID:PRTIMEENTRYID@, @SELECT:SUBSTR(TSK.PRNAME,1,30):USERVALUE@, @SELECT:SUBSTR(TSK.PRNAME,1,30):DISPLAYVALUE@, @SELECT:LANG.LANGUAGE_CODE:LANGUAGE_CODE@, @SELECT:LANG.ID:LANGUAGE_ID@ FROM PRTIMESHEET TS, PRTIMEENTRY TE, PRASSIGNMENT ASSG, PRTASK TSK, CMN_LANGUAGES LANG WHERE TS.PRID = @WHERE:PARAM:USER_DEF:INTEGER:USERDEFTSID_PARAM@ AND TS.PRID = TE.PRTIMESHEETID AND TE.PRASSIGNMENTID = ASSG.PRID AND TSK.PRID = ASSG.PRTASKID AND LANG.LANGUAGE_CODE = 'en' AND @FILTER@ Query Reference: https://comm.support.ca.com/kb/how-can-we-use-our-own-userdefined-lookup-with-the-time-entry-user-value-1-field-for-timesheet-entries/kb000022205 2. In Classic Clarity PPM, click Administration, Project Management, Timesheet Options. 3. Modify the Value of "User Value 1 Lookup" from the default "Time Entry User Lookup Field 1" to the newly created "Test Lookup". 4. Run the Load Data Warehouse job in full mode. Expected Result: Job completes without issues. Actual Result: Load DWH job fails with error [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30926: unable to get a stable set of rows in the source tables While merging DWH_META_COLUMNS DE46372: Export to Excel (Data Only) Does Not Work when Results include Negative Numbers Steps to Reproduce: 1. For simplicity, create a custom number attribute on the Team object (this issue is also reproducible with default system attributes). 2. Go to the Team tab of an existing project and add the custom number attribute to the Team list view. 3. Type in a negative amount for this custom field on the list view (for example -25). 4. Click Save. 5. Click Options, Export to Excel (Data Only). 6. Open the downloaded file. Expected Result: The file opens in a spreadsheet application such as Microsoft Excel. Actual Result: The file does not open and throws one of the following two errors: • "The file is corrupt and cannot be opened." • "Problems During Load, Problems came up in the following areas during the load: Table". DE42922: LDAP - Synchronize Obsolete Users job taking longer than usual Steps to Reproduce: 1. Enable LDAP integration with a large number of users (for example, 30,000 users). 2. Run the Synchronize Obsolete Users job. 3. Record the time for completion. 4. Use the new option of group membership based sync. 5. Run Synchronize Obsolete Users job. 6. Record the time for completion. Expected Result: Complete it in minutes. Actual Result: Took more than two hours to synchronize. DE46043: Modern UX Project Tile Labels for Blueprint Visuals Are Not Translated Steps to Reproduce: 1. Log in to the CA Clarity PPM New User Experience. 2. In the main menu, navigate to Classic PPM. 3. Set your Language account settings to a non-English language (for example, Spanish). 4. Switch back to the New User Experience. 5. In the main menu, click Projects. The project tiles appear. Expected Result: Labels are translated. Actual Result: Everything is translated into Spanish except for the labels below the visual gauges. DE45714: Avatar Error in New User Experience Additional symptoms that may be seen: Unable to view Status Reports or Attachments in the New UX Steps to Reproduce: Prerequisites: Have IIS Configured in the environment. 1. In the New UX, click on the application drop-down menu where your name appears at top right and select Settings. 2. On the Profile page, click UPLOAD. 4. Browse and select an image file to upload. Expected Result: Avatar displays successfully and no error is generated. Actual Result: A message states "Avatar Uploaded Successfully" but is followed by a "Could not load the avatar image" error and the image does not appear in the New UX. DE45950: Existing custom sub-objects that are API enabled through the UI can not be found on Blueprint Modules Steps to Reproduce: 1. In Classic PPM, click Administration, Studio, Objects. 2. Create a new object Sub1. This is a subobject of the master project object. 3. Select the API Enabled check box. 4. Save the object. 5. Create a new object Sub2. This is a subobject of the master project object 6. Do not check the API Enabled check box. 7. Save the object 8. Select the API Enabled check box. 9. Save the object. 10. Log in to the Modern UX. 11. In the main menu, click Administration, Blueprints. 12. Open a blueprint. 13. Click Modules. Expected Result: Both Sub1 and Sub2 subobjects are available to be added as modules. Actual Result: Only Sub1 is available. The existing subobject that has been API-enabled through the UI is not available for blueprint modules. DE45859: SSO Logout URL value is not being applied when logging out on the Modern UX Steps to Reproduce: 1. Configure SSO with CA PPM. (This issue was observed only when SSO was integrated with the on-premise edition of CA Clarity PPM.) 2. Navigate to New UX. 3. Click Logout. Expected Result: Application logs out and the Logout URL specified in CSA is displayed. Actual Result: Logout navigates to the Home page on New UX. DE46001: Calendar Date Picker Widget does not show Japanese correctly Steps to Reproduce: 1. Log in to the application where the user has their account settings for Language set to Japanese. 2. Go to any page that has a calendar date picker user interface control. 3. Click on the calendar icon and see the labels are not translated. 4. Click on the header pull down to see Months and Years and the labels are not translated. Expected Result: Calendar date picker labels show Japanese correctly. Actual Result: Calendar date picker labels do not show Japanese correctly. Month, Week Day, and Today are shown as ? or ??. DE44336: Copy Tasks from Previous Week adding Other Work Steps to Reproduce: 1. Add user to Other Work Team. 2. Post time without Other Work item. 3. On following week, populate the timesheet with copy from previous time period. Expected Result: Other work should not be on there. Actual Result: Other work item shows. DE48698: Data Warehouse Table Constraint issue when running Load Data Warehouse job Steps to Reproduce: 1. Run the full load data warehouse job to completed status Expected Result: the status attribute of the DWH_INV_SERVICE_LN_FK1 constraint ought to have an "enabled" value after the job is completed. Actual Result: the status attribute has the value "disabled" after the job is completed. DE50332: Incremental DW load failing after upgrade to 15.5.1.1 Steps to Reproduce: 1. Login to Clarity PPM. 2. Create an MVL attribute and Configure for DWH. 3. Populate values to the Attribute. 4. Run DWH Full Load. It completes and you see that values are populated for the MVL Attribute. 5. Go back to investment where MVL attribute is configured and remove the values(Nullify).  6. Run DWH Incremental Load. Expected Result: Job completes within a reasonable amount of time.  Actual Result: Incremental Job times out after running for 11 hours as 600 mins is the Time-out that's set.