Attempting to launch my first Amazon Selling Partn...
# replication-troubleshooting
n
Attempting to launch my first Amazon Selling Partner > Postgres sync. I'm failing w/ a normalization error. How do see which record it's failing on or find `get_merchant_listings_all_data.sql`:
Copy code
2022-11-14 15:23:23 INFO i.a.w.g.DefaultNormalizationWorker(run):93 - Normalization executed in 13 seconds.
2022-11-14 15:23:23 ERROR i.a.w.g.DefaultNormalizationWorker(run):101 - Normalization Failed.
2022-11-14 15:23:23 INFO i.a.w.g.DefaultNormalizationWorker(run):106 - Normalization summary: io.airbyte.config.NormalizationSummary@68a2f518[startTime=1668439390337,endTime=1668439403632,failures=[io.airbyte.config.FailureReason@fba5e53[failureOrigin=normalization,failureType=system_error,internalMessage=invalid input syntax for type double precision: "",externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@15c237d4[additionalProperties={attemptNumber=0, jobId=3, from_trace_message=true}],stacktrace=AirbyteDbtError: 
1 of 1 ERROR creating table model temp_workspace.get_merchant_listings_all_data......................................... [ERROR in 0.16s]
Database Error in model get_merchant_listings_all_data (models/generated/airbyte_tables/temp_workspace/get_merchant_listings_all_data.sql)
  invalid input syntax for type double precision: ""
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/temp_workspace/get_merchant_listings_all_data.sql
It's importing JSON into a temp table, but won't move from there.
Ok found it. Source data from Amazon has
"quantity": ""
I need that to read as 0
I actually would just want "" as NULL
so i'm guessing I can't use the standard normalization?
u
Hello Nick Saroki, it's been a while without an update from us. Are you still having problems or did you find a solution?
n
Oh I gave up
s
Hey @Nick Saroki, sorry to hear that, This might be something that was fixed with the latest version of the connector. Otherwise, we can turn this into a github issue so that the issue can be properly added to the backlog.