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
2005 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
sanjays0006
over 8 years ago
I have seen this error when the primary key is not set properly in the view and CDT.
It would be better if you can attach the view definition and the CDT to look into the issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sanjays0006
over 8 years ago
I have seen this error when the primary key is not set properly in the view and CDT.
It would be better if you can attach the view definition and the CDT to look into the issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data