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.
For your reference this is what your XSD definition should look like for that paritcular column
<xsd:element name="number" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="Number", columnDefinition="BIGINT")</xsd:appinfo> </xsd:annotation> </xsd:element>
Hi, Apologies. I have finally fixed that issue. Thank you for your help. Now i just need to resolve why an error is arrising when debugging my process model that states the account manager's name is too long even though it is set to 255 characters :) this is all a learning curve!
This fixed my problem