When executing a "copy file" activity, and it fails, the value of its "#_ACTIVITY_RESULT#" variable has the PATH of the file it tried to copy, like this:
Copy_1 - Could not find file "\\\\remote_folder\\subfolder_1\\subfolder_n\\example_file.txt".; Inner exception: This file was not available at runtime. The location and user authentication may be different at runtime.
So:
1. - That value won't be useful in a IF activity, at least not until QAT-12485 is resolved.
2. - When trying to use "Substr('#_ACTIVITY_RESULT#', 0, 9)" in a "Set Variable" activity, to save into another variable the part that did not include the PATH, in order to use the OTHER Variable in the IF statement, then TDP's showing this error:
Set_Variable_1 - Object reference not set to an instance of an object.
Object reference not set to an instance of an object.
Failed
And, as one is also unable to use the Substr(...) function to extract just the part that does not include the PATH, then one is unable to evaluate an Automation "_ACTIVITY_RESULT" variable.
Issue resolved in Toad Data Point 5.0.
Corrected an issue that caused an error when attempting to evaluate an expression in a variable and the expression contained the back slash (\) character (such as in a file path). This issue was encountered when attempting to compare the ROOT_PATH variable in an IF statement.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center