Skip to main content
sarathkumr268295
sarathkumr268295
December 15, 2023
Question

XSD Datatype and table datatype mismatch

  • December 15, 2023
  • 7 replies
  • 1 view

Reframing the whole question, can we change the datatype of column from one datatype to another datatype? 

7 replies

karumurua531442
karumurua531442
December 15, 2023

Hi [mention:b08a9915dde2428e9c6dfef8cba0cdd6:e9ed411860ed4f2ba0265705b8793d05]  yes we can do it. could give more info about what is the datatype mismatch error?

sarathkumr268295
sarathkumr268295Author
December 15, 2023

The database schema currently does not match the CDT mappings (schema-validation: wrong column type encountered in column [amount] in table [`table_name`]; found [int (types#integer)], but expecting [decimal (types#double)]). After the attached database scripts execute, the data store will be successfully imported and saved. The data store will only be published if there are no schema mismatches.

karumurua531442
karumurua531442
December 15, 2023

Hi [mention:b08a9915dde2428e9c6dfef8cba0cdd6:e9ed411860ed4f2ba0265705b8793d05]  

Download the XSD file of the cdt.  Edit the column definition to INT or Decimal as per your requirement check from the image below. save the xsd file. open your cdt click on gear icon you will find an option create new version from XSD. click on that upload the latest version of your XSD proceed with create new version

Terms & ConditionsAccessibility statement