I am trying to create a Data type using the SQL view, but I am facing the following error:
I am unable to Adding the data type to data store. Any suggestion?
Discussion posts and replies are publicly visible
If you open the saved data store and attempt to Save/Publish it, you will receive a red error message that will be helpful to identify the specific issue. Within the message click "More Info", and share the details here.
The More info says "The data source schema does not match the type mappings: Wrong column type in Appian.vendors for column accountnumber. Found: int, expected: varchar(255) (APNX-2-4056-000)"
This indicates your accountnumber column is an integer field in the database, but defined as text in your CDT. Assuming you are expecting integer, update your CDT field to type Number (Integer).
Karanc, you have a type mismatch for the field accountnumber between your SQL View and the CDT that you created. Once you fix that mismatch, you should be good to go