Good morning -
Apologies if the issue I'm presenting has been resolved in prior discussions. I have not been able to track down a definitive source for my question yet.
I'm having chronic issues with macros in my environment - specifically, the "Wait a Second" macro. They keep disappearing from my workflows at seemingly random intervals. I add these macros at the end of my logic to slow down the output and prevent collision with open-files in the file system (when exporting to Excel).
Normally, these macros work like a champ. Every once in a while, I open the workflow and they've all disappeared. I've checked my settings, my temp folder, etc - I can't quite pin this one down.
I've scoured the forums and attempted several fixes and other options, which seem to help, but don't actually solve the issue completely.
Am I making a fundamental mistake with my usage of macros, or is my temp file floating (staging areas) and causing the dependency to break? How can I prevent this from happening in a shared environment where multiple developers may be working on the same workflow?
Thank you for any advice you might provide - again, I know this is probably a simple fix and will ultimately be a head-slapper moment for me, but I'm struggling and would appreciate the expertise of this group.