Hi everyone
i have a problem that i dont understand with the datastore
i created a CDT "CreditRequest" and added it as Entity in the Datastore.
after 10 minutes i changed my mind i wanted to change many things in my datatype. so i deleted this entity from the datastore and deleted the table from the database. (i dont have any table of creditrequest now)
after my changes i saved the new data type and tried to add it to the datastore as a new entity and i have this Error.
What doest it mean ??? what i need to do to add this entity back to the datastore ???
Discussion posts and replies are publicly visible
Could it be that your created some nested tables with foreign key constraints? You would have to delete the constraints as well.
exactly my thoughts. This sounds majorly like FK constraints and "subtables" which are not deleted properly and shall be created again and the DB recognizes some issues there.
You said you deleted the table from database .right? After modifying cdt , did you create the table? And you have issues with foreign constraints as well.
YES MY TABLE WAS WITH FOREIGN KEYS.... SO I NEED TO DELETE ALL THOSE TABLES THAT I HAVE IN MY DATABASE TO RE-ADD THE ENTITY TO THE DATASTORE ?
You probably don't need to delete the tables, just remove those constraints. If you're using the out-of-the-box database, there's a button on each index where you can drop the constraints:
Just make sure to also drop any fields that reference the nested data from your CDTs as well.