Josefin Gruvander
05/17/2022, 2:56 PMMichal Hauzírek
05/17/2022, 3:59 PMJosefin Gruvander
05/18/2022, 6:09 AMMichal Hauzírek
05/18/2022, 11:16 PMinvalid input syntax for type integer
error you were getting.
You probably fixed that by reloading the data without empty value, but that itself did not resume the data type change. So the conversion never finished and the column remained varchar (and therefore it is still sorting alphabetically).
You can tell that there was some issue in the synchronization (publishing of the model changes) if you go to the Manage section and check the history there. There is no synchronization operation that would end without error.
You can do this to fix that:
Option one - (if there is no empty value in the data anymore) - which seems to be the case
1. go to https://brandranalytics.on.gooddata.com/gdc/md/i57o7ciy7dqqu3ecynq8fjkz3bxd0bsb/ldm/manage2
2. paste SYNCHRONIZE {dataset.vanswers} PRESERVE DATA;
into the text field there
3. click submit. (this will attempt to change the data type of the attribute again and it should succeed if there is no offending values.) and this will keep the data loaded as they are
4. repeat this for other client workspaces if they are also affected (just change the part after /gdc/md to the ID of each workspace
Option two - if there would still be data which can not be converted to integer
do the same as in “option one” but in step 2. remove the “`PRESERVE DATA`” part - that is paste there SYNCHRONIZE {dataset.vanswers};
This will cause the data for this dataset will be removed and the data type synchronization will happen again. You will then need to reload the data for this dataset.
I am sorry for the troubles here. I understand that is a bit tricky and confusing. Our engineers are already working on a fix to the LCM that would automatically do the force the cleanup of the dataset data during model change deployment if would end up in this kind of error, so in the future this will not be an issue anymore. But this will take some more time to deploy.
In the meantime, please be careful when doing data type changes or primary key changes with data already loaded. I checked the other datasets in the client workspace for you and the other ones all seem fine.Josefin Gruvander
05/19/2022, 8:50 AM