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 ...

    • TypeInitializationException: A network-related or instance-specific error... [Error: 26]

      Issue: You receive the following error when trying to login to Forecast 5. Forecast 5 cannot continue because of an exception occurred. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Cause: This error indicates that ...