Hi.
Is someone able to help me with the below error i am getting when veryifing the data, when i hover over the more part it says The data source schema does not match the type mappings: Wrong column type in Appian.spotifycustomer for column paymentDetails. Found: bigint, expected: integer (APNX-2-4056-000). I have checked the database and the data type and it all matches. I cannot amend the payment details from bigint to integer as it comes up with an error due to a query so i am stuck. I am very new to Appian so any help will be greatly appreciated :)
Thank you,
Sarah
Discussion posts and replies are publicly visible
Hi Sarah, It would be helpful if you can tell what is the type of column paymentDetails in your cdt? Also, if you change bigInt to int in cdt as well as db what error you are getting in the query?
Hi Harsha,
The paymentDetails column is a foreign key to my data type payment details, when i change this the error is the same and it will not let me amend the db even when this is changed
So the column that is defined as bigInt, in appian CDT/XSD are you having Integer as the data type?
no, i assume it needs to be bigint, as it was autocreated and this was the type given. hence my confusion?
Can you try publishing the datastore by keeping bigInt in the backend and in CDT having the type as Integer? I don't think Appian supports bigInt as datatype in cdt designer.
it didn't work, it just will not accept it and it also won't let me change it either.
Can you attach a screenshot as in what error you are getting when trying to modify the type. Also, not sure if you tried modifying it from data type designer or XSD file.