SQLDATETIME overflow

Nov 25, 2015 at 5:24 PM
Hi Sebastian

Not sure this is related but has started happening since running the latest version of turbo. This affects Ventrian Property Agent. Thanks!

Error: Events is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource1 completion, Int32 startRpc, Int32 startParam) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Ventrian.PropertyAgent.SqlDataProvider.AddProperty(Int32 moduleID, Int32 propertyTypeID, Boolean isFeatured, DateTime dateCreated, DateTime dateModified, DateTime datePublished, DateTime dateExpired, Int32 viewCount, Int32 status, Int32 authorID, Int32 modifiedID, Double latitude, Double longitude) at Ventrian.PropertyAgent.PropertyController.Add(PropertyInfo objProperty) at Ventrian.PropertyAgent.EditProperty.Update() at Ventrian.PropertyAgent.EditProperty.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Nov 28, 2015 at 7:58 PM
Edited Nov 28, 2015 at 8:05 PM
I believe I worked around this by changing datetime to datetime2. Not sure why but I don't get the overflow error now.
Coordinator
Dec 31, 2015 at 11:02 AM
sorry again for the late reply. This seems to be another improper value being used by Ventrian Property Agent (the error is caused in Ventrian.PropertyAgent.SqlDataProvider.AddProperty). This procedure is specific to the Ventrian module and uses a custom Table, AFAIK.
You should try to contact Scott about it (yes, I know it is difficult).
Marked as answer by leupold on 1/10/2016 at 6:05 AM
Dec 31, 2015 at 1:44 PM
No worries Sebastian, thanks for responding. Yes getting a response from Scott is impossible but I was able to get around this issue by changing the datetime on that table to datetime2.

Carl