Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Data import from SQL via link server through MId Server reporting SQL error - Error converting data type DBTYPE_DBDATE to date - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Data import from SQL via link server through MId Server reporting SQL error - Error converting data type DBTYPE_DBDATE to date
KB0744595

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


818 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

Overview

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. 

 

Subject

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

   - https://knowledgebase.progress.com/articles/Article/000044844
   - https://www.tek-tips.com/viewthread.cfm?qid=1087756


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.