I was able to bypass the issue by, instead of running T2L from DEV, i ran T2L through UAT without any error messages appearing.
Probably because there is more space in the temp drive in the other server.
I've been experiencing the same problem as Ricardo with the same error message. I added memory on our development virtual server but it hasn't change anything. Do you think it could be caused by something else?
Here is the error I get (very similar, right?):
[10:12:32] RedGate - Add indexes to [dbo].[tps_privilege]
[10:12:36] SyncData - Data Sync - Sync failed:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tps_privilege' and the index name 'index$priv$coll_item'. The duplicate key value is (9d1a3c51-57bf-4e7e-9477-02860f50f028, 9b199d2a-4811-4b45-9a37-9da589f3ee21)..
[10:12:36] SyncData - Data Sync - Writing sync SQL to 'C:\Users\theriaultj\AppData\Local\LANDesk\TestToLive\TestToLive - 2017-09-15 10.09.44.sql'...
[10:12:36] SyncData - Data Sync - Sync SQL saved.
[10:12:36] Engine - State Change - Need: 'DataSyncInProgress', Current: 'DataSyncInProgress', New: 'EngineFailed'.
[10:12:36] Engine - State Change - State 'EngineFailed' set.
What I did:
- With my team we investigated on the duplicate mentionned in the error message, but couldn't find any for this combination.
- We tried to drop the index on our development database and recreated it, but there was no error.
- We added memory so the vm where the Test to Live is hosted now has 40GB free. Our two database combined (Dev and Prod) are approximately 35GB.
1 of 1 people found this helpful
you see a different issue here.
In your live System you created a new privilege which you also created in Test. Upon sync via TTL these two privileges clash.
Please do all design work in your Test system.
I've run the script that was in the article you linked me. It worked!
Thank you very much Senta