Hi,
I'm facing this error while trying to import the sql backpac file.
An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Cannot insert duplicate key row in object 'dbo.BATCHJOBACTIVEPERIOD' with unique index 'I_15337IDIDX'. The duplicate key value is ().
Can anyone suggest some solution?
Regards,Zohan
Hi Zohan,
Can you tell if the source and target environments are the same or different versions? From where did you get the bacpac and where do you want to restore it?
Hi Andre,
Yes they are of same version. Import Bacpac file from UAT and wants to restore on Dev. I've tried multiple times this activity before but haven't faced this error.
Regards,
Zohan
Did you follow the procedure as described within the documentation? docs.microsoft.com/.../dbmovement-scenario-exportuat
Do you get the error during import in SQL server or during a DB sync task?
Yes Andre, the same procedure i followed, However, This time i set connection Timeout to = 0 in import bacpac file command. The first time i set the connection Timeout = 1200. It's now executing, Can you please tell me is connection timeout was the difference? and what does it mean
Glad it is working with another setting.
I'm not a SQL server specialist. I do think there will be some waiting times now and then; probably because of latencies. With a setting 0, you might not allow for any latency. Probably, you can find more information about connection timeout on the internet or on a SQL server forum.
Try importing DB again with new name in destination. I have seen issue when importing DB on top of existing.
If this doesn't work:
-Drop index from dbo.BATCHJOBACTIVEPERIOD in source environment and export again.
Retry import.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
