logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to forums.ablecommerce.com. Please use your AbleCommerce username and password to Login. Forums Registration.

Notification

Icon
Error

Options
Go to last post Go to first unread
speedythinker1832579  
#1 Posted : Tuesday, August 13, 2019 6:46:33 PM(UTC)
speedythinker1832579

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 5/20/2019(UTC)
Posts: 38

Thanks: 1 times
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 crash

Message 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

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. Forums Registration.

judy at Web2Market  
#2 Posted : Wednesday, August 14, 2019 6:10:10 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/7/2018(UTC)
Posts: 64

Was thanked: 2 time(s) in 2 post(s)
I can confirm both of these issues in B5588.
You can fix the popular categories issue by changing
<td><a target="_blank" href="@Url.Content("~/" + category.navigateUrl)">@category.category</a></td>
to
<td><a target="_blank" href="@Url.Content(category.navigateUrl)">@category.category</a></td>
on line 35 in E:\Able9B5588Test2\Website\Areas\Admin\Views\Report\_GetPopularCategoriesReport.cshtml

Edited by user Wednesday, August 14, 2019 6:14:39 AM(UTC)  | Reason: Not specified

katie_able_support  
#3 Posted : Wednesday, August 14, 2019 8:13:03 AM(UTC)
katie_able_support

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System
Joined: 10/29/2018(UTC)
Posts: 88

Thanks: 2 times
Was thanked: 6 time(s) in 5 post(s)
Thanks for letting us know, and especially for providing a fix here.

I will get this reported.
Thanks for your support!
Katie
speedythinker1832579  
#4 Posted : Wednesday, August 14, 2019 9:58:36 AM(UTC)
speedythinker1832579

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 5/20/2019(UTC)
Posts: 38

Thanks: 1 times
Thanks Judy!

BTW, I have another post that need to be identified. Would you mind to take a look at it:

https://www.ablecommerce...from-the-log--Is-it-bugs


Thanks
Marco

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.