Thanks all, appreciate the feedback.
I did try pulling out the synonyms to simplify the troubleshooting and still ran into the same issue while it was broken. For now, my code is working though and it difficult to troubleshoot.
I am going to add in the TRY CATCH as describe by LutzM (Thanks) and see what parts are breaking when it does fail.
LutM - do you have a recommendation for how to capture the output?
I will also look into the openquery function as suggested by Lynn Pettis (Thanks) and the followup with EXECUTE AT linkedserver from ChrisM@home
Thanks all for helping this newb 😉 oh now bumped to Grasshopper status