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 has been terminated.

Note: the words in italics may differ based on your database and issue.

Cause:

This is caused when there has been some vital information missing from the forecast you are trying to import or copy.

This can occur when using the integrations or importing from spreadsheets.

Solution:

In the original copy of the forecast you are trying to copy/import, check that:

1. You have run the budget and system recalcs. Found under Utilities.
   
2. There are no missing defaults in the settings, e.g. Currency, GST, PAYE, etc.
   
   

Then you will need to export the forecast again.

• Related Articles

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

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

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

• TypeInitializationException: "System.Array.Empty" when opening Forecast 5

  Issue: After an upgrade, you are receiving the following error when opening Forecast 5: TypeInitializationException The type initializer for 'Forecast5.Model.Node' threw an exception. TargetInvocationException Exception has been thrown by the target ...