Issue in loading data thorugh data source in ServiceNow

[Sriram28]

Hello team,

I am getting this error in schedule job for a data sources while pulling the data.

MID Server reported error: SQLState: S0003
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129)

please check and let us know the issue.

Thanks in advance

[Simon Christens]

Hi

Theres not alot of information included.
Please describe what field you use in the target table

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

It seems like format could be wrong dd/MM/yyyy vs MM/dd/yyyy etc
But because there's no further info then its very hard to help.

If you search for the error on google its kinda says the same though

Reason: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.” This error typically occurs when there is a mismatch in the date format. For instance, if you have used the DD/MM/YYYY format for a parameter and the SQL Server is set to the MM/DD/YYYY format.

[Sriram28]

@Simon Christens 

After adding the below to data source, the error started appearing.

[Simon Christens]

You need to explain some more.

Is the screenshot an example of data imported into ServiceNow import table? - how is the data handled / transformed afterwards?

Its very difficult to figure out whats going on

[LearnerSN7]

How this issue was resolved?.