DynamoDB Error "com.amazonaws.services.dynamodbv2.document.TableWriteItems.getItemsToPut()" is null

Hi All, I’m new to Airbyte and was pointed here from their Slack channel. I’m trying to setup a MSSQL to DynamoDB connection. I have the source and destination setup successfully but when I try to sync I get this error:

2022-05-05 17:51:32 destination > 2022-05-05 17:51:32 INFO i.a.i.d.d.DynamodbWriter(close):161 - Data writing completed for DynamoDB.
2022-05-05 17:51:32 destination > 2022-05-05 17:51:32 ERROR i.a.i.d.d.DynamodbWriter(close):159 - Cannot invoke "java.util.Collection.size()" because the return value of "com.amazonaws.services.dynamodbv2.document.TableWriteItems.getItemsToPut()" is null

Can someone point me in the best direction to resolve?
Thanks!

  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Windows
  • Memory / Disk: 16GB /1TB
  • Deployment: Docker
  • Airbyte Version: Latest
  • Source name/version: MS SQL
  • Destination name/version: Dynamo DB
  • Step: The issue is happening during sync, creating the connection or a new source? During Sync
  • Description: Above

Hello Kyle, can you update the template with your env values and share the complete log to read the complete error stacktrace?

Log file is attached, I’m not sure what you mean by en values?

logs-16.txt (391.6 KB)

Change values in this file: https://github.com/airbytehq/airbyte/blob/master/.env

Looks you’re trying to sync some functions from MSSQL, could you disable it and test again?

2022-05-06 16:59:46 e[44msourcee[0m > java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Parameters were not supplied for the function 'dbo.ufnGetContactInformation'.2022-05-06 16:59:46 e[44msourcee[0m > Exception in thread "main" java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Parameters were not supplied for the function 'dbo.ufnGetContactInformation'.