Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you select a vendor in Requisition Management for Business Portal in Microsoft Dynamics GP: "Incorrect Syntax near 'TO'"

Error message when you select a vendor in Requisition Management for Business Portal in Microsoft Dynamics GP: "Incorrect Syntax near 'TO'"

Symptoms

When you select a vendor in Requisition Management for Business Portal in Microsoft Dynamics GP 9.0, you receive the following error message:

Query Error. Microsoft.BusinessFramework.Data.GeneralDatabaseException Line 1: Incorrect syntax near ‘TO’

↑ Back to the top

Resolution

To resolve this problem, run the iisreset command to reset Internet Information Services (IIS). To do this, follow these steps:
  1. Make sure that you have a complete backup copy of the database. You can use this backup copy to restore the database if a problem occurs.
  2. Make sure that all users exit Business Portal.
  3. Click Start, click Run, type iisreset in the Open box, and then click OK.


    Note If you use more than one company in Business Portal, you may have to run the iisreset command multiple times.

↑ Back to the top

Keywords: kbnosurvey, kbgreatplainsbp, kbentirenet, kberrmsg, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbprb, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 939122
Revision : 1
Created on : 3/3/2017
Published on : 1/11/2015
Exists online : False
Views : 92