Hey folks, I believe there is an issue with the qu...
# ask-community-for-troubleshootingl
Lenin Mishra
05/29/2023, 7:11 AMHey folks, I believe there is an issue with the quickbooks connector. One of the fields for payments table in the Quickbooks connector is expecting a bigint, but the API is providing a float. Can the Airbyte team prioritise this?
Or can we create a PR fixing the data type in the json files?
Here is the error log for your reference.
Copy code
2023-05-28 12:10:34 INFO i.a.w.g.DefaultNormalizationWorker(run):97 - Normalization executed in 1 minute 41 seconds for job 6366.
2023-05-28 12:10:34 INFO i.a.w.g.DefaultNormalizationWorker(run):109 - Normalization summary: io.airbyte.config.NormalizationSummary@3ebf738b[startTime=1685275733084,endTime=1685275834419,failures=[io.airbyte.config.FailureReason@1bd36d8f[failureOrigin=normalization,failureType=system_error,internalMessage=invalid input syntax for type bigint: "2016649.0",externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@7b630e39[additionalProperties={attemptNumber=2, jobId=6366, from_trace_message=true}],stacktrace=AirbyteDbtError:
18 of 337 ERROR creating incremental model _airbyte_quickbooks_4037.payments_stg........................................ [ERROR in 0.83s]
Database Error in model payments_stg (models/generated/airbyte_incremental/quickbooks_4037/payments_stg.sql)
invalid input syntax for type bigint: "2016649.0"
Database Error in model payments_stg (models/generated/airbyte_incremental/quickbooks_4037/payments_stg.sql)
invalid input syntax for type bigint: "2016649.0",retryable=<null>,timestamp=1685275834418,additionalProperties={}], io.airbyte.config.FailureReason@194851f8[failureOrigin=normalization,failureType=system_error,internalMessage=invalid input syntax for type bigint: "2016649.0",externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@5c2e4a71[additionalProperties={attemptNumber=2, jobId=6366, from_trace_message=true}],stacktrace=AirbyteDbtError:
18 of 337 ERROR creating incremental model _airbyte_quickbooks_4037.payments_stg........................................ [ERROR in 0.83s]
Database Error in model payments_stg (models/generated/airbyte_incremental/quickbooks_4037/payments_stg.sql)
invalid input syntax for type bigint: "2016649.0"
Database Error in model payments_stg (models/generated/airbyte_incremental/quickbooks_4037/payments_stg.sql)
invalid input syntax for type bigint: "2016649.0",retryable=<null>,timestamp=1685275834418,additionalProperties={}]],additionalProperties={}]
2023-05-28 12:10:34 INFO i.a.c.i.LineGobbler(voidCall):149 -
2023-05-28 12:10:34 INFO i.a.w.t.TemporalAttemptExecution(get):163 - Stopping cancellation check scheduling...
2023-05-28 12:10:34 INFO i.a.c.i.LineGobbler(voidCall):149 - ----- END DEFAULT NORMALIZATION -----k
kapa.ai
05/29/2023, 7:11 AMA message from kapa.ai
kapa.ai
05/29/2023, 7:12 AMHmm, I don't know enough to give you a confident answer yet. However, you can refer to the [Airbyte documentation](https://docs.airbyte.com) for more information and guidance. If you'd like to contribute a fix, you can create a PR on the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte).