Error verifying datastore

Question

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.

ramkumars0001 · Accepted Answer

, 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!

Peter Lewis · Answer

The easiest way to find the correct syntax you need is to generate a new CDT directly from the database view. You won't actually need the CDT later (and can plan to delete it once you're done), but that should tell you what syntax is needed to connect to that field if you then download the XSD of this new CDT. Then, just copy the element from this new CDT into your old CDT XSD and re-upload, and you should be good to go!

Selvakumar Kumarasamy · Answer

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: If that column is for sure going to capture text values, then change the columnDefinition in your XSD file to below: @Column(name="fs_structure", nullable=true, columnDefinition="TEXT") If that column doesn't need to be a text type, you can typecast the column in your view to the defined format. 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.

Error verifying datastore

Top Replies