Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
2670 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I have a table in Oracle database say "AG_SRV_TRAN_EXT". Created a CDT
kumaraveln
over 10 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
OriginalPostID-114323
OriginalPostID-114323
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