Server Crashes When Deleting a Record From T_ROL_TSK and the Assigned Privilege Has a Name With More Than 20 Characters
(Doc ID 1994062.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.2.2 and laterInformation in this document applies to any platform.

Symptoms

On Oracle Agile e6.1.2.2 and e6.1.3.0, Roles and Privileges,When a manager user tries to remove a privilege from a role, the server crashes.The issue happens only if the privilege name (in field T_TSK_DAT.EDB_ID) is longer than 20 characters.The field length of that field in the standard is 40.If the privilege name is less than 21 characters long, the application behaves as expected.

Expected Behavior:==============No crash should happen

The issue can be reproduced at will with the following steps: ==========================================1. Create a privilege with a name that has more than 20 characters in field T_TSK_DAT.EDB_ID.2. Add this privilege to any role (for example to role EDB-DESIGNER)3.Try to remove this assignment to the role again=> The server crashes and the client receives a "connection lost" error

If the name of the privilege is changed and its length is reduced below 21 characters the assignment can be removed again without any issue.