Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

(Version 9.x) After moving database to new server I am getting DB error

Juan Munoz
Juan Munoz
Vote:
 

Hi

I am getting errors in sometine, when I do some question to Commerce DB.

Ex: The INSERT statement conflict with the FOREIGN KEY constraint "FK_LineItemEx_LineItem". The conflict accurred in fatabase "commerceDB", table "dbo.LineItem", column "LineItemId".

But it works, like 50% of the time.

And this is not the only error, I got more, but all have to do with  FOREIGN KEY problem.

Any ideas?

#198001
Oct 18, 2018 16:18
Quan Mai
Quan Mai
Vote:
 

How do you "move" to the new server?

#198005
Oct 18, 2018 17:24
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.