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

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 database cannot handle quotation marks.

Solution:
Remove the quotation or apostrophe from the template and try to import again.
If the second line on the error message says Incorrect syntax near '...' , this will tell you where the quotation is to be removed.

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

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

    • SQLException: Cannot insert the value NULL into column

      Issue: When importing or copying a forecast, you are are getting the following error: SqlException Cannot insert the value NULL into column 'InputDataBase', table 'Forecast52020.dbo.InputData'; column does not allow nulls. INSERT fails. The statement ...

    • SQLException: A network-related or instance-specific error... [Error: 52]

      Issue: Forecast 5 cannot continue because of an exception occured: SqlException Solution:   This error is generally caused because the Forecast 5 cannot find the SQL Server you are trying to connect to. Please check that your computer can see the SQL ...

    • Bulk Employee Group Import Error: IndexOutOfRangeException

      Issue: When trying to import bulk employee groups using the Employee Details import, I receive this error: Cause: This error is commonly caused by: The removal of column I in the template. Columns in the template have been reordered. Solution: Check ...