DB error on delete free shipping coupon

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.

Home / Forums / Developers (Main Products) Forum / Problems and bugs /

DB error on delete free shipping coupon

Per Jørgensen

Vote:

expand_less 0 expand_more

Hey,

We have a customer that has implemented unique coupon codes for optimizely.

Inspiration for implementation: https://www.david-tec.com/2017/10/unique-vouchercoupon-codes-in-episerver-commerce-using-episerver-campaign/

Were we have experenced that we are getting an error from the SQL Server, if a customer is attempting to remove an added coupon.

SQL error message: "The DELETE statement conflicted with the REFERENCE constraint \"FK_PromotionInformationShipment_PromotionInformationId\". The conflict occurred in database \"CBB.EpiServerCommerceDB\", table \"dbo.PromotionInformationShipment\", column 'PromotionInformationId'.\r\nThe statement has been terminated."

If i drop the foreign key and add it again with "ON DELETE CASCADE", it all works for me locally.

Is it an error that this table, doesn't already have cascade delete ?

Versions:
EPiServer.CMS: 11.20.13
EPiServer.Commerce: 13.37.00

#336990

Feb 24, 2025 11:39

Quan Mai

Vote:

expand_less 0 expand_more

Do you have the full stack trace?

Yes FK_PromotionInformationShipment_PromotionInformationId should have ON DELETE CASCADE from the beginning

#336997

Feb 25, 2025 10:44

error This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.