VERIFIED SOLUTION i

Resolve Error "java.sql.SQLException: Value conflicts occurs" in EngageOne Server

Product Feature: SOAP

Operating System: Windows Server /Linux

 

Issue

When running concurrent Soap requests in EngageOne Server, the below error appears in the composition-services logs:

ERROR | com.pb.engageone.composition.service.rest.security.UserContextSetupJAXRSInvoker] Error while getting and setting user context
com.g1.ocm.api.ConnectionException: java.sql.SQLException: Value conflicts occurs

Cause

This can be caused when authentication is done with the same user identifier as provided in the deploy.properties file for EngageOne Server. As the below was specified:

ldap.username=CN=eoadmin,CN=Users,DC=PB,DC=local 
system.user.username=eoadmin
initial.sysadmin.username=eoadmin 

Resolution

UPDATED: May 10, 2018
During SOAP calls executions, authentication using the same user identifier in deploy.properties file (system.user.username property) should be avoided.

The below should be a working configuration:

ldap.username=CN=eoadmin,CN=Users,DC=PB,DC=local
system.user.username=eosystem
initial.sysadmin.username=eosuper

Rectified in EngageOne Server release 4.4.6 (4.4SP6).

This release can be downloaded from the PB eStore.