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
Foreign key violation when deploying site
Mmmm it's stopped erroring now but it isn't saving. On publsih the field reverts to an empty string. I'll see if it starts to error again
Jun 13, 2014 17:09
I've redeployed and got another FK error so this is cropping up a lot. The error is
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblWorkContentProperty_tblPropertyDefinition". The conflict occurred in database
"NITB_MIGRATION", table "dbo.tblPropertyDefinition", column 'pkID'.So same/similar
I'm going to raise a bug report about this as it's a geninue app issue
Jun 23, 2014 13:30
You can delte Existing PageTypes/Bock Types If these have not been used from Admin mode.
Most probably some page/Block/media/meta type with that guid already exist.
/K
Jun 23, 2014 14:31
Thanks for the input but unfortunately this isn't it. The Guids are OK and unique. Thanks
Jun 23, 2014 15:03
Hi
I'm getting foreign key violations when deploying out new version of a site. It looks like the autogeneration of properties has failed. Is it possible to delete a property type of a page/block then allow the site to regenerate it.
Currently I am fixing by
Clearly this isn't a long term solution. I need to be able to fix it in situ - without the need for 2 additional deployments of the site.
My error is
Many thanks for any all help