Error ORA-02049: Timeout When Changing Role Permission in Maintenance Screen
Last updated on MARCH 14, 2018
Applies to:Oracle Retail Store Inventory Management - Version 13.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 27-May-2013
In Store Inventory Management (SIM) 13.1.2 version, when attempting to give permissions to a new role the following error occurs:
Unable to execute ParametricStatement: update AC_ROLE
Caused by: java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock
Steps to Recreate:
1. In SIM navigate to Admin >> Security >> Role Maintenance.
2. Create a new role.
3. Go back and try to edit the role created at step 2 and add some permissions to this role.
4. Click on "Done" to confirm the changes. The error will appear.
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