E1: SOLEXP: Cannot insert duplicate key in object F9001- Unable to Rename the Favorites

(Doc ID 2232805.1)

Last updated on NOVEMBER 07, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.


 User is not able to change the title of tasks in favorites which are copied from existing user. When user tries to change the title of tasks in favorites, an exception is thrown.


Also E1root.log has below error message :

JDBJSQLException occured in the SQLPhysicalConnection.insert(): | Vendor code= 2627, SQL state = 23000 | Table or View Name = F9001 | Data Source =Control Tables - Test com.microsoft.sqlserver.jdbc.SQLServerException:Violation of PRIMARY KEY constraint 'F9001_PK'. Cannot insert duplicate key in object 'TESTCTL.F9001'.The duplicate key value is (98 , B7332 , B7332 ,545D99D4-2D21-495f-A879-36BCEEDA93F4, 005787e7-af4b-11d3-a276-00104b65be64,20).



(1) User A has few favorites
(2) User A favorites were copied to User B following the steps in Document : 2137548.1


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