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

0 Barry Jackson over 8 years ago

Hi,

In your sync project go to Configuration > Base objects .....

If you don't have a base object that defines the job server where the sync should be run then you will get the above error.

Create a base object and try again.

HTH, B.
Cancel
Up 0 Down

Cancel

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

0 Barry Jackson over 8 years ago

Hi,

This error:

The object pointed to by 'Primary department' does not exist in the database (QER_432-Department).

Suggests to me that you are mapping some value to uid_department on the left hand side but the resolution
configuration is not finding a value.

If your dept id in HR has a value 12345 then in the mapping the config on uid_department will need to resolve
12345 to be a UID.

Have you loaded data to the Department table beforehand?

Regards, B.

0 PAL over 8 years ago

HI,

Yes. i have loaded data to department table earlier.

My department name is Sales and same in Idm as Sales.

secondly, when do synchronization without department field is working fine, but central account is not populating automatically.

Regards,
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 8 years ago

The central account will not be generated because your sync step for the persons is marked as primary system. In that case no templates will be calculated when the data will be inserted into D1IM by the sync.

In your case, if the templates should fire, the sync could be marked as from a secondary system by setting the flag "Data Import" on the synchronization step.

You will find more in the online documentation: http://documents.software.dell.com/identity-manager/7.0.1/target-system-synchronization-reference-guide/basics-of-target-system-synchronization/synchronizing-user-data-with-different-Systems
Cancel
Up 0 Down

Cancel
0 PAL over 8 years ago

Hi,

i did some changes in mapping for department, created one virtual attribute for department name search and referenced to UID_Department, it worked fine.

but for UID_Locality and UID_Org its not working in the same. how to mapped those link attribute?

Regards,
Cancel
Up 0 Down

Cancel