This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Error while executing synchronization project for oracle database

Hi All,

we have created a connection to oracle database with native database connector in Dell One Identity Manager 7.0.1.

we created synchronization project for initial sync. job server have been defined with Native Database Connector function. but while executing the sync project its giving me below error;

"[2161006] Error executing full synchronization!

at VI.Projector.Editor.Internal.GlobalActionHandler.HandleEvent(Object sender, String eventName, Object[] args)
at VI.Projector.Editor.Internal.GlobalActionHandler._ExecuteStartInfo(IProjectionStartInfo startInfo)

[810103] Error generating processes for event Run.
at VI.DB.Entities.PermissionsUnitOfWork.<GenerateAsync>d__2b.MoveNext()
at VI.DB.Entities.UnitOfWorkImpl.<GenerateAsync>d__13.MoveNext()
at VI.DB.JobGeneration.JobGeneratorImpl.<CreateChainsAsync>d__0.MoveNext()

[810222] Error executing script 'Event_Run'.
at VI.DB.JobGeneration.JobGeneratorImpl.<CreateChainsAsync>d__0.MoveNext()
at VI.DB.JobGeneration.JobGeneratorImpl.<_CreateChainsForSingle>d__10.MoveNext()
at VI.DB.Scripting.ScriptInstance.Eval(String key, Object[] parameters)

[810108] Error generation process step event Run.
at DynScripts.JobGen_DPRProjectionStartInfo_203oMa0Utun7HUiP7JfLSY2TsE.Event_Run(JobGenContext context)

[810109] Error generating process DPR_DPRProjectionStartInfo_Run_Synchronization.
at DynScripts.JobGen_DPRProjectionStartInfo_203oMa0Utun7HUiP7JfLSY2TsE.Event_Run(JobGenContext context)
at DynScripts.JobGen_DPRProjectionStartInfo_203oMa0Utun7HUiP7JfLSY2TsE.Chain_DPR_DPRProjectionStartInfo_Run_Synchronization(JobGenContext context, String EventName)

[810110] Error generating process step Run Synchronization.
at DynScripts.JobGen_DPRProjectionStartInfo_203oMa0Utun7HUiP7JfLSY2TsE.Chain_DPR_DPRProjectionStartInfo_Run_Synchronization(JobGenContext context, String EventName)
at DynScripts.JobGen_DPRProjectionStartInfo_203oMa0Utun7HUiP7JfLSY2TsE.Job_DPR_DPRProjectionStartInfo_Run_Synchronization_Run_Synchronization(JobGenContext context, String EventName, JobChain myChain, IVarContext chainValues)

[810112] There is no server that can fulfill server mask and/or server selection script input.
at VI.DB.JobGeneration.JobGenContext.<>c__DisplayClass1.<<_GetJobServer>b__0>d__3.MoveNext()

Can any please help me in this.

Regards,

SyncError.jpg

Parents

0 PAL over 8 years ago

Hi Bjackso1,

thank you for your help, its started working...!!!

can you help me in below error? getting while running the sync project.

not able to figure it out..

2016-06-08 04:25:43 -07:00 - VI.Projector.JobComponent.ProjectorComponent - 1fbd2e40-772d-4695-b1c8-7e8e8a9e4731: Errors occured
    [2134003] Error executing a full projection!
    [1777018] Error executing workflow (Update from HR) of synchronization project (HR Database).
    [1777124] Error executing projection step (user) of projection configuration (Update from HR (8c390733-ede3-474b-bbbc-739281829152)).
    [1777219] Error executing projection step (user)!
    [1777004] Method (Update object (Update)) could not be executed successfully.
    [810306] Error during execution of 'OnSaving' in logic module 'VI.DB.Entities.ReferentialIntegrityLogic'.
    [810169] The object pointed to by 'Primary department' does not exist in the database (QER_432-Department).
       at StdioProcessor.StdioProcessor._Execute(Job job)
       at VI.Projector.JobComponent.ProjectorComponent.Activate(String task)
       at VI.Projector.JobComponent.ProjectorComponent._FullProjection()
       ---- Start of Inner Exception ----
       at VI.Projector.JobComponent.ProjectorComponent._FullProjection()
       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)
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<ExecuteStepAsync>d__24.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<ExecuteStepAsync>d__24.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<_ProcessIntersectionSetAsync>d__102.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<_ProcessMappingOfSystemObjectPairsAsync>d__14c.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at System.Threading.Tasks.Task.Execute()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<>c__DisplayClass147.<_ProcessMappingOfSystemObjectPairsAsync>b__139()
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper._ExecuteMethods(IProjectionStep step, SystemObjectMatchingSet matchingSet, ISystemConnection connection, ISchemaMethodAssignment[] methodAssignments, IList`1 systemObjectPairs, SystemMappingSide side, ProjectionDirection projectionDirection, Boolean forceReloadObject, Boolean ignoreQuotas)
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper._ExecuteMethodNative(ISystemConnection connection, SystemObjectMatchingSet matchingSet, ISchemaMethod method, IEnumerable`1 objectsToExecute, Boolean reloadObjects, Boolean isImport)
       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.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.Database.DatabaseConnector.OnCommitObject(CommitObjectRequest request)
       at VI.Base.SyncActions.Do(Func`1 action)
       at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
       ---- Start of Inner Exception ----
       at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.PermissionsUnitOfWork.<PutAsync>d__10.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.UnitOfWorkImpl.<PutAsync>d__2.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.DbEntitySink.<PutAsync>d__1f.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.DelayedLogicSaveEntityStrategy.<OnSavingAsync>d__5.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.CombinedEntityLogic.<_CollectChangesAsync>d__45.MoveNext()
       ---- Start of Inner Exception ----
       at VI.DB.Entities.CombinedEntityLogic.<_CollectChangesAsync>d__45.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.ReferentialIntegrityLogic.<OnSavingAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.ReferentialIntegrityLogic.<_InsertCheckOnUpdateAsync>d__19.MoveNext()

Reply

0 PAL over 8 years ago

Hi Bjackso1,

thank you for your help, its started working...!!!

can you help me in below error? getting while running the sync project.

not able to figure it out..

2016-06-08 04:25:43 -07:00 - VI.Projector.JobComponent.ProjectorComponent - 1fbd2e40-772d-4695-b1c8-7e8e8a9e4731: Errors occured
    [2134003] Error executing a full projection!
    [1777018] Error executing workflow (Update from HR) of synchronization project (HR Database).
    [1777124] Error executing projection step (user) of projection configuration (Update from HR (8c390733-ede3-474b-bbbc-739281829152)).
    [1777219] Error executing projection step (user)!
    [1777004] Method (Update object (Update)) could not be executed successfully.
    [810306] Error during execution of 'OnSaving' in logic module 'VI.DB.Entities.ReferentialIntegrityLogic'.
    [810169] The object pointed to by 'Primary department' does not exist in the database (QER_432-Department).
       at StdioProcessor.StdioProcessor._Execute(Job job)
       at VI.Projector.JobComponent.ProjectorComponent.Activate(String task)
       at VI.Projector.JobComponent.ProjectorComponent._FullProjection()
       ---- Start of Inner Exception ----
       at VI.Projector.JobComponent.ProjectorComponent._FullProjection()
       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)
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.ProjectorEngine.<ExecuteAsync>d__4.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<ExecuteStepAsync>d__24.MoveNext()
       ---- Start of Inner Exception ----
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<ExecuteStepAsync>d__24.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<_ProcessIntersectionSetAsync>d__102.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<_ProcessMappingOfSystemObjectPairsAsync>d__14c.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at System.Threading.Tasks.Task.Execute()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper.<>c__DisplayClass147.<_ProcessMappingOfSystemObjectPairsAsync>b__139()
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper._ExecuteMethods(IProjectionStep step, SystemObjectMatchingSet matchingSet, ISystemConnection connection, ISchemaMethodAssignment[] methodAssignments, IList`1 systemObjectPairs, SystemMappingSide side, ProjectionDirection projectionDirection, Boolean forceReloadObject, Boolean ignoreQuotas)
       at VI.Projector.Projection.Internal.ProjectorEngineExecutionHelper._ExecuteMethodNative(ISystemConnection connection, SystemObjectMatchingSet matchingSet, ISchemaMethod method, IEnumerable`1 objectsToExecute, Boolean reloadObjects, Boolean isImport)
       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.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.Database.DatabaseConnector.OnCommitObject(CommitObjectRequest request)
       at VI.Base.SyncActions.Do(Func`1 action)
       at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
       ---- Start of Inner Exception ----
       at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.PermissionsUnitOfWork.<PutAsync>d__10.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.UnitOfWorkImpl.<PutAsync>d__2.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.DbEntitySink.<PutAsync>d__1f.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.DelayedLogicSaveEntityStrategy.<OnSavingAsync>d__5.MoveNext()
       at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.CombinedEntityLogic.<_CollectChangesAsync>d__45.MoveNext()
       ---- Start of Inner Exception ----
       at VI.DB.Entities.CombinedEntityLogic.<_CollectChangesAsync>d__45.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.ReferentialIntegrityLogic.<OnSavingAsync>d__0.MoveNext()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    --- End of stack trace from previous location where exception was thrown ---
       at VI.DB.Entities.ReferentialIntegrityLogic.<_InsertCheckOnUpdateAsync>d__19.MoveNext()

Children

No Data