Invalid number of columns in query while writing to a dataset

[jvijayakumar2]

I get the following error while trying to run a recipe that writes to a newly created dataset. Please help!

[sergeyd]

Hi @jvijayakumar2 

Quite often, prepare recipes change dataset schema (adding/removing columns). In all such cases when you run the recipe, DSS will ask you if you want to accept schema changes. When you do this, the output dataset will have the correct number and types of columns. If you do not do this, you will get an error like you shown on the screenshot. 

You can try navigating to the output dataset->Settings->Schema and hit "Check now". You should see a message to accept new schema. 

[jvijayakumar2]

Thanks for your reply! The schema seems to be good but the error wouldn't go away.