Difficulty saving SPDATs | Voters

Difficulty saving SPDATs

complete

Ali Ryder

London has a lot of SPDATs and have found that while attempting to save a SPDAT, the application goes through all of the other SPDATs first before saving, which causes it to time out.

September 12, 2023

Ali Ryder

marked this post as

complete

Update to version 4.0.60.1 from 2023-11-17

Ryan Booker

an update to version 4.0.60.1 was released on 2023-11-17 which contains a fix for this issue!

Ali Ryder

Ryan Booker: Amazing!

Ryan Booker

This issue has not been fixed in version 4.0.60.1
Instead, it may have made this issue worse.
In 4.0.60.1, the behaviour of the Autosave feature has changed and it now runs every time the person completing the SPDAT moves from one question to another. Depending on how quickly a user moves through the SPDAT form, this could cause multiple instances of the Autosave feature to run at the same time. This scenario was tested and multiple Autosave instances consumed all available CPU and memory resources in our dev/qa environment.
The cause of this issue has been identified as Autosave selecting all 440,053+ records in the HIFIS_SPDAT_Intake_QuestionsAnswered table.  Most of these records are not relevant to the SPDAT being completed. Changing the Autosave feature so that it only selects answers that are relevant to the SPDAT being completed would likely solve this issue.
This information has been shared with support@hifis.ca

Ali Ryder

Ryan Booker: Thanks for the update. Ugh! That's annoying!