Import Error: SQL Exception: Incorrect Syntax near "s"

Import Error: SQL Exception: Incorrect Syntax near "s"

Issue: Receiving this error message when trying to import records, sections or folders.



SQL Exception

Incorrect Syntax near "s"

Unclosed quotation mark after the character string 'WHERE'



This error is caused because there is a single quote character in one of the records/sections/folders name that they are trying to import.

 

 

Solution:

To resolve this error, remove the quotation in the import data and try re importing.

 


    • Related Articles

    • SqlException: Incorrect syntax near...

      Issue / Error Message: When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs: SqlException Incorrect syntax near 's' Unclosed quotation mark after the character string ...

    • SqlException Incorrect syntax near ','.

      Error Message: TargetInvocationException Exception has been thrown by the target of an invocation. SqlException Incorrect syntax near ','. at Forecast5.DataAccessLayer.Forecast5Db_SQL2008.Save(IDbTable entity, IEnumerable`1 columns, IEnumerable`1 ...

    • Exception: Cannot get computer id

      Issue: When trying to open Forecast 5, you get the following error: Exception Cannot get computer id Cause: Forecast 5 requires a computerid in order to license successfully. If the id cannot be read for any reason, the exception will occur. ...

    • Hotlink Error: "Exception of Type 'Forecast5.Model.HotlinkException' was thrown."

      Issue: When trying to setup a second Hotlink record, you receive this error: Exception of type 'Forecast5.Model.HotlinkException' was thrown.: 'location and name of the hotlink file.xlsx 2". Hot Link error found in 'Record Name'. Do you want to ...

    • Import Error: SqlException - Unclosed quotation mark after the character string..

      Issue: When trying to import bulk Employee Groups, you receive a similar error message to the ones below:   Cause: This is caused by an apostrophe or quotation mark being entered on the template. Forecast 5 is built on an SQL database and the SQL ...