Can anyone help solve the Broken Pipe Error 32
# troubleshooting
i
Can anyone help solve the Broken Pipe Error 32
a
Mmm meltano version? Which tap and target config are you using? Can you provide a sample of the config? Which command are you using to trigger the error
i
- My version of meltano is version 3.4.2. I'm using tap-postgres (my postgress is running in a docker container) and target-jsonl. The command I'm using to see the log is "meltano --log-level=debug elt tap-postgres target-jsonl"
d
@Iara Campos try to invoke tap/target independently as described here
2
i
Is there something wrong here? I didn t understand
a
If you look at the second screenshot it seems to complain about a specific column
It seems to be some confusion between one side declaring it a string, and another a Decimal. In particular for a value 32.38
f
The problematic property stated there by @Alejandro A is freight, with that value 32.38, seems like it is defined as decimal in the source and string in the target-jsonl there.
i
I tried change type of freight to string, but it didn t work. What do to solve?
a
Does your target allow to define schema?
Also where did you exactly try to change freight to string?
i
I had changed real type to varying character (60)
a
Did it produce the same error?
Are you following some tutorial so I can try and reproduce this locally?
i
yep, the same error appears. I was following this tutorial https://docs.meltano.com/getting-started/
i followed this tutorial you sent too
a
Mmmm I can’t find any jsonl or mention to your target or the command you used
meltano --log-level=debug elt tap-postgres target-jsonl
d
@Iara Campos try to use one of the following number types for freight column: numeric, decimal, double, float