What am I doing wrong here? I'm trying to import a CDT that maps to one of o

dylanf over 10 years ago

What am I doing wrong here? I'm trying to import a CDT that maps to one of our existing tables on our MS SQL database. When I try to import the cdt using the @Id annotation, I get this error:

A type mapping annotation is invalid: The eclass: HbAnnotatedEReference does not have an efeature for Id (APNX-2-4055-000)

However, when I remove the @Id annotation, when I try to create a data entity that uses the cdt, it balks saying that my table doesn't have an a_id column. I'm attaching the xsd for reference....

processstreamresolution.xsd

Discussion posts and replies are publicly visible

Parents

0 dylanf over 10 years ago

Thanks, Owen. I actually ended up using type="xsd:ID" since this is a GUID and not an integer (MS SQL uniqueidentifier), and the CDT did import fine, but when I tried to verify the data entity, I'm now getting this error:

The data source schema does not match the type mappings: Wrong column type in ObjectViews.dbo.InternalProcessResolution for column KeyProcessStreamResolution. Found: uniqueidentifier, expected: nvarchar(255) (APNX-2-4056-000)

Any thoughts on this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 dylanf over 10 years ago

Thanks, Owen. I actually ended up using type="xsd:ID" since this is a GUID and not an integer (MS SQL uniqueidentifier), and the CDT did import fine, but when I tried to verify the data entity, I'm now getting this error:

The data source schema does not match the type mappings: Wrong column type in ObjectViews.dbo.InternalProcessResolution for column KeyProcessStreamResolution. Found: uniqueidentifier, expected: nvarchar(255) (APNX-2-4056-000)

Any thoughts on this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data