As digging more into this issue, I believe Houdini Python (Hython) is not able to resolve the Output path set to the ROP node and failing with a syntax error. I was able to reproduce this with Hython running the below command:
hou.findDirectory("<Node_Output_Path_Directory>")
You would need to run under Hython.exe, can be found in the below paths:
C:\Program Files\Side Effects Software\Houdini [Version]\bin\hython.exe
/Applications/Houdini/Houdini[Version]/Frameworks/Houdini.framework/Versions/[Version]/Resources/bin/hython
/opt/hfs[Version]/bin/hython
I was able to reproduce this issue using the above hou.findDirectory command with path posted in the error logs on the other forum post: Deadline Redshift expression error - #8 by Ahmed_Hindy