3 Resolved Issues

This chapter lists issues that were resolved during this release.

For each resolved issue, on the first line, the number is the internal Defect number.

3.1 Product Collaboration

18858771

Changes

Issue: PENDING CHANGE WARNING LOOP FOR ITEMS THAT HAVE EQUAL SIGN IN PARTNUMBER

Root Cause: The privilege check for an object in a dynamic list depends on its default latest change since the criteria is based on the lifecycle phase attribute, but the rev is gotten from the context is for the parent object. This is why the privilege check returns an incorrect result.

Resolution: Reset rev info in context before doing the privilege check for the selected value of the dynamic list.

Verification:

Log in to Web Client.
Create a new Part named 15600-SA=.
Create a new Change from Part 15600-SA= named Change C00222.
Go to a 15600-SA -> Actions menu > Create new changes again.

A Warning message window appears saying Part 15600-SA= is already on pending changes: C00222.
Click Finish in the warning windows.

Result: It works fine without a duplicated message window appearing.

20217800

Roles & Privileges

Issue: USER WITH LIMITED DISCOVER AND READ PRIVILEGE CANNOT SEE ITEMS MULTILIST FIELD C

Root Cause: The privilege check for object in dynamic list depends on its default latest change since the criteria is based on the lifecycle phase attribute, but the rev from the context is for parent object. That's why the priv check returns an incorrect result.

Resolution: Reset rev info in context before doing the privilege check for selection value of dynamic list.

Verification:

Create a Part with sammi03 role with the following privileges:

Discover/Read/Modify changes

Display No Privilege Fields: Yes

Read Items with same new criteria

Discover parts with new criteria:

Parts Title Block.Lifecycle phase In production

or

Parts Title Block.Lifecycle phase In frozen or

Parts Title Block.Lifecycle phase In prototype
Set Part.P2.multilist01 with Items dynamic list.
Log in to Web Client as admin.
Create a Part, P001, and create ECO, c0001, for it.
Set Lifecycle with production.
Release C0001.
Create P002 and create ECO, c0002, and release C0002 and with lifecycle: frozen.

A Warning message window appears saying Part 15600-SA= is already on pending changes: C00222.
Create a p003 and create ECO, c0003, release c0003 and with lifecycle: prototype.
Open P001 and modify p2.multilist01.
Input p002 and p003 and save it.
Log in to the system as sammi03.
Search for P001 and open it.
Check the p2.mulitlist01 values.

Result: The p002 and P003 are displayed correctly in the p2.multilist01.

20272396

Workflow

Issue: FAIL TO ADD AFFECTED ITEM

Root Cause: When changing the status of an ECO and meeting ExitCriteriaNotMatch/EnterCriteriaNotMatch error, the ECO's OBJVERSION will +1 while the OBJVERSION on page was not changed (without refreshing the page).

Resolution: After closing the audit status dialog, refresh the page.

Verification:

Log in to the Java Client as admin.
Go to the workflow: Default change orders.
Save as new workflow: Default change orders_2.
Go to the Default change orders_2 to status and create a review2 status and move to CCB and under it.
Go to Classes > Change Orders > ECO > Page three.list01.
Enable it and assign the new simple list01:Yes/No.
Save it.
Go to the criteria (newchangeorder_1) with the following condition:

Type: ECO

Condition: Affected Item.Item number is not null and Page Three.list01 in yes.
Go back to Default change orders_2 with review2 status.
Create a Criteria with new newchangeorder_1.
Create change status for this workflow Default change orders_2 assign to users.
Log in to Web Client.
Create an ECO and change status to review_2. The following error message appears: "No matching entry criteria. Review_2''.
Click Close.
Click Add and click the Create New button.
Go to the Create new tab of Create Part.
Click Add.

Result: The value is created successfully and added into the Affected Items tab.

20767804

Folders, Files & Attachments

Issue: CANNOT CLICK ADD TO UPLOAD FILE IF ONCE UPLOADED TO OBJECT WITH DOUBLE QUOTE

Root Cause: Double quotation is not supported.

Resolution: Added code to handle double quotations.

Verification:

Log in to Web Client.
Create a new Item and name it abc"123. (There is a double quotation mark in the name.)
Upload a file attachment. It succeeds.
Log out and log in again to Web Client as the same user.
Try to open any object, go to Attachment tab, click Add.

Result: File Upload works successfully.

20846622

Changes

Issue: AUDIT RELEASE: ON SAME CHANGE GIVES DIFFERENT ERRORS DEPENDING ON ACCESSED FROM

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 will be 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 wrong result. Case 2: Once the user manually changes the tab name from 'Page Two' to 'Document Info' the 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 rev for correct AI's which is being dealt with at run time, and 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.

Verification:

Log in to the Java Client as admin.
Go to Classes > Parts > Page Two > Enable page Two.list01 and Title.block.product line to Yes.
Create a user named user01 with below privilege:

Discover/Read/Modify changes

Discover/Read Parts

Modify privilege only for parts that 'Title block.rev release date is not null' with apply to all
Go to the workflow, edit criteria for release status of default change orders, set exit required fields as page Two.list01 and Title.block.product line.
Log in to Web Client as admin.
Create a Part, part0001, and create an ECO C00001 for it.
Release C00001 with A version.
Log in to Web Client as user01.
Go to C00001 directly and do an audit release. Audit result shows correct warnings without any insufficient privileges'.
Go to Part0001, the edit button is enabled since current rev is A and rev release date is not null. Now choose 'introductory' rev and you can find that the Edit button is greyed out. This is correct since rev release date is blank for rev introductory.
Go to the part0001's Change History tab and open C00001.
Go to the C00001's Actions and click Audit release

Result: Check the Audit release table, there is a message: "The following required fields are missing: Part0001: Page Two.list11 and Title.block.product line".

20960104

Changes

Issue: THE RECENTLY SELECTED USER GROUP IS CLEARED IN DROP-DOWN LIST OF REVIEWERS

Root Cause: Cursor in an Iterator is to the last, making some code uncovered.

Resolution: Reset the cursor to the beginning.

Verification:

Create over 200 User Groups.
Create the Change Order and assign the workflow.
Change status to CCB.
Launch the palette for approvers.
Select the Search within a User Group option and select User Group, UserGroup101.
Search for a user in UserGroup101 and return to the Change Status window.
Launch the palette for approvers/acknowledgers/observers.
UserGroup101 is listed in the dropdown list of search type.
Close the Change Status window.
Open the Change Status window.
Launch the palette for approvers/acknowledgers/observers.

Result: UserGroup101 is listed in the dropdown list of search type.

21615075

Changes

Issue: STATUS CHANGE COMMENTS SPECIAL CHARACTERS CONVERTED TO HTML HEXADECIMAL CODE

Root Cause: When you refresh to the Comments page, the value of comments is encoded twice.

Resolution: Encode only one time.

Verification:

Precondition: Set the notification in the Java Client.

Log in to Web Client as admin.
Create an ECO, c0001.
Click Next Status and assign a workflow for it.Click the Continue button and go to the table of "Change Status to Submitted."
Assign one notify user, user01, who can get email with related privilege and in the comments field, put some special characters as follows: "?", "!",";", "(", "/", " or ", ":", "[", "'",@,~,`,|,{},\,[],?,>,<,+,%,$,3,^,&,*,(),_+@,!,#
Click Finish.
Go to the History tab.
Check the comments field.

Result: All the special character appear as they should in the comments field.
Check user email.

Result: In the email comments field, the special values are displayed properly.

21786162

Web Client

Issue: AFTER UPGRADING FROM AGILE 9.3.1 TO 9.3.4 ITEM ATTACHMENTS TAB IS MISSING FILE NAME, FILE DESCRIPTION

Root Cause: This is an AUT bug. The fix requires the customer to upgrade again from 931 to 933 with the fixed script, but the data after 933 will be lost.

Resolution: Use the fixed script.

Verification:

Log in to Java Client or Web Client.
Open Item, P03673, and click Attachments tab.
Verify Filename, File Description, File Size and File Type.

Result: Filename, File Description, File Size and File Type are displayed appropriately.

21807870

Web Client

Issue: SELECTED CONTENT TAB REV FIELD DOES NOT DISPLAY LATEST REVISION ON WEB CLIENT

Root Cause: The introductory revision of an Item object is always added to the selected content table of CTO from Web Client.

Resolution: Always add the latest released revision of the Item object to the selected content table of CTO when it is from Web Client.

Verification:

Log in to Web Client.
Create a Part, P1.
Create an ECO against the Part P1, and release it with revision A.
Create a CTO, go to Selected Content tab and add P1, check the Rev field.

Result: The Rev field displays latest revision A.

21815271

Java Client

Issue: USER NOT ABLE TO VIEW ATTACHMENTS FROM WHERE USED TAB BEFORE REFRESHING PAGE

Root Cause: When the Relationship table of the Item object is loaded, the data model of the Relationship table is stored in the action context, so at this time, if the user clicks the Item object within the left tree panel, the system uses the old data model of the Relationship table which was already in the action context.

Resolution: Special handle Item objects, so that if the user clicks the Item object in the left tree panel, the data model of the Item object should refresh first.

Verification:

Create P/N "Part01", attach file/s as attachment and release it to create rev A.
Assign Part01 to a new ECO . The current rev is B. Do not release this ECO.
Go to the Attachment tab of rev B. You can see the attachment file.
Click on part01 from the recently visited section. The user gets the Attachment tab of rev A.

Result: The Attachment tab of rev A has dot and all the files are displayed.

21840078

Changes

Issue: ADDING REVIEWERS INEFFICIENT WHEN USER GROUPS ARE MORE THAN 250

Root Cause: Cursor in an Iterator is at the last, making some code uncovered.

Resolution: Reset the cursor to the beginning.

Verification:

Create over 250+ User Groups with one user with reviewers privilege.
Create a Change Order and assign the workflow.
Change status to CCB.
Launch the palette for approvers.
Select the Search within a User Group option and select a User Group: UserGroup263.
Search for a user in UserGroup263 and return to the Change Status window.
Launch the palette for approvers/acknowledgers/observers.
UserGroup263 is listed in the drop-down list of search type.
Close the Change Status window.
Open the Change Status window.
Launch the palette for approvers/acknowledgers/observers.

Result: UserGroup263 is listed in the drop-down list of search type.

21888449

Mfr/Mfr Parts

Issue: SAVE AS MFR PARTS DOES NOT VALIDATE ALL MANDATORY ATTRIBUTES, E.G.MANUFACTURER

Root Cause: Save As MFR part does not check MFR Name.

Resolution: Check MFR Name when getting from UI.

Verification:

Log in to Web Client as admin.
Create the new Mfr Part manually (not using Save As) with all mandatory fields, for example:

Type: Manufacturer Part

Number: PW.0001-SCE

Manufacturer Name: AMD
Click on Actions > Save As.
Enter the mandatory attribute

Type: Manufacturer Part

Remove the value (AMD) for mandatory attribute Manufacturer Name

Number: PW.0002-SCE
Click Save.

Result: The following error message is displayed: "Please enter a valid manufacturer name."

21980278

User/User Group

Issue: JOB FUNCTIONS TAB ERRORS WITH VOCELLLISTVALUE CANNOT BE CAST TO VOCELLMULTILIST

Root Cause: FT.JF.User/UG attribute index is hard-coded as 2 in the code.

Resolution: Should get index as attribute id.

Verification:

Log in to Java Client as admin.
Go to Classes > Functional Teams > Job Functions tab, disable attribute:Name, then enable it again.
Log in to Web Client as admin.
Go to Tools and Settings > Address book > Functional Teams, open any functional team, then click its Job Functions tab.

Result: Job Functions tab opens successfully.

22081546

Folders, Files & Attachments

Issue: SMARTLINK DOES NOT WORK CONSISTENTLY WHEN CREATED FROM A NON-ENGLISH PROFILE

Root Cause: user profile did not load lang settings and the default value is English.

Resolution: when client lang setting is not correct, it will load user profile settings.

Verification:

Log in to Web Client.
Create a file folder.
Add files and check in.
Select a record and click Get Shortcut.
Copy the URL and paste in a new window.

Result: The file opens if the user selects it to open through the smart URL/link.

22087544

Notifications & Subscriptions

Issue: EMAIL TO ALL LOGGED IN USERS THROUGH JAVA CLIENT, IT SENDS TO INACTIVE USERS

Root Cause: When sending an email to all logged in users, the system does not check whether the user is inactive or not.

Resolution: Filter inactive users before sending email to all logged in users.

Verification:

Precondition: E-mail setting should work fine.

Do a Save As on the admin to new User, user01.
Set the admin and user01 email with XX@oracle.com (use valid email address).
Log in to Web Client as user01.

Result: User01 can log in successfully.
Close the web side of user01's session. (Do not click the logout button.)
Log in to Java Client as admin.
Go to email to users (under Analytics and Reports) and open.
Select All logged in users and enter "send" in the content.
Click Send.
Check the email. It sends the email with Agile System Notification to two users.
Go to Java Client and inactivate user01.
Go to the email to the users.
Open it.
Select All logged in users and enter "send" in the content.
Click Send.

Result: The inactive user does not receive the email again.

22112072

Changes

Issue: MCO ARE NOT ABLE TO MOVE TO NEXT STATUS, WORKFLOW CRITERIA NOT WORKING PROPERLY

Root Cause: Affected Item's required field checking logic is wrong.

Resolution: Correct the Affected Item's required field checking logic.

Verification:

Create two criteria: For example

MCOwithAItypepart:MCO Affected Items.Item Type In Part MCOwithAItypeDocument: MCO Affected Items.Item Type in Document
Open Default Manufacturer Orders and go to the pending status.
Create two new criteria by using the new criteria:

One criteria with requires exit field Part.Page three.text01

Two criteria with requires exit field Document.Page three.text02
Make sure the Item type is enabled in MCO.AI tab in Java Client.
Log in to Web Client as admin.
Create MCO, M001, with unassign status.
Add one Part, P001, and One Document D0001.
Both Items have no values in page 3 fields.
Assign one workflow to Attemp to change next status.
Filled in the values from required field hyperlink.
Save and change status.

Result: The change status can be changed successfully.

22112347

Roles & Privileges

Issue: "ADD TO TABLE" AND "DELETE FROM TABLE" DO NOT WORK AS EXPECTED

Root Cause: When a user does not have modify privilege for Item.relationship.name the user should be allowed to delete the relationship as long as the user has delete from table all items priv with relationship table applied.

Resolution: Change the code's logic.

Verification:

Log in to Java Client as admin.
Create a new user:U001 with the following privileges:

--- Discover Items

--- Read Items

--- Create Items

--- Modify Items (remove Items.Relationships.Name from applied to field)

--- Add to Table All Item (Add Items.Relationships in the Applied to field)

--- Delete From Table all Items (Add Items.Relationships in the Applied to field)
Log in to Web Client as U001.
Do a quick search of Items -->*, open some Items, such as P001, D001, P002.
Open P001, go to its Relationships table, an add D001 to this table by dragging from recently visited panel.
Try to add another Item to the P001.relatioship table by search: Items -->P002 or create a new part:P003.

Result:

4. P001, D001 and P002 were displayed in Recently visited panel.5. D001 can be added to P001.Relationships table successfully. 6. P002/P003 can be added to P001.Relationships table successfully.

22246064

Changes

Issue: USER IS NOT ABLE TO EXPORT THE WHERE USED TAB INFORMATION. EXPORT UTILITY HANGS

Root Cause: The rev change id and rev change class are missing when executing export, which makes the user unable to go through privilege check.

Resolution: Added rev change id and rev change class when submitting export request in ITEMTABLE_WHERELIST and ITEMTABLE_WHEREPENDLIS.

Verification:

Log in to Java Client as admin.
Create a User, user001, with the following privileges:

1) Discover Items - Latest Released Revision Only(Criteria:Items $LATESTREV Is Released And Title Block.Lifecycle Phase Is Not Null)

2) Read Items - Latest Released Revision Only(Criteria:Items $LATESTREV Is Released And Title Block.Lifecycle Phase Is Not Null)

3) Read Items - Read Only Users(Criteria:Items (

$CURRENTREV Equal To $STATUSTYPE.RELEASED Or

$CURRENTREV Equal To $STATUSTYPE.COMPLETE ) And

$LATESTREV Is Released)

4) Export
Log in to Web Client as admin.
Create Items P0001, P0002 and P0003.
Add P0003 to the Items P0001 and P0002's BOM tab.
Create a Change, C0001, and add the newly created Items to the Affected Items tab.
Set Rev to A and Lifecycle Phase to Production, then release the change.
Log in to Web Client as User, user001.
Open the Item, P0003, and go to its Where Used tab.
Click More > Export button.

Result: The data on the Where Used tab is exported successfully.

22278675

Standard Reports

Issue: PAGE TWO ATTRIBUTES ARE NOT DISPLAYED ON ITEM MANUFACTURING REPORT

Root Cause: The application does not correctly get P2 attribute. The combined key is classID+attributeID, but there is some attribute id that equals this combined key.

Resolution: Change combined key as classID+"#"+attributeID to resolve this issue.

Verification:

Log in to Java Client, enable Parts Page Two, enable Page Two,, Text11, MultiText31, Date01, MultiList01, Money01 and Numeric01 on page2.
Log in to Web Client, create a new Part, P00011, and set each attribute in Page2.
Go to Manufacturer tab, add Mfr Part amd001.
Run the Item Manufactures Report.
One page 1 of the wizard, edit DEFAULT LAYOUT, add all Item.Parts.Page2 attributes.
On page 2 of the wizard, use Advanced Search to query out P00011: Items.Parts.Object Search Number Equal To P00011.
On page 2 of the wizard, select all for list Preferred Status and Manufacturer part Lifecycle Phase.
Click Finish to get the report.

Result: PageTwo attributes all have correct values.

22642747

Folders, Files, & Attachments

Issue: UNABLE TO GET THUMBNAIL: ORA-00942: TABLE OR VIEW DOES NOT EXIST ERROR

Root Cause: According to error stack tracing, the table FS_ONETIME_TRANSACTION_KEYS is not existing in the database.

Resolution: After running the SQL from HF30, the table is created.

Verification:

Enable thumbnails.
Create a new Part and add a .jpg file to the Attachments tab.
Modify the thumbnail preference on the user account.
Click on the new Part in Recently Visited list.

Result: No application error is displayed.

23549688

Relationships

Issue: ADD AVERIFY CASE FOR 23317450

Root Cause: Need a new Averify case to report missing Page Two/Page Three data issue for User Group.

Resolution: Added an Averify test case to report miss Page Two/Page Three data issue for User Group.

Verification:

Data Preparation:

Prepare a fresh DB and link it to Agile. Log in to Web Client.
Tools and Settings > Address Book > User Groups. Add a new User Group named UG01.
Use sqldeveloper to connect that DB user to execute below SQLs: (A) select id,class,name from user_group where name = 'UG01'; (get ID) (B) delete from page_two where id = ID;ID got from(A) (C) delete from page_three where id = ID;ID got from (A).

Steps:

Set averify.properties. (a)averify.runOption=all (b)averify.runOption=modules,averify.modules=pcp qm (c)averify.runOption=tables,averify.tables=user_ group (d)averify.runOption=testcases,averify.testcases =AGIL-00015006
Run Averify on that DB user.

Result: In oracle_averify_report.log, there should be error messages like below:AGIL -00015006 : E : USER_GROUP table has bad data (ID XXX CLASS column XXX is deleted from PAGE_TWO).AGIL -00015006 : E : USER_GROUP table has bad data (ID XXX CLASS column XXX is deleted from PAGE_THREE).

23594069

Folders, Files & Attachments

Issue: GETTING BLANK PAGE FOR THUMBNAIL

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.

Verification:

Pre-Condition: In Java Client|Admin|Server Settings|Preferences|Thumbnail Support should be set to enabled.

Log in to Web Client.
Create an Item.
Navigate to Attachments tab and add an image or a ZIP file or Microsoft Office files or HTML or unsupported files OR add multiple files in a single file folder OR add a URL.
Navigate to the Title Block tab and verify the Thumbnail.

Result: The thumbnail is displayed in the Item's Title Block tab.

24305185

Standard Reports

Issue: EXECUTING ATTRIBUTE HISTORY REPORT CREATES A ZERO SIZE FILE INSTEAD OF HISTORY

Root Cause: When getting Rev Release Date attribute value while it is not enabled, will return -1 as attribute id and an array out of index:-1 exception will be thrown.

Resolution: If Attribute Rev Release Date is not enabled, set release date to null instead of getting its value.

Verification:

Preconditions:

1. Log in to Java Client as admin. 2. Disable Parts.Title Block.Rev Release Date. 3. Proper privileges for Part, ECO and MCO.

Log in to Web Client as admin.
Create 1 Part: P0001.
Create ECO & MCO against P0001, and route workflow to release.
Go to P0001, click Actions > Attribute History Report.
Select any layout and output format.
Click Next and finish.
Open Item_Attribute_History_Report.pdf with Adobe Acrobat Reader DC.

Result: Item_Attribute_History_Report can generate successfully.

24312344

Folders, Files & Attachments

Issue: USER CANNOT MAKE CHECKIN IN PRELIMINARY STATUS WITH PENDING CHANGE FOR DOCUMENT

Root Cause: We do not transfer the info of Change when calling getFileUploadFormData, so it fails to match some criteria when doing checkin.

Resolution: Transfer the changeclass and changeid when call getFileUploadFormData.

Verification:

Log in to A9 Web Client.
Create a Document
Navigate to the Attachments tab and add a file of File Folder/Design.
Create an ECO for Document.
Navigate to Attachments tab of pending Document.
Select the file and click on checkout, so that the file is downloaded.
Select the checked out file and click on Checkin so that File Replace Selector dialog box appears.

Result: Click on the Browse for file and upload a file, so that the file is replaced successfully.

24458295

User/User Group

Issue: 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 the FT data.

Verification:

Log in to web client as admin.
Import 210 users:933_u001 - 933_u210 to system, and add Job functions: QA lead; Product strategy to all of these users
Create a functional team, FT001, go to its Job functions tab, and add job function, QA lead with all 210 new created users
Open any user that displayed in Job function table such as, 933_u180, go to its User Groups/Functional Teams tab, check displayed functional teams.

Result:

3. Job function: QA lead with all 210 new created users can be added successfully.4. Only FT001 with related job function, QA lead, is displayed.

24491560

Performance

Issue: OBSERVING HIGH CPU UTILIZATION GREATER THAN 90%

Root Cause: Using String in a large loop creates many objects.

Resolution: Use StringBuilder in the loop.

Verification:

Ran load test for 25 concurrent users for 30 minutes for all frequently used actions and monitored CPU usage through out the test.

Result: Confirmed that CPU utilization is normal.

24799737

Item & BOM

Issue: ITEM WITH URL ATTACHMENT IS NOT SHOWING DOT ON ATTACHMENT TAB OF ECO REDLINE

Root Cause: Cannot catch the warning messages when copying attachments of Affected Item.

Resolution: Check Copy attachment warning before copying an Affected Item attachments.

Verification:

Log in to Java Client as admin user.
Set a Smart Rule: Copy Files To Rev-File Folders: Copy with Warning.
Log in to Web Client as admin.
Create a new Part, P001, then attach a URL to its Attachment tab.
Create an ECO, C001, against P001
Go to the Affected Items tab of C001, choose P001, check the redline attachment tab.

Result: There is a dot on the Attachment tab.

24914666

Changes

Issue: 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.

Verification:

Log in to Web Client.
Create a Part, release it with several versions: A, B, C.
Create a Change Request or a Deviation, add the Part to the Affected Items tab.
In the Affected Items tab of the Change Request or the Deviation, click the Revision cell of the Part.

Result: The cell is editable, all revisions are listed.

3.2 Product Cost Management

21946042

RFQ/Response

Issue: PCM ERROR: INSUFFICIENT PRIVILEGE TO VIEW RFQ WITH AUTHORIZED USERS/OTHER USERS

Root Cause: Failed to add subclass ID to object and user created discover and read RFQ privilege based on subclass level.

Resolution: Added subclass ID to CMObjectID.

Verification:

Log in to Java Client and create a Discover RFQ privilege with RFQ subclass level.
Create a Read RFQ privilege with RFQ subclass level.
Assign the Read and Discovery RFQ subclass privilege to role1, and grant it to user1.
Create a Discover Authorized RFQ privilege with RFQ subclass level. Privilege Criteria: RFQ CoverPage.Authorized Users Contains Any $USER.
Create a Read Authorized RFQ privilege with RFQ subclass level and above criteria.
Assign the Read and Discover Authorized RFQ subclass privilege to role2, and grant it to user2.
Disable the OOTB Read/Discover RFQs and Read/Discover Authorized RFQs privileges with class level.
Log in to Web Client as user3, and create a Sourcing Project and add Items.
Open the Sourcing Project.
Create an RFQ, and edit the RFQ.Cover Page.Authorized User with user2.
Log in to Web Client as user1 and open the Sourcing Project.
View the RFQ in the Sourcing Project.RFQs tab.

Result: The other user (user1) can view the RFQ in the sourcing project's RFQs tab with discover and read RFQ privileges.
Do quick search with the RFQ number.

Result: The user1 can also search out the RFQ.
Log in to Web Client as user2 who is Authorized on the RFQ. Open the sourcing project.
View the RFQ in sourcing project.RFQs tab.

Result: The authorized user (user2) can view the RFQ in sourcing project.RFQs tab with Discover and Read Authorized RFQ privileges.
Do a Quick Search with the RFQ number.

Result: The user2 can also search out the RFQ.

23487785

Standard Reports

Issue: MISMATCH IN MANUALLY CALCULATED VALUE AND REPORTED VALUE IN ASSEMBLY COST REPORT

Root Cause: Material price adder attributes are not passed, so they are not included in the total extended price.

Resolution: Invoke related method with material price adder attributes.

Verification:

Log in to Java Client.
In the Sourcing Project's Price Detail table, enable two material price adders, one for supplier and the other for internal.
Log in to Web Client.
Create an assembly whose BOM Item has AML.
Create a Sourcing Project and add the new assembly.
Create an RFQ and open it to Suppliers.
Get a response from the Supplier.
Go to Analysis tab, select the Response line and apply price adder by Part.
Manually set this Supplier as best.
Execute Assembly cost report.
Apply price adder by commodity.
Manually set this Supplier as best.
Execute Effective Cost Comparison Report.
Apply price adder by Supplier.
Manually set this Supplier as best
Execute the Unit Cost Comparison Report.

Result: For steps 10, 13, and 16, all values of the reports are calculated correctly.

3.3 Product Governance & Compliance

14654981

Declaration

Issue: IF THE "DECLARED COMPLIANCE" VALUE IS NOT EXEMPT THEN EXEMPTION AND EXEMPTION EXPIRATION DATE SHOULD BE DISABLED

Root Cause: Modifying Exemption Expiration Date does not check Declared Compliance status.

Resolution: Check Declared Compliance Status when modifying Exemption Expiration Date.

Verification:

Log in to Web Client as admin.
Create a Change Order, ECO001, then add a Part, P001, to its AI tab.
Navigate to Affected Item, P001, through change.
Add an existing specification, such as SP1 to P001.specification table, select any value except exempt for Declared Compliance, such as Compliant, then modify Exemption Expiration Date, and save it.
Click Cancel.
Reset Declared Compliance to Exempt, select a value for Exemptions and Exemption Expiration Date, save it

Result:

4. Can't save the modification, it prompts an error: Declared Compliance/Exemption Expiration Date Values Mismatch: Only when the Declared Compliance is set to Exempt, should you select an Exemption Expiration Date. Please resolve this issue.5. P001 is refreshed and no value displayed for Exemption Expiration Date. 6. Can modify Exemption Expiration Date successfully when DECLARED COMPLIANCE value is EXEMPT.

3.4 Product Portfolio Management

14605210

Administration/Configuration

Issue: SYSTEM ALLOWS TO CHANGE THE STATUS ON A LOCKED PHASE/TASK

Root Cause: Change status lock check is for root activity instead of an activity that is being worked on.

Resolution: Added lock check for activity status change that is being is performed.

Verification:

Log in to Web Client as USER1.
Create a Phase, PH1.
Add 3 tasks T1, T2 and T3 under phase PH1.
Task T1, T2 are complete.
Delegate task T3 to a user USER2 with team member role.
Lock the phase PH1.
Log in to Web Client as USER2 who has Team member role on phase PH1.
Change status of task T3 to Complete and check the status rollup on parent phase PH1.

Result: USER2 is not allowed to change the status of locked task T3. Appropriate error message saying "USER1 has explicitly locked the object T3 for update. Please try again after the lock is released by USER1 or by unlocking T3." is displayed when the user tries to change the status.

21910467

Content Management

Issue: CONTENT PAGE DOES NOT REFRESH WHEN ADDING FILE

Root Cause: The application does not refresh when files are added to the Content table.

Resolution: Refresh the table after adding files.

Verification:

Log in to Web Client.
Create a Program.
Add files in the Content tab.

Result: The Content tab is refreshed.

23252327

Export

Issue: PROJECT EXPORT GIVES ORA-00904: "T37"."RESOURCE_STATUS": INVALID IDENTIFIER

Root Cause: When the user makes the Projects.Schedule.Resource Status attribute visible and exports the PPM object to Excel, the column name corresponding to this attribute, which is ACTIVITY.RESOURCE_STATUS, does not exist in the Activity table. It is supposed to be ACTIVITY.RESOURCE_HEALTH.

Resolution: Correct the value from ACTIVITY.RESOURCE_STATUS to ACTIVITY.RESOURCE_HEALTH.

Verification:

Preconditions: Log in to Java Client and navigate to Classes > Projects >Activities > Schedule tab and enable the Resource Status attribute.

Log in to Web Client and create a Program with some child objects.
Go to Action > Export and click Export.

Result: The Program is exported as an Excel file and the exported file displays the Resource Status attribute.

3.5 Product Quality Management

21550796

Java Client

Issue: AFFECTED ITEMS NAME MODIFIED FROM JAVA CLIENT IS NOT REFLECTED TO WEB CLIENT

Root Cause: Get the display name from hard code.

Resolution: Get correct display name from the database.

Verification:

Log in to Java Client as Admin.
Go to Admin > Settings > Data Settings > Classes > Quality Change Requests > Corrective and Preventive Actions.
Go to User Interface tab > Affected Items.
Change name:

Affected Item(s) : Affected Items to Name Affected Items XX
Log in to Web Client and create a new CAPA.
Go to the Affected Items tab. Check the Affected Item.

Result: The Affected Item name displays Affected Items XX.

3.6 Agile PLM Framework

17969693

Event Java PX

Issue: "NO PRIVILEGE" SHOWS IN EVENT HANDLER MONITOR

Root Cause: "NO PRIVILEGE" was inserted into event history table as object number.

Resolution: Do not insert "NO PRIVILEGE" as object number into event history table.

Verification:

Case 1:

Create two roles. test_role with privileges as follows:

Modify all Change Orders

Discovery all Change Orders

Read Change Orders exclude Title Block.Number

Enforce Field Level Read
Log in to Web Client with one user who has the test_role role and trigger any Event PX. Check if PX succeeds.
Log in to Java Client as admin and include the privilege of Read Change Orders Title Block.Number and check the Event Handler Monitor.

Result: The object number displays correctly in the Event Handler Monitor.

Case 2:

Create two roles. test_role with privileges as follows:

Modify all Change Orders

Discovery all Change Orders

Read Change Orders exclude Title Block.Number

Enforce Field Level Read
Log in to Web Client as one user who has the new role, trigger any Event PX. See PX succeeds.
Log in to Java Client as admin user without privilege of Read Change Orders Title Block.Number and check the Event Handler Monitor.

Result: No privilege is displayed correctly in the Event Handler Monitor.

20566624

Web Client

Issue: SAVEAS OF A CHANGE WITH SITE ENABLED AUTOMATICALLY FILL OBSOLETE DATE

Root Cause: When doing a Save As on a Change Order with Affected Items, if Site is added to the Item after the Change Order is released, at the same time, the obsolete date is null, it is filled with the current date.

Resolution: If the Affected Item has no obsolete date, then let the user select it. If the AI does have an obsolete date and the date is before the current date, the obsolete date will be replaced by the current date.

Verification:

Log in to Web Client as admin.
Create a Part P00119, without a site.
Create an ECO, C00059, and add the Item to Affected Items.
Set the new revision with A and effective date and save.
Release ECO C00059.
Add a Site to Part P00119's Site tab.
Do a Save As on the released C00059 to C00106.
Check C00106's Affected Items tab. The Site record has an effective date and obsolete date.

Result: The obsolete date appears blank and can be edited.

20863155

Folders, Files, & Attachments

Issue: JAPANESE FILE NAME IN DOWNLOAD.ZIP IS CORRUPTED ON DOWNLOADING MULTIPLE FILES OR MULTIPLE FILES IN A SINGLE FILE FOLDER

Root Cause: File encoding issue.

Resolution: Fix in code.

Verification:

Log in to Web Client on Mozilla or on IE11 with Document Mode as Edge.
Create an Item and navigate to the Attachments tab.
Add multiple Japanese files or multiple Japanese files in a single file folder.
Select multiple files or multiple Japanese files in a single file folder and click on Get.
Unzip the download.zip file.

Result: The file names in download.zip file is not corrupted.

20958426

Web Client

Issue: LARGE TEXT ORDERING ISSUE

Root Cause: N/A

Resolution: N/A

Verification:

Log in to Java Client as admin on F1 with pre-sales DB.
Go to Changes > Change Requests > Finance Documents > Attributes > Page Three (had more 90+attributes)
Enable large text attributes.
Click the re-oder button.
Move up one of largetext into the top or others.
Click the OK button.
Check the Page Three attributes.

Result: The largetext attributes are moved up successfully.

21188847

Web Client

Issue: CANNOT COPY AND PASTE FROM EXCEL ONTO AFFECTED ITEMS

Root Cause: N/A

Resolution: N/A

Verification:

Open the an Excel spreadsheet that contains multiple rows of items. Copy the column range of Item numbers.
Log in to Web Cient as admin.
Create an ECO.
Go to Affected Items.
Click Add, then CTRL V to paste.

Result: The values can be added successfully in IE/FF/Chrome.

21265268

Mfr/Mfr Parts

Issue: AVERIFY CHECK NEEDED FOR MANU_BY DUPLICATES WHERE COUNT(PRIOR_ROW)>1

Root Cause: N/A

Resolution: N/A

Verification:

Data Preparation:

Prepare a fresh database and link it to Agile.
Log in to Web Client.
Create a Part and a add a manufacturer. Create two ECOs (Change A, Change B) for the Part.
Redline for manufacturer in both Change A and B.
Release Change A.

Steps:

set averify.properties.

(a) averify.runOption=all(b) averify.runOption=modules,averify.modules=pcpqm(c) averify.runOption=tables,averify.tables=manu_by(d) averify.runOption=testcases,averify.testcases=AGIL-00060004
Run Averify on that DB user.

Result: For the 4 runOption, in oracle_averify_report.log, there should be error messages like below:AGIL -00060004 : E : MANU_BY table has bad data (ITEM ID XXX PRIOR_ROW column XXX has duplicates on release changes.)

21865894

Web Client

Issue: LARGE TEXT FIELD CANNOT BE RE-ORDERED

Root Cause: N/A

Resolution: N/A

Verification:

Log in to Java Client as admin.
Open a sub class like parts.page Two.
Enable LargeText field.
Move the new attribute up.
Click Ok.

Result: The LargeText attributes are saved successfully with the new sort order.

21923921

AUT

Issue: AFTER UPGRADE FROM AGILE 9.3.1 TO 9.3.4 ITEM ATTACHMENTS TAB IS MISSING

Root Cause: This is an AUT bug. The fix requires that the customer upgrade again from 931 to 933 with the fixed script, but the data after 933 will lost.

Resolution: Use the fixed script.

Verification:

Log in to Java Client or Web Client.
Open Item, P03673, and click the Attachments tab.
Verify Filename, File Description, File Size and File Type.

Result: The Filename, File Description, File Size and File type are displayed appropriately.

21984096

Import

Issue: GETTING FATAL ERROR WHILE IMPORT BOM WITH EFFECTIVE DATE

Root Cause: Null point exception.

Resolution: Modified code to avoid the exception.

Verification:

Launch the Import wizard in Web Client.
Select Import file: test.xlsx.
Choose Template Type: Level template
Modify Preferences as below:

Parsing and Validation Multilist Delimiter Character: semicolon (;)

Cascade Delimiter Character: Vertical bar (|)

Whitespace Validation Action: Strip

Case Validation Action: Convert Length Validation Action: Truncate

Blank Data Action: Retain Data Business Rule

Smart Rules Warning Violation Behavior: Accept objects

Reference Designator Quantity Mismatch Behavior: Accept

Behavior upon non-existing objects: Accept

Change Mode: Redlining

Redline Mode Behavior: New/Redlined items onto the change

BOM & AML import behavior: Import assys, amls and component

Multi Row Update Mode: Complete Replace
Click Save and then click Next.
Select the saved mapping file: NewMapFile_5_.xml
Create or search for a change for Redline Option and click Next.
Click Import and check the message in the Import Log

Result: The file is imported successfully without fatal error in the Import Log.

22198042

Web Client

Issue: LIST DISPLAY CHANGED FROM LIST TO SEARCH

Root Cause: When list record size is greater than Maximum List Values Displayed that was set on the admin side, Agile switches the UI control from list to search, as well as display type of the list in the cache.

Resolution: Block auto switch from UI, especially on the title block, grid table and search. Enable the ability to manually change and save display type via Java Client.

Verification:

Log in to Java Client as admin.
Click Admin > Data Settings > Lists.
Click the New button and input List Name=L001, set List Type = Simple and Display Type =List , then click OK.
Add more than 300 entries for the list, L001.
Click Admin > Data Settings > Preference, set the preference 'Maximum List Values Display to 300'.
Open Class > Parts and enable a list, List01, on Page Two and point to list, L001.
Log in to Web Client as admin.
Create a Part, P001, and go to List01 on Page Two.

Result: List01 on Page Two displays as list not search.

22309209

Custom Reports

Issue: CUSTOM REPORT LAYOUTS CANNOT BE OPENED IN REPORT PALETTE UNDER ITEM MANUFACTURER REPORT

Root Cause: If the Report layout list contains more than 10 values, the issue occurs. It uses default batch size 10 as list range for all situations and causes this issue.

Resolution: Reset the range when loading the report table.

Verification:

Log in to Web Client, find Item Manufacturer Report.
On the Layout tab, create more than 10 custom layouts, for example, test1 - test12.
Click the name of the bottom layouts, like test10 - test12.

Result: There is no error.

22334568

Event Java PX

Issue: PATCH 18795976: 9.3.3.0.74 DOESN'T WORK

Root Cause: The wrong changeKey is sent to the process extension code. In CMSessionBean.java, after the fix of PATCH 18795976: 9.3.3.0.74, reset the wrong values in request.

Resolution: If using drag & drop, do not set the wrong values in the request.

Verification:

Create Event Event Type: Update table

Object Type: Change Order

Table name: Affected Items
Create Event Handler with the following code:

IUpdateTableEventInfo info =(IUpdateTableEventInfo) eventInfo;IChange parent = (IChange)info.getDataObject();Iterator iter =info.getTable().iterator();while (iter.hasNext()){IEventDirtyRowUpdate element =(IEventDirtyRowUpdate) iter.next();IItem child = (IItem)element.getReferent();if(child == null){System.out.println("child is null");}else{System.out.println("child is not null");System.out.println( "########Action= " + element.getAction());if (element.getAction()== 0){System.out.println("############ add action### ");System.out.println("########### size" + child.getValues());System.out.println("@@@@@@@@@@Item number="+child.getValue(new Integer(1001)));}}
Create an Event Subscriber with the event & event handler. from step 2
Log in to Agile Web Client. Drag and drop an item to a Change Order's Affected Items tab.

Result: The action completes successfully.

22334923

Standard Reports

Issue: BOM COMPARISON REPORT IS BLANK WHILE RUNNING IN FRENCH LANGUAGE

Root Cause: The BOM Comparison report does not handle special characters when generating XML files.

Resolution: Handle XML special characters.

Verification:

Log in to Web Client as admin.
Go to My Settings > Preference, set language to French and log out.
Log in to Web Client as admin.
Rapports -> Rapports Standard -> Rapports de produit -> Rapport de comparaison des nomenclatures (BOM Comparison Report).
Execute the report, choose 'word' format in the 'Format de sortie' area.
Go through the report wizard, check the output report.
Repeat steps 5~6 with Excel/HTML format.

Result: The report works properly.

22557810

DB Upgrade/AUT

Issue: AVERIFY ERROR AGIL-00025020,AGIL-00025036 HAPPENS ON PDCS DUMP AFTER UPGRADE

Root Cause: Bad data in adminmsatt table due to some out-of-box privileges being deleted in nodetable.

Resolution: Delete bad data in adminmsatt.

Verification:

Import the 934 PDCS dump file.
Run AUT 1.7.7 to upgrade the database to 935.
Go to logs\averifylogs\9.3.5 and check if there are any errors in the oracle_averify_report.log.

Result: No error is introduced after the upgrade.

22580429

Searches

Issue: INCORRECT ERROR MESSAGE WHILE TRYING TO USE GO TO OPTION UNDER BOM

Root Cause: The message is not correct for the Go To Item BOM popup windows.

Resolution: Fixed and changed the message to "No Item matching the Search Criteria."

Verification:

Log in to Web Client.
Create a Part, P0001, and go to the BOM tab.
Click the Go To button.
Enter a value and press the Find Next button.

Result: It displays the error message "No matches were found for the specified levels."

22695394

Web Client

Issue: CERTIFICATION OF MICROSOFT WINDOWS 10, IE11 AND EDGE BROWSERS ON PLM 9.3.4

Root Cause: Agile PLM 9.3.4 did not support IE11 and Edge browsers on windows10 OS.

Resolution: Support IE11 and Edge browsers on windows10 OS in Agile PLM 9.3.6.

Verification:

Log in to the windows 10 OS.
Open 9.3.6 product's Web Client within Edge or IE11 browsers.
Check the UI.
Do some function checks.

Result: The values appear correctly and basic functions work fine with Edge and IE11 browsers.

22721697

Web Client

Issue: DIFFERENT BEHAVIOR WHEN ENTERING SINGLE/DOUBLE BYTE SPACE ON TEXT/MULTITEXT

Root Cause: Two bytes space (typically used in Japanese, and Unicode is \u3000) is not trimmed.

Resolution: Trim two bytes spaces(\u3000).

Verification:

Log in to Java Client as admin.
Set the following Page Three. MultiText30 atrributes to yes Name : MultiText30 Include Characters : All Characters with space and Mixed Case Required : Yes, save it
Log in to Web Client and open an object with Page Three. MultiText30 attribute.
Enter double byte space " " to the Page Three. MultiText30 field and save.

Result: A message pops up with "MultiText30 is a required field." The space is trimmed now.

22752236

Administration/Configuration

Issue: TRANSFER AUTHORITY GETS COMPLAINT ABOUT THE START DATE FOR GERMAN LANGUAGE

Root Cause: For German language, when displaying the Create/Edit Transter Authority page, the timezone id is set to U.S. locale, not the locale of the current user, which causes a parsing error when saving it.

Resolution: Set the time zone id to the current user's locale, not the U.S. locale.

Verification:

Log in to Web Client as admin.
Create a new admin user, u001, go to its Preference tab, set its Language as German, Time Zone as (GMT+01:00) Berlin.
Log in to Web Client as u001.
Click my Settings > Transfer Authority, try to create a Transfer Authority, enter values for all required fields containing start date and end date, then save it.

Results: The user can create TA for German User successfully.

22824681

Web Client

Issue: WEB CLIENT PAGE BLANKS OUT BY EXPANDING NAVIGATION PANE AFTER RESIZING WINDOW

Root Cause: When collapsing the left pane, Agile backs up the width of the main pane, and restores it when expanding the left pane. In the case reported in this bug, the width of main pane already changes, which is the issue.

Resolution: When expanding the left pane, recalculate the width of main pane.

Verification:

Log in to Web Client with IE11 and FF browsers.
Click Restore Down to change the window size.
Collapse Left Navigation.
Click Maximize Window.
Expand Left Navigation

Results: There is no blank page on the Web Client with IE11 and FF browsers.

22884300

Searches

Issue: ADVANCED SEARCH NOT SHOWING CORRECT RESULTS

Root Cause: When searching for the workflow.approver, Agile needs to join workflow_process table and get state_code in (0,1) to filter historical approver info.

Resolution: Join the workflow_process table to identify real approvers for changes.

Verification:

Log in to Java Client as admin.
Go to System Settings > Smart Rules, set Demotion Reviewers removal as remove.
Log in to Web Client as admin.
Create a Change Order, ECO001, with workflow, Default change orders, then route it to CCB status with approver as admin.
Roll back to Pending status.
Do an Advanced Search: Changes > Workflow.Approver Contains, click the prompt box and Workflow.Signoff User Dose Not Contain, click the prompt box, and save it as S1, then run the search.
Input admin as search criteria for both fields, run the search.
Route ECO001 to submit status again, run the saved search S1, and input admin as search criteria for both fields, run the search.

Results:

6. Enter Search Values window is prompted.7. ECO001 is not in search results.8. ECO001 is not in search results.

23029108

Web Client

Issue: LOADING PROGRESS ICON KEEPS RUNNING EVEN THOUGH DATA LOAD HAS COMPLETED

Root Cause: Inbox.jsp AGILE.EventManager.addEvent(RIGHTPANECONTENT, ON_LOAD, function() { doInboxOnloadActions(); if(dashboardLoadActions) dashboardLoadActions(); }); DashboardExecutiveTab.jsp AGILE.EventManager.addEvent('content_view', ON_LOAD, function() { dashboardLoadActions(); }); . Inbox.jsp calls dashboardLoadActions, but actually this page is used by Notifications, Workflow Routings and My Assignments, in these pages function dashboardLoadActions should not be called, so there is script error.

Resolution: Try any exception in layout.js: AGILE.EventManager.fireEvent(this.container.id, ON_LOAD, fireArgs);

Verification:

Log in to Web Client.
Click the Home button and move to Notifications, Workflow Routings, and My Assignments tab.

Result: The loading progress icon on the upper right corner disappears when the data is finished loading.

23633902

Web Client

Issue: CAN'T PASTE ALL COPIED DATA

Root Cause: AC type ahead functionality behavior: 1. Type in a keyword. 2. Server returns values that match the keywords. 3. If server returns only one value, the value will be selected, if server returns multiple matched values, none of the values will be selected. For example, there are several values: valueX, valueXX, valueXXX, valueXXXBB, if the user types in keyword 'value', four values will be returned, if the user types in keyword 'valueXXX', two values will be returned, if the user types in keyword 'valuesXXXB', only one value 'valueXXXBB' will be returned and it will be selected. There is a little functionality defect: if a user types in valueX, although four values will be returned, but actually there is a value 'valueX' which is exactly match the keyword, it should be selected.

Resolution: Even if the server returns multiple values for a keyword, if one of the returned values exactly matches the keyword, it should be selected.

Verification:

Log in to Java client to add below list entries to ProductLin list and save it.

Grapple Grapple-C Sideswipe Sideswipe-C Sideswipe OEM Steeljaw-M Steeljaw-M Plasma Soundwave Soundwave OEM
Log in to Web Client to create a Change Order and populate the required fields for creation.
Copy Step 1 list values from notepad: Grapple; Grapple-C; Sideswipe; Sideswipe-C; Sideswipe OEM; Steeljaw-M; Steeljaw-M Plasma; Soundwave; Soundwave OEM
Navigate back to the new Change Order and click the Edit button.
Paste the values into the ProductLine field.
Click the Save button - review the pasted result.

Result: All 9 values keep in ProductLine field.

24007652

Event Java PX

Issue: CANNOT FIND ANY SUBSCRIBER IN EVENT SUBSCRIBERS TAB OF DOCUMENTS CLASS

Root Cause: The following 2 classes are not packaged into pcserver.jar:com/agile/admin/server/HistoryRecordable.classcom/agile/admin/server/ADNodeAssign.class

Resolution: Added the 2 classes into usedejbclasses.txt to ensure that the 2 classes will be packaged into pcserver.jar.

Verification:

Create any type of Event Subscriber for any class. For example, the Documents class.
Open Classes > Documents > Event Subscriber ST-tab, select Show All.

Result: The Configured Event Subscriber is shown.

24306125

Export

Issue: EXPORTING PROJECT RESULTS IN JAVA.LANG.NULLPOINTEREXCEPTION ERROR

Root Cause: A mistake of using the "And" operator, use "&&", not "&".

Resolution: Change "&" to "&&".

Verification:

Log in to Web Client as user A.
From the Home screen select Tools and Settings > Export.
Leave Format as Excel.
Click Add.
Execute search for Program (Device), Project.
Select "ABASIN-27".
Click Next.
Output Filter > Create custom Filter.
Click Next.
Custom Select Content > Select All.
Click Next.
Click Export.

Result: Export occurs successfully with correct result.

24311793

Import

Issue: IMPORTING SPECIFICATION OBJECT GET A WRONG NAME

Root Cause: To support upper/lower/mixed case, the method createRealObjNumberCollection of super class BatchHandler.java should be overwritten, but the specification handler does not overwrite it.

Resolution: Overwrite the method 'createRealObjNumberCollection' to support upper/lower/mixed case when creating specification.

Verification:

Prepare data in a source file to import. Input the value for Specification Name with mixed case.
Log in to Web Client, and run Import.
Select the file created in step 1 for Import File.
On the Specify File Content screen, select Specification | Specification only.
Define the attribute mapping.
Run Import. Check the imported specification.

Result: Specification Name is created in its original case, instead of all upper case.

24365011

Averify Issues

Issue: ADD AVERIFY CASE FOR 24334009

Root Cause: There is no case to verify if this user is still used as an owner in the User Group when the user is deleted permanently.

Resolution: Add a new case to check whether a user is still used as an owner in a User Group when it is deleted permanently.

Verification:

Data Preparation:

Start Agile and log in as admin.
Create a new user, testsla, and create a User Group and add the new user into the User Group. Make sure the user is owner of the User Group.
Log in as DB user with sqlplus and execute below SQLs:

select id from agileuser where loginid = 'testsla';delete from agileuser where loginid=id;(got from above)

Steps:

Set averify.properties.

(a) averify.runOption=all(b) averify.runOption=modules,averify.modules=com mon,ppm(c) averify.runOption=testcases,averify.testcases =AGIL-00028000
Run Averify on that DB user.

Result: In oracle_averify_report.log, there should be error messages like below:AGIL -00028000 : E : USER_GROUP table has bad data (User ID XXX has been deleted. But owner of user group XXX is still there.)

24365645

Folders, Files, & Attachments

Issue: AFTER APPLYING 9.3.5.0.11 CHECKOUT FOR FILE FOLDERS PRIVILEGE DOES NOT WORK

Root Cause: After 9350.11, Agile does not check checkout privilege by object type. This is a code defect.

Resolution: Check the checkout privilege by object type.

Verification:

Preconditions: In Java Client, User docm has 'Component Engineer', Folder Administrator and 'Design Engineer' roles. Privilege 'Checkout for unreleased Items' is enabled and granted to the 'Component Engineer' role along with other privileges and Privilege 'Checkout Designs' is enabled and granted to the 'Design Engineer' role along with other privileges. Privilege 'Checkout File Folders' is enabled and granted to the 'Folder Administrator' role along with other privileges.

Log in to Web Client as docm user.
Create a Design/File Folder, add single or multiple files and checkin.
Create a Part, Navigate to Attachments Tab and add the Design/File Folder.
Access Design/File Folder object and verify the Checkout button.
Access the Item object, navigate to the Attachment tab, select the file and click on Checkout .
In Java Client, disable the privilege 'Checkout for unreleased Items' granted to the 'Component Engineer' role.
Log out and log in to Web Client as docm user.
Access Design/File Folder object or Quick View and verify the Checkout button.

Result: The Checkout button is active for Design/File Folder object

24407139

Averify Issues

Issue: ADD AVERIFY CASE FOR 21540894

Root Cause: There is no case to verify if data still exists for user related field of workflow status/criteria in adminmsatt table when a user is deleted permanently.

Resolution: Add a new case to verify if data still exists for user related field of workflow status/criteria in adminmsatt table when a user is deleted permanently.

Verification:

Set averify.properties.

(a)averify.runOption=all (b)averify.runOption=modules,averify.modules=common (c)averify.runOption=tables,averify.tables=adminmsatt (d)averify.runOption=testcases,averify.testcases=AGIL-00028001
Run Averify on that DB user.

Result: In oracle_averify_report.log, there is an error messages as follows: AGIL -00028001 : E : ADMINMSATT table has bad data (Missing adminmsatt data reference at User ID XXX)

24494674

Web Client

Issue: FAIL TO SYNC USER FROM AGILE TO RMW

Root Cause: Agile 9.3.6 introduced a new number format, but the integration properties did not change with admin meta data.

Resolution: Update integration properties with new meta data.

Verification:

Make sure Agile-RMW Web Service Integration is configured.
Log in to Agile Web Client.
Go to Address Book > Users, create a new user, give it all Roles, save.
Go to History tab.

Result: The use is synchronized to RMW successfully. In RMW, this user can be searched out.

24502403

Folders, Files, & Attachments

Issue: CAN NOT CHECK IN MULTIPLE FILES FOR PART WITH REVISION

Root Cause: Introduced this bug by 935. This is a code defect. We do not correctly handle file upload in the Item Files tab.

Resolution: Handle Item Files tab the same as in 934.

Verification:

Log in to Web Client.
Create Item P00066, and add two attachments.
Add Item P00066 to Change C00044, and release with revision 01.
Open revision 01 of Item P00066, and checkout attachments A.txt and B.txt.
Check in attachments A.txt and B.txt.

Result: File check in occurs successfully.

24511051

Web Services

Issue: HOW TO SEND THE OBJECT IN MICROSOFT C#

Root Cause: In this case, the client needs to send the class and object information to the server. The XSD schema definition AgileUserUserGroupIdentifierType, C# strictly follows the limitation for choice type that prevents you from setting classIdentifier and objectIdentifier at the same time.

Resolution: Correct the definition AgileUserUserGroupIdentifierType as sequence instead of choice type. This way, Java and C# both can set classIdentifier and objectIdentifier at the same time.

Verification:

Access the http://hostname:portnumber/CoreService/services/BusinessObject?xsd=1
Verify that AgileUserUserGroupIdentifierType has now been changed to <xsd:sequence>.
The AgileUserUserGroupIdentifierType has been changed to sequence so that Class identifier and ObjectIdentifier can be set at the same time.

Result: AgileUserUserGroupIdentifierType has now been changed to <xsd:sequence>.

24554823

Averify Issues

Issue: ADD AVERIFY CASE FOR 24339072

Root Cause: N/A

Resolution: N/A

Verification:

Preconditions:

1. Create a database user and import a demo database. 2. Log in to sqlplus on DB user and execute the following SQLs to create bad data: (a) insert into user_group (id, name,enabled,delete_flag) values ('2000','UG01','1','1'); (b) update agileuser set delete_flag=1 where loginid='test01'; (choose a user to set its delete_flag to 1)

(c) select id from agileuser where delete_flag=1 union select id from user_group where RN-delete_flag=1; (d) insert into adminmsatt (parentid,attid,value) values (22820,230,2000); (attid in 230,208,213,218,219,257, value in result of (c)) (e) commit; .

Set averify.properties.

(A) averify.runOption = all;

(B) verify.runOption = modules. averify.modules = pcpqm;

(C) averify.runOption = testcases. averify.testcases = AGIL-00015007
Run Averify on that DB user.

Result: In oracle_averify_report.log, there is an error messages like below:

AGIL -00015007 : E : ADMINMSATT table has bad data (ATTIDXXX VALUE column XXX is marked as delete in table AGILEUSER/USER_GROUP.)

3.7 Agile Engineering Collaboration

20911872

EC Services

Issue: INITIAL SAVE MAPPING FOR DESIGN.TITLEBLOCK.COMPONENT TYPE IS NOT WORKING

Root Cause: From the fiddler, the value of component type is sent to ECS when creating a design object, however, the server side ignored this value and did not save it.

Resolution: Make sure the value of component type is updated correctly when creating the design object.

Verification:

Open Solidworks and login Preference.
Open Mapping Editor.
In Ithe nitial Save tab and Update Save tab, add mapping for Design.Title Block.Component Type then save.
Create a Part from File > New and save it locally.
Select the CAD file in Model Tree then click File > Properties. Then Add properties for Design.Title Block.Component Type and set some values for them.
Click Agile -> Save Preview button, double click the component will bring up edit properties table, Design.Title Block.Component Type can display with correct value.
Click Continue and open the object from the save summary window.
In Agile Web Client, check the value of Design.Title Block.Component Type.

Result: Component type is displayed with the correct value.
In the CAD system, select the CAD file in the Model Tree and click File > Properties.

Result: Component Type is displayed with the correct value.
Click Agile > Save preview and click Continue.
Log in to Agile Web Client and check Design.Title Block.Component Type.

Result: Design.Title Block.Component Type is displayed with the correct value under version 2.