Hello Folks, I am facing a issue with tap-recharge...
# troubleshooting
m
Hello Folks, I am facing a issue with tap-recharge order pipeline and using target-redshift. Error-
TypeError: Parser must be a string or character stream, not NoneType
This is the main error log ``` CRITICAL Parser must be a string or character stream, not NoneType cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191041Z [info ] Traceback (most recent call last): cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191237Z [info ] File "/home/ubuntu/rm-projects/meltano-projects/.meltano/extractors/recharge-orders/venv/bin/tap-recharge", line 8, in <module> cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191405Z [info ] sys.exit(main()) cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191565Z [info ] File "/home/ubuntu/rm-projects/meltano-projects//.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/singer/utils.py", line 230, in wrapped cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191738Z [info ] return fnc(*args, **kwargs) cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.191897Z [info ] File "/home/ubuntu/rm-projects/meltano-projects/dev-/.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/tap_recharge/__init__.py", line 44, in main cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192069Z [info ] sync( cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192224Z [info ] File "/home/ubuntu/rm-projects/meltano-projects/.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/tap_recharge/sync.py", line 35, in sync cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192375Z [info ] state = stream_obj.sync( cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192525Z [info ] File "/home/ubuntu/rm-projects/meltano-projects//.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/tap_recharge/streams.py", line 138, in sync cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192674Z [info ] record_datetime = utils.strptime_to_utc(transformed_record[self.replication_key]) cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192829Z [info ] File "/home/ubuntu/rm-projects/meltano-projects/.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/singer/utils.py", line 61, in strptime_to_utc cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.192981Z [info ] d_object = dateutil.parser.parse(dtimestr) cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.193141Z [info ] File "/home/ubuntu/rm-projects/meltano-projects/.meltano/extractors/recharge-orders/venv/lib/python3.8/site-packages/dateutil/parser/_parser.py", line 1368, in parse cmd_type=extractor job_id=recharge-orders name=recharge-orders run_id=002f75b7-660c-497b-83ed-6007b3a45c79 stdio=stderr 2022-03-11T114113.193293Z [info ] return DEFAULTPARSER.parse(timestr, **kwargs) c…
p
Hey @monika_rajput it looks like someone submitted an issue to the tap's repo around something that looks similar. https://github.com/singer-io/tap-recharge/issues/20
Oh I thought this looked familiar! This was a response I sent earlier https://meltano.slack.com/archives/C01TCRBBJD7/p1646245043180319?thread_ts=1646168474.850749&amp;cid=C01TCRBBJD7 related to this. Did you have any luck debugging with that info? You can also try commenting on that issue to see if there are work arounds or how others have resolved it
m
@pat_nadolny This issue was submitted in 2021 but as i remember i was successfully ran the pipeline and the data was also loaded into the database. We are facing this issue after applying the
replication_key
to the pipeline so i think we are getting `replication_key`(updated_at) as
"null"
and i think that's causing this error. As you also mentioned in earlier thread. And Thank you so much for the response. @pat_nadolny