Cannot verify data store - The data source schema does not match the type mappings: Wrong column type.

Question

We wanted to change one some of our table columns from int to varchar. I updated the relevant columns in the database, altered the CDT's, but now when I try to verify the data store I'm getting the following error:

The data source schema does not match the type mappings: Wrong column type in Database.Table for column Currency. Found: varchar, expected: INT (APNX-2-4056-000).

I've checked the data type, and downloaded the xsd and it looks to be correct:

<xsd:element name="currency" nillable="true" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="appian.jpa">@Column(name="Currency", columnDefinition="text")</xsd:appinfo>

</xsd:annotation>

</xsd:element>

If I try to remove the entity from the data store and verify, I'm still getting the error message somehow. I've checked the logs and they're not showing me any issues.

Any suggestions on a way to remediate this? If I change the column type in the DB back to int, it successfully verifies again.

johng0005 · Accepted Answer

Found it, I'm an idiot. For anyone else who faces this issue, check to make sure that you've updated all of your other entities that may reference the same database fields.

Cannot verify data store - The data source schema does not match the type mappings: Wrong column type.

Top Replies