I'm attempting to generate a model for our manufacturing database in Report Server. I can create the Data Source, but when I attempt to generate the model, I get several errors in the following format ...
More than one item in the Entity 'CUST ADDRESS' has the name 'COUNTRY'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help
More than one Field in the Entity 'CUST ADDRESS' has the name 'COUNTRY'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help
There are several pairs of similar error messages (DuplicateItemName and DuplicateFieldName) listed.
The tables (i.e. CUST_ADDRESS) do contain the column name (i.e. COUNTRY) but are otherwise unremarkable.
Clicking the "Get Online Help" link leads to a page with an apology and no useful information.
The database is at Compatibility Level 80, but I am able to generate models for other databases at that level.
I've run DBCC CHECKDB against the database and it returns without errors.
This is on SQL Server 2005, Standard Edition x64 with SP2.
I'm at a loss for what to do next, there doesn't seem to be any documentation for this error available.
Thanks for any insight into this matter.