You can translate the question and the replies:

Incompatible subtype

Hi there, The data source data type has changed from int to text. I would like to change the my base you to reflect this new data type. The error im getting is "the field has a compatible subtype for type "text": INTEGER Please assist with me with changing the BV Regards, Kaashief
string conversion
user
10-01-2020 08:26:41 -0500
code

1 Answer

Hi, I have experienced the incompatible subtype error before. This occurs when, after doing a [source refresh](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh), you have not updated the [source type properties](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/viewing_the_schema_of_a_base_view/viewing_the_schema_of_a_base_view#source-type-properties) to match those of the fields in the underlying data source. To resolve this, you can: 1. Go to the "Edit" tab of your view. 2. Under "Field Type," click the pencil icon next to the fields marked as red. 3. Specify the source type properties of the field. Hope this helps!
Denodo Team
10-01-2020 20:49:26 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here