Server Crashes When Deleting a Record From T_ROL_TSK and the Assigned Privilege Has a Name With More Than 20 Characters
Last updated on MARCH 08, 2017
Applies to:Oracle Agile Engineering Data Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
On Oracle Agile e18.104.22.168 and e22.214.171.124, 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms