• State Not Answered
  • Replies 7 replies
  • Subscribers 12 subscribers
  • Views 3579 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Data Store Entity Error

akshayg0006

Hi,

I have two doubt related to data Store entity:

1) After matching with cdt name and publishing the data am getting an error " Unable to automatically create tables". I have the DDL which i have attached. Can someone help me like what change am supposed to do so it starts working. 

.

Fullscreen TC_DS_User DDL.sql Download 
/* UPDATE DDL */
/* DROP AND CREATE DDL */
/* WARNING: The DDL commented out below will drop and re-create all tables.
    drop table if exists `tccustomerdetails`;

    drop table if exists `tckycdetails`;

    drop table if exists `tcuserinfo`;

    create table `tccustomerdetails` (
        `customerid` integer not null auto_increment,
        `firstname` varchar(255),
        `lastname` varchar(255),
        `mobile` integer,
        `email` varchar(255),
        `customertype` varchar(255),
        `userid` varchar(255),
        `password` varchar(255),
        `confirmpassword` varchar(255),
        `updatepassword` varchar(255),
        `updateuserid` varchar(255),
        `createdby` varchar(255),
        `createdon` datetime,
        `updatedby` varchar(255),
        `updatedon` datetime,
        `requesttype` varchar(255),
        `requestid` integer,
        primary key (`customerid`)
    ) ENGINE=InnoDB;

    create table `tckycdetails` (
        `kycid` integer not null auto_increment,
        `d01` varchar(255),
        `d01passport` varchar(255),
        `d01docnumber` varchar(255),
        `d01name` varchar(255),
        `d01date` date,
        `d01upload` varchar(255),
        `d02` varchar(255),
        `d02passport` varchar(255),
        `d02docnumber` varchar(255),
        `d02name` varchar(255),
        `d02date` date,
        `d02upload` varchar(255),
        `d03` varchar(255),
        `d03passport` varchar(255),
        `d03docnumber` varchar(255),
        `d03name` varchar(255),
        `d03date` date,
        `d03upload` varchar(255),
        `d04` varchar(255),
        `d04passport` varchar(255),
        `d04docnumber` varchar(255),
        `d04name` varchar(255),
        `d04date` date,
        `d04upload` varchar(255),
        `d05` varchar(255),
        `d05passport` varchar(255),
        `d05docnumber` varchar(255),
        `d05name` varchar(255),
        `d05date` date,
        `d05upload` varchar(255),
        `addressline1` varchar(255),
        `addressline2` varchar(255),
        `addressline3` varchar(255),
        `city` varchar(255),
        `state` varchar(255),
        `pincode` integer,
        primary key (`kycid`)
    ) ENGINE=InnoDB;

    create table `tcuserinfo` (
        `userid` integer not null auto_increment,
        `name` varchar(255),
        `dob` date,
        `email` varchar(255),
        `usertype` varchar(255),
        `submittime` datetime,
        `loginid` varchar(255),
        `phoneno` integer,
        `password` varchar(255),
        primary key (`userid`)
    ) ENGINE=InnoDB;
*/

2) By Mistake i have clicked on save Draft in Data store .. If i try to map cdt and publish. It gets published in Appian Cloud but i cannot use that cdt while configuring Constant. Can someone help out.

Do find the screenshot attached.

  Discussion posts and replies are publicly visible

Parents Reply
  • 0 in reply to Peter Lewis

    I had clicked on save draft while publishing previous cdt which had the issue " Unable to automatically create tables".. which i had described above. 

    Now again i had to create a cdt and publish it. Which got published and i was able to see those fields in Appian cloud database. But I am getting the issue described below. And if i try to use this entity while mapping in Constant, Interface or record. This cdt name is not displaying.

    So probably my assumption is till the time previous cdt mapping is not published correctly. We cannot publish another cdt. Is this right? 

Children

© 2024 Appian. All rights reserved.