Skip to main content
K
kundank0001
December 17, 2022
Question

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

  • December 17, 2022
  • 3 replies
  • 0 views

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
stefanhelzle0001
Brainy
December 17, 2022

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

    komalj3844
    komalj3844
    December 17, 2022

    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>

    K
    kundank0001Author
    December 18, 2022

    Thanks, [mention:181141e1c8ac4da2b75e98be94c06e98:e9ed411860ed4f2ba0265705b8793d05]

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

    Terms & ConditionsAccessibility statement