Forum Discussion
Invalid or unknown format type 'MISONCSV'. Dynamics F&O Export to Data Lake, CDM Util
To give some context:
We have a data feed out of Microsoft Dynamics F&O, Exporting data tables to our Azure Data Lake Gen 2. This is then picked up by Synapse as tables. I created the tables using the CDM util.
This has been working perfect for the last couple of months. As of today all tables are throwing this error:
CSV looks fine to me and lines up with the cdm.json file.
Can't find any mention of this error online so not really sure where to start looking.
If you are experiencing the following error message within Synapse Serverless SQL Pool for OPENROWSET(), remove the PARSER_VERSION='2.0' and let Synapse Serverless SQL Pool use the default CSV parser or CSV PARSER_VERSION='1.0' (the only limitation is that you will not be able to use the HEADER_ROW option). This error message is specific to CSV parser version 2.0.
"Invalid or unknown format type 'MISONCSV'"
Also, reduce the max VARCHAR / NVARCHAR size to 4000
- I have exactly the same error. My CSV file is a simple save as CSV out of Excel. All my other CSV files work fine.
If you are experiencing the following error message within Synapse Serverless SQL Pool for OPENROWSET(), remove the PARSER_VERSION='2.0' and let Synapse Serverless SQL Pool use the default CSV parser or CSV PARSER_VERSION='1.0' (the only limitation is that you will not be able to use the HEADER_ROW option). This error message is specific to CSV parser version 2.0.
"Invalid or unknown format type 'MISONCSV'"
Also, reduce the max VARCHAR / NVARCHAR size to 4000
- Not sure what happened but this issue somehow fixed itself. I did have a ticket in with Microsoft so maybe they did something.
