Hello.
We have set up synchronization project with authoritative HR Source to create Departments in 1IM.
When we run synchronization, it shows that 288 Inserts are done.But in fact there are no new Department objects appearing in the OIM database.
We have used Manager application and created one of these Departments manually (with correct ID). Then run synchronization again. This time it shows 1 Update and 287 Inserts. But update is donecorrectly, Inserts are not executed. There are no error in Log section of syncronization projects.
We have started to investigate Job Server logs.
Here some lines:
2019-01-09 14:44:01.1111 DEBUG (SystemConnection 335cf928-5620-454a-b41f-100d4c397177) : CreateObject: Creating 287 object(s) of type Departments (Department).
2019-01-09 14:44:01.1111 DEBUG (SystemConnection 335cf928-5620-454a-b41f-100d4c397177) : Options: ExceptionHandling=BreakOnError
This is strange as workflow has Continue On Error option selected.
Then goes many errors:
2019-01-09 14:44:08.0331 DEBUG (ObjectLog b4d5f2ee-51d7-48d6-a7be-90a80262d6e1) : ... ---> VI.Base.ViException: Trying to execute SQL command in canceled transaction: insert into Department (CustomDatetime1, CustomProperty01, CustomProperty02, ....
Then these lines:
2019-01-09 14:44:08.1268 DEBUG (ObjectLog b4d5f2ee-51d7-48d6-a7be-90a80262d6e1) : Session: Rollback Transaction
2019-01-09 14:44:08.1893 DEBUG (SqlLog b4d5f2ee-51d7-48d6-a7be-90a80262d6e1) : Resetting DB context data.
2019-01-09 14:44:08.1893 DEBUG (SqlLog b4d5f2ee-51d7-48d6-a7be-90a80262d6e1) : (69 ms) - ROLLBACK TRANSACTION
Then goes the lines that describes why all is OK in the synchronization project logs:
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : DB sink: Putting entity '175f84cd-5c0c-461a-a3f9-e847ed82950e' of table 'DPRJournalObject' with state PermissionBased into database queue (level 0)
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Begin transaction in read/write entity
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Delayed Logic: OnSaving for 175f84cd-5c0c-461a-a3f9-e847ed82950e
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Initializing logic...
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Fast path, because there are no colliding changes from Init or OnLoaded
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Applying entity changes...
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with Insert
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with <Key><T>Department</T><P>a2e1552e-fa7e-4c2c-ba0b-0b9cf05baf0e</P></Key>
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with New
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with Department
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with CCC-8FDF7360FFF1B64CA98357101B2066DE
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with d90a7a5a-7a4f-4b5d-9023-450c9bc880a8
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Check and execute column format Single Line with 175f84cd-5c0c-461a-a3f9-e847ed82950e
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Old state: PermissionBased, New state: PermissionBased, LogicSetValues
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Customizer SetValueAsync
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Old state: PermissionBased, LogicSetValues, New state: PermissionBased
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Calling OnSaving logic...
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Db Operations Queue: Operation Insert on <Key><T>DPRJournalObject</T><P>175f84cd-5c0c-461a-a3f9-e847ed82950e</P></Key> added to database queue.
2019-01-09 14:44:08.2363 DEBUG (ObjectLog 6099faaa-4856-4e5c-a05e-d94bc087caab) : Delayed Logic: OnSaved for 175f84cd-5c0c-461a-a3f9-e847ed82950e
Please, help us with this proplem.
