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 APRIL 04, 2019

Applies to:

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.