Hello everyone! I have a tap-oracle and target-postgres for replicate Oracle tables to Postgres. All tables in my pipeline work except one. The error received is

[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.485381Z [info     ]     for error in self.iter_errors(*args, **kwargs): cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.485816Z [info     ]   File "/opt/meltano/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/jsonschema/validators.py", line 384, in iter_errors cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.486245Z [info     ]     for error in errors:       cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.486608Z [info     ]   File "/opt/meltano/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/jsonschema/_keywords.py", line 296, in properties cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.486962Z [info     ]     yield from validator.descend( cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.487294Z [info     ]   File "/opt/meltano/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/jsonschema/validators.py", line 432, in descend cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.487576Z [info     ]     for error in errors:       cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.487897Z [info     ]   File "/opt/meltano/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/jsonschema/_keywords.py", line 188, in multipleOf cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.488199Z [info     ]     failed = instance % dB     cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr
[2025-02-18, 17:20:54 UTC] {{docker.py:438}} INFO - 2025-02-18T17:20:54.488474Z [info     ] decimal.InvalidOperation: [<class 'decimal.DivisionImpossible'>] cmd_type=loader name=target-postgres run_id=741fc8b3-a4ed-4289-9013-97e96c62b26d state_id=usu_vbiponto-to-postgres stdio=stderr

It reports a

decimal.InvalidOperation

, but in this table there are only columns of type text, int, number and timestamp. Has anyone experienced this situation and have any suggestions on how to fix it?

I think that's https://github.com/python-jsonschema/jsonschema/issues/701. Which variant of target-postgres are you using?

Thanks for the answer Edgar! About the version of

target-postgres

that I use is

meltanolabs-target-postgres

Do you know of any other version that doesn't have this problem?

You can turn off schema validation by setting

validate_records

to

False

for that target

It worked here! Thank you very much Edgar 🙌

Awesome!