Hi all,
I am a beginner in Appian and I have come across a problem that I've debugged for an hour but can't find the solution to. I'm attempting to write data to a data store entity and I continue to get the following error:
Problem: An error occurred in executing an Activity Class.
Details: An error occurred while trying to write to the entity "vehicle_parts" [id=7241da9e-15f3-402f-ae6d-b0f08195974e@87648, type=VFM_Part (id=3724)] (data store: VFM DS CK). Details: java.lang.IllegalArgumentException: The record to be saved must not be null: TypedValue[it=3724,v=<null>] Data: TypedValue[it=3724,v=<null>]
Recommended Action: Examine the activity class to correct the error and then resume.
Priority of this problem: High Priority
Does anyone have any idea how to solve this? If it helps, I'm also having trouble finding the created table after I save and publish my data store with no issues.
Discussion posts and replies are publicly visible
In addition to this, you'll also need to map the table's columns to the CDT fields. Check out the following documentation to learn more about available XSD annotations you can use:
docs.appian.com/.../Supported_XSD_Elements_and_JPA_Annotations.html
I've also linked a test CDT XSD that will help you understand this better.
<?xml version="1.0"?> <xsd:schema xmlns:tns="urn:test:TEST" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:test:TEST"> <xsd:complexType name="TEST_testCdt"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Table(name="TEST_TEST_TABLE_MAPPING")</xsd:appinfo> </xsd:annotation> <xsd:sequence> <xsd:element name="testColumn1" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="TEST_COLUMN_1" columnDefinition="integer not null")</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="testColumn2" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="TEST_COLUMN_2" columnDefinition="integer not null")</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="testColumn3" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa"> @Column(name="TEST_COLUMN_3" columnDefinition="varchar(255) not null")</xsd:appinfo> </xsd:annotation> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:schema>
is this what you're referencing?