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

0 Sathya Srinivasan
Appian Employee
over 10 years ago

Check if the column type and column definition matches what already exist.
For e.g. if your table has a column of varchar(30) and this is not defined in the XSD, apian will try to create a default text column of definition varchar(255). So look for these.
Secondly, if you have auto-generate ID, check the corresponding sequences are in place (namely for Oracle)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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