Database creation: NullReferenceException
Issue:
When trying to create a new database, you are receiving the following error but the database is still created in SQL:
NullReferenceException
Object reference not set to an instance of an object.
Cause:
This is caused by attempting to connect to an SQL Server that is lower than 2018 (e.g. SQL Server 2008, 2008 R2).
The reason this fails is SQL Server 2008 R2 became unsupported by Forecast 5 in March 2018 as there are a number of features Forecast 5 uses that are not available in these older version, as per this Microsoft article
Solution:
Upgrade to a supported SQL Server version or install a supported standalone SQL Server Express version.
Related Articles
Sending Your Database To Support
To send your database to support for investigation, please follow the steps below: 1. C:\ProgramData\Forecast 5 Ltd 2. Copy the data folder to your desktop in a zip folder. 3. Attach the zip folder to an email and send to support@forecast5.comHot Link - NullReferenceException in View.HotLinkDetailsExcelView.ComboBox_SelectionChanged
Issue: Receive this error when clicking the Hotlink Button: NullReferenceException in View.HotLinkDetailsExcelView.ComboBox_SelectionChanged Cause: - The user creates a record and changes the method/derivation to HotLink - The user then makes a ...SQLException: Failed to update database... because the database is read-only
Issue/Error: When opening Forecast 5, you are receiving an error: Forecast5 cannot continue because of an exception occured: SqlException. Failed to update database "[database name]" because the database is read-only. Forecast 5 will fail to open. ...Cannot open database "...." requested by the login. The login failed.
Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...Update the config file - point Forecast 5 to a new server or database.
If you have a network license and you wish to store the Forecast 5 database on a server, you will need to update the config file to point to the correct server and database. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd Edit the file ...