Can someone please help me figure this error out f...
# replication-troubleshooting
i
Can someone please help me figure this error out for ZOHO connector - refresh token is correct
Copy code
2023-01-18 11:25:04 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/da20fe77-8a29-4276-9668-4d7e68c3140e/0/logs.log
2023-01-18 11:25:04 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.28
2023-01-18 11:25:04 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):172 - Attempt 0 to save workflow id for cancellation
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK -----
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-zoho-crm:0.1.0 exists...
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-zoho-crm:0.1.0 was found locally.
2023-01-18 11:25:04 INFO i.a.w.p.DockerProcessFactory(create):120 - Creating docker container = source-zoho-crm-check-da20fe77-8a29-4276-9668-4d7e68c3140e-0-jhenx with resources io.airbyte.config.ResourceRequirements@6740bbac[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=]
2023-01-18 11:25:04 INFO i.a.w.p.DockerProcessFactory(create):164 - Preparing command: docker run --rm --init -i -w /data/da20fe77-8a29-4276-9668-4d7e68c3140e/0 --log-driver none --name source-zoho-crm-check-da20fe77-8a29-4276-9668-4d7e68c3140e-0-jhenx --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e FIELD_SELECTION_WORKSPACES= -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e APPLY_FIELD_SELECTION=false -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-zoho-crm:0.1.0 -e AUTO_DETECT_SCHEMA=false -e AIRBYTE_VERSION=0.40.28 -e WORKER_JOB_ID=da20fe77-8a29-4276-9668-4d7e68c3140e airbyte/source-zoho-crm:0.1.0 check --config source_config.json
2023-01-18 11:25:04 INFO i.a.w.i.VersionedAirbyteStreamFactory(create):100 - Reading messages from protocol version 0.2.0
2023-01-18 11:25:07 ERROR i.a.w.i.DefaultAirbyteStreamFactory(internalLog):116 - Check failed
2023-01-18 11:25:07 INFO i.a.w.g.DefaultCheckConnectionWorker(run):110 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@6a6fef64[status=failed,message=Exception("Error while refreshing access token: 'access_token'")]
2023-01-18 11:25:07 INFO i.a.w.t.TemporalAttemptExecution(get):163 - Stopping cancellation check scheduling...
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 - 
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK -----
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 -
u
I'll take a look!
i
Thank you, I appreciate you, king!
do you have an update for me please? i am still getting this issue - i am happy to pay for this fix if anyone willing to resolve this ZOHO CRM issue 🙏
Exception("Error while refreshing access token: 'access_token'")
u
Sorry Ihsan I missed your replied. I checked the connector code and the current implementation doesn't return a meaningful error to you. I created the issue https://github.com/airbytehq/airbyte/issues/21849 I'll submit a fix at least to improve the error message
m
The PR improving the error message: https://github.com/airbytehq/airbyte/pull/21852
i
Thank you! I realized that from ZOHO we use ZOHO-BOOKS and NOT ZOHO-CRM. however, i see it is the same API but access to different scope of permission. Do you know anything about connecting this to ZOHO-BOOKS?
u
Not today, only Zoho CRM! There is a Github issue requesting the Zoho Book connector https://github.com/airbytehq/airbyte/issues/2585 no ETA so far.
j
@Marcos Marx (Airbyte) Has this issue been fixed, please? I'm running into the same error when I try to connect to Zoho CRM