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
2 replies
Subscribers
10 subscribers
Views
2004 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Data Store not validating but "Update" DDL is empty
tomm7361
over 8 years ago
Verify Data Store reports a problem, but downloaded DDL contains nothing in the "Update DDL" section (see snippet below).
The V_xxx is a view not a table, but I have no trouble with other views in the same schema.
/*
Data Store: XXX
Created: 2017-02-06T15:38:18.587Z
By: yyy
Appian Version: 16.2.0.0
Target Database: Oracle Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Database Driver: Oracle JDBC driver 11.2.0.4.0
*/
/* UPDATE DDL */
/* DROP AND CREATE DDL */
/* WARNING: The DDL commented out below will drop and re-create all tables.
drop table "V_EPC_WEB_PEC_ASSETS" cascade constraints;
create table "V_EPC_WEB_PEC_ASSETS" (
"INSTANCEID" varchar2(255 char) not null,
...
primary key ("INSTANCEID")
);
*/
OriginalPostID-262592
Discussion posts and replies are publicly visible
Parents
0
ChristineH
Certified Lead Developer
over 8 years ago
This seems like it can't find the 'view', hence why nothing in the alter.
In your XSD, do you have the Table Name annotation set. Do you have the ID annotation for the unique field.
It may help to post your XSD. Thanks!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ChristineH
Certified Lead Developer
over 8 years ago
This seems like it can't find the 'view', hence why nothing in the alter.
In your XSD, do you have the Table Name annotation set. Do you have the ID annotation for the unique field.
It may help to post your XSD. Thanks!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data