6 Replies Latest reply on Sep 19, 2017 9:39 AM by Spacecake

    T2L Fail - Help

    Ricardo_Almeida Specialist

      Hi Community,

       

       

      I require to perform a t2l in order to place our modifications in PROD.

       

       

      I am currently having issue performing t2l. It seems that privileges were changed in test, and it is not letting me perform t2l from dev to test.

       

       

      Cannot insert duplicate key row in object 'dbo.tps_privilege' with unique index 'index$priv$coll_item'. The duplicate key value is (72864191-4638-4ac2-bda5-65c71ee43070, f70c5099-bc5f-418c-846e-1f7202f3f364)..

      [10:03:45] SyncData - Data Sync - Writing sync SQL to 'C:\Users\AlmeidaR\AppData\Local\LANDesk\TestToLive\TestToLive - 2016-12-15 06.07.16.sql'...

      [10:03:45] SyncData - Data Sync - Sync SQL saved.

      [10:03:45] Engine - State Change - Need: 'DataSyncInProgress', Current: 'DataSyncInProgress', New: 'EngineFailed'.

      [10:03:45] Engine - State Change - State 'EngineFailed' set.

       

       

      I have used design transfer to transfer the privileges but i get the same error. I am sure this is related to the priviledges

       

       

      Is there any way of knowing exactly which ones were changed?

       

      error.png

       

       

      Cannot insert duplicate key row in object 'dbo.tps_privilege' with unique index 'index$priv$coll_item'. The duplicate key value is (72864191-4638-4ac2-bda5-65c71ee43070, f70c5099-bc5f-418c-846e-1f7202f3f364)..

      [10:28:45] SyncData - Data Sync - Writing sync SQL to 'C:\Users\AlmeidaR\AppData\Local\LANDesk\TestToLive\TestToLive - 2016-12-15 06.07.16.sql'...

      [10:28:45] SyncData - Data Sync - Sync SQL saved.

      [10:28:45] Engine - State Change - Need: 'DataSyncInProgress', Current: 'DataSyncInProgress', New: 'EngineFailed'.

      [10:28:45] Engine - State Change - State 'EngineFailed' set.

       

       

      changes.png

       

       

       

      Thanks in advance.

       

       

      Ricardo Almeida