Data import from SQL via link server through MId Server reporting SQL error - Error converting data type DBTYPE_DBDATE to date



This KB talks about a SQL exception which may appear when a customer is trying to import data using JDBC Data Source through MID server from SQL via Link server. 



Let's say a data source is defined to import data by connecting to the SQL server via link server. Assume you needed to import null values as well, so you've ticked 'Copy empty fields' on the transform map mapped to this data source. MID Server is involved in this import.

Now when the import is executed , you might receive the following error message:

"MID Server reported error: com. microsoft. sql server. jdbc. SQL ServerException: Error converting data type DBTYPE_DBDATE to date.
at com. microsoft. sql server. jdbc. SQL ServerException. make FromDatabaseError(SQL Server Exception. java: 216)" 

This error has nothing to do with our platform nor the MID Server and is something that the SQL admins to deal with. This is completely an SQL exception.

Please reach out to the Database Admins and fix the error at the DB level 


Additional Information

Here are few links from google on this SQL exception