Crash when saving project after adding range dependency

Relates to versions - 1.6.6+

This documentation displays the procedure that needs to be performed to eradicate the crash issues occurring on spry projects with exception message: "could not insert: [PrecisionMining.Spry.Scenarios.RangeDependencyEntry][SQL: INSERT INTO RangeDependencyEntry (idx, Name, Description, Active, PredecessorTextRange, PredecessorIncludeAllProcesses, SuccessorTextRange, SuccessorIncludeAllProcesses, ReleaseDelayExpression, Colour, Items_id, PredecessorProcesses_id, SuccessorProcesses_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select last_insert_rowid()]".

Procedure

1. Open Spry but do not load any projects.
 
2. Click on File → Database Maintenance → Sqlite Executer

3. Select the Spry file you want to diagnose in the Database option by clicking the '…' button.
 
4. In the input text box, paste the text in it i.e. SELECT Colour FROM RangeDependencyEntry
 
5. Click the Execute button or hit F5. If the range dependency entry colour does not exist you will receive this message (Kindly refer below screenshot, If it does exist, the results grid will be populated and the problem is something else. If there is no colour column, proceed to apply the fix mentioned from Step 6 onwards).

6. Clear the SQL statement in the input text box and paste the following in:
 
ALTER TABLE RangeDependencyEntry
ADD COLUMN Colour INTEGER NULL;
UPDATE RangeDependencyEntry SET Colour = -29696;
 
7. Click the Execute button or hit F5. You should get a dialog that looks like the following:

8. Close the Sqlite Executer form and open the Spry file. It should now open or save successfully.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access