The issue turned out to be the blank string variable at run time. As soon as I provided an 'xx' as the value for the variable, the package runs, sets the variable correctly, and they query runs as expected.

Thank you everyone for your help!