Hi,
I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text.
When i try to verify the datastore, it is giving me the below error
The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain.
any help is appreciated.
Discussion posts and replies are publicly visible
Hi ramkumars0001,
The data store throws an error because the column data type in the view is different than what you've defined in the XSD. To overcome this you should either:
<xsd:element name="financialStructure" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="YOURSOURCE">@Column(name="fs_structure", nullable=true, columnDefinition="TEXT")</xsd:appinfo> </xsd:annotation> </xsd:element>
Also, I could see that all the columns have different definitions in Appian and in the database. Kindly ensure that the data type that you mention in the XSD is the same as the one in the database.
hi Selvakumar Kumarasamy I tried your solution and it still complains.
Our DB was migrated from MySQL to MariaDB. Not sure if this is the root causee.
Thank you so much for your time and attention! You are awesome!. Have a great day