We have a script to update user defined fields on a project card, with total time spent on appointments stored against the project. Depending on the appointment type, depends on which totals fields it updates. The script run every night and loops through the projects using the following COM code.
Set objProjects = objSODB.Find.ProjectsByName("")
This has worked fine for years since SuperOffice 6. However since the upgrade to 8.2 it runs for about 30 minutes, updating various projects before crashing with the following error.
The file as expected does exist.
It normally crashes around the same place (I have exported the project name it is updating to a text file so I can see where it crashes). However the issue is not due to an error in any project in particular, because if I use ProjectsByName("CB"), then the projects it was crashing on that started with CB, all complete succesfully, the problem is with the volume of project being processed.
This has never been a problem pre 8.2, so is there an issue with long running Com scripts in SuperOffice 8.2.