Infor CRM (Formerly Saleslogix) Error in the Web Client- Invalid usage of the option NEXT in the FETCH statement. : Incorrect syntax near ‘OFFSET’

 I recently ran into a web client system that was unable to operate properly.  Whenever a page opened, the following error would be thrown:

The following SData diagnosis occurred: Description=Operation failed. Message=Invalid usage of the option NEXT in the FETCH statement. : Incorrect syntax near ‘OFFSET’. HTTP status: Internal Server Error (500).

The solution to this is something simple that I had ran into before.  Luckily my senility hadn’t yet reached that memory bank.  Here is how to fix this issue:

In the Saleslogix Connection Manager on the server someone had chosen the 2012 SQL Client (SQLNCLI11.1) rather than the 2010 SQL Client as the SQL OLE DB Provider to use to connect to the database.

After redefining the connection using the other provider, and an IIS reset- Kamblam! A working web site!

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!