Try our conversational search powered by Generative AI!

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

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
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.