Hi Matt,
I am using Version: Nifi 1.0.0.
The data that I get from the getHttp request is the same as in the text
file. I just copied the content of the flowfile from the getHttp processor
to the text file.
What do you suggest i should do for the failure error?
The database that I use is MySql. There were a total of 14 flowfiles as the
input to the PutSQL processor. 7 went through and were successful. 7 are
still in the incoming connection and are not processed because of the error
i posted earlier. I know that the query itself is correct and there is no
issue with the syntax as these 7 files are the same as the first 7. Also I
copied the content and ran it directly in MySQL Workbench and data was
successfully loaded. As advised I changed the query to:
INSERT INTO periodic_group
(ISN,
AX,
AY)
VALUES
('200',
'19990801',
'19990831')
This resulted in the same error as before. It is only when i set the
property "Support Fragmented Transactions" to false that all records were
processed and successfully loaded.
So this issue was resolved.
Regards
Arsalan Siddiqi
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Replace-Text-for-updating-the-flow-file-content-tp13712p13767.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
