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 JUNE 21, 2018
Applies to:Oracle Agile Engineering Data Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
On Oracle Agile e188.8.131.52 and e184.108.40.206, 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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!