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]

Hi @Not defined Not defined​ , could you share picture of your job ,component used and schema of them ?

also when you try to import them have you specific message in the console ?

When you say you try to import, does carpark_id already exist.(do you update or insert or both ?)

Maybe you have to check autocommit in you dbconnection component advanced settings.

Send me love and kudos

[amba1]

hi @guenneguez jeremy​,

Here's a screenshot of the whole job to give you an idea of what I'm doing:

And here's a picture of the last tMap (tmap-5)

licenseplatekey if else: Relational.ISNULL(licenseplate.licenseplatekey)?

(Relational.ISNULL(row7.key)?-1:row7.key):licenseplate.licenseplatekey 

Schema of target table:

[gjeremy1617088143]

why you don't use tpostjob and tdbclose to close all your db connection ?

do you select auto commit on advanced settings of you tDBConnection component ?

the issue don't seem to be on the data but more on the database

also i see you have different db type for carpark id et licenceplate :

INT8 and INT4,maybe check your database tp see if you have the good db type

[amba1]

I do use it, had no place left for the screenshot sorry:

 

[gjeremy1617088143]

if for example you use a tdbinput and a query on your table , a select * for example, and you do guess schema have you the same DB type in the schema as your db output ?

[amba1]

The Schema seems to be the same as in the database:

When trying to get the schema with a tdbinput, i get the following error, database connection failed:

jdbc:postgresql://localhost:5432/USERNAME?"" does not work as string of connection, am i missing something?=

[gjeremy1617088143]

in your tDBOutput advanced settings you can select debug query mode and you can acces to the query with this variable :

((String)globalMap.get("tDBOutput_1_QUERY"))

it can be a good way to investigate

[gjeremy1617088143]

put an empty string "" on jdbc parameters

[amba1]

Database connection failed, but works when testing it from the metadata directly...