Hot fixes included in this product release are:
This section includes Hot Fixes included in Agile PLM 9.3.1.0.
Bug ID 23285323: PROJECTS SHOWING INCORRECT BASELINE DATESSEV 1 SR
Root Cause: When reading baseline contents from the database, the application always uses the first parent id of one Activity, rather than its current parent id, which causes an error if the activity has a changed parent.
Resolution: Explicitly pass the parent id when reading baseline contents.
This section includes Hot Fixes included in Agile PLM 9.3.1.2.
Bug ID 22146467: SMART URL AND GET SHORTCUT URL ERRORS WITH AUTOVUE ERROR
Root Cause: When the object attachment row is found, the code does not compare the attachment file name.
Resolution: Need to compare file name when we get the file row.
Bug ID 22372971: AXML FILE MISSING RELATIONSHIPS TAB CURRENTSTATUS VALUE
Root Cause: We currently export load the available life-cycle phases by class id, not subclass id, so subclass-specific lifecycle phases can not be exported in the Relationship tab as read-through attribute Current Status.
Resolution: Load the available lifecycle phases by subclass id.
Bug ID 22668498: PRICE EFFECTIVE DATE REDUCED ONE DAY DURING IMPORT
Root Cause: Import uses the import user's time zone setting to convert string to date for the date only attribute.
Resolution: Always use GMT time zone to convert string to date for date only attribute.
This section includes Hot Fixes included in Agile PLM 9.3.2.0.
Bug ID 21848388: USING SET AS BEST, PCM COST CALCULATION IS WRONG IN ASSEMBLY COST REPORT AND ECR
Root Cause: The Material Price Adder attributes are not passed as needed, so it does not include them in the Total Extended Price.
Resolution: Invoke related method with Material Price Adder attributes.
Bug ID 22258772: LEGACY BOM COMPARISON REPORT DOES NOT DETECT DIFFERENCES IN FIND NUM
Root Cause: The code uses HashSet to store mfrParts, but multiple Items may have the same mfrParts, which can cause the pricelines read though from mfrParts to get lost for some Items.
Resolution: Use ArrayList to store mfrParts.
Bug ID 22078398: EXTERNAL ROLLUP (BATCH AND AD-HOC) NOT RETURNING SUBSTANCES IF BOM
Root Cause: When one of the BOM parts' quantity is set to 0, there is a substance whose calculated mass is 0 in table result_substance_compliance. When getting validate substance, total count (include 0) and valid count (nono-zero) in table result_substance_compliance does not match. Therefore, no substance is returned.
Resolution: Made the valid count include 0 substance.
Bug ID 22619898: AGILE 934 AUDIT STATUS PROVIDING INCONSISTENT RESULTS
Root Cause: When a user opens an Item with a certain rev, the rev information is stored in user context. When the user then opens a Change object to do an audit, some priv checks are done for Affected Items using the rev information stored in user context. The mismatch between rev stored in user context and Affected Item object causes the problem.If there is criteria related to rev or rev attributes the priv check returns the wrong result.
Resolution: Reset rev for correct AI's which is being dealt with run time, and set the original rev back to context after the required fields check is finished.
Bug ID 22979199: DYNAMIC LIST WITH CRITERIA SET FOR SUPPLIERS SHOW SUPPLIER NAME IN WEB CLIENT
Root Cause: Get supplier name from cache.
Resolution: Get display name from cache when displaying supplier.
Bug ID 22817641: NO MORE DATA TO READ FROM SOCKET ERROR WHILE RELEASING DECLARATION
Root Cause: When updating REV flags according to (Item, Change) key-value record selecting from SUBSTANCE_MAP, there are thousands of duplicate (Item, Change) appearing after IN clause.
Resolution: Filter duplicate records using GROUP BY OBJECT_ID, OBJECT_CHANGE.
Bug ID 24336433: SELECT ITEM FOR THE REPORT WINDOW SHOWS BLANK REVISON FOR BOM COMPARISON REPORT
Root Cause: If the user disables the license of PGC model and goes to the report wizard, the add by search window is deployed with fewer columns than usual, and it brings a mismatch at the code level.
Resolution: Get the right column value of Revision.
Bug ID 24564717: PORTFOLIO DELIVERABLE GATE REPORT - ROWS MISSING IN TABLE INSUFFICIENT
Root Cause: Missing row is counted correctly.
Resolution: Change the code in regards to how the row is counted.
Bug ID 23588916: AGILE PPM - CONTENT TAB, EDIT RULE ERROR
Root Cause: If the Activities.Content.RelatedTo field is not in the Applied To list of the Read Programs privilege, it generates a nullpointerexception as there is no null check.
Resolution: Handled the Null.
Bug ID 24713366: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000
Root Cause: This is caused by an Oracle DM limitation. The key word 'in' in the PL/SLQL statement only can add 1000 parameters.
Resolution: If the list is beyond 1000, correct the PL/SQL statement so that there is no limitation like '(table.column,0) in ((1,0),(2,0)...)'.
Bug ID 24842691: UNABLE TO SAVE "CORRECT UNKNOWN SUBSTANCES" ON HOMOGENEOUS MATERIAL
Root Cause: The key word 'in' in a PL/SQL statement only can add 1000 parameters due to an Oracle database limitation. The number of rows that are going to be corrected are more than 1000 in table SUBSTANCE_MAP. An exception is thrown.
Resolution: If the list is beyond 1000, correct the PL/SQL statement so that there is no limitation like '(rowID,0) in ((1,0),(2,0)...)'.
This section includes Hot Fixes included in Agile PLM 9.3.3.0.
Bug ID 21641482: ADVANCED SEARCH DISUCSSION OBJECT RELATED TO IS NOT WORKING AS EXPECTED
Root Cause: If there is a value in the Discussion's related to attribute, the data should exist in view 'DISCUSSION_RELATED_TO', but it loses RFQ object.
Resolution: Union all the data in RFQ object.
Bug ID 21760176: "MORE->FULL DISPLAY MODE" IS GRAYED OUT FOR THE USER WITHOUT MODIFY ITEM PRIVILEGE
Root Cause: The Full display mode needs Edit privilege on Change.Affected Item.Title Block.
Resolution: Removed the privilege check.
Bug ID 22063346: CANNOT INACTIVATE/DELETE CONTACT USER OF SUPPLIER
Root Cause: Code defect, no subclass id when check discovery privilege.
Resolution: Add subclass id when check discovery privilege.
Bug ID 21756864: ITEM HISTORY GROWING DUE TO IMPORT
Root Cause: When Change Items's new revision in ECO'S AI, system will re-get the value from DB and change the numeric flex attributes's value to double, the system compares the new value with the old value in String.
Resolution: When comparing the numeric attribute's value, remove the last '0' and '.'
Bug ID 21950348: PARTNER DETAILS ARE NOT APPEARING CORRECTLY ON THE SOURCING PROJECT
Root Cause: The system currently loads all partners for the child component if rendering Parts in UI.
Resolution: Only load the partners created for the child component if rendering Part in UI.
Bug ID 22098118: CAN NOT ADD USER GROUP TO ESCALATION TAB OF USER GROUP IN WEB CLIENT
Root Cause: The UserGroup option hasn't been configured to be displayed, and special strings in notified user value hasn't be properly handled.
Resolution: Turn the display config of UserGroup on and add new method to handle special strings in notified user value.
Bug ID 21982192: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000
Root Cause: This is caused by an Oracle database limitation. The key word 'in' in the PL/SQL statement only can add 1000 parameters.
Resolution: If the list is beyond 1000, correct the PL/SQL statement that there is no limitation like '(table.column,0) in ((1,0),(2,0)...)'.
Bug ID 22078422: EXCEL IS CRASHING WHILE EXPORTING REPORT
Root Cause: The Report Export function treats HTML as EXCEL for output data.
Resolution: Fixed issues.
Bug ID 21768570: BREAKS PART GROUPS > COMMODITY SEARCH VIA WEB CLIENT IN SDK
Root Cause: For Part Family, it does not have a default sort column, however, HF933.180 uses the sort column ID for all kinds of objects and exposes this issue.
Resolution:
1. Filter 0 case in HF180 functional code.2. Add a default sort column for PartFamily. Actually, a default sort column exists in the UI and it displays sort by name, however, it does not work now. This fix will make it work.
Bug ID 22065657: UNABLE TO IMPORT SUPPLIER COMMODITY OFFERINGS
Root Cause: Import attempts to use the Commodity name, Ship To and Rating as the unique key of one Supplier Commodity Offering row when it tries to determine the import operation(Update existing row or Create a new Row).
Resolution: Use the Commodity name and Ship To as the unique key of one Supplier Commodity Offering row
Bug ID 22170859: GETCELL() FOR API NAME RENAMED PAGE THREE ATTRIBUTE ENDS IN NULLPOINTER
Root Cause: This is because the current attribute key for the subclass level is not unique in the cache.
Resolution: Added subclass id as part of the key to distinguish the different attribute.
Bug ID 22265593: SDK IMPORT FAILED WITH ERROR
Root Cause: The api-ejb.jar used in the following two paths and current hf installer template only replace #1 path, depending on the environment, the server may load the class from either #1 or #2. This can cause an issue if the classloader loads that file from path2 . This also explains why it works in the QA environment at load path #1. Path 1: application.ear/ api-ejb.jar Path 2: application.ear/APP-INF/lib/api-ejb.jar
Resolution: Change the hf installer template to replace both paths. Also, check in to clearcase that all future hot fixes will use this latest template.
Bug ID 22199750: SPECIAL CHARACTERS IN NOTIFICATIONS AND COMMENTS ARE BEING REPLACED
Root Cause: When going back to the Comments page, the value of comments is encoded twice.
Resolution: Encode only one time.
Related Bug 22121771: SPECIAL CHARACTERS IN NOTIFICATIONS AND COMMENTS ARE BEING REPLACED
Bug ID 22115775: UNABLE TO RUN CHANGE PACKAGE REPORT FOR SOME PARTICULAR ECOS
Root Cause: Dead loop to make heap warning when there is a very large amount of text in report headers. It should cover more cases even when it has a specific BOM value.
Resolution: Split the content to jump out of the dead loop to make sure the report runs successfully.
Bug ID 22185883: IMPROPER VALIDATION WHILE IMPORTING OBJECTS TO AGILE 933
Root Cause: The warning msg was changed to not include object number in 933.
Resolution: Check whether autonumber is used before deciding whether the warning msg should include the object number info or not.
Bug ID 20681846: UNABLE TO SAVE AS PROJECT (IPROGRAM) USING AGILE SDK
Root Cause: The behavior of SDK is different from that in the UI.
Resolution: Added a new method also named saveAs() by adding a new boolean parameter, createFromTemplate, to distinguish whether it is created from saveAs or created from template.
Bug ID 22159320: DATA IN MULTITEXT FIELDS DO NOT CARRYOVER ON THE NEW REV
Root Cause: When adding a newly created Change Order or doing a Save As on an Item, it does not insert the related row to the agile_flex table if multiText1 and multiText2 values exist.
Resolution: If the value of the multiText1 and multiText2 fields are there, it adds the records to the agile_flex table accordingly when doing a Save As on an Item or creating a Change on it.
Bug ID 21660318: INCORRECT COMPLIANCE VALUE CALCULATION ON BOM
Root Cause: While rolling up the BOM structure if the Deviation released is base on the latest ECO and the released Date < the released Date of some leaf BOM children, the rollup result might be incorrect. The released date of deviation will be treated as the cut off date so those leaf boms released later will be missed.
Resolution: If the latest rev is deviation/stop shop/ECR based on the latest released ECO/MCO the cut off date would be a hard code date in the future so all leaf children are counted in.
Bug ID 22004887: UNABLE TO SEE ATTACHMENTS WHEN ACCESSED FROM WHEREUSED TAB OF ANOTHER
Root Cause: Did not get the correct default change class id for the Where Used object.
Resolution: Get the correct default change class id for the Where Used object.
Bug ID 22150906: EXPORTED RESULTS HAS INFORMATION OF ATTACHMENTS FOR INTROD. REV AND NOT LATEST
Root Cause: Export from search always exports the introductory rev.
Resolution: Export the rev in the search result.
Bug ID 21878301: ISSUES IN IE, PATCH 21118501 (9.3.3.0.256) WAS APPLIED FOR IE11 COMPATABILITY
Root Cause: IE specific issue. CSS property position of auto-complete suggestion is absolute, and the position of its ancestors is static until the HTML document.
Resolution: Set the position of PageViewContent to relative from static.
Bug ID 22280112: CONTENT RULE FAILING FOR PROJECT CREATED FROM TEMPLATE AND MULTIPLE RULES SET
Root Cause: When building subscription info, the retrieved subscriber id is equal to publisher id from the hashmap, which makes the function not work.
Resolution: When building subscription info, if retrieved subscriber id is equal to publisher id, we need to get the publisher id through the subscriber id instead of getting subscriber id through publisher id from hashmap.
Bug ID 22316859: TAKING HUGE TIME WHILE LOADING WORKFLOW ROUTING TAB ON HOMEPAGE
Root Cause: Running some SQL takes too much time.
Resolution: Create a composite index on the target table.
Bug ID 22180711: ITEM ATTACHMENT TAB FOLDER DESCRIPTION FIELD LENGTH CANNOT BE MODIFIED
Root Cause: Max length of Attachment.FolderDescription is smaller than FileFolder.Titleblock.Description and it cannot be modified, so the description will be truncated when the row is built.
Resolution: First make the Attachment.FolderDescription.MaxLength modifiable. Then deal with inconsistency between Attachment.FolderDescription.MaxLength and FileFolder.Titleblock.Description.MaxLength. Truncate the description if the former is smaller than the latter, or stop the user from saving as well as showing the error message in the opposite case.
Bug ID 21967777: BOM EXPLOSION REPORT FAILED WITH 'SOME ONE WORKING ON THIS OBJECT' ERROR
Root Cause: It is to acquire report object lock when logging report execution history. Multiple threads are executing the same report at the same time, so only one thread can acquire the lock at a time, other threads fail with "some one working on the object".
Resolution: Remove the acquire report object lock when logging report execution history.
Bug ID 22111632: SCROLL BAR AND UPDATE BUTTON MISSING IN MORE || VIEW LATEST CURRENCY RATES
Root Cause: Using incorrect CSS on div layer so that the scroll bar is hidden.
Resolution: Use proper CSS on div layer when viewing conversion rates.
Bug ID 22447281: DEFAULT ACTIVITIES WORKFLOW DOES NOT ALWAYS TRIGGER EMAIL NOTIFICATION
Root Cause: When editing Schedule Date/Percentage in the Cover Page of a Project object, the default notifiers are not retrieved.
Resolution: Retrieve the default notifiers when editing Schedule Date/Percentage in the Cover Page of a Project object and set them to the nofity list.
Bug ID 22367423: ONE OFF REQUEST FOR 22147646: SERVER HANG AND OOM CONDITION
Root Cause: There is a huge history of data in the customer's environment. The attribute, Transaction ID(s), has a huge amount of data and the change to this attribute is triggering a huge entry into history. The size of one history record data is about 200KB.
Resolution: Add a new property, export.maxHistoryDetailsLength, into the properties file, and only if export.maxHistoryDetailsLength is set to a value that is bigger than 0 ,export will truncate the value of history details.
Bug ID 22345551: ERROR FAILED TO GET PROPERY AFTER INSTALLING PATCH 9.3.3.0.310
Root Cause: the date format for PrintDate was hard-coded. Also all date attributes were not formatted to the user date format.
Resolution: Used a a user date format for PrintDate and for all attributes of Date type.
Bug ID 22487429: GETFILENAME USED IN PX DURING CHECKIN DOES NOT
Root Cause: All file names are the first file name.
Resolution: Get all files name correctly.
Bug ID 22509103: DRAG AND DROP ITEM ON UPDATE TABLE EVENT FAILING EVEN WITH 9.3.3.0
Root Cause: The change key object ID can be -1. This is not a valid object ID, but it is not caught and handled properly in EventDirtyRowUpdate#getReferent().
Resolution: If the change key object ID is -1, then set the change object key to null.
Bug ID 22492951: CHANGE STATUS EVENT INFO IS NOT PROVIDING THE CURRENT APPROVERS PROPERLY
Root Cause: If the user sets auto-prompt as yes, and adds approvers in Web Client, Agile cannot fetch the users updated in Web Client. It only gets the users from Template.
Resolution: If there is any user updated in Web Client, catch it using method getReviewersByStatusID().
Bug ID 22563487: JAPANESE FILE NAME IN DOWNLOAD.ZIP IS CORRUPTED
Root Cause: This is caused by an Agile ZIP util bug.
Resolution: Use JDK API to create a ZIP file.
Related Bug: 23037147: JAPANESE FILE NAME IN DOWNLOAD.ZIP IS CORRUPTED
Bug ID 22636323: PATCH 9.3.3.0.255 CAUSING APPLICTION ERROR WHILE MOVING WORKFLOW
Root Cause: This issue is caused by a code defect that was introduced by bug 21118850.
Resolution: Used proper approach to handle the case when the class type is changed.
Bug ID 22651310: AFTER APPLYING 9.3.3.0.258 LIFECYCLE PHASE ERRORS OUT: JAPANESE ENVIRONMENT XLSX IMPORT
Root Cause: The is a Japanese language specific issue. The xml data file of xlsx file may contains 'rPh' element, and 'rPh' shows pronunciation of the data text. The data text inside it should not be extracted
Resolution: Does not extract data inside the 'rPh' element.
Bug ID 22366692: EXPORTING OF SEARCH RESULT IGNORES THE SCALE OF NUMERIC ATTRIBUTES
Root Cause: The code does not handle the decimal scale while exporting the search result.
Resolution: Add the code to handle this.
Bug ID 22921798: OWNER OF PROJECT DOES NOT GET ACTIVITIES - PREDECESSOR PROJECT SCHEDULE NOTIFICATION
Root Cause: When activity P1 is required for P2, and P1 and P2 have different root parents, P2 is not notified when P1's schedule is changed. Notification of external dependencies are not included.
Resolution: When sending notification, it should notify those activities which are dependent upon this activity - both internal and external dependencies.
Bug ID 22921798: TASK CONFIGURATION FOR 'SCHEDULE EVENT TASK' IS NOT WORKING IN CLUSTER
Root Cause: In a cluster situation, node 1 had a scheduled event that was executed for much longer than 5 minutes. The task in one node was started after the scheduled task started in 1 node. The secondary node did not know if the first node already started a scheduled event.
Resolution: Added a column, server_node_name, in scheduled_event_tracking, to store the node name in this column. Then we can identity which task runs which node.
Bug ID 22900862: IE 11, EXTRA PAGE
Root Cause: If the browser is not FF or IE10, it will always open another window to check JRE.
Resolution: Skip the opening of the window to do the JRE check when using IE11.
Bug ID 22963448: SIZE ATTRIBUTE(ITEM.DOCSIZE) IS NULL WHEN EXPORTING
Root Cause: Always use Parts.Title Block.Size attribute info to resolve list value.
Resolution: If the object class is Document, then use Document.Title Block.Size attribute info to resolve the list value.
Bug ID 22854267: AXML EXPORT OF DEVIATION PROVIDES INCORRECT REVISION INFORMATION FOR ITEM
Root Cause: When the user attempts to set the release date of the introductory rev to 01-01-1900 to make its release date earlier than any change date, the release date is set to current date due because the Calendar is used incorrectly.
Resolution: Adjust the code to set the release date of the introductory rev to 01-01-1900.
Bug ID 23064272: DFM - ADD/GET FILE ATTACHMENTS TAKE 16-18SEC WHILE ON IFS ONLY A FEW SEC
Root Cause: Two factors:
1. Pinging DFM costs a lot of time.
2. When replicating, the check to see if file exists WS call also costs a lot of time.
Resolution:
1. Ping action correct to normal ping servlet approach.2. Remove file exists WS call, instead of using get file size WS call.
Bug ID 22889506: JAVA PX ERROR DURING FILE UPLOAD IS NOT DISPLAYED IN WEB CLIENT UI
Root Cause: UI did not handle the error message from the Agile server.
Resolution: Display the error message and do not refresh the table.
Bug ID 22889469: CHECKIN JAVA PX ERROR DOES NOT REFLECT UPLOAD STATUS ON FILE UPLOAD
Root Cause:
1. JavaScript does not correctly update the page after an exception is caught.2. The sserver updates the DB table, HISTORY_FILE_UPLOAD, setting UPLOAD_STATUS=1, before an exception is thrown. Additionally, there is no rollback action after the exception is caught.
Resolution: 1. Set the error message in the callback function of the check in action in JavaScript.2. Rollback the DB entry after folder check-in fails.
Bug ID 23077369: ERROR ADDING NEW ATTRIBUTE DURING ACP IMPORT
Root Cause: On the server side, an exception is thrown when inserting records to langtable with multiple languages enabled when using ACP import.
Resolution: Handle this special exception when importing attributes with ACP.
Bug ID 23080898: NOT GETTING POP UP WHEN FORGOT TO SAVE REDLINE CHANGES IN FULL DISPLAY MODE
Root Cause: The code does not do an unsaved change check while navigating via backward/forward arrow in full display mode.
Resolution: Added unsaved change check.
Bug ID 22889496: CHECKOUT EVENT ON MULTIPLE FILES NOT RETURNING CORRECT ITEM REVISION
Root Cause: The application does not get rev info from the UI. When an Event object is built, it is passed null as rev.
Resolution: Get the Item rev from the UI. Build the Event object with Change ID and Change class.
Bug ID 23124702: SQL USED TO SETUP THUMBNAIL MAXES DB SERVER CPU
Root Cause: Thumbnails are set up even though thumbnails are disabled. Thumbnail setup SQL is bad.
Resolution: Do not setup thumbnail when it is disabled and correct SQL.
Bug ID 23134768: LONG CHINESE FILENAME SHOWS LFDOWNLOADSERVLET WHEN TO DOWNLOAD
Root Cause: The method, MimeUtility.encodeText(), folds the text if the length is too long.
Resolution: Replace folded string, \r, \n with empty.
Bug ID 23122375: FILELOAD DOES NOT WORK AFTER INSTALLING PATCH 9.3.3.30 USING WEB CLIENT
Root Cause: The system does not correct handle the Linux file path with '/'. After 933.30 it gets an invalid character error when doing an upload on Linux client.
Resolution: Get the file name and ignore '/' to support file load on Linux.
Bug ID 23013844: ERROR WHEN CHANGING LIFECYCLE BY FILL DOWN OPTION UNDER A CHANGE
Root Cause: Fill down/up in UI only uses the attribute id of the selected LCP cell to set rows below/above. The id of the LCP may not be in the other classes.
Resolution: Added LCP check for fill down/up LCP cell case. If class does not have the LCP with the replace id value, but has the same name LCP, the system will use the same name LCP in this class to do the replace.
Bug ID 23274677: SEARCH PPM OBJECT FAILED WITH ERROR: FAIL TO CONVERT TO INTERNAL REPRESENTATION
Root Cause: The Root Parent attribute is added into the select clause for privilege checking. This attribute requires adding three more columns (id, class, subclass). Therefore, this issue is caused by fetching the wrong column value as added three more columns in select clause.
Resolution: Handle the root parent from privilege checking the same as the one to be output column.
Bug ID 23343504: ISSUE WITH GET FILE ATTACHMENT WITH HTTPS://CONNECTION
Root Cause: Download servlet cannot get the correct url when doing forward. So it use request URL to redirect request. but sometimes request URl is different with user preferred File Manager URL. It causes the download to fail.
Resolution: Put user preferred URL in request parameters instead of request URL.
Bug ID 23483391: POP UP DOES NOT APPEAR WHEN USER FORGETS TO SAVE REDLINE CHANGES IN FULL DISPLAY MODE
Root Cause: The code does not do an unsaved change check while navigating via backward/forward arrow in full display mode.
Resolution: Added unsaved change check.
Bug ID 23520126: AGILE IMPORT ISSUE WITH MULTI LIST ATTRIBUTES
Root Cause: When the aXML file contains flexible attributes, the XML node of the multilist attribute inside the source file is treated as non-multilist.
Resolution: Correct the logic of determining whether or not an XML node inside the source file is a multilist.
Bug ID 23623043: AGILE CLASSES REPORT SHOW BLANK FOR NUMERIC ATTRIBUTE MIN VALUE WITH MINUS VALUE
Root Cause: When typing in a negative value for MIN VALUE, after loading data, Agile compares MIN VALUE with Double.MIN_VALUE when Double.MIN_VALUE is between 0 and 1 and negative value is less than Double.MIN_VALUE. The value is consequently set to empty.
Resolution: Compare MIN Value with - Double.MAX_VALUE instead of Double.MIN_VALUE.
Bug ID 23573090: USER ABLE TO IMPORT EXT GROUPS TO ITEM USERGROUP ACCESS-INTERNAL FIELD
Root Cause: Before import, illegal values that do not meet the criteria have not been ruled out.
Resolution: First select the result lists based on criteria, and then check if the user-given value is in the list.
Bug ID 23645490: UNABLE TO RETRIEVE 'JOB FUNCTION' COLUMN VALUE FROM 'FUNCTIONAL TEAM
Root Cause: Functional Teams.Job Function(s) is a multilist attribute, but its value was constructed as a text attribute.
Resolution: Construct a multilist value for the Functional Teams.Job Function(s) while loading from database.
Bug ID 24351704: *NULL VALUES BEING DISPLAYED WHEN LARGE NUMBERS OF USERS ASSIGNED
Root Cause: Wrong type is passed when retrieving user data.
Resolution: Explicitly pass the correct type, rather than getting from attribute.
Bug ID 24292326: LIST TYPE ATTRUBUTE OF FEW LIST HAVE CHANGED TO SEARCH
Root Cause: When list record size is greater than Maximum List Values Displayed set on the admin side, Agile switches the UI control from list to search, as well as the display type of the list in the cache.
Resolution: Block auto switch from UI, especially on titleblock, grid table and search. Enable to manually change and save display type via Java Client.
Bug ID 24358717 FUNCTIONAL TEAM QUERY NOT GIVING CONSISTENT RESULTS BETWEEN WEB CLIENT
Root Cause: SDK query only gets some of the available values for the User Group list and then compares these values with the search condition.
Resolution: Changed the logic to get all available values for the User Group list and then compare these values with the search condition.
Bug ID 24374300: NOT ABLE TO OPEN THE ACTION ITEM FROM REVIEW OBJECT
Root Cause: There is no special handler for the ''' and '"' in the subject of an Action Item.
Resolution: Added a special handler for ''' and '"' in the subject of an Action Item.
Bug ID 24305162: LIST TYPE ATTRIBUTE OF FEW LIST HAVE CHANGED TO SEARCH
Root Cause: When the list record size is greater than Maximum List Values Displayed set on the admin side, Agile switches the UI control from list to search, as well as the display type of the list in the cache.
Resolution: Block auto switch from UI, especially on titleblock, grid table and search. Enable the ability to manually change and save display type via Java Client.
Bug ID 24461182: THUMBNAILS DO NOT GET GENERATED
Root Cause: If some cookies have a null value, it blocks the thumbnail server authentication.
Resolution: Filter out all null value cookies when doing authentication.
Bug ID 24467424: SEARCH ISSUE WHEN LARGE NUMBER OF USERS ARE ASSIGNED TO JOB FUNCTION
Root Cause: The Functional Team has its own table that is not stored in the User Group table.
Resolution: Get correct database table for Functional Team
Bug ID 24500659: CHANGE.AFFECTEDITEM.MULTILIST02 BEHAVES DIFFERENT THAN MULTILIST10
Root Cause: The max length of PAGETWO.MULTILIST01(MULTILIST02 and MULTILIST03 are the same) is 255 bytes. Those whose length is more than 255 are cut to 255 and are saved into table PageTwo.
Resolution: If the string length is more than 255, set ",-1," to multilist01 in table PageTwo. When getting the value of attribute multilist01, load the full result from table MSATT.
Bug ID 24592795: NODE (18022 , 2480887) DOES NOT EXIST IN THE CACHE ERROR WHEN CREATING SUBCLASS
Root Cause: When checkinf the P3 flexible attribute of a newly created subclass, the subclass id is not passed.
Resolution: Pass the subclass id when checking the P3 flexible attribute of the newly created subclass.
Bug ID 24564941: ADVANCE SEARCH REPORTS DELETED OBJECT IN DYNAMIC LIST AS NO PRIVILEGE
Root Cause: When an object is soft-deleted or hard-deleted, the multilist value referencing this object is not deleted in the database side. In the query result, the server side does not return any value if the current object is in the delete state.
Resolution: When an object is soft-deleted or hard-deleted, the server-side check references the object delete status before adding its value into the query result.
Bug ID 24602367: SEARCH ISSUE WHEN LARGE NUMBER OF USERS ARE ASSIGNED TO JOB FUNCTION
Root Cause: Functional Team has its own table, not stored in the User Group table.
Resolution: Get the correct database table for the functional team.
Bug ID 24651232: WHERE USED TAB OF FUNCTIONAL TEAM NOT LOADING
Root Cause: The SQL to get whereused is not correct.
Resolution: Tuned the bad SQL.
Bug ID 24702136: SYSTEM RETURNS JAVA.LANG.NULLPOINTEREXCEPTION WHILE CHANGING TASK STATUS IN PPM
Root Cause: A user who made some changes on workflow has been deleted permanently. Then when changing the status and loading the workflow table, the deleted user can NOT be found and null pointer exception is thrown.
Resolution: Handle the nulllpointer exception.
Bug ID 24675460: IN IE11 DOCUMENT MODE IS NOT FORCED TO
Root Cause: Browser detection fails when running in IE11.
Resolution: Force IE to go to the IE7 document mode and resolve the found bugs.
Bug ID 24694426: SDK RETURNS WRONG COUNT OF SUBSTANCES IN MFR PART.
Root Cause: The loading flag in user context is not reset before invoking the Event script PX.
Resolution: Reset the loading flag to load all substances.
Bug ID 24933696: ECR/DEVIATION REV COLUMN ISSUE.
Root Cause: Class has not been checked before class casting, which leads to a ClassCastException.
Resolution: Check class before casting.
Bug ID 24785838: ERROR CODE: 985 OCCURS AFTER CHANGING THE SDK USER FROM SYSTEM USER
Root Cause: Agile generates a session ID for a WebLogic LDAP authenticated user by the user principal signature, so the session ID is not unique if it invokes a WSX service concurrently with the same LDAP user account. All the WSX invocations share the same session. If one of the WSX invocation finishes, it logs out the user and terminates the session, then the incomplete web service invocation will have a Null Point error.
Resolution: Generate a unique session ID for each invocation of WSX service.
Bug ID 24464004: UPCOMING ACTIVITIES AND ACTION ITEMS ARE NOT LOADING
Root Cause: TheTableComparator's compare method is not transitive. When comparing date, null value is treated as equal to any other date, but this is not reasonable. An exception may be thrown when using it to sort.
Resolution: Fix the compare method. The Null value will be larger than any other date.
Bug ID 24464382: FUNCTIONAL TEAM DETAILS DISPLAYED WRONGLY ON USER PROFILE
Root Cause: The function team of a user displays more FT when responding job functions have many users that exceed maximum multiple list entry length. The server has the wrong codes to fetch FT data.
Resolution: Correct the codes to get correct FT data.
Bug ID 24952656: DYNAMIC LIST WITH CRITERIA SET FOR SUPPLIERS SHOW SUPPLIER NAME IN WEB CLIENT
Root Cause: Application currently gets the Supplier Name from the cache.
Resolution: Get Supplier display name from cache when displaying QCR.
Bug ID 24843233: NEEDS 9.3.3.0.170; HAS A CONFLICT BETWEEN 9.3.3.0.67 & 9.3.3.0.125.
Root Cause: Browser detection fails when running in IE11.
Resolution: Force IE to go to the IE7 document mode and resolve the bugs.
Bug ID 24956464: ADD AN ITEM IN THE RELATIONSHIP OF ANOTHER ITEM VIA SDK API AND JSP
Root Cause: The incorrect object is used to register the event.
Resolution: Set the correct object ID.
Bug ID 25037483: CANNOT ADD ANY BOM COMPONENT TO ITEM
Root Cause: The length of collection t_varchar2s defined at the system level is 32. When an object number is larger than 32, doing external rollup throws a numeric or value error exception.
Resolution: Exceed length of t_varchar2s to 300.
Bug ID 22708010: API ALLOWS ASSIGNING INACTIVE LIST VALUE TO LIST
Root Cause: This is caused by a list attribute validation defect in SDK if a CascadeList is used during setvalue.
Resolution: Additional validation was added to throw an error if an attempt is made to set an inactive list entry value to an attribute.
This section includes Hot Fixes included in Agile PLM 9.4.0.
Bug ID 21645895: EC ATTACHMENTS, PDF, VIEWABLES
Root Cause: In 934, EC does not process the configuration of PublishAttachments in CAXConfig.xml. The correct logic will only have these viewable files when publishing the files to the Item's Attachment table if the customer configure it.
Resolution: Make sure that the viewable files is published to Item correctly if the customer configures PublishAttachments in CAXConfig.xml
Bug ID 21779707: ITEM DATA IS MISSING IN ACS OUTPUT FILE
Root Cause: The loop index to process batch is not increased correctly.
Resolution: Correct the loop index.
Bug ID 21908877: LENGTH OF URL FIELD IN REFERENCE_OBJECT TABLE IS TOO SMALL
Root Cause: The size of URL column of table REFERENCE_OBJECT is small (255 char).
Resolution: Change the size of URL column of table REFERENCE_OBJECT to 2000 characters.
Bug ID 21902250: PASTING TEXT INTO LARGE TEXT FIELD REMOVES FORMATTING
Root Cause: If the user copies text from Editor, for example, Windows Notepad or Notepad++, to LargeText editor, line breaks generate html tag </br>, but </br> is not allowed.
Resolution: Allow html tag </br>.
Bug ID 21977627: AGILE CONFIGURATION AND PROPAGATION DOES NOT IMPORT NOTIFICATIONS
Root Cause: This is caused when the ACP import's target A9 system does not exist and the customized notification, which was created in the source A9 system, does the updating after creation, but it cannot get the ID, so it throws the nullpoint exception.
Resolution: If the target A9 system does not exist the customized notification (which was created in the source A9 system), just create it, because there is no need to do the update. Update is only used for an existing object.
Bug ID 22021795: THE MULTI-TEXT FIELDS WRAP THE TEXT IN THE MIDDLE OF A WORD.
Root Cause: word-break: break-all; This CSS property breaks word.
Resolution: Remove this CSS property: word-break: break-all;
Bug ID 22052448: UNABLE TO BLANK OUT NUMERIC ATTRIBUTE FIELDS
Root Cause: If the numeric field is blanked out, the code to parse the entered value returns a NULL Number object. Getting the double value by Number.doubleValue throws a NULL pointer exception.
Resolution: Rewrite the logic to compare entered value and old value.
Bug ID 22128958: 9.3.4 IS LOOKING AT THE CHANGE AS A WHOLE
Root Cause: We only check privilege on class level and do not do the subclass level check.
Resolution: Involved subclass id verification when checking Required fields.
Bug ID 22095842: CANNOT RUN IMPORT FROM THE AGILE CLIENT WITH NON-EXISTING PARTS IN AGILE 9.3.4
Root Cause: This is a nullpoint issue, because the Part that is imported in the aXML file does not exist in the system, so it throws the error.
Resolution: When doing the import, first determine if the Part exists. If it exists, the code will go on, otherwise skip.
Bug ID 22033395: VISIT AGILE PLM SERVER BY IP ADDRESS, CANNOT UPLOAD FILE
Root Cause: Only a URL entered into Java Client's Web Server URL can be used to do file upload. This is used to check the origin of request that can be allowed to access file server for uploading from web client. The IP address of the server will also be treated as an unaccepted URL.
Resolution: We provided configuration in the file server's server.conf for extra access URLs so that File server considers those URLs as valid "Access-Control-Allow-Origin". After the installation of each file server, add those extra Agile access URLs to the configuration parameter "extra.allowedorigin.appurl", and separated by ";". This solution can also be used for proxy servers.
Bug ID 22308397: UNABLE TO SAVE FILES FROM MCAD CONNECTOR INTO AGILE
Root Cause: There is an NPE if the subclass part is deleted. It is caused by the code to check the whether the attributes (part > relationship > text01, part > relationship > text02, design > relationship > text01, design > relationship > text02) enabled or not in the subclass level.
Resolution: If the subclass part is deleted, omit the checks to avoid the NPE that causes the issue.
Bug ID 22293199: WRONG FORMAT FOR NUMERIC FIELD IN AXML OUTPUT FOR FRENCH LANGUAGE
Root Cause: The French system's number format is different form standard English.
Resolution: Convert the number format to English format.
Bug ID 22234155: WORKFLOW EXIT REQUIRED FIELDS NOT ENFORCED
Root Cause: If an update is made to the attribute Relationship.name, the attribute id changes and the original special handler misses it.
Resolution: Got the base id of the attribute and made the handler make sense.
Bug ID 22288264: THE STATUS OF LOCAL FILE SHOULD BE SYNCED TO AGILE EVEN THE USED
Root Cause: There is NPE when the user selects the row that is associated with the specified Item in the Save Preview window. This is caused by getting the cascade list data that value is removed or nonexistent.
Resolution: Make sure the NPE is resolved and can get the correct Item and version information when the row is selected in the Save Preview window.
Bug ID 22478088: SEARCH RESULT EXPORT CONVERTED INTO USER'S LOCAL TIMEZONE
Root Cause: For Activity common attributes, it does not show date time as configured in Java Client when exporting.
Resolution: For Activity common attributes, only show the date if date only, not date and time.
Bug ID 22465085: AGILE 934 AUDIT STATUS PROVIDING INCONSISTENT RESULTS
Root Cause:
Case 1: The root cause is that when we open an Item with a certain rev, the rev information is stored in the user context. When the user then opens a Change object to do an audit some privilege checks are done for Affected Items using the rev information stored in the user context. The mismatch between rev stored in user context and the Affected Item object causes the problem. If there's criteria related to rev or rev attributes the priv check returns wrong result. Case 2: Once a user manually changes the tab name from 'Page Two' to 'Document Info' a new hereditary node is created in the database for this subclass level table. The fix of 934HF42 gets the subclass node by invoking some admin side API, but it returns the wrong node which causes the problem.
Resolution:
Case 1: Reset the rev for the correct AI's which is being dealt with at run time. Set the original rev back to context after the required fields check is finished. Case 2: Check if the enabled tab id either equals to one of the enabled tables at subclass level, or equals to any inherit id of the enabled tables at subclass levels.
Bug ID 22481579: SPECIAL CHARACTERS IN NOTIFICATIONS AND COMMENTS ARE BEING REPLACE
Root Cause: When the user goes back to the Comments page, the value of comments is encoded twice.
Resolution: Choose encoding one time
Related Bug: 22553818: SPECIAL CHARACTERS IN NOTIFICATIONS AND COMMENTS ARE BEING REPLACED
Bug ID 22510989: APOSTROPHE IN MANUFACTURER PART NUMBER THROWS ERROR
Root Cause: We do not use the correct approach to handle the Manufacturer Part Number which contain the apostrophe in any position.
Resolution: Use the existing method TextUtility.parseEscapeSingleQuote to handle the case correctly.
Bug ID 22373933: MANDATORY FIELD IS NOT ENFORCED IF DATA IS CHANGED AT DIFFERENT PAGE/TAB
Root Cause: There are three tables on Items: Cover Page, Page Two, Page Three. When redlining items, the required attribute is not checked if there is no attribute changed within that table.
Resolution: Set the attribute isEdited to true in the three tables, even though there is no attribute changed on these three tables.
Bug ID 22380646: UNZIP UPLOAD FAILS IF ZIP FILE CONTAINS FILE WITH MULTIBYTE CHARACTERS
Root Cause: This issue is caused by JDK and zip software issues. The zip file may not be encoded properly in UTF-8.
Resolution: Try to unzip in Charset "Cp437". Refer to http://bugs.java.com/view_bug.do?bug_id=4244499.
Bug ID 22506922: EXTERNAL USER ENCOUNTER APPLICATION ERROR WHILE SIGNOFF WORKFLOW STATUS
Root Cause: If the approver does not have privilge to view the new status of a Change this issue occurs. On the server side, an empty Cover Page table is returned, but we still try to get the status attribute, so there is an out of bounds exception.
Resolution: Validate if the table contain any row data before getting an attribute from it.
Bug ID 22450150: ACS OUTPUTS DATE IN FORMAT DATE & TIME REGARDLESS OF THE ADMIN TYPE
Root Cause: The XML schema definition for date attribute value is xsd:dateTime, date only value '2015-2-15' is invalid.
Resolution: Change the aXML schema definition to allow xsd:dateTime and xsd:date for Agile date attribute value.
Bug ID 22550304: GANTT CHART SHOWS BLANK SCREEN AFTER SAVING
Root Cause: When the user saves the Gantt chart, there are 2 steps: 1. Update and, refresh and expand all the leaf nodes, and 2. The UI is set to editable.
The user can edit a few cells during the period - after updating before refreshing, after expanding all, the user will be confused as changes are messed up.
Resolution: Set the UI to be not editable until the leaf nodes are refreshed and expanded so that the terminal user can not edit cells during the process.
Bug ID 22600566: LONG CHINESE FILENAME SHOWS LFDOWNLOADSERVLET WHEN TO DOWNLOAD
Root Cause: Method MimeUtility.encodeText() folds the text if the length is too long.
Resolution: Replace fold string, \r, \n to empty
Related Bug: 22727241: AGILE 9.3.4 FILE DOWNLOAD ISSUES DUE TO INVALID CHARACTERS
Bug ID 22674951: SQL USED TO SETUP THUMBNAIL MAX'ES DB SERVER CPU
Root Cause: Thumbnails are set up even though thumbnail is disabled. Thumbnail setup SQL is bad.
Resolution: Do not setup thumbnail when it is disabled and avoid SQL tuning.
Bug ID 22713023: DISCUSSION DATE/TIME IS NOT IN ORDER
Root Cause: The reply order should be in the timestamp sequence not by the id sequence.
Resolution: Order the replies in timestamp sequence.
Bug ID 22729850: ERROR WHILE INVOKING .NET WEBSERVICE FROM PX
Root Cause: SDK has a custom hot deploy class loader which is used to deploy the Process Extension (PX) JAR files. Inside the PX, JAXWS is used. While the PX is triggered, the current thread context loader is not the SDK hot deploy class loader, so the current thread can read some class files which are loaded by the SDK hot deploy class loader.
Resolution: Set the SDK hot deploy class loader as thread context class loader while executing a PX.
Bug ID 22761592: DUAL IDENTIFICATION REQUIRED FLAG FOR WORKFLOW STEPS WHERE STATUS TYPE=RELEASED
Root Cause: When the user does a Save As/New release status of a workflow, the Dual Identification Required property is not inserted into the node.
Resolution: Add this property to release status of workflow when doing a Save As/New status.
Bug ID 22674235: AGILE 9.3.4 BOM REDLINES MISSING WHEN LAST RELEASED CHANGE IS SCO
Root Cause: 1. The logic for checking whether the revision of the Affected Item added to SCO is the latest rev is wrong. The current logic may use pending revision for checking.2. The redline deleted BOMs will be filtered out if the rev of Affected Item that is added to SCO is not the latest revision.
Resolution: Correct the logic of the check to filter out the pending revision directly, and do not filter out the redline deleted BOMs if the redline deleted action is done by the root change itself.
Bug ID 22659501: WARNING MESSAGE WILL POP UP TWICE WHEN DRAGGING MULTI-OBJECT WITH PENDING ECO
Root Cause: The EW.js sends the handle request to the server again even if one warning is handled already.
Resolution: If one warning is handled already, do not send handle request to server.
Bug ID 22671630: WHEN SAVING AN OBJECT MORE THAN ONE MISSING FIELDS, SHOWS "...YOU HAVE ONE ERROR"
Root Cause: This is caused by a code defect introduced by bug 19162231 and 21118850.
Resolution: Use the proper approach to handle the case if the class type is changed, and show the right count of the errors size.
Bug ID 22379231: IE 11, EXTRA PAGE
Root Cause: If the browser is not FF or IE10, it will always open another window to check JRE.
Resolution: Skip the open JRE check window when using IE11.
Bug ID 22846280: GANTT REFRESH TIME IS UNACCEPTABLE
Root Cause: It takes time to refresh the Gantt chart during the Save action; and the Refresh action is introduced in 934 comparing with the previous version.
Resolution: Run the SQL script to correct the data type to be double for attribute 2000000100.
Bug ID 22887140: DRAG AND DROP ITEM ON UPDATE TABLE EVENT FAILING EVEN WITH 9.3.3.0
Root Cause: The change key object ID could be `-1' , This is not a valid object ID, but it is not caught and handled properly in EventDirtyRowUpdate#getReferent().
Resolution: If the change key object ID is `-1',then set the change object key to null.
Bug ID 22878739: COMPLIANCE CALCULATIONS FOR A PART ARE NOT AS EXPECTED.
Root Cause: When updating a specification, the cache table specification_substances is not refreshed.
Resolution: After modifying an existing specification, the cache table specification_substances will be cleared according to the specification.
Bug ID 22385677: BAD INDEX 1:1 WHEN CLICKING ON ATTACHMENTS TAB
Root Cause: When the file version is loaded, there is an Out of Range error.
Resolution: Check the version size before loading.
Bug ID 22854830: EXPORT MANUFACTURER DOES NOT INCLUDE THE RELATIONSHIP INFORMATION
Root Cause: The total number of supported tables is not updated when adding support for the Relationship table, and this causes the relationship table to be ignored
Resolution: Update the total number.
Bug ID 22905607: DMS HEADER PROPERTIES OF AN ATTACHMENT OPEN THROUGH AUTOVUE HAS WRONG INFORMATION
Root Cause: The vuelink did not pass F5 cookies info to the request header, so F5 can not correctly load the balance.
Resolution: Add all cookies when executing a web service request from AV.
Bug ID 22898248: RUNNING CHANGE PACKAGE REPORT BRINGS AGILE 9.3.4 SYSTEM DOWN
Root Cause: There is a loop condition.
Resolution: Remove the loop condition.
Bug ID 22898970: UNABLE TO IMPORT SOME FIELDS FOR COSTING
Root Cause: This issue was introduced when upgrading POI-3.0.1-Final to POI-3.5-Final in the Agile 9.3.1 release. The way to check whether a FormulaRecord has a cached string value in the following StringRecord is change in POI-3.5-Final.
Resolution: Use the new method FormulaRecord .hasCachedResultString() in POI-3.5-Final.
Bug ID 22917939: 'HAS PENDING CHANGE' FLAG IS INCORRECTLY SET ON ITEM THAT HAS NOT CHANGED
Root Cause: We do not copy the Item status flag from the old row to the new row if there is a redline on any attributes on the Item BOM.
Resolution: If any attributes of the Item BOM are redline, copy the item status flag from the old row to the new row.
Bug ID 22822669: FAILED CHECK IN FILE WITH A SPCECIAL NAME
Root Cause: The wrong method is used to fetch the file name and suffix.
Resolution: Correct the code to get the correct filename and suffix.
Bug ID 23004827: DURING IMPORT SPECIAL CHARACTERS GET OVERWRITTEN, WHEN USING TRANSEXTERNAL ROLLUP RETURNING INCONSISTENT & INCORRECT CALCULATED CONC RESULTS ON SP
Root Cause: The incoming value was encoded by WebSecurityAPI and inserted into the database.
Resolution: The value encoded by WebSecurityAPI should only be used to display in the web UI and the original incoming value should be inserted into the database.
Bug ID 23071115: EXPORT A CHANGE ORDER WITH A SPECIFIC SITE ERROR
Root Cause: A null point exception is caused by a check for privilege on a null revision.
Resolution: Check if the revision is null before checking privilege.
Bug ID 23101220: EFFECTIVE BOM EXPLOSION REPORT HAS NO DATA
Root Cause: Date conversion error between user format and database format.
Resolution: Only do the conversion when displaying date on the UI.
Bug ID 23108843: CANNOT ADD ANY BOM COMPONENTS TO ITEM
Root Cause: Length of collection t_varchar2s defined on system level is 32. When the object number is larger than 32, doing an external rollup throws a numeric or value error exception.
Resolution: Exceed length of t_varchar2s to 300.
Bug ID 23065019: USER WITHOUT READ PRIV TO THE USERS CAN SEE THE LIST OF CHANGE ANALYSTS
Root Cause: When getting possible values for users, the system does not check whether the current user has privilege to access the users in the user list.
Resolution: Added a privilege check when getting possible values for users.
Bug ID 23139730: VISIT AGILE PLM SERVER BY IP ADDRESS, CAN NOT UPLOAD FILE
Root Cause: Only the URL entered in Java Client's Web Server URL can be used to do file upload file. This is used to check the origin of the request that can be allowed to access file server for uploading from Web Client. Therefore, the IP address of the server will also be treated as an unaccepted URL.
Resolution: We provided configuration in the file server's server.conf for extra access URLs so that the File Server considers those URLs as valid "Access-Control-Allow-Origin". Post-installation of each file server, add those extra Agile access URLs to the configuration parameter "extra.allowedorigin.appurl", and separated by ";". This solution can also be used for proxy servers.
Bug ID 23195668: ADD AN ITEM IN THE RELATIONSHIP OF ANOTHER ITEM VIA SDK API AND JS
Root Cause: When the user attempts to enable an event trigger, update event information fails because row Object ID is set incorrectly. Thus, when Object cache is created, it throws a "no target object class ID" exception.
Resolution: Change the server event code to get the correct object ID.
Bug ID 23146980: NOT ABLE TO RESTRICT EXTERNAL USER READ ACCESS BASED ON #CURRENTREV
Root Cause: Get the incorrect change key when the row under the AI tab is highlighted.
Resolution: Use the proper logic to get the correct change key when the row under AI tab is highlighted.
Bug ID 23183928: PERMISSION ISSUE WHEN LIMITING ACCESS TO WORKFLOW NEXT STEP
Root Cause: The Agile System checks the privilege of change backward status privilege to decide whether the Next Status button is available.
Resolution: Enable the Next Status button if the current status has next status even if there is no default backward status.
Bug ID 22910065: SDK IQUERY DOES NOT WORK AFTER MOVING TO 9.3.4
Root Cause: ADList.getIDNameList() returns the wrong value for supplier list.
Resolution: Fix the issue.
Bug ID 23219770: UNABLE TO USE FILL-DOWN IN CHANGE ORDER'S AFFECTED ITEM
Root Cause: Fill down/up in UI only uses the id value of the selected LCP cell to set rows below/up. The id of LCP may not in all other classes.
Resolution: Added LCP check for fill down/up LCP cell case. If class does not have the LCP with the replace id value, but has same name LCP, the system uses the same name LCP in this class to do the replace.
Bug ID 23213968: MISSING DOT ICON ON ATTACHMENT TAB
Root Cause: The Attachment flag is not updated after inserting into table REV.
Resolution: Insert the latest attachment record into table REV by popup window to select process model (with or without attachment) according to Java Client settings.
Bug ID 22650284: CANNOT IMPORT MAPPED MS PROJECT
Root Cause: In 934, we only certify the MSP2010 base version, not any upgrade versions (14.0.7165.5000 or above). On the customer side, the version is 14.0.7165.5000. Microsoft project delivered a patch to solve some security issues and it made some cases not work for PPM/MSP integration.
Resolution: Changed code to adapt new MSP version (14.0.7169.5000).
Bug ID 23508732: NUMERIC P2 ATTRIBUTE VALUE IS NOT DISPLAYED WHEN TYPE IS DOUBLE
Root Cause: This issue is caused by HF934.11 that supports the flag isLoadPartsP1P2P3InBatch. If the client sends this flag, there is a ClassCastException error thrown when A9 code tries to cast a string to double type.
Resolution: Resolve the ClassCastException and make sure that the client gets the correct the numeric.
Bug ID 23521927: VALUE BEING APPENDED INSTEAD OF OVERWRITTEN TO A BOM ITEM NUMBER
Root Cause: 934HF29 causes the append issue in the BOM Item number.
Resolution: Fix 934HF29 so that BOM Item number and Manufacturer Part number do not get appended to.
Bug ID 23497688: EXPORT WEB SERVICE FAILED WHEN USING SOAP UI TOOL
Root Cause: Validation is failed when soapui opens the WSDL file. That is because the XML element <xs:all> has the 'unbounded' definition for its child elements in the export schema definition. The child elements, however, only occur zero or one time.
Resolution: Correct the schema definition.Use the element <xs:sequence> instead of <xs:all> to fix it and <xs:sequence> specifies child elements can only appear in the order mentioned.
Bug ID 23086616: WEB SERVICE EXTENSION (WSX) HAVE TO CALLED INTERNALLY BEFORE THEY
Root Cause: Apache reversed proxy is used and SSL is enabled at the proxy tier, but WebLogic application server does not enable SSL. While the user accesses the WSX URL via HTTPS, the request URL protocol is HTTPS, so the WebLogic application server can not publish the web service to a HTTPS URL address.
Resolution: Construct an HTTP URL address to publish the web service.
Bug ID 23254372: ATTRIBUTE HISTORY REPORT DOES NOT GENERATE THE ATTRIBUTE CHANGE HISTORY
Root Cause: This issue is caused by the defect of bug [10205415]. An object cannot get the right subclass/class id, if the customer set privilege on subclass/class level, it skips rev related info.
Resolution: Set the correct subclass/class id for object and check privileges.
Bug ID 23703346: EXTERNAL ROLLUP (BATCH AND AD-HOC) NOT RETURNING SUBSTANCES IF BOM PART QTY IS 0
Root Cause: When one of the BOM part's QTY is set to 0, there will be a substance whose calculated mass is 0 in table result_substance_compliance. When validating the substance, the total count (include 0) and valid count (non-zero) in table result_substance_compliance does not match. As a result, no substance will be returned.
Resolution: Making valid count include 0 substance.
Bug ID 23732544: % COMPLETE DOES NOT MATCH FOR MILESTONE WHEN DURATION IS 0
Root Cause: For the Gate object, when importing from MSP to PPM, percent complete column will be reset to 0 duration. It is considered as a defect.
Resolution: Set percent complete to the value before importing Gate object.
Related Bugs:
23666747: SUCCESSOR AND PREDECESSOR LINKLAG NOT PROPERLY IMPORTED
24494414: OOB - ESTIMATED FLAG OF PPM GENERATED ACTIVITY/GATE SHOULD ALWAYS BE SET TO NO
Bug ID 23723485: BUSINESS OBJECT WEB SERVICE
Root Cause: Double value from SOAP request is not formatted properly.
Resolution: Correct the format.
Bug ID 23718233: SDK IQUERY DOESN'T WORK AFTER MOVING TO 9.3.4
Root Cause: The server side does not return list value for criteria-based dynamic list for supplier.
Resolution: Use a special handler to return criteria-based supplier list value.
Bug ID 23490591: INTRODUCED, APPROVE/REJECT/ACKNOWLEDGE BUTTONS VISIBLE
Root Cause: After the workflow is signed off and auto-promotes tothe next status, the user has no read privilege on this object, yet the Approve, Acknowlege, Reject and Comment buttons are still available because the read privilege is not checked.
Resolution: When clicking these buttons, check the read privilege of the current user in JSP Pages.
Bug ID 24289278: IMPORTED MPP PROJECT AUTOMATIC UPDATE OF DURATION OF PPM WHEN EDITING AND SAVING
Root Cause: When the display type of Calendar Library is set to Search, the format of the selected entry is like ClendarName=CalendarID, not just CalendarID in the dropdown list. The calendar ID is parsed as 0 and gets non-working day as working day. This is why the schedule end date moved forward.
Resolution: Change the code to adapt for both formats: calendarID or ClendarName=CalendarID.
Bug ID 24312919: NOT ABLE TO EXPORT CHANGE WITH SPECIFIC SITES EVEN AFTER INSTALLING PATCH 125
Root Cause: When the PGC license is disabled, some special attributes are not readable, and the export logic tries to remove attribute values from revision, but the revision could be null.
Resolution: Check revision before using it.
Bug ID 24344788: LARGE TEXT DOES NOT SUPPORT CHANGE CONTROLLED FUNCTIONALITY AND REDLINE CHANGES
Root Cause: Large text data is not copied from P3 when releasing a change.
Resolution: Copy the large data for Page 3 in the release change process.
Bug ID 24285313: AFTER SAVE/CHECK-IN, LIST VALUE WITH SPECIAL CHARACTER NOT VISIBLE
Root Cause: This issue is caused by the list values which have the special character defined by regular express. Since the ECS implementation is based on search that supports regular express character to match, if the matching is not correct then it can not save the value to Agile Server.
Resolution: For this case, we do not need to consider the value if there is a regular express character. Ensured that the value can be saved to the Agile Server and can be displayed in web UI correctly.
Bug ID 24368578: UNABLE TO IMPORT THE PPM PROJECT FROM ONE AGILE INSTANCE TO ANOTHER
Root Cause: This is a code defect. There is an out of boundary exception of int when handling linklag of dependency.
Resolution: Changed from int to long for this case
Bug ID 23616874: JAVA.NET.PROTOCOLEXCEPTION ON AGILE SSO ENVIRONMENT WHEN ADDING AF
Root Cause: The response buffer flush is not correct when adding object by search.
Resolution: Set correct response string length, and refresh buffer.
Bug ID 23249804: UPLOAD FILE FAILED IF CHOOSE UNZIP OPTION
Root Cause: The uploaded file name is encoded by GB2312, but Agile uses UTF-8 to decode file name.
Resolution: Use UTF-8 to decode the file name. If it fails, try to use login user preference settings.
Bug ID 24401812: GATE ESTIMATED END DATE CANNOT BE SET TO AN EARLIER DATE ONCE SET
Root Cause: This is a code defect. For the Gate object, Estimated End Date is always the same as Estimated Start Date. When choosing an earlier date, it will ignore it.
Resolution: Need to specially handle Estimated End Date for Gate.
Bug ID 24529954: SSL CONFIG ON DFM CAUSING HTTP AND HTTPS MIXED CONTENT
Root Cause: The download servlet cannot get the correct URL when doing a forward. Therefore, it uses the request URL to redirect the request, but sometimes the request URl is different from the user preferred File Manager URL. This causes a download fail.
Resolution: Put the user preferred URL in the request parameters instead of request URL.
Bug ID 24573174: SEARCH FAILS -- ERROR: ORA-00904:
Root Cause: The customer created flexible attributes and they are all stored in the agile_flex table. Those flexible attributes default admin value is not Database column. Query side gets invalid database column when parsing the database column for flexible attribute.
Resolution: When the query condition or output attribute is flexible attribute, handle it to get the correct database column value as multilist value.
Bug ID 24572430: NO DUPLICATE NAME REMOVAL SUGGESTION WHEN ADDING SAME USER AS APPROVER AND OBSERVER
Root Cause: The duplicate names removal suggestion window has been removed since 9.3.2.
Resolution: Implement these functions when duplicate names are found. The user can click 'Resolve duplicates' button to launch the suggestion window.
Bug ID 24610371: PROJECTS MUTLIST01 VALUE ON FILES TAB OF FILEFOLDER DISAPPEARS ON
Root Cause: This is a discussion cache issue. We do not refresh cache after the attachment file is changed.
Resolution: Refresh Attachment table when adding files to file folder.
Bug ID 24613961: YOU DO NOT HAVE THE READ/DISCOVER PRIVILEGE OCCURS WHEN TRY TO OPEN OBJECT
Root Cause: When loading the discover object with multi QCR/PSR objects at one execution, some of the resulting discover objects lose the supplier/customer attribute. This makes it so that the user cannot pass the privilege check in issue case.
Resolution: Correct logic to discover object for QCR/PSR.
Bug ID 24577918: EMPTY BOM COMPARISON REPORT IS GENERATED
Root Cause: The BOM Comparsion report does not handle special characters when generating XML files.
Resolution: Handle XML special characters.
Bug ID 24614700: ACS SUBSCRIBER PROCESSING ALL RECORDS DESPITE NO CHANGES
Root Cause: While there are two subscriber detail rows with different filter, or role, or format, the ATO created by the scheduled subscriber is extracted multiple times, thus the selected object version is increased multiple times, that cause error while checking if the selected object was changed by its version.
Resolution: Increase the object version in the ACS extract track table and adjusted the SQL query accordingly
Bug ID 24674751: JOB FUNCTION TEAM DOES NOT GET NOTIFY WHEN AUTOPROMOTE SET TO YES
Root Cause: When using auto promote to change status, Agile fails to get Users/User Groups based on job function id using existing API.
Resolution: Get the Users/User Groups based on job function when getting notify users during auto promote.
Bug ID 24741613: UPDATE TABE EVENT THROWS ERROR NODE 0 DOESN'T NOT EXISTE FOR TEMP
Root Cause: For BOM blank row, an exception is thrown when event is triggered.
Resolution: Need to have a special handler for a blank BOM row when event is triggered.
Bug ID 24745790: HUGE BOM IN AFFECTED ITEM REDLINE SWITCH BETWEEN VIEWS TAKE LONG TIME
Root Cause: Do not cache the data for the BOM table.
Resolution: Cache the data for the BOM table.
Bug ID 24741653: APPLICATION ERROR WHILE RUNNING "ATTRIBUTE HISTORY REPORT" FROM ACTIONS MENU
Root Cause: Missed privilege check while displaying the Attribute History report in the Item action menu.
Resolution: Disable the Attribute History report in the Item action menu unless the user has privileges to discover, read and run the Attribute History report.
Bug ID 24712312: CANNOT CREATE MULTIPLE PROJECTS CONCURRENTLY USING THE SAME TEMPLATE
Root Cause: When creating from a template unsuccessfully, we set the template's object id as the new object id.
Resolution: When creating from a template unsuccessfully, set the new object id as null. Meanwhile correct the error message and return the failed status when creating the relationship unsuccessfully.
Bug ID 24766324: SDK FAILS TO RECOGNIZE THE VISIBILITY OF THE FIELD AT SUBCLASS LEVEL
Root Cause: The Class ID is used to get the Page Two attribute meta data, so the Page Two attribute visibility is wrong at the sub class level.
Resolution: Use the subclass ID to get the attribute admin meta data.
Bug ID 24566091: ARCHIVED TEMPLATES APPEAR IN SEARCH DIALOG RESULT
Root Cause: We do not filter archived template when creating from template.
Resolution: Filter archived template when creating from template.
Bug ID 25036713: MERGE HF 155 WITH TO ALIGN GOOGLE CODE BASE
Root Cause: HF155 is incompatible with HF8.
Resolution: Provide HF206 to be compatible with HF8.
Bug ID 25091503: HAS PENDING CHANGE FLAG IS INCORRECTLY SET ON ITEM THAT HAS NOT CHANGED
Root Cause: We do not copy the Item status flag from the old row to the new row if there is a redline on any attributes in the Item BOM.
Resolution: When redlining any attributes of an Item's BOM, copy the Item's status flag from the old row to the new row.
This section includes Hot Fixes included in Agile PLM 9.3.5.0.
Bug ID 23096623: SUPPORT FOR "GENERATE MOBILE STREAMING FILES" FROM AGILE
Root Cause: N/A
Resolution: This is an enhancement.
Bug ID 22585512: AGILE9.3.5 PRODUCT SUPPORTS EDGE AND IE11 BROWSERS OF WINDOWS 10OS
Root Cause: The 935 product does not support IE11 and Edge browsers in windows10 OS.
Resolution: Start to support Edge/IE11 of windows 10 OS in 935 with this HF applied.
Bug ID 22777068: THE MULTI-TEXT FIELDS WRAP THE TEXT IN THE MIDDLE OF A WORD
Root Cause: word-break: break-all; This CSS property breaks word.
Resolution: Remove this CSS property:word-break: break-all;
Bug ID 22950364: SETCRITERIA DOES RESULTS IN JAVA.LANG.NULLPOINTEREXCEPTION FOR GRO
Root Cause: Null point exception
Resolution: If the query is created using base change, then exclude the Affected Files table from searchable tables.
Bug ID 22957414: USING SET AS BEST, PCM COST CALCULATION IS WRONG IN ASSEMBLY COST
Root Cause: We do not pass the Material Price Adder attributes, so it does not include them in the total extended price.
Resolution: Invoke the related method with the Material Price Adder attributes.
Bug ID 23177608: EC SERVICES TO SUPPORT MCAD 3.5
Root Cause: EC Service does not support MCAD3.5.
Resolution: EC Service improved to support MCAD3.5.
Bug ID 23212335: CURRENCY RATE AT TIME OF QUOTATION, THE PROJECT SHOULD KEEP OLD CURRENCY RATE
Root Cause: The system misses the project snap date when getting the report in issue case.
Resolution: Added project snap date when getting report in issue case.
Bug ID 23220900: BOM TAB REFRESHES TO TOP OF TABLE IN INTERNET EXPLORER 11 (IE11)
Root Cause: TreeGrid source Update6.js 374th lines if(this.MainTable) this.MainTable.style.display = "none"; this.MainTable.style.display = ""; Set the display property of MainTable to 'none' and set it back; the vertical scollbar will miss its position.
Resolution: Remember the scrollTop of vertical scrollbar before setting the display property of the MainTable then set it back.
Bug ID 23487699: ATTRIBUTE NAME (LABEL) IS WRAPPING IN MIDDLE
Root Cause: word-break: break-all;This CSS property breaks word. When it contains the " " characters in output text, word-wrap: break-word property can not work well.
Resolution: Remove this CSS property: word-break: break-all;Replace " " by one general space no matter how many spaces the user types in the label attribute.
Bug ID 23623623: CREATE ITEM WITH NUMERIC ATTRIBUTE VALUE ADD EXTRA DIGITS AFTER DECIMAL PLACES
Root Cause: The number value is not rounded.
Resolution: Round the double value with the admin attribute scale.
Bug ID 23596732: DRAG AND DROP ITEM ON UPDATE TABLE EVENT FAILING EVEN WITH 9.3.3.0
Root Cause: The change key object ID could be '-1', but this is not a valid object ID. It is not caught and handled properly in EventDirtyRowUpdate#getReferent().
Resolution: If the change key object ID is '-1', then set the change object key to null.
Bug ID 23597068: SIZE ATTRIBUTE(ITEM.DOCSIZE) IS NULL WHEN EXPORT
Root Cause: Always Use Parts.Title Block.Size attribute info to resolve list value.
Resolution: If object class is Document, then use the Document.Title Block.Size attribute info to resolve list value.
Bug ID 23597938: JAVA PX ERROR DURING FILE UPLOAD IS NOT DISPLAYED IN WEB CLIENT UI
Root Cause: The UI does not handle the error message from the Agile server.
Resolution: Display error message and do not refresh table.
Bug ID 23596802: AFTER APPLYING 9.3.3.0.258 LIFECYCLE PHASE ERRORS OUT: JAPANESE ENVIRONMENT
Root Cause: The is a Japanese language-specific issue. The XML data file in the XLSX file may contain the 'rPh' element. The 'rPh' shows pronunciation of the data text, but the data text inside it should not be extracted.
Resolution: Do not extract data inside 'rPh' element.
Bug ID 23597997: CHECKIN JAVA PX ERROR DOES NOT REFLECT UPLOAD STATUS ON FILE UPLOAD
Root Cause: 1. JavaScript does not correctly update the page after the exception is caught 2. The server updates the DB table HISTORY_FILE_UPLOAD, setting UPLOAD_STATUS=1, before the exception is thrown. Also, there is no rollback action after the exception is caught.
Resolution: 1. Set the error message in the callback function of the check in action in JavaScript. 2. Rollback the DB entry after the folder check in fails.
Bug ID 23623242: ADD AND REMOVE BUTTONS ARE ACTIVE IN DFCO RELEASED STATUS
Root Cause: This bug is caused by the special handler for the DFCO privilege check return before the workflow status check.
Resolution: Move the special handler for the DFCO privilege check after the workflow status check.
Bug ID 23624757: DESCRIPTION IS NOT FILLED WHEN ITEM CREATED BY IMPORT
Root Cause: Import does not handle special characters in Characters set while doing format validation. For example, it does not treat ^s as blank space.
Resolution: Convert special characters in Characters set before doing format validation.
Bug ID 23706122: IMPORT NON VISIBLE MULTILIST VALUE ENDS IN FATAL EXCEPTION OCCURED
Root Cause: Import tries to update an invisible multilist attribute which causes an ArrayIndexOutOfBoundsException.
Resolution: Do not update invisible multilist attribute.
Bug ID 23596625: GETFILENAME USED IN PROCESS EXTENSION DURING CHECKIN DOES NOT RETRIEVE EVERY FILE
Root Cause: This is caused by a code defect. When checking in multiple files, the application does not get all filenames and file ids for event info.
Resolution: Loop all file names and file ids, and construct file name string with all files.
Bug ID 23743008: UNABLE TO BLANK OUT NUMERIC ATTRIBUTE FIELDS
Root Cause: If the numeric field is blanked out, the code to parse the entered value returns a NULL Number object, and getting ouble vlaue by Number.doubleValue will throw NULL pointer exception.
Resolution: Rewrite the logic to compare entered value and old value.
Bug ID 24320626: NO DUPLICATE NAME REMOVAL SUGGESTION WHEN ADDING SAME USER AS APPROVER AND OBSERVER
Root Cause: The duplicate names removal suggestion window has been removed since 9.3.2.
Resolution: Implement these functions when duplicates names are found. User can click Resolve duplicates' button to launch suggestion window.
Bug ID 24350803: UPDATE TABLE BOM/MANUFACTURERS/ATTACHMENT NOT WORKING ON IEV
Root Cause: The API CMSessionBean.logUserDefinedActionWOVersionChang e( ...) should not lock object.
Resolution: Change the API to not lock the object.
Bug ID 24350846: WHEN REMOVING ATTACHMENT IEVENTDIRTYROW.GETACTION() RETURN NUMBER
Root Cause: Agile 935 defined some new delete actions for DFCO related features on the server side and event framework use it directly.
Resolution: If it is a delete action, the API IEventDirtyRow.getAction() always returns 1.
Bug ID 23762754: IE 11, EXTRA PAGE
Root Cause: If the browser is not FF or IE10 it always opens another window to check JRE.
Resolution: Skip open the JRE check window when using IE11.
Bug ID 23857331: CANNOT CONFIGURE CHECKOUT PRIVILEGE FOR DESIGNS
Root Cause: After 9350.11, the application does not check the checkout privilege by object type. This is code defect.
Resolution: Check the checkout privilege by object type.
Bug ID 24422906: HF CONFLICT 9.3.5.0.11: CHECKIN JAVA PX ERROR DOES NOT REFLECT UPLOAD STATUS ON FILE UPLOAD MANAGER.
Root Cause: HF conflict.
Resolution: Rebase HF, this HF includes the code fix for HF935.27,935.29,933.388
Related Bugs:
24422592: HF CONFLICT:JAVA PX ERROR DURING FILE UPLOAD IS NOT DISPLAYED IN
24422674: CHECKOUT EVENT ON MULTIPLE FILES NOT RETURNING CORRECT ITEM REVISIT
Bug ID 24447418: GANTT CHART SHOWS BLANK SCREEN AFTER SAVING
Root Cause: When saving a Gantt Chart, it has 2 steps: update and refresh and expand all the leaf nodes. The UI is set to editable and the user can edit few cells during the period - after updating before refreshing, after expanding all, user will be confused as changes are messed up. The Refresh action is introduced in 934 comparing with previous version.
Resolution: Remove the Refresh action from the Save action just as in the previous version.
Related Bug 24592414: GANTT CHART ERROR WHEN DELETING TASKS
Bug ID 24448116: EXTERNAL ROLL UP NOT ACCURATE
Root Cause: It does not find out the exact rev of the BOM child for ECR on external rollup process.
Resolution: Set the latest MCO or ECO rev as ECR's version.
Bug ID 24572867: EC 3.5 - WORKSPACE MANAGER REFRESH PERFORMANCE
Root Cause: Dynamic list is enabled to search PLM objects. From one web service call, the MCAD client send many objects to Agile and the search query is executed for handling every object (including Design and Item objects) even if the result is the same. These queries takes most of the time.
Resolution: When refreshing in the workspace window, the MCAD client sends the web service request to load the P1P2P3 information of these objects. Once PLM get the request, the web service RetrieveDesignStructure implementation just needs to return the information of the P1P2P3 and make sure these redundant queries are not executed.
Bug ID 24699716: ATTACHMENT FILE NAME INCLUDING PARENTHESIS AND DOT CANNOT BE OPENED
Root Cause: Cannot get file type when file name contains dot and parenthesis.
Resolution: Get the correct file name and file type.
Bug ID 24685758: CANNOT FIND ANY SUBSCRIBER IN EVENT SUBSCRIBERS TAB OF DOCUMENTS CLASS
Root Cause: The following two classes are not packaged into pcserver.jarcom/agile/admin/server/HistoryRecordable.classcom/agile/admin/server/ADNodeAssign.class
Resolution: Added the two class into usedejbclasses.txt to make sure the 2 class will be packaged into pcserver.jar.
Bug ID 24755937: USERS CANNOT ADD ADDERS IN THE QUOTATION SANDBOX A SECOND TIME
Root Cause: When changing price adder by part, by commodity, by supplier, Agile updates the changed adder value and loses the values of other adders in the same price point.
Resolution: Add the original adders's values to update when adding price adders.