Skip to main content
November 18, 2022
Question

Error while writing in data store entity

  • November 18, 2022
  • 8 replies
  • 0 views


I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured in cdt 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


Can you help me what is the issue here?

8 replies

stefanhelzle0001
Brainy
November 18, 2022

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.

November 18, 2022

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>

stefanhelzle0001
Brainy
November 18, 2022

You need to check that directly in the database.