Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
Error when Deploying to DB
emcneill
I'm trying to deploy a dcr to the database and I'm getting an error. my deployment config has 3 groups in it. The root group feature_group_schedule has a primary key of feature_group_schedule_id, the second group content has a primary key called content_id, the 3rd group feature, uses the feature_group_schedule_id and content_id as foreign key constraints.
The deployment doesn't try to insert into the content table, so the it fails when trying to insert into feature since the content id does not exist in the database. Is it possible to insert a table that doesn't have the primary key of the root group as a field? Is there anyway around this?
Find more posts tagged with
Comments
developer2008
Just out of curiosity ,Doesnt the combo of feature_id,content_id,feature_group_schedule_id in the third table should be the primary key.And so in the foreign key you should mention content_id too.
nakumar
Looked into your deployment configuration file, the 3rd group feature uses only 'feature_group_schedule' as foreign key *NOT* content_id.
DD expects atleast one primary key per group.