search

alan-turing-institute / WimbledonPlanner

Project planning for REG
MIT License
0 stars 0 forks source link

Update can fail if a project with time entries has been deleted #70

Open kdixey opened 4 years ago

kdixey commented 4 years ago

On clicking 'update' I get the error message attached:

wimbledon_error_020320.txt

jack89roberts commented 4 years ago

Hi Katherine,

I have a temporary workaround so the data on the web-site is now up to date, but it is likely to fail with the same error again in the future if a project is deleted from Forecast that has time tracked against it in Harvest.

I'll try to fix it properly soon, but if you get the error again just let me know and I can force it through.

Thanks, Jack

jack89roberts commented 4 years ago

Details:

As the app doesn't need Harvest data it is set not to update the time entries for a project (as this takes a relatively long time). However, if a project with time entries is deleted from Forecast/Harvest it causes the update to fail as it tries to delete the project from the database without removing the time entries first.

Need to check the time entries table for deletions even if time entries are not being updated.

kdixey commented 4 years ago

Ah great to know- will keep this in mind. Thank you!