Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Favorite list fails in 9.4.8

Favorite list fails in 9.4.8

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 11/04/2018 16:45:03

Hi Dynamicweb,

 

I am using 9.4.8, but cannot access the favorite list with the customer center after upgrading. We now get this error:

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at 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)
   at 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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.CustomerCenter.CustomerProductListProduct.GetProductsBySql(CommandBuilder builder) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\CustomerProductListProduct.vb:line 354
   at Dynamicweb.Ecommerce.CustomerCenter.CustomerProductListProduct.GetPagedProductsByListId(Int32 id, Int32 startIndex, Int32 pageSize) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\CustomerProductListProduct.vb:line 207
   at Dynamicweb.Ecommerce.CustomerCenter.CustomerProductList.GetPagedProducts(Int32 startIndex, Int32 pageSize) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\CustomerProductList.vb:line 223
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer.RenderCustomerProductsList(CustomerProductList favoriteList, Template template) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 866
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer.RenderLists(CustomerProductList favoriteList, Template template, Boolean isDefault) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 784
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer.RenderLists(CustomerProductList favoriteList, Template template) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 770
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer.RenderMyListInternal(PageView& pageView, Boolean isForEmailBody) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 675
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer..ctor(CustomerCenterSettings settings, PageView pageView, Int32 paragraphId, Template template, Boolean isForEmailBody) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 528
   at Dynamicweb.Ecommerce.CustomerCenter.Renderers.MyListsRenderer..ctor(CustomerCenterSettings settings, PageView pageView, Int32 paragraphId) in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Renderers\MyListsRenderer.vb:line 512
   at Dynamicweb.Ecommerce.CustomerCenter.Frontend.GetContent() in C:\Dynamicweb9\05 - Modules\Dynamicweb.Ecommerce\Head\Dynamicweb.Ecommerce\CustomerCenter\Frontend.vb:line 154
   at Dynamicweb.Frontend.Content.GetModuleOutput(Paragraph paragraph, PageView pageview)
ClientConnectionId:04f6f569-6caf-4a87-8ee4-bd9a2f8406f8
Error Number:102,State:1,Class:15

 

Hope you are able to help?

 

Best regards, Anders


Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 12/04/2018 03:31:32
Reply

Hi,

Tested on solution under DW948 and uses Rapido v2 design - no an exception found

BR, Oleg QA 

 
Anders Ebdrup
Anders Ebdrup
Posted on 12/04/2018 07:20:06
Reply

Hi Oleg,

 

Thank you for testing. Can it be caused by an old version of SQL? They are running 2008.

 

Best regards, Anders

 
Gaëtan Di Caro
Posted on 12/04/2018 08:48:03
Reply
This post has been marked as an answer

Yes, OFFSET FETCH is only available in SQL2012 : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f24c0a3d-e8e9-4041-aca5-590a6e1a2e81/how-to-use-offset-fetch-next-in-sql-server-2008-r2?forum=databasedesign

Which Dynamicweb 9 requires at the minimum : https://doc.dynamicweb.com/get-started/introduction/requirements/requirements-dw9#sideNavTitle1-2-3

Votes for this answer: 1

 

You must be logged in to post in the forum