Hi all. I'm working with transferwise Tap-Oracle a...
# troubleshooting
j
Hi all. I'm working with transferwise Tap-Oracle and am running into the below error. "CRITICAL PY_SSIZE_T_CLEAN macro must be defined for '#' formats cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle" The error is occurring after the first table is created in Snowflake. It creates the table and then executes a select against the source table in Oracle at which point the above error is returned. I did some searching online and it appears to be related to changes made to Python (in 3.10) that may not be reflected in the Tap. Thought I'd check here to see if others using this tap have encountered this error and found a way to address it. So close to getting data moving... Any help would be appreciated. Thanks!
v
I use Python 3.8 currently and it works you could try that?
definietly worth putting in an issue to the tap though
j
I'll give that a try. Looks like I'll be taking a stroll into the virtual environment docs. Thanks for the tip about using the lower version!
v
Honestly you just have to install python, get it on your path so
python --version
shows 3.8. Then run
meltano install --clean
done
j
Oh nice! I got it installed and in the path. Looks like the meltano install --clean was what I was missing. Thanks!
v
yeah without clean it doesnt' remove the old venvs 🙂
j
So I switched to 3.8.10 and am still getting the error. Is that the version of python that you're running currently?
v
yeah 3.8.x something
j
Quick update on this. I dropped down to 3.8.0 and am still getting the error. Must be something else going on. Continuing to investigate...