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
Could you check the XSD for the View CDT and see if you have something similar to the code below:
<xsd:element name="financialStructure" nillable="true" type="xsd:string">
<xsd:appinfo source="YOURSOURCE">@Column(name="fs_structure", nullable=true, columnDefinition="VARCHAR(341)")</xsd:appinfo>
I'm not sure if you already tried that, but maybe you just need to download and edit the XSD and create a new version of the CDT.
hi Acacio Barrado Thank you so much for your help. I already tried creating new version from XSD. It still complains
I also tried the solution suggested Selvakumar Kumarasamy below and it still complains the same.
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
I have a problem when importing my datastore, it does not work, it indicates that it does not find some sequences but of those sequences mentioned are not used, I need to know why it requests them.Where can I find all the sequences used by the system besides the cdts?
Acacio Barrado , Selvakumar Kumarasamy, Peter Lewis, jasong0004
I had to change my view and cast my text columns into varchar and it fixed the problem.
Many thanks for your time and assistance. Have a great day to you all!
Please mark the question as answered.
© 2021 Appian. All rights reserved.