I have a table in Oracle database say "AG_SRV_TRAN_EXT". Created a CDT

kumaraveln over 11 years ago

I have a table in Oracle database say "AG_SRV_TRAN_EXT". Created a CDT of similar structure,then an entity and when verifiying the mappings i am getting the below error. "The data source schema does not match the type mappings: Missing sequence or table: AG_SRV_TRAN_EXT_sq (APNX-2-4056-000) ".

Attaching the DDL script, XSD and script generated from DB

Note: I already have 2 Entities verified and published in the same data store without any issues.
...

Missing Sequence Err.zip

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If the table doesn't exist in your DB at all then it's better to create the XSD and annotate it accordingly (so you choose the types/lengths and names of your columns) then publish the Data Store so Appian create all artifacts for you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If the table doesn't exist in your DB at all then it's better to create the XSD and annotate it accordingly (so you choose the types/lengths and names of your columns) then publish the Data Store so Appian create all artifacts for you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data