My Oracle Support Banner

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.

Symptoms

 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).

 

Changes

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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.