My Oracle Support Banner

E1: E1PAGE: SOLEXP: F90012 Duplicate Key Error On Load Balanced Environment (Doc ID 2483322.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


When using P90013 [Task Index Build], on a setup with load balancer, hundreds of F90012 [DUPLICATE_KEY_ERROR] errors flooded e1root HTML log.

e1root.log contain errors:


The issue can be reproduced at will with the following steps:
1. User 1 with Role X logins into Instance A.The index for role X is not built so the Instance A start building it.
2. User 2 with Role X logins and the load balancer redirects to Instance B. The index is still not built for role X, so it also start to build the index for it.
3. Notice the [DUPLICATE_KEY_ERROR] errors in e1root.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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