The number of rows provided for a FETCH clause must be greater then zero

  • Updated

This article describes an an error message that appears in the error logging after having upgraded to EPiServer.Commerce 11.2.6.  This error was introduced with a new set of Commerce Connect stored procedures. 

The number of rows provided for a FETCH clause must be greater then zero

The stack trace may have the following entry as well.

Stack Trace:
http://<our site name>/adminui/cms/Stores/contentstructure/?query=activitiesnotready&sort(+name)

This issue was raised in escalation COM-5771 and resolved in EPiServer.Commerce 11.4.1 which can be found here.  The recommendation is to apply the nuget package to that version or later.