Error while writing in data store entity

Could it be that you changed the ID field to auto-generate after publishing that data store? Appian will not modify an already existing field.

XSD for the same

<xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:TS" targetNamespace="urn:com:appian:types:TS">
<xsd:complexType name="TS_DataType_User_Product_Cart">
<xsd:sequence>
<xsd:element name="id" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="userId" nillable="true" type="xsd:int" />
<xsd:element name="productId" nillable="true" type="xsd:int" />
<xsd:element name="userProductQuantity" nillable="true" type="xsd:double" />
<xsd:element name="totalPrice" nillable="true" type="xsd:double" />
<xsd:element name="isActive" nillable="true" type="xsd:boolean" />
</xsd:sequence>
</xsd:complexType>
</xsd:schema>

XSD for the same

<xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:TS" targetNamespace="urn:com:appian:types:TS">
<xsd:complexType name="TS_DataType_User_Product_Cart">
<xsd:sequence>
<xsd:element name="id" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="userId" nillable="true" type="xsd:int" />
<xsd:element name="productId" nillable="true" type="xsd:int" />
<xsd:element name="userProductQuantity" nillable="true" type="xsd:double" />
<xsd:element name="totalPrice" nillable="true" type="xsd:double" />
<xsd:element name="isActive" nillable="true" type="xsd:boolean" />
</xsd:sequence>
</xsd:complexType>
</xsd:schema>

You need to check that directly in the database.

Thanks for the help,

Actually I don't know what to check,

Is the below screenshot is fine?

Hi Thanks a Lot, 

The error got resolved but 

I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured  as autogenerate),
Like paasing a code in userId which returns {2,2,2,2}
code in product id returns {1,2,3,4}
code in userProduct quantity returns {100,55,68,75}
code in total price returns {100,230,45,67}

isactive is true

in table only 1st values are getting written
in above case it is only creating only 1 row instead of 4 rows

in this case am I supposed to use looping and writing every time?

No. You need to pass multiple CDT items instead of multiple values per each field.

Thanks a Lot ,

I need to rework my interface with CDT, then it should work fine.