Hello, has anyone ran into a NoneType error when u...
# troubleshootingc
connor_flynn
02/18/2022, 4:11 PMHello, has anyone ran into a NoneType error when using DDL files to create tables in a Postgres database.
However when we do not create the tables with DDLs before running the meltano pipeline, there seems to be no error.
Thank you in advance!
connor_flynn
02/18/2022, 4:12 PM@jo_pearson @edward_ryan
a
aaronsteers
02/18/2022, 9:46 PMI'm not following the context regarding DDL files. Sounds like it is possibly a bug in the target postgres loader. "NoneType" generically indicates that where a value was expected, none was available. Could be caused by missing columns or unreadable/unparseable column types and/or primary keys.
aaronsteers
02/18/2022, 9:47 PMIt would make some sense that it does not occur without custom DDL, since in that case the target takes full responsibility for creating its own target tables.
c
connor_flynn
02/18/2022, 10:00 PMThank you @aaronsteers! We will definitely look into the column types and primary keys!
a
aaronsteers
02/18/2022, 10:03 PMHappy to help! And if still nothing pops out as problematic, one option for next step would be to see if you can isolate the issue to one table and one DDL, then posting an issue (along with full log output) to the github repo for that specific target.
aaronsteers
02/18/2022, 10:04 PM(If you do log an issue, please also share a link here so we can review and chime in.)
aaronsteers
02/18/2022, 10:05 PMGood luck!
c
connor_flynn
02/18/2022, 10:05 PMThank you!