Not able to save configurable options changes or modifications in BCC
While saving configurable options changes in BCC,it is not allowing to save those changes.
Throwing up below errors in logs.
com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt".
The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt".
Fix for this error is to drop the foreign key constraint
Query: ALTER TABLE xxx_config_opt_media DROP CONSTRAINT xxx_config_opt_media_f
Foreign key constraint should be dropped for custom tables in publishing schema. There should not be any foreign key constraint for custom tables to avoid such errors in publishing schema.
Throwing up below errors in logs.
com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt".
The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt".
Fix for this error is to drop the foreign key constraint
Query: ALTER TABLE xxx_config_opt_media DROP CONSTRAINT xxx_config_opt_media_f
Foreign key constraint should be dropped for custom tables in publishing schema. There should not be any foreign key constraint for custom tables to avoid such errors in publishing schema.
Comments
Post a Comment