We just migrated from V7 (gold) to V9 (Final and found a couple issues. The tech who performed upgrade from the hosting company claiming that it wasn't server issue but he insisted that it was coding issue. We paid a lot of money for the upgrade and I seems a lot of errors from the error log. Please take a look of these issue and confirm that whether is it coding issue or server issue.
Problem:1) By clicking any tap from the Sales by Product such as 'Quantity', 'Costs of Goods', or 'Amount', under Reports at Admin page will cause system crashMessage shown after crashed:
Server Error in '/' Application.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.]
System.Data.SqlClient.TdsParser.TdsExecuteRPC(SqlCommand cmd, _SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) +8146
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2598
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +1483
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +64
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +161
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
System.Data.Common.DbCommand.ExecuteReader() +14
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) +336
NHibernate.Loader.Loader.GetResultSet(DbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +258
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +192
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +139
[GenericADOException: could not execute query
[ SELECT this_.ProductId as y0_, sum(cast( this_.Quantity as INT)) as y1_, sum((this_.CostOfGoods * this_.Quantity)) as y2_, sum((this_.Price * this_.Quantity)) as y3_, this_.ProductId as y4_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId inner join ac_Products p2_ on this_.ProductId=p2_.ProductId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1) and o1_.OrderDate <= @p2 GROUP BY this_.ProductId ORDER BY y3_ asc ]
Name:cp0 - Value:CommerceBuilder.Orders.OrderStatus Name:cp1 - Value:CommerceBuilder.Orders.OrderStatus Name:cp2 - Value:1/2/0001 7:59:59 AM
[SQL: SELECT this_.ProductId as y0_, sum(cast( this_.Quantity as INT)) as y1_, sum((this_.CostOfGoods * this_.Quantity)) as y2_, sum((this_.Price * this_.Quantity)) as y3_, this_.ProductId as y4_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId inner join ac_Products p2_ on this_.ProductId=p2_.ProductId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1) and o1_.OrderDate <= @p2 GROUP BY this_.ProductId ORDER BY y3_ asc]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +226
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +20
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +76
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +369
NHibernate.Impl.CriteriaImpl.List(IList results) +49
NHibernate.Impl.CriteriaImpl.List() +58
NHibernate.Impl.Subcriteria.List() +48.....................
....
2) Clicking on any category b]Category[/b] under "Report>Popular Category" will show "Server Error in '/' Application.
I found that it was caused by having an extra symbol "~/" added to the link. If I copied the link and remove the "~/", it worked!
Error:
https://www.lightobject.com/~/Laser-Machines Working:
https://www.lightobject.com/Laser-Machines Thanks
Marco
