Datastore Entity Problem asking for composite id

Certified Lead Developer

Hello,

I am having an issue with my CDT. I can verify it but it does not save and publish. Also, I cannot write to my database it gives me an error. This happened after I added a related table to my main table. I deleted the table and foreign keys but still, I see these errors. How can I solve this problem?

ERROR:

An error occurred while trying to retrieve the data store entity [id=]. Verify that the data store and entity have not been deleted, and have the correct security settings. Details: java.lang.IllegalArgumentException: The id of the data store entity must be a composite id with a "@" as separator:

XSD:
<xsd:documentation><![CDATA[LMS data cdt]]></xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="employeeid" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="employeeID", nullable=false, unique=true, columnDefinition="INT")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Thank you

  Discussion posts and replies are publicly visible

Parents Reply
  • +1
    Certified Lead Developer
    in reply to Deepak Shinde

    Hi Deepak. Yes, I solved it. You can create your CDT again from the database table to make sure it is correctly formatted. My problem was because of a minor mistake. I gave a text value for my managerId in the form, but actually it was an integer value in my CDT. That's why it couldn't cast it. Then I deleted the write to datastore entity and created a new one. It worked after that.

Children