Skip to main content
To homepage To homepage
Solved

Mirgration Tool Dialog Box Question

  • October 15, 2024
  • 2 replies
  • 38 views
avanrijn
Contributor
Forum|alt.badge.img+2

Dear Sir,

The migration Tool is giving me this dialog.

Is there anything I can do ?

Regards,

Arthur

 


ExecuteBulkInsertQueryStep Failed at Step BusinessUnits.Adding to table [dbo].[ODXConnects]

Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999).

The statement has been terminated.

Details:

SQL Server: 'sql-instances-prod-002.database.windows.net'

SQL Procedure: ''

SQL Line Number: 1

SQL Error Number: 2627

Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999). ...

Best answer by avanrijn

Hi Christian,
 

When I use the Migration Tool in version 20.10.53.64 I can migrate the same project succesfully.

So we don't have to look into this issue anymore, I have a work arround.

Export project from 20.10.52, import into version 20.10.53 and run the Migration Tool.

Thanx for looking into this.
 

Regards,
Arthur

View original
Did this topic help you find an answer to your question?

2 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @avanrijn 

As mentioned in the support ticket, it seems this error was resolved by upgrading to 20.10.53.

avanrijn
Contributor
Forum|alt.badge.img+2
  • avanrijn
  • Author
  • Contributor
  • 36 replies
  • Answer
  • October 16, 2024

Hi Christian,
 

When I use the Migration Tool in version 20.10.53.64 I can migrate the same project succesfully.

So we don't have to look into this issue anymore, I have a work arround.

Export project from 20.10.52, import into version 20.10.53 and run the Migration Tool.

Thanx for looking into this.
 

Regards,
Arthur

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings