Field Requires Unsupported Conversion

While performing an alter on a table, I received the following error in the SQL Build log (PSBUILD.LOG):

Error: PS_EXAMPLE_REC - Field EXAMPLE_FIELD requires an unsupported conversion.  Record skipped. (76,29)

In this scenario, I had updated a field on a record after incorrectly making it a character field instead of a signed number. The conversion was from character (e.g. '1') to signed number (e.g. 1). However, the alter could not do this as indicated by the error.

Because this was a mistake in the field definition, I ended up dropping the field from the record definition, and performing the alter which dropped the column from the table. Then, I added the field back to the record definition and performed the alter which worked.

This works fine, if you have the luxury of dropping the data in the field…

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License