Database values are not imported but are visible in logrow

[amba1]

Hi everyone,

I have a strange issue here.

Basically I retrieve data from some files and import them in a database.

In my database I have a a table with a column called licenseplatekey. If no match is found, the value is set to -1.

When testing my job with a tlogrow, everything works perfectly, as you can see in the screenshot:

 

But when I import the data in my database, none of the data for the licenseplatekey column is imported. Each row just contains a NULL

All other columns are imported normally...

 

I also tried outputting the data in a csv files and it works as well.

Does anyone know what I might be doing wrong here?

Thanks!

[gjeremy1617088143]

just try to force the jdbc parameter with empty string "", in your tdbconnection component : additionnal jdbc parameters : ""

[amba1]

Tried the empty strings as well, unfortunately no success. The error message under Details is "Schema not present in Database".

The schema is indeed present...

[amba1]

Managed to make it work.

The schema is exactly the same as the one I use as output

[gjeremy1617088143]

do you try my suggest for debugging query ?

[amba1 · Accepted solution]

@guenneguez jeremy​ I was able to find the issue!

The licenseplatekey is a column that i added with an alter table after the table was created. I use a function to partition the tables and forgot to update the function with the new column. It is now working! Thanks for your help 🙂