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 Sarah,
Please checkout this link https://docs.appian.com/suite/help/19.1/Generating_Database_Tables_from_CDTs.html#default-column-types-based-on-xsd-types
Please check your CDT whether the datatype in XSD is specified as mentioned in the table for bigint.
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>
Publishing a data store based on already existing table is always tedious and mind breaking. Here are the few simple steps you can follow to achieve what you need
1) First of all create a table in mysql. Make sure there is one primary key column exists
2) Once you have done with your table creation, Create a data store in your appian application
3) Now create a Data type using "Create from database table or View" option. This will give you the list of all existing table and views in your appian database
4) Chose the table that you have just created. It will take you to the next page showing column details and data store information
5) Make sure the data store is selected there and the column is set as primary key which you have set as a primary key in DB
6) After reviewing all these information. you can click on save and submit button. You data store will automatically get published but you can verify it by opening your data store and making sure that entity has been added for the data type that you have just created.
Hope this helps