Source ZohoCRM: fails to connect

Connector Questions & Issues
, ,
1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Ubuntu
  • Memory / Disk: you can use something like 8 GB
  • Deployment: Docker
  • Airbyte Version: 0.40.0 alpha
  • Source name/version: ZohoCRM 0.1.0
  • Destination name/version: Snowflake 0.4.34
  • Step: Sync
  • Description: After passing the connection creation, the sync fails with the following error:

Failure Origin: source, Message: Something went wrong within the source connector2022-08-10 15:53:14 - Additional Failure Information: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped!

2

Hi @mijbel, thanks for your post! Could you share the full sync logs for the failed sync? The source cannot be stopped is a fairly generic log error so we need more context.

3

Hi @sajarin … sorry for the delay I missed your reply. I’ve attached the sync logs here.
logs-175.txt (293.2 KB)

4

Hi @mljbel, thanks for posting the logs. I will try to see if I can duplicate the issue and report back with any findings. Seems like one of the streams is broken or isn’t working but I will try to see if I can replicate it on my end. Thanks for making this post!

5

Hi @sajarin … any luck duplicating the issue?

6

Hello Mijbel I created the issue https://github.com/airbytehq/airbyte/issues/17098

I found the error when Zoho try to convert a datetime.

2022-08-21 08:19:19 e[44msourcee[0m > Invalid isoformat string: '2022-07-01T00:00:00Z'Traceback (most recent call last): File "/airbyte/integration_code/main.py", line 13, in <module> launch(source, sys.argv[1:]) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 127, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 118, in run for message in generator: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 123, in read raise e File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 119, in read internal_config=internal_config, File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 159, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 248, in _read_full_refresh for record in records: File "/airbyte/integration_code/source_zoho_crm/streams.py", line 88, in read_records for record in super().read_records(*args, **kwargs): File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 353, in read_records stream_state=stream_state, stream_slice=stream_slice, next_page_token=next_page_token File "/airbyte/integration_code/source_zoho_crm/streams.py", line 100, in request_headers last_modified_dt = datetime.datetime.fromisoformat(last_modified)ValueError: Invalid isoformat string: '2022-07-01T00:00:00Z'

A workaround for now it is to use only full refresh sync mode.

7

Thanks Marcos. FYI I’m using full refresh-overwrite when getting the error.