search

AtlasOfLivingAustralia / fieldcapture

Natural resource management project data capture and reporting
http://fieldcapture.ala.org.au
4 stars 8 forks source link

Another weekly scheduled staging download failed #2603

Closed salomon-j closed 2 years ago

salomon-j commented 2 years ago

Another weekly scheduled staging download failed over the weekend, had a quick eyeball and the download issue is different from the reported issue last week.

salomon-j commented 2 years ago

https://support.ehelp.edu.au/a/tickets/151816

salomon-j commented 2 years ago

Downloaded Tabs/Activity Types:

Tabs: [Indigenous Employment and Businesses, Outcomes, Evaluation and Learning - final report, Project Administration, Progress, Outcomes and Learning - stage report, Biodiversity Fund - Outcomes and Monitoring, Site assessment, Fauna Survey - general, Flora Survey - general, Pest Animal Survey, Plant Survival Survey, Site Monitoring Plan, Water Quality Survey, Weed Mapping & Monitoring, Vegetation Assessment - Commonwealth government methodology, Community Participation and Engagement, Debris Removal, Disease Management, Erosion Management, Fencing, Conservation Grazing Management, Ecological Fire Management, Fire Management, Heritage Conservation, Management Plan Development, Management Practice Change, Conservation Actions for Species and Communities, Pest Management, Plant Propagation, Public Access and Infrastructure, Research, Revegetation, Seed Collection, Site Preparation, Water Management, Weed Treatment, Works Planning and Risk, Upload of stage 1 and 2 reporting data, Indigenous Knowledge Transfer, Training and Skills Development]

salomon-j commented 2 years ago

I'm suspecting the issue happens during the batch run. Didn't replicate the issue in staging and in my local when the report was executed independently. Will wait until the next batch run this weekend.

salomon-j commented 2 years ago

Ticket filed today - https://support.ehelp.edu.au/a/tickets/153760

This download failed again yesterday 07/08/2022. What change after a few weeks of not having download issues was Ecodata 3.9-SNAPSHOT was deployed in test and staging last Thursday(04/08/2022). Prior from the weeks which wasn't failing after the first ticket issue was reported, Ecodata 3.8.2-SNAPSHOT was running in test and staging.

chrisala commented 2 years ago

This is caused by a sheet name clash between Participant Information from Ecological Fire Management and Participant Information from Fire Management.
(The Biodiversity Fund is the only program that has both, as one was removed in favour of the second). It's not clear to me at the moment why the 3.8.2 version works, and the 3.9-SNAPSHOT fails.

salomon-j commented 2 years ago

@chrisala It's the temp fix I've done in https://github.com/AtlasOfLivingAustralia/fieldcapture/issues/2597 It's really strange the error didn't happened in Ecodata 3.8.2-SANPSHOT hence I was thinking it might be a different issue.