• State Not Answered
  • Replies 7 replies
  • Subscribers 11 subscribers
  • Views 3568 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
  • 0
    Appian Employee

    It's tough to tell from just that DDL script, because this also depends on the current structure and constraints in the database. Can you try to run that exact DDL script directly against the database? That should tell you what the error is and should help you to try and resolve it.

  • 0 in reply to Peter Lewis

    Thanks for reply.. I was able to figure out..

    Can you help me with 2nd question. Is it kind of glitch because none of my friend have any idea about it

  • 0
    Appian Employee
     in reply to akshayg0006

    I'm not sure I follow that question - were you able to publish the data store? Once you publish, the draft message should go away. Also you mentioned:

    Unknown said:
    It gets published in Appian Cloud but i cannot use that cdt while configuring Constant. Can someone help out.

    Can you describe how you are trying to use this? Are you saying you can't find the entity when creating a data store entity constant, or do you see it but it doesn't work? If possible, can you try to remove the entity, add it back, and republish?

  • 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? 

  • 0
    Appian Employee
     in reply to akshayg0006

    Usually that message goes away when you publish again though - are you still seeing that message after you have published? Can you delete the old entity that had the problem, publish without it, and then add it back to the data store and publish again?

    Also does it work if you create a new data store? If so, it might be easiest to just recreate the data store and delete the existing one (depending on how many entities you have in your data store).

Reply
  • 0
    Appian Employee
     in reply to akshayg0006

    Usually that message goes away when you publish again though - are you still seeing that message after you have published? Can you delete the old entity that had the problem, publish without it, and then add it back to the data store and publish again?

    Also does it work if you create a new data store? If so, it might be easiest to just recreate the data store and delete the existing one (depending on how many entities you have in your data store).

Children

© 2024 Appian. All rights reserved.