Hi, I have created a CDT by importing a xsd file where I have given the nec

khalidk912 over 10 years ago

Hi,
I have created a CDT by importing a xsd file where I have given the necessary annotations in order to map with the table that is already craeted in Oracle DB. For every column I have used @column(name="", columnDefinition=""). When I add this CDT as a data entity in my Data Store and verify mapping it gives me a message saying "The Data source schema does not match the type mappings: Missing column: columnName in schema.tableName(APNX-2-4056-000)".

I have cross-checked the Appian generated DDL, DB script(which was used to generate tablein DB),and my xsd and I found that the missing column is present everywhere. I couldn't figure out where I am going wrong. If anyone have faced a similar issue please share your experience in solving it.

Thanks for your time!...

Discussion posts and replies are publicly visible

Parents

0 arpitg over 10 years ago

If you column name is too long then appian strips out some characters. So there can be scenario where you have 2 smilarly named columns and when appian is stripping out characters it ends up with the same name eg. AppianColumn & AppianColumn2 so it may be Setting both column names to be "AppianClmn".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 arpitg over 10 years ago

If you column name is too long then appian strips out some characters. So there can be scenario where you have 2 smilarly named columns and when appian is stripping out characters it ends up with the same name eg. AppianColumn & AppianColumn2 so it may be Setting both column names to be "AppianClmn".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data