'I have 2 different environments with the same version of alteryx running on each, the exact same routine running on each, and in 1 environment the excel output breaks (when opening it it says "a problem was found - do you want to attempt to fix - clicking yes does the "fix", but my target sheets now all empty instead of showing the output data in them) - attached screenshot as "UnexplainedErrorNotFixed"
In the other it doesn't break (when opening it still displays the "a problem was found - do you want to attempt to fix" message, but clicking "yes" actually fixes the excel as expected, and my data appears where it should be) - attached screenshot as "ExpectedErrorFixed"
Environment A: Alteryx Server 2020.4.5.12471 (Local VM) - Behavior is as expected
Environment B: Alteryx Server 2020.4.5.12471 (Azure Server) - Output excel breaks
For both environments, the routine used is exactly the same, the same data, created by the same Alteryx Designer version (Alteryx Admin Designer 2019.3.5.17947)
My routine is reading a pre-formatted excel with data in it from a Shared Drive that is visible to alteryx, performs some calculations, and then enriches that same excel with new data, in specific sheets, specific ranges. I am attaching a screenshot of the specific output settings I'm using.
Can you give me some pointers as to what factors may be causing the exact same routine to behave differently in 1 environment than the other, so as to drill down on the potential issue? I'm also attaching a simplified version of the routine "Example of issue.yxzp"
Thanks in advance.
