https://linen.dev logo
Join Slack
Powered by
# ask-community-for-troubleshooting
  • y

    Yepher

    02/09/2023, 3:38 PM
    I see in GitHub issues there is "bounty" and "reward-100". What is that? Here is an example: https://github.com/airbytehq/airbyte/issues/20703
    a
    • 2
    • 1
  • p

    Pol Monsó

    02/09/2023, 3:52 PM
    Is using HTTPStream still the way to go to add a new connector for Odoo ? https://discuss.airbyte.io/t/odoo-xmlrpc-source-development/441
    n
    s
    • 3
    • 2
  • s

    Shraddha Borkar

    02/09/2023, 4:02 PM
    Hello All! I am using open source Airbyte on EKS and trying to set up a S3 destination. Getting below error
    Could not connect to the S3 bucket with the provided configuration. Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request ID: VEWP01YGPY0JMN6T; S3 Extended Request ID: +DLkF/GRo7Udb8jZR4QQUOEiXU9QzsYFFfmKsceaaoQeir9m5qsXk69uS/Ouv1oUQpPdyAo0iPU=; Proxy: null)
    I can see some connection test files getting created in the bucket. I have passed access and secret access key and applied below policy to the bucket
    Copy code
    Action = [
                "s3:ListBucket",
                "s3:GetObject",
                "s3:PutObject",
                "s3:PutObjectAcl",
                "s3:AbortMultipartUpload"
              ],
              Effect = "Allow"
    Could someone please help me understand the issue here? Thanks!
    m
    • 2
    • 4
  • k

    Kevin Phan

    02/09/2023, 4:06 PM
    hey yall, what is the downtime of upgrading a connector in airbyte? cc @John (Airbyte), are there any risks I should know of?
    n
    • 2
    • 2
  • m

    Masly Alexandra Velasquez Monsalve

    02/09/2023, 4:19 PM
    Hi everyone!. I’m trying to create a connection between salesforce and s3, i created the source and the destination succesfull but when i setup de connection i have the error “non-json-response”. See the next image. When i review the server logs i found an error related to internet connection but mi server have internet connection, my others connections are running correctly. Also there is a reference to the format destination, i try with json with and without compression and i have the same error. Someody can hepl me. i attach the server logs. Thank you very much!
    log airbyte.txt
    u
    • 2
    • 2
  • a

    Albert Segarra

    02/09/2023, 4:37 PM
    Connector upgrading is not working for me. It was working this morning with the same configuration 😕 I'm using Airbyte Open Source 0.40.32
    m
    • 2
    • 5
  • a

    AJ Floersch

    02/09/2023, 4:51 PM
    Has any one successfully synced a Jira <> Snowflake connection? I seem to continually hit this error on certain streams (such as _board_*).*
    Copy code
    Traceback (most recent call last):
      File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 111, in read
        yield from self._read_stream(
      File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 180, in _read_stream
        for record in record_iterator:
      File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 290, in _read_full_refresh
        for record_data_or_message in record_data_or_messages:
      File "/airbyte/integration_code/source_jira/streams.py", line 192, in read_records
        for board in super().read_records(**kwargs):
      File "/airbyte/integration_code/source_jira/streams.py", line 90, in read_records
        yield from super().read_records(**kwargs)
      File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 413, in read_records
        yield from self._read_pages(
      File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 430, in _read_pages
        yield from records_generator_fn(request, response, stream_state, stream_slice)
      File "/airbyte/integration_code/source_jira/streams.py", line 81, in parse_response
        yield self.transform(record=record, **kwargs)
      File "/airbyte/integration_code/source_jira/streams.py", line 197, in transform
        record["projectId"] = str(record["location"]["projectId"])
    KeyError: 'projectId'
    m
    n
    j
    • 4
    • 8
  • c

    Carolina Buckler

    02/09/2023, 4:55 PM
    Anyone successfully set up Pardot as a source? Getting this error
    Copy code
    requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: <https://pi.pardot.com/api/emailClick/version/4/do/query?format=json>
    2023-02-09 16:51:12 [44msource[0m > Finished syncing email_clicks
    2023-02-09 16:51:12 [44msource[0m > SourcePardot runtimes:
    Syncing stream email_clicks 0:00:00.061133
    2023-02-09 16:51:12 [44msource[0m > 400 Client Error: Bad Request for url: <https://pi.pardot.com/api/emailClick/version/4/do/query?format=json>
    Traceback (most recent call last):
      File "/airbyte/integration_code/main.py"
    m
    t
    u
    • 4
    • 11
  • g

    Gerard Clos

    02/09/2023, 5:00 PM
    hey there 👋 I'm deploying airbyte on k8s but worker fails to start with a StartContainerConfigError
    m
    b
    +4
    • 7
    • 11
  • m

    Manish Khatri

    02/09/2023, 5:09 PM
    Hi, I’ve just signed upto a 14 day trial but not all the connectors are there? The one I wanted to trial is https://docs.airbyte.com/integrations/sources/Commercetools but doesn’t show up in the dropdown. Any help from the airbyte team would be appreciated🔥
    m
    • 2
    • 3
  • g

    Gleber Baptistella

    02/09/2023, 5:56 PM
    Hi guys! How are you? • Airbyte version: 0.40.26 • Source Postgresql version: 1.0.43 • Destination S3 version: 0.3.189 I'm facing a problem to load a table from PostgreSQL to S3. The first load fails without getting all the data, however it updates the state and sends the data to S3 (around 40Gb). After that, the loads should be incremental according to the cursor field, but the ingestion fails without updating the state and without sending any data to S3. The error seems to be similar to this thread but we are not able to solve it. Could you help me? I can send the logs if it is necessary. Thank you very much!
    • 1
    • 1
  • a

    Alex Welch

    02/09/2023, 7:38 PM
    Is there a way to, within a stream, define the snowflake schema you would like the data written to? Taking that a step further, can you define a destination schema per table within the stream?
  • s

    Sanjay

    02/09/2023, 8:01 PM
    Hi All, I’m new to AirByte, have couple questions: 1. if we use AWS env., how to deploy AirByte for CDC? 2. Does AirByte support scaling when increase/decrease loads? 3. Can we tranform the CDC to some other format? 4. Does AirByte supports schema for CDC replication > 30MB?
  • r

    Renat Zubayrov

    02/09/2023, 8:16 PM
    Hey guys, can it be that when building a connector docker image on Mac and uploading it to docker hub I'm getting a wrong image architecture because I'm on M1 Mac?
    • 1
    • 5
  • z

    Zach Lynch

    02/09/2023, 8:37 PM
    Hey guys! Hope all is well 😁 Has a quick troubleshooting question about airbyte cloud I'm trying to sync Amplitude to Snowflake, and it was working properly until a couple days ago. Now it seems to be erroring out and giving this error message:
    Copy code
    2023-02-09 19:05:46 [32mINFO[m i.a.w.g.DefaultReplicationWorker(getReplicationOutput):407 - failures: [ {
      "failureOrigin" : "source",
      "failureType" : "system_error",
      "internalMessage" : "argument of type 'NoneType' is not iterable",
      "externalMessage" : "Something went wrong in the connector. See the logs for more details.",
      "metadata" : {
        "attemptNumber" : 1,
        "jobId" : 465,
        "from_trace_message" : true,
        "connector_command" : "read"
      },
    Airbyte version 0.40.20 Amplitude version 0.1.17 Snowflake version 0.4.40 On another note, I'm unable to update Amplitude to the current version, I just get a "Something went wrong.." error message Any help with this issue would be much appreciated 🙂
  • e

    Erry Kostala

    02/09/2023, 11:56 PM
    So I added a new thing to my source and i clicked the thing to reset, which was a terrible idea
    s
    • 2
    • 1
  • e

    Erry Kostala

    02/09/2023, 11:56 PM
    if i restore an RDS snapshot, please tell me there’s some way to also get airbyte to continue where it left off
  • j

    Jacob Roe

    02/10/2023, 1:59 AM
    Running into an issue with the datadog source. When we setup the source the connection tests runs fine however when we try to setup a connection it comes up with something has gone wrong on the page you would normally select your streams. We have tested this with locally run airbyte and on airbyte running on kube and get the same issue on both. Have also tried multiple destinations and have confirmed the destinations work with other sources. Any ideas?
    m
    s
    u
    • 4
    • 8
  • s

    shubham baldava

    02/10/2023, 6:38 AM
    Facing an issue to sync data from Mongodb connector : our collection looks like this :
    Copy code
    {
      order_placed_time: '2022-11-06T18:30:00.000Z',
      '': 'test',
      stateTransitionInfo: { ebndh1: { timestamp: 2022-11-07T10:07:22.648Z } },
      trackingId: 'OUZ3x9uF9keqdrqzTl5dTQ=='
    }
    There is an emtpy key in the collection document. The connector is not able to determine schema/catalogue with following error :
    Copy code
    com.mongodb.MongoCommandException: Command failed with error 40353 (Location40353): 'Invalid $project :: caused by :: FieldPath must not end with a '.'.' on server
    u
    a
    • 3
    • 2
  • j

    Jason Maddern

    02/10/2023, 6:52 AM
    I need to be able to manage 200+ Airbyte connectors. 150 all configured the same; 40 the same; and a few ad-hoc ones. I’ve been looking at custom scripting this using the Airbyte api, but I thought I’d best ask the experts 1. how should I do this? 2. Are there any useful scripts already out there in the community?
    u
    l
    u
    • 4
    • 10
  • j

    Jay Crawford

    02/10/2023, 6:56 AM
    Hi All. Setting up a NetSuite connection here. Auth is happening fine. User role was set up to spec in the documentation. But when Airbyte tries to load the schema for NetSuite I am getting “Error: non-json response”. The schema actually did resolve and display on screen once, but that was out of 15 attempts to connect. Ideas?
    r
    a
    +3
    • 6
    • 13
  • t

    Tmac Han

    02/10/2023, 7:52 AM
    Hi team, I wanna to ask a question: Can airbyte merge different table in one source database to one table of target destination while sync data?
    u
    • 2
    • 1
  • h

    Hans Lemm

    02/10/2023, 8:19 AM
    Hello team! How are you doing? I hope all is fine. We were deploying Airbyte OSS where I work and we would like to understand what are the S3/minio state variables used for (https://discuss.airbyte.io/t/what-are-the-state-storage-configuration-used-for/2415/2 - here it says it was deprecated, yet they still show up in the Helm Charts). Are they needed? Thanks.
    u
    • 2
    • 2
  • u

    user

    02/10/2023, 8:26 AM
    Hello Joel, usually you past the certificates and the connector will insert them into the certificateStore. Did you try to remove the \n or other chars? Sorry the delay to reply!
  • t

    Tmac Han

    02/10/2023, 8:55 AM
    Hi team, I wanna to ask a airbyte question: I want to use airbyte kafka source and I want to konw Spit to the binlog format of kafka, can the airbyte kafka source be parsed and read out?
    n
    • 2
    • 2
  • e

    Efim Matytsin

    02/10/2023, 9:03 AM
    Sorry guys, but can someone say how long do I have to wait code review? https://github.com/airbytehq/airbyte/pull/22469
  • j

    Jakub Wszolek

    02/10/2023, 9:20 AM
    Hey there, do you know how I can stop access to system tables in the Airbyte DB2 adapter? Our DB2 user only needs access to certain tables and shouldn't be able to see the system tables. Any help you can offer would be much appreciated. Thanks for your suggestions!
    n
    • 2
    • 1
  • s

    Shraddha Borkar

    02/10/2023, 9:39 AM
    Hello All! I am using open source Airbyte on EKS and currently adding connections using the UI. Is there a way of adding connections using code? Thanks!
    u
    • 2
    • 2
  • r

    Rob Lawrence

    02/10/2023, 9:55 AM
    Hello Airbyte community 😊 I am using Airbyte on EKS using a Helm chart and trying to connect to the API, As per the Airbyte Docs,
    Copy code
    When authenticating to the Configuration API, you must use Basic Authentication by setting the Authentication Header to Basic and base64 encoding the username and password (which are airbyte and password by default - so base64 encoding airbyte:password results in YWlyYnl0ZTpwYXNzd29yZA==). So the full header reads 'Authorization': "Basic YWlyYnl0ZTpwYXNzd29yZA=="
    However I am still getting forbidden responses, What am I missing? Thanks in advance, Rob
    n
    • 2
    • 1
  • d

    Dhanji Mahto

    02/10/2023, 12:09 PM
    Hi all, I am running command - ./gradlew airbyte integrationsconnectorsdestination &lt;name&gt;build to build my newely created destination connector but getting below error. Can any one help ?
    m
    • 2
    • 1
1...140141142...245Latest