HOTFIX README Version #: Clarity 12.0.6 Hotfix#: 12.0.6_generic_010 Customer: ALL NOTE ON HOTFIXES --------------------------------------------- Hotfixes are groups of critical bug fixes bundled in a single easy-to-apply package. It is important to note that hotfixes are not releases - they do not involve full code replacement and data upgrade; they are much more surgical and precise in application. Hotfixes are available to customers on the support web site. Because hotfixes are cumulative, customers need only apply the most recent hotfix to get all the latest fixes. CA Technologies feels confident that this hotfix will resolve the addressed problems, but customers should be aware that we do not recommend that Customers apply hotfixes directly to production systems without first verifying in a test environment. If any issues arise in the installation or use of this hotfix, please contact Clarity Division Technical Support at 1-888-550-6458. INCLUDED FILES: README.txt--> This file install.sh--> Unix installer install.bat--> Windows installer install.xml--> Ant install script package--> Directory of updated files. tools--> Directory of supporting files. IMPORTANT: - You are responsible for backing up Clarity PRIOR to installing a hotfix in case you need to restore to a pre-hotfix version. - Install only on systems running the version stated above. - Clarity client component installs are optional, however to gain the benefit of the client fixes (Workbench, MSP-Interface) they must be installed on the user workstation. You will be asked during the installation if you wish to deploy any updated clients to the server for download. - There are different sections below depending on which application server vendor you are using: Tomcat, WebSphere, or WebLogic. - Application of this hotfix on average may take between 30 minutes and 3 hours. This is provided only as an estimate. Your mileage may vary. - Issues marked with ** are items that may change the user experience, most often is a positive way. - Updated versions of this and all other Clarity documentation can be found at http://support.ca.com ----------------------------------------------------------------------------- SPECIAL INSTRUCTION for 12.0.6_generic_005 and later: ----------------------------------------------------------------------------- Additional steps may be required to take advantage of incremental mode for the rate matrix job (CLRT-49457). If you are installing 12.0.6_generic_005 or later for the first time, perform the following steps after unpacking the hotfix, but before running the install script. dbpatch -install -file \package\files\database\schema\pre-upgrade\PREUPGRADE_RME_INCREMENTAL_ONLY_OPTION.xml -apply Now run the Rate Matrix Extraction job to COMPLETION, this may take hours in some cases. Please let it run until it shows "Completed", then complete the hotfix installation. After the installation is completed, you can enable incremental mode in the Rate Matrix job properies. This is a one time operation and does not have to be repeated for subsequent hotfix installations. ----------------------------------------------------------------------------- END OF SPECIAL INSTRUCTIONS ----------------------------------------------------------------------------- HOW TO INSTALL THIS HOTFIX --------------------------------------------- 0. BACK UP YOUR CLARITY INSTALLATION ------------------ TOMCAT CUSTOMERS: ------------------ 1. On NSA server, extract the install package into a temporary directory: jar -xvf D:\niku\temp (For Windows Systems ) or jar -xvf /niku/temp (For Unix Systems ) See 'SPECIAL INSTRUCTION' above... 2. Stop all local nsa, app and bg services (database and reports must stay running): niku stop nsa app bg beacon 3. From temp directory, execute the install script and follow the instructions on the screen: install.bat (For Windows Systems) or install.sh (For Unix Systems) 4. Start all services: niku start all 5. If you are running multiple servers in a cluster: a) Log into NSA and go to All Services page to shut down any remote app and bg services. b) Go to Distribute All page, select remote servers and click Distribute. c) Return to All Services page to restart services when distribution is complete. 6. If the hotfix includes the fixes of reporting bugs please do the following steps: a) Re-install the reports from NSA b) Restart the Report server services c) Restart the Clarity services ------------------------------------------------------------- BEA WEBLOGIC / IBM WEBSPHERE APPLICATION SERVER INSTRUCTIONS ------------------------------------------------------------- 1. On the NSA server, extract the install package into a temporary directory: jar -xvf D:\niku\temp (For Windows Systems ) or jar -xvf /niku/temp (For Unix Systems ) See 'SPECIAL INSTRUCTION' above... 2. Stop all bg services using the NSA application (database and reports must stay running) 3. Stop the NSA and Clarity (if you decided to deploy/start after all) applications using the application server administration console. 4. From temp directory, execute the install script and follow the instructions on the screen: install.bat (For Windows Systems) or install.sh (For Unix Systems) 5. Package the NSA application using the following command which will create the nsa.ear package: nikuadmin package nsa 6. Using the application server administration console, re-deploy the nsa.ear package. 7. WebSphere only: Start the NSA application using the administration console 8. Using the NSA application, package the Clarity application which creates the niku.ear package. 9. Using the application server administration console, deploy the updated niku.ear package. --------------------------------------------- Issues Fixed in 12.0.6_generic_010 Hotfix: --------------------------------------------- CLRT-54955 : MSP -- scheduling issue when you allocate a team member at less than 100%. Steps to Reproduce: 1. In clarity create a new project june 1st - 30th 2. Add a team member at 5% allocation 3. Add a task with the same start and finish as the project 4. Assign resource to task. 8 hours of ETC for the duration (5% of their availability) as expected. 5. Export to MSP Expected Result: start and finish June 1st -June 30th, .4 hours per day. Actual Result: start , finish June 1st. 8 hours of ETC on the assignment. HOWEVER....the task shows .4 hours. It's like it started to do the right thing then it failed somehow. The resource list sheet correctly shows 5% allocation, and they are overallocated CLRT-56068: Work effort Units: Replace Resources on Task Assignment screen is displaying in Hours, when System Default is in days. Steps to Reproduce: 1. Go to Admin Side - Project Management - Settings 2. Make sure Default Display Unit for Work Effort is Days 3. Create a project 4. Staff it 5. Create a Task, assign the resources to it 6. Go to Task - Assignments screen 7. Note the ETC is shown in days 8. Select a resource and click Replace Expected Result: The ETC to be displayed in Days (matching the Work Effort Unit on the Assignments/ Resource selection potlet) Actual Result: Actual results : ETC is displayed in Hours CLRT-51872: When a user deletes the process which sent Action Item and notification the Action Item is deleted but the notification is not. Clicking on Action Item link caused undefined system error Steps to Reproduce: 1. Create a process that sends Action Item to the user a) Log in to the Clarity like Administrator b) Go to Admin-tools -> processes and click the "New" button c) Enter requested information (Process Name: Test1, Process ID: Test2) and click "Save" button d) Go to Start Step and Create a Manual Action Item that sends Action Item to administrator (Action = Approved + Rejected, Subject = Test, Assignees = Administrator) e) Define the Post-condition of Start Step (( Action Item.Start.AI Number of assignees with Status Open = 0 ) >>>> Finish) f) Go to Validate and - click the "Validate All and Active" button 2. Test the scenario a) Go to the Home ->Organizer -> Processes -> Available and start process "Test" b) Go to the Home ->Organizer ->Action Items (You should see the Action Item) c) Go to the Home ->Organizer -> Processes -> Initiated and cancel and delete the process "Test" d) Go to the Home ->Organizer ->Action Items (You shouldn't see the Action Item) e) Go to the Home ->Organizer -> Notification and click on the link of the notification ( the error Appears) Expected Result: Clarity should display a message stating that the Action Item was deleted Actual Result: The Clarity displays unspecific system error . CLRT-55428: RATE MATRIX JOB RUNTIME with no incremental data still takes ~25 minutes. Steps to Reproduce: 1.Log on to the server which has some amount of data which makes Rate Matrix job to run for atleast 30-40 minutes. 2. schedule a Rate Matrix Extraction job with Incremental option checked. 3. If you schedule the job to run back to back , Job run take same amount of time. Expected Result: Job should finish in less time of the previous Job run Actual Result: If you schedule the job to run back to back , Job run take same amount of time. CLRT-56364 - Notes for timesheet time entries do not appear in the Timesheet Detail Report (Port CLRT-57038) Steps to Reproduce: 1. Open a timesheet 2. Click on the time entry note icon, immediately to the left of a task 3. Enter a note and save it 4. After the timesheet has been posted, run the Timesheet Detail Report Expected Result: The note is shown in the report Actual Result: The note is not shown in the report CLRT-54561 - Soft Allocation Start Date, and Booking Status changed for non-Labor resources after saving back to Clarity from MSP (Port CLRT-57040) Steps to Reproduce: 1. Create a new project. 2. Make the schedule from April 1st 2010 to April 30th 2010. 3. Staff it with one Labor resource, and one non-Labor resource [I used an Equipment resource]. 4. In the Team -> Staff view, go do Edit Mode and change the [Allocation] Start date to April 2nd and the [Allocation] Finish date to April 29th for both resources. 5. Change the Booking Status to Hard for both resources. 6. Create a new Task, from April 27th to April 28th. 7. Do NOT assign the Resources from before [though assigning them does not really make a difference for this case]. 8. Open the project in MSP. 9. Without performing any changes, save back to Clarity and close MSP. 10. Go back to Team -> Staff. 11. Notice that the Finish Date has changed to April 28th. This is fine, as MSP has changed the project's schedule too to finish on April 28th. 12. Notice the Booking Status and Start Date for the Labour Resource: Hard and April 2nd, as before. 13. Notice the Booking Status and Start Date for the non-Labour resource. Expected Result: Booking Status and Start Date to be left untouched, like for the Labour resource. Actual Result: Booking Status and Start Date changed to Mixed and April 1st [the Start date of the project schedule] --------------------------------------------- Issues Fixed in 12.0.6_generic_009 Hotfix: --------------------------------------------- CLRT-52258: Proxool connection maximum lifetime is set to 48 hours resulting in a very long delay for the connection pool to shrink. Steps to Reproduce: 1) Start clarity and access /niku/proxool to monitor the connection pool 2) Create some artificial load against the clarity environment (using apachebench or load runner) with a large number of simultaneous requests into Clarity. 3) Take note of the increased number of connection pool entries and wait 4 hours. Expected Result: With a completely idle Clarity environment, you should see only a few connections if any Actual Result: The number of connection pool entries is the same as at the end of the load test, but they are almost all idle. CLRT-55537: The actions > edit mode view is not working with TSV values if the first attribute is not ediatble. Steps to Reproduce: 1. Login to Clarity 2. Go to Studio > Objects 3. Select the Team object 4.Go to Views > Project Team - Detail > Fields 5. Select the Weekly Allocations properties 6. Add the Actuals, Allocations and ETC to the selected column and set the display type as number 7. Save changes 8. Go to the project team detail page and from the actions drop down menu, select the edit mode. 9. These go into edit mode. 10. Modify the Weekly Allocations properties by changing the order of the available attributes, by setting the ETC as first 11. Go to the edit mode through the actions drop down menu Expected Result: The values to be editable Actual Result: They are not editable CLRT-55870 : Cannot Open Jobs and Reports on the Admin Side Without Having a Report Server Defined Steps to Reproduce: 1. Login to Clarity 2. Click the tool icon to go to the admin side. 3. On the admin side click Reports and Jobs. Expected Result: Job Definition page to be displayed. Actual Result: Fatal error. CLRT-55838: Date format is MM/DD/YYYY for European locale under Matrix Properties: Edit Matrix Rows --> New Steps to Reproduce: --> admin side --> "Finance" --> "Manage Matrix" --> select an existing matrix --> click "New" Expected Result: "From Date" and "To Date" have date format DD/MM/YYYY Actual Result: "From Date" and "To Date" have date format MM/DD/YYYY --------------------------------------------- Issues Fixed in 12.0.6_generic_008a Hotfix: --------------------------------------------- CLRT-56580: Roll back fix for CLRT-47797 to prevent incorrect deletion of instance rights. --------------------------------------------- Issues Fixed in 12.0.6_generic_008 Hotfix: --------------------------------------------- CLRT-56016: PRNOTE orphan delete dramatically slows down performance during Delete Investments job run. Steps to Reproduce: On a large customer dataset 1. Mark a group of projects for purge 2. Run the Delete Investment job 3. Watch "top activity" in Oracle enterprise manager. Expected Result: Projects delete fairly quickly, no "generic" (non project specific) delete queries are executed on a per project basis Actual Result: Project deletes are slow, db cost is high and a PRNOTE generic orphan delete query is run for each specific project deleted CLRT-55815: Delete Investment job consumes 100% CPU while reading object instances using ODF classes prior to deleting the instances Steps to Reproduce: 1. In a large dataset, mark 1000 projects for deletion 2. Run the Delete Investment job 3. Watch the database and BG activity during the job execution 4. When the DB activity for the job drops to 0, inspect the state of the BG and capture a thread dump Expected Result: Delete Investments job will run fairly quickly Actual Result: Job consumes excessive amounts of CPU and takes a very long time to delete investments CLRT-56000: Gantt Scrolling Does Not Work Gantt Scrolling to Previous Periods and Next Periods does not work. By not work, I mean that when you click on the left arrow for previous periods or the right arrow for next periods, the Gantt view does not move back or forward periods as it is supposed to move. Steps to Reproduce: 1. Create one resource and one project 2. Assign that resource to the project task 3. Go to any one of the following pages where the issue can be reproduced: a. Project Tasks Task List b. Project Tasks Work Breakdown Structure c. Project Tasks Resource Utilization 4. Click '[--Actions--]' pull-down menu, select 'Gantt' 5. Set the TSV value and do not enter any value in Time Period Offset field 6. Save and exit 7. Click on backward (<) or forward (>) button on Gantt 8. Open the TSV properties again Expected Result: Time Period Offset value is correct Actual Result: Time Period Offset value is incorrect CLRT-55005 : Chargeback code doesn't recognize Credit To Rule when location is set to Project Location in Wip Settings Steps to Reproduce: 1. Create a specific Entity Department that will be used to 'debit' the 'capital cost' from 2. Associate the Department to a Location for the Entity 3. Create a specific 'Service' 4. Enter financial properties on the Service, using the Department created in step 1 This will create a Recovery Statement tab from which credits can be viewed 5. Subscribe the specific Department to its own Service. This will create an Invoice tab from which charges can be viewed 6. Create GL Accounts for Expenses and Capital 7. Create a Investment (Project) 8. Create a specific Location that will only be used for this project and link the Entity Department 9. Assign this Location and Department to the project in the project financial properties page 10. Set up Project Team, Tasks and assignments 11. Create the Project 'Charge To' (Debit) rule Chargeback type = Investment, Bill Expense Type = Capital Expense Set the Charge To (Debit) Header record to use the Department and set the Charge Code to 'Capital' Set the Charge To (Debit) Detail record to use the Department and set the GL Account 12. Create the 'Credit To' rule Set the 'Credit To' Header record to use the Project Location and set the Charge Code to 'Capital' Set the 'Credit To' Detail record to use the Project Department and set the GL Account 13. Run Jobs to process financial records and generate Chargeback Invoices - Post Timesheet job - Post Transactions to Financials job - Post to WIP page - Generate Invoices job 14. Check Admin Tool > Chargebacks: Messages Expected Result: The Credit To rule should be recognized with the Project Location value set Actual Result: The Credit To rule is not recognized with the Project Location value set and the transaction appears on the Chargebacks Messages page. CLRT-56260: Incorrect number format error when trying to save a value in a multi-valued lookup attribute based on OBS_BROWSE_* lookup Steps to Reproduce: 1. Create a multi-valued lookup attribute on the project object. Use the OBS_BROWSE_FILTER lookup. 3. Add the attribute to the edit page of the object. 4. Open an existing project and choose one or more values for the multi-valued lookup. 5. Click Save or Submit. Expected Result:The selected values will be saved successfully. Actual Result:The user receives an "Incorrect number format" error message the value(s) is (are) not saved. --------------------------------------------- Issues Fixed in 12.0.6_generic_007 Hotfix: --------------------------------------------- CLRT-53596: WEBI AND RECURRENT PARAMETERS Steps to Reproduce: These first 4 screen shots show the 4 queries we have written for the Report - this shows that all the Prompts are compatible and have identical names. The next screen shot shows the Infoview Prompt screen for this report, which shows each prompt only being requested once. The next two screenshots show parts of the resulting report, showing correct date range and percentages The next screenshot shows the parameter screen from Clarity, which shows the same parameters selected as when run from Business Objects directly. Before running the report from Clarity I have run the report from Business Objects with a different set of parameters to illustrate that the additional queries are picking up values from the last run in Business Objects, rather than accepting the parameters from Clarity. The next screen shot shows the instance created in Business Objects from running the report from Clarity, which shows the parameters being passed to the report. As you can see the parameter set appears 4 times, the first set are as sent from Clarity and the rest are from the previous run from Business Objects. The final screen shots show the resulting report - the date range is incorrect and the percentages do not appear. (In some cases the percentages appear, but are incorrect). Expected Result: should appear only one times Actual Result: as you can see the parameter set appears 4 times. CLRT-55972: Cost Plan - Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint Steps to Reproduce: 1. Have multiple Users log onto Clarity 12.0.6 and all access cost Plan UI concurrently Expected Result: Users should access page without problems Actual Result: The following error is thrown - System error. Contact system administrator --------------------------------------------- Issues Fixed in 12.0.6_generic_006 Hotfix: --------------------------------------------- CLRT-54106: When Populate from Resource plan by Assignment, task with no charge code assigned should not be shown in Cost Plan details Steps to Reproduce: Prerequisites:: 1. Create OBS for department and location, create Entity using these associate OBS. 2. Go to Fiscal time periods tab and create new fiscal time period with name 'Monthly" fiscal year - 2010, start date 1/1/10 End date 12/31/10 and submit. Select the created fiscal time period and ACTIVATE. 3. Go to Project Mangement->charge code and create charge codes: 'ba' and 'ca' 4. Admin->Finance->Manage Matrix: Create a Rate Matrix "byCC" with Charge Code column, edit Matrix Row with cost and rate having a catch all row that has * as the charge code with a rate of $100. 1. Create resource A with Primary Role 'Architect'; resource B with Primary Role 'DBA'; resource C with no Primary Role 2. Create a new project, assign a Department value 3. Create 3 tasks on the project - Task1 with no charge code; have A and B assigned; Task2 with charge code 'ca', have C assigned; Task3 with charge code 'ba', have B assigned; 4. Create a new cost plan on the project, duration and period type do not matter, must group by Charge Code, then sub group by Roles 5. click on Populate from Resource Plan, select Copy From 'Assignment', click Submit 6. An Alert is displayed: "One or more tasks in the staff plan does not have a charge code. Do you want to proceed? Click Yes to create a financial plan with only the valid staff plan data. Click No to cancel the process.". Click 'Yes' Expected Result: line items have specific values in the group by and sub group by columns Actual Result: some line items have blank group by column CLRT-50437: The display of user value 1 dynamic lookups is not honoring the sort Steps to Reproduce: 1. Pick or create a project that has 5 or more tasks (or create one), note the internal id field value. (i.e. testing, analysis, development, refactor,distribution) 2. Create a new lookup using a dynamic query from the admin tool's lookups link. 3. Specify the following for the query (this is a simplified but functional query): SELECT @SELECT:TE.PRID:PRTIMEENTRYID@, @SELECT:TSK.prname:USERVALUE@ FROM PRTIMESHEET TS, PRTIMEENTRY TE, PRASSIGNMENT ASSG, PRTASK TSK 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 OR TSK.PRID in (select prid from prtask where prprojectid = nnnnnnn)) AND @FILTER@ note: replace nnnnnnn in the query above with the id gathered from step 1. This just makes it easier for us to populate our query. 4. Specify uservalue for the display attribute 5. In the lookup properties, specify the default sorting column as "uservalue", with ascending order. Save 6. Navigate to the admin tool to Timesheet Options under the Project Management heading in the admin tool. 7. Specify the lookup you created in step 2 for the "User Value 1 Lookup" 8. Access a timesheet 9. Use the configure button to move the user value 1 field to the selected columns and save 10. Populate a timesheets with one or more tasks. 11. Click one of the task's user value 1 field. Expected Result: The items should be sorted. Actual Result: The items in the dropdown are not sorted. PMO-356: Resource Availability Report by week is showing hours by day and doubled in end/start of the Month Steps to Reproduce: 1. Go to Reports 2. Select Resource Availability Report 3. Reporting Periods = Weeks 4. Take a period of more than one month. Using 2 or 3 will exhibit the problem 5. Run the report Expected Result: Get the correct results for all the weeks Actual Result: week is showing 8 hours and the first week of some months (not all) it is showing 16. --------------------------------------------- Issues Fixed in 12.0.6_generic_005 Hotfix: --------------------------------------------- CLRT-49457: Slow performance for Rate Matrix Extraction job after upgrade to version 12 Steps to Reproduce: 1. Login as Clarity administrator 2. Execute the 'Rate Matrix Extraction' Job Expected Result: job should complete in ~30 minutes Actual Result: job completes in ~90 minutes CLRT-12011: CMN_SEC_USERS.LAST_LOGGED_IN_DATE is always null Steps to Reproduce: 1. Log in to Clarity application 2. Query the CMN_SEC_USERS table > Review the value in the LAST_LOGGED_IN_DATE field. Expected : The date/time of the last time that the user logged into Clarity is displayed Actual : A NULL value is displayed CLRT-47797: Cancelled and Immediate Run reports can continue to build up records in the CMN_SCH_JOBS table and can cause performance problems ** NOTE: the fix was rolled back in 12.0.6_generic_008a.*** Steps to Reproduce: 1. Run a report and under the report properties specify for the "When" option the checkbox value for "Immediately" 2. Observe the data that appears in the CMN_SCH_JOBS table select * from cmn_sch_jobs where is_visible = 0 Expected Result: Records for an 'Immediate' execution should be automatically purged Actual Result: A new record is added to cmn_sch_jobs with an is_visible value of 0. CLRT-48499: Removing subproject (or child project in hierarchy) leaves orphaned hierarchy records Steps to Reproduce 1. In Clarity, create 4 projects as follows: "Master", "sub1", "sub2" and "sub3" 2. Add "sub3" as a subproject/child of "sub2" 3. Add "sub2" as a subproject/child of "sub1" 4. Add "sub1" as a subproject/child of "master" 5. Remove "sub1" as a subproject/child of "master" Expected Result: No references from any sub to the master in inv_flat_hierarchies or inv_hierarchies table Actual Result: Orphaned references exist CLRT-50211: Export to Excel from Portlet by an user causes out of memory error which results in bringing the server down. Steps to Reproduce: 1. Create a portlet based on a dynamic query 2. A query returns 40k rows in portlet 3. Export to Excel the entire number of rows from portlet to Excel Expected Result: The application should terminate that particular user gracefully; also Clarity should be able to recover from OOM error instead of bringing the whole server down Actual Result: Java Out of Memory error occurs CLRT-54989: Time-Scaled Value for Resource Allocation does not display Previous Periods correctly, starting with 12.0.6. Steps to Reproduce: For all the pages listed below: - Resource Planning -> Workloads tab -> Allocation TSV. - Resource Planning -> Allocations tab -> Weekly Detail portlet -> Allocation TSV. - Resource -> Allocations tab -> Detail subtab -> Weekly Allocation TSV. - Project -> Tasks tab -> Resource Utilization subtab -> Weekly Schedule TSV. 1. Open the page. 2. Click on the Previous Periods button. Expected: Only the periods previous to the one displayed at step 1. to be displayed. Actual: The period that was first at step 1. is now last, and greyed out. 3. Click on the Previous Periods button again. Expected: Only the periods previous to the one displayed at step 2. to be displayed. Actual: The period that was first at step 1. is now last, and greyed out. Plus, the periods displayed at step 2 are still displayed, and greyed out. 4. Go back to the original period [the one from step 1]. 5. Go to Action -> Configure and add one column [say the ETC] *to the right* of the Time-Scaled Value. 6. Click on the Previous Periods button a few times, and for each click observe the layout. Expected: That only the correct period is displayed, plus that the extra column to the right is displayed. Actual: The extra columns to the right will be greyed out. A number of extra periods may appear in the Time-Scaled Value, and they will be greyed out as well. CLRT-54995: Export to Excel (Data Only) is dramatically slower after upgrade from 8.1.1 to 12.0.5 Steps to reproduce: 1. Export a large number of projects from the project list page to Excel at 8.1.1 and time how long it takes 2. Upgrade the dataset from 8.1.1 to 12.0.5 3. Export the same number of projects from the project list page to Excel and time how long it takes Actual Result: Export to Excel (Data Only) at 12.0.5 is dramatically slower Expected Result: Both exports (8.1.1 and 12.0.5) should take roughly the same amount of time CLRT-55085: Gantt virtual attribute displays data beyond defined number of time periods under list or portlet Gantt time period settings Steps to Reproduce: 1. Login and navigate to the Project List 2. Select Configure from the Action menu and select the Fields link in the submenu. 3. Click on New and create a Virtual List column of type Gantt (note: if this option is missing it means there is already another gantt defined) 4. Give the column a label for the required text field, then set the Primary Bar required attributes to: Item Name Attribute: Project Code Start Date Attribute: Start Finish Date Attribute: Finish 5. Click on Save. 6. In the Time Scale section select: Rolling Date: Start of Current Year Time Scale: Month Number of Periods: 12 Time Period Offset: 0 or blank 7. Click Submit 8. Change the Finish date of a project to 1/1/2020 9. Examine the display of the List View Expected Result: The time period range should span for all months of the current year. Actual Result: The time period range spans more than 12 monthly periods until the project finish date in 2020. CLRT-55239: Filtering for Static Dependent Lookup does not work on 12.0.6 Steps to Reproduce: 1. Create a Static dependent lookup (xog in the Static Dependent Lookup attached lookup_write.xml) 2. Log into Clarity > Admin > Object > Project 3. Create a new attribute Attribute Name: myAtt Attribute ID: myAtt Data Type: Multi Valued Lookup Lookup: myLookup 4. Save 5. Verify the following Entry Level: myLookup Exit: level3 6. Submit 7. Add this attribute to the Project [Layout: Edit] view 8. Also addd this attrinute to the Project Filter [Layout] view 9. Go to application side and click on Projects 10. Create one project with myAtt set to /11/1111/1111last 11. Submit 12. In the Project list page Filter for /11/1111/1111last Expected Result: Your project will be the only one in the list Actual Result: No project is listed and the value in myAtt in the filter is gone --------------------------------------------- Issues Fixed in 12.0.6_generic_004 Hotfix: --------------------------------------------- CLRT-53880: Cost Plan Time Scale Value setting Not Configurable Steps to Reproduce: 1. Create a Partition in the 'Partition Models' 2. Navigate to Objects link in Clarity Admin page and attach the newly created partition to 'Cost Plan' and 'Project' object. 3. Create a new attribute (for Cost Plan object) of data type string under the newly created partition. 4. Attach a resource to the newly created partition. 5. Log out of Clarity and log back in using login details of the newly created resource that is attached to the partition. 6. Create a new project under the newly created partition. 7. Create a cost plan for the project using 'Monthly' period type with a January - December duration and Group by 'Transaction Classes'. 8. Manually Populate the cost and units of the cost plan. 9. Select 'Time-Scale value' from 'Actions' dropdown link and change 'Time Scale' to Year, set 'Number of Time periods' to 1. Set Rolling Date to 'Start of Current Year' Expected Result: Cost plan details page for 'Flat view' to display data of Cost and Units yearly Actual Result: Cost and Units data are still displayed in Monthly --------------------------------------------- Issues Fixed in 12.0.6_generic_003 Hotfix: --------------------------------------------- CLRT-53168: Power filter in project list with OBS unit doesn't work Steps to Reproduce: 1. Create an OBS with at least 2 levels and 2 units 2. Create 3 projects (1 with obs unit1, 1 with obs unit2, and 1 with no obs) 3. Create power filter for project list (object= project, field= obs unit) 4. Select the obs unit1, click Add and submit. Expected Result: Results specific to the OBS unit are shown Actual Result: No results are shown CLRT-53222: Attributes with same ID set as Optimization cause Scenario Generation System error in Portfolio Steps to Reproduce: 1. Go to Studio - Object - Project 2. Create an attribute Lookup - String with ID nika_obli2 3. Add to Views 4. Create a portfolio, include projects 5. Create a Scenario 6. Add optimizations: same attribute 7. Save 8. Generate - working fine 9. Go to Studio - Idea 10. Create an attribute Lookup - String with ID nika_obli2 11. Add to Views 12. Go to the portfolio 13. Include Ideas 14. Open the Scenario 15. Generate : System error in UI Expected Result: Show Scenario results Actual Result: System error in UI, Ambiguous column error in the SQL trace CLRT-54115: XOG resource or projects with values not present for custom attributes will set the values to the "Default" value (CLRT-54115) Steps to Reproduce: 1.Create a boolean attribute on either Resource or Project object 2. Add the boolean attribute to the Edit view. 3. Edit a resource (or a project), "Check" this boolean attribute 4. XOG out this resource (or project) 5. Watch the xml output, it should have the boolean attribute with a "true" value. 6. Change this "true" value to "false" 7. XOG in this xml file 8. Look at the resource (or project) from step 3. 9. The boolean attribute should be "Unchecked". 10. Check the boolean attribute in the UI for the resource (or project) and save it 11. In the xml file from step 5, remove the boolen attribute from the xml file. 12. XOG in this file. Expected Result: The boolean attribute should stay "Checked" Actual Result: Boolean attribute is "UnChecked" CLRT-54116: XOG OBS complete='true' flag fails to replace unit changes Steps to Reproduce: 1. Create an OBS via XOG using the sample XML write file, replacing with valid names in your system 2. Verify that your OBS exists the way it is written above 3. Use the above XML again to modify your last resource in the list and replace them with someone else from your test system 4. XOG in this XML and observe that it writes successfully 5. Navigate to the UI and check your OBS - you will see that the user whom you replaced with a new resource is now gone and your replacement is missing Expected Result: The complete='true" flag should make changes Actual Result: Change does not occur - original unit is removed and new entry is not written even though the XOG log states that it was CLRT-54278: XOG OBS write for unit update is behaving like an insert rather than an update and generates XOG-2628 error Steps to Reproduce: 1. Create a test OBS using the following XML:
2. Navigate to UI and observer that the OBS exists and is as written. 3. Attempt to move a unit to be the child of another unit by using the following XML:
4. You'll get the following error: XOG-2628: OBS Unit Name must be unique within an OBS Expected Result: OBS unit update is written properly Actual Result: XOG error is thrown and OBS updates cannot be made CLRT-54789: Process tied to an OBS expression in the start condition does not start when combined with attribute expressions or if other processes exist on update for the same object Steps to Reproduce: 1. Create the sample OBS 2. Create the 2 sample processes 3. Validate and activate the 2 processes 4. Associate a project instance to one of the units in the sample OBS 5a. With both processes active, click "Save" on the project. Check the Processes tab to see if any processes started. 5b. With the Attribute Test Process on hold, click "Save" on the project. Check the Processes tab to see if any processes started. 5c. Modify the OBS Test Process start condition and add "&& project.is_active==1" to the start condition. Validate/Activate and click "Save" on the project. Check to see if any processes started. Expected Result: a) Both processes should start... b) The OBS process should run .... c) The OBS process should run Actual Result: a) Only the Attribute Test Process runs. b) The OBS process runs. c) The OBS process doesn't run. --------------------------------------------- Issues Fixed in 12.0.6_generic_002 Hotfix: --------------------------------------------- CLRT-53795: Baseline Cost not populated in OWB if Task has an Expense Resource assigned with 0 ETC Steps to Reproduce: 1. Ensure you have 2 Labour resources [say, A and B] and 1 Expense resource [say E]. 2. Ensure that they are financially enabled by filling up the Financial subtab of each resource. 3. Create a project. 4. Enable it financially. Ensure you set the Rate/Cost Matrices for all resource types. 5. Staff the project with the newly-created resources. 6. Delete the Effort Task, if it's created. 7. Create a Task, and name it "Expense 0". 8. Assign the 3 resources to it. 9. In the Assignment section, set the ETC as follows: A to 0, B to non-0, E to 0. 10. Create another new Task, and name it "Expense non 0". 11. In this case too, assign the 3 resources to it. 12. In the Assignment section, set the ETC as follows: A to 0, B to non-0, E to non-0. 13. Run the Rate Matrix Extraction job. 14. Open the Project in OWB. 15. In the Gantt view, add the Resource Baseline Cost and Assignment Baseline cost columns. 16. Select the task "Expense non 0". 17. From the Tools menu, go to Baselines -> Set Baseline; click on "Selected Task(s)" and then Ok. 18. You should see that the Assignment-level Baseline Cost column is now populated. This is expected. 19. Select the task "Expense 0". 20. From the Tools menu, go to Baselines -> Set Baseline; click on "Selected Task(s)" and then Ok. Expected: Assignment-level Baseline Cost column to be now populated. Actual: Nothing happens. Assignment-level Baseline Cost column stays blank. 21. From the Tools menu, go to Baselines -> Set Baseline; click on "Project" and then Ok. Expected: All Baseline Cost columns in the view to be populated [Assignment-level and Resource-level]. Actual: Nothing at all happens. --------------------------------------------- Issues Fixed in 12.0.6_907404 Hotfix: --------------------------------------------- CLRT-45739: Unable to batch printing an invoice to a printer or a file Steps to Reproduce: Preq: Setup network printer for print batch billing 1. Created financially enabled project 2. Add task to this project 3. Set up batch billing cycle, assign resource 4. Create a transaction entry, add project and task that you just created 5. Post to WIP 6. Generate Batch billing, check Automatically Approve and do Selective 7. Go to Print Batch Billing, select value for "Select Billing Run", Try by both Print methods with printer and file name 8. Print 9. Run "Batch Billing" job- the result is completed 10. Verify the content of the file Expected Result: Should be able to see the details of the batch billing within the file and printer Actual Result: Data has not been printed to the file and a printer Solution: 1. Default file that the invoice will be written for any exceptions is $ClarityInstallDir/logs/invoices/$userId/$BillRunkey_yyyy-MM-dd-hh.mm.ss 2. Print will be sent to either default printer or first pick from the available printers mapped on the server where batch printing invoice job is run and the data will be persisted to $ClarityInstallDir/logs/invoices/$userId/$BillRunkey_yyyy-MM-dd-hh.mm.ss CLRT-46122: Demand Billing: Adjustment amount not rounded properly can cause error REVMGR-20908 Steps to Reproduce: 1. Create a project, assign a finanically enabled resource to team and task. 2. Go to Transaction Entry, create a transaction with the project. Enter: Quanity = 1,399.95 Cost = 1 Rate = 1 3. Post this transaction to WIP 4. Go to Demand Billing, select the transaction 5. Go to Category detail, put Bill = 1391.93 Adjustment amount = -8.02 and click Submit Expected Result: It will allow user to adjust the amount without error Actual Result: It gave error: REVMGR-20908: You can not Bill and Adjust more than the amount remaining