Product: ImportOmatic
Description: This solution describes how to resolve the error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Environment: All
Versions: 3.0 and earlier
Answer:
The full text of the error reads:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. -->System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)-->System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)-->System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)-->System.Data.SqlClient.TdsParser.TryRun(RunBehavior
This error was resolved in IOM version 3.1. The latest version of IOM can be found here.
Description: This solution describes how to resolve the error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Environment: All
Versions: 3.0 and earlier
Answer:
The full text of the error reads:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. -->System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)-->System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)-->System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)-->System.Data.SqlClient.TdsParser.TryRun(RunBehavior
This error was resolved in IOM version 3.1. The latest version of IOM can be found here.