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>

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.

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.