I moved the step where the storedProc is being called from lower in the flow (step 5 or 6) up to the 2nd step. This appears to have resolved the disappearing Advanced Parameters issue in the storedProc step for me. I assume it was a matter of scope, though I'm not sure why.
I encountered the error again but just in our DME environment. UT and PROD were good.
I encountered the error again but just in our DME environment. UT and PROD were good.
I'm having the same issue with a step that calls a Stored Procedure in a SQL DB. I have 4 advanced parameters set, and everything works fine. The next morning those 4 parameters are gone. If I replace them, all's well... until the next morning when they're missing again.
Why do these keep disappearing and need to be redone daily?
Additional information: The above happened last Monday, 3/18. I re-added paramter values and UT and DME were working good until today, It reported the error again just in UT. DME is good. These cloud flows are scheduled to run daily in the AM.
Thank you!
Michael E. Gernaey
8
Super User 2025 Season 1
David_MA
8
Super User 2025 Season 1
ankit_singhal
7
Super User 2025 Season 1