Hi Team,
We are getting connected to Oracle target system via synchronization editor. Almost for all cases whenever a new user account gets inserted at oracle database we are getting below mentioned error:-
ErrorMessages (2022-05-29 10:39:00.220) [1777018] Error executing synchronization project (Oracle E-Business Suite (Sync))'s workflow (Provisioning).
[1777124] Error executing projection step (oRA-Account) of projection configuration (Provisioning (Provisioning)).
[1777219] Error executing synchronization step (oRA-Account)!
[1777004] Method (Create new object (Insert)) could not be executed successfully.
[2604004] Object CN=107808,O=ORA-Account,O=ORA-System,DC=ORACLEEBS not commited or checked (Error Object has been correctly committed. The existence check failed because of a missing key feature.
).
at VI.Projector.JobComponent.ProjectorComponent._AdHocProjection()
at VI.Projector.Database.ProjectorExecutor.Project(ISession session, IProjectionConfiguration configuration, ProjectionOption options, ISystemObject adHocObject, CancellationToken cancellationToken)
at VI.Projector.Projection.Extensions.Execute(IProjectorEngine engine, IProjectionConfiguration configuration, ProjectionOption options, ISystemObject adHocObject, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
---- Start of Inner Exception ----
at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__3.MoveNext()
---- Start of Inner Exception ----
at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__3.MoveNext()
---- Start of Inner Exception ----
at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__3.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.Projector.Projection.ProjectionStrategy.<ExecuteStepAsync>d__3.MoveNext()
---- Start of Inner Exception ----
at VI.Projector.Projection.ProjectionStrategy.<ExecuteStepAsync>d__3.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.Projector.Projection.ProjectionStrategyBase.<OnExecuteStepAsync>d__6.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.Projector.Projection.ProjectionStrategyBase.<_ProcessDifferenceSetAsync>d__14.MoveNext()
at VI.Projector.Projection.ProjectionStrategyBase._ExecuteMethods(IProjectionStep step, SystemObjectMatchingSet matchingSet, ISystemConnection connection, ISchemaMethodAssignment[] methodAssignments, IList`1 systemObjectPairs, SystemMappingSide side, ProjectionDirection projectionDirection, Boolean forceReloadObject, Boolean ignoreQuotas)
at VI.Projector.Projection.ProjectionStrategyBase._ExecuteMethodNative(ISystemConnection connection, SystemObjectMatchingSet matchingSet, ISchemaMethod method, IEnumerable`1 objectsWithAncestryToExecute, Boolean reloadObjects, Boolean isImport)
at VI.Projector.Connection.Connections.BottleNeckConnection._Redirect[T](Func`1 redirection)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
---- Start of Inner Exception ----
at VI.Projector.Connection.Connections.BottleNeckConnectionTask.Execute()
at VI.Projector.Connection.SystemConnection.ExecuteMethod(ISchemaMethod method, IEnumerable`1 systemObjects, ExecuteMethodOptions option)
---- Start of Inner Exception ----
at VI.Projector.Connection.SystemConnection.ExecuteMethod(ISchemaMethod method, IEnumerable`1 systemObjects, ExecuteMethodOptions option)
at VI.Projector.Journal.JournalConnector.OnExecuteMethod(ExecuteMethodRequest request)
at VI.Projector.Connection.Connectors.DistributionConnector.ExecuteMethod(ExecuteMethodRequest request)
at VI.Projector.Connection.SystemConnector.ExecuteMethod(ExecuteMethodRequest request)
at VI.Projector.Connection.SystemConnector.CommitObject(CommitObjectRequest request)
at VI.Projector.EBS.Connector.ProjectorEBSConnector.OnCommitObject(CommitObjectRequest request)
Synchronization ended with errors.
Account gets successfully created at target side but not able to replicate the issue and not able to understand the root cause of the issue. Any help would be appreciated. Thanks in advance.