February 4, 2008 at 9:11 am
Hi,
using SSRS I try to generate a model for my database. Unfortunately I get an error
[font="Courier New"]Im Entity 'NGESRA'-Objekt weisen mehrere Elemente den Namen 'NANTEI' auf. Bei direkten gleichgeordneten Elementen muss jeder Elementname eindeutig sein. (DuplicateItemName) Im Entity 'NGESRA'-Objekt weisen mehrere Felder den Namen 'NANTEI' auf. In einer Entität muss jeder Name eines Feldes eindeutig sein. (DuplicateFieldName)
[/font]
i.e. something like "Object NGESRA contains multiple fields 'NANTEI'".
The data source of course does not contain duplicate column or foreign key names. It seems to me that the friendly names for the Report Manager generated data source views are different from the original column names (like substitution or deletion of underscores "_") while not maintaining identity.
Is there a way to influence the generation process by not changing the physical database object names, for example to suggest friendly names by providing an extended property to the database objects?
April 8, 2008 at 11:24 am
Did you ever solve your problem? I am getting a similar message when I try to generate a model too:
More than one item in the Entity 'Customer' has the name 'Customer Merge Custs'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help More than one Field in the Entity 'Customer' has the name 'Customer Merge Custs'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help
More than one item in the Entity 'Pricing Service Layout Detail' has the name 'Pricing Service Extensions'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help
More than one Field in the Entity 'Pricing Service Layout Detail' has the name 'Pricing Service Extensions'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help
April 9, 2008 at 6:21 am
No, unfortunately i haven't got a solution yet...
April 14, 2008 at 3:32 am
I am getting exactly the same problem. Is there another way to create the Data Model that i am missing?
June 4, 2010 at 12:28 am
Hi, I don't know if this is the situation you have but we had the same error when we had a foreign key with a primary table that has the same name as a column on the foreign key table
Ex.
Two tables, Employee and Number
Employee table has the following columns:
Name
EmpNumber (FK to table 'Number')
Number.
In SQL database, there is no problem as all columns are unique on the Employee table.
When building a Report Model, the generator will try to create two entities on Employee, a item called Number (referring to the linked table) and a Field called Number.
Boom! You can't have to items with same name.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply