Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Insert in postgresql not correctly formatted

hello,
I receive the following message when inserting data from a tMap component to outputPostGreSql
L'élément du batch 0 INSERT INTO "nom"."formatmessage" ("entetemessage","nommessage","nb_param","sm_nomspecification") VALUES (8CF00400,Electronic Engine Controller 1,5,J1939) a été annulé. Appeler getNextException pour en connaître la cause.
disconnected
I've check on pgAdmin : pg would like something looking like :
INSERT INTO "nom"."variable"
("fm_entetemessage","nom","domainededefinition","unite","taillebrute","coefficient","offset")
VALUES ('8CF00400','engine retarder torque mode','dtEnum3Bit','',4,1.0,0)
I would even prefer if the 'taillebrute' '' would go NULL but that's no the most important.

Thanks
Labels (2)
11 Replies
Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

hi,
I have folder which consists of 10 csv files, now i want to delimit csv files one after the other iteratively
tfilelist(consists of csv files)----->tfileinpuydelimited
i've tried this but it is not working
thanks,
shashank