July 21, 2010 at 1:00 pm
Hi
I'm gettin the following error when I Deploy the report model. Can you tell me what does it mean?
The Relation property of the Role "CP" refers to the Target end of the Relation "CpSite-DSAdata", which is not bound to a set of uniquely constrained columns for the Table "dbo_DSAdata". Roles with Cardinality of One or OptionalOne require relations bound to uniquely constrained columns of the table.
Thanks
July 21, 2010 at 1:24 pm
Either there is not PK (or unique index) on table dbo_DSAdata or FK is not referencing such PK (or unique index)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2010 at 1:47 pm
Hi
Yes, I don't have any column with unique values. But my report works. So is it safe to ignore this warning?
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply