Skip to main content
Inspiring
Dec 17, 2022 12:04 AM UTC
Question

Missing table: ntnhhandoverhistory (APNX-2-4056-000)

Hi Team,

After creating a CDT properly, I am unable to verify  Entity mappings in the data store. It is giving me the below error.

Note:- Record type is generated and synced with the table already available in the DB.

I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory.

I have to keep the table name in upper case. Could you please suggest?

3 replies

stefanhelzle0001
Brainy
Dec 17, 2022 10:21 AM UTC

You would need to modify the XSD from the data type designer to modify the table name.

komalj3844
Participating Frequently
Dec 17, 2022 11:54 AM UTC

Please use this schema to define table name. the bold once will help you define table name 

<xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:MA" targetNamespace="urn:com:appian:types:NT">
<xsd:complexType name="NT_NH_Handover_History">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Table(name="NT_NH_Handover_History")</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="id" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="id", nullable=false, unique=true, columnDefinition="INT")</xsd:appinfo>
</xsd:annotation>
</xsd:element>


</xsd:sequence>
</xsd:complexType>
</xsd:schema>

Inspiring
Dec 18, 2022 9:49 AM UTC

Thanks, [mention:181141e1c8ac4da2b75e98be94c06e98:e9ed411860ed4f2ba0265705b8793d05]

It worked, I was missing the table name in XSD.