[ https://issues.apache.org/jira/browse/NIFI-5312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16538955#comment-16538955 ]
ASF GitHub Bot commented on NIFI-5312: -------------------------------------- Github user patricker commented on a diff in the pull request: https://github.com/apache/nifi/pull/2868#discussion_r201420130 --- Diff: nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/QueryDatabaseTable.java --- @@ -433,7 +434,7 @@ public void onTrigger(final ProcessContext context, final ProcessSessionFactory } finally { session.commit(); try { - // Update the state + // Check if we should, and then update the state --- End diff -- OK, try it now. > QueryDatabaseTable updates state when an SQLException is thrown > --------------------------------------------------------------- > > Key: NIFI-5312 > URL: https://issues.apache.org/jira/browse/NIFI-5312 > Project: Apache NiFi > Issue Type: Bug > Environment: Ubuntu 16.04 > Apache NiFi 1.5.0, 1.6.0 > IBM DB2 for Linux, UNIX and Windows 10.5.0.7, 10.5.0.8 (1) > IBM Data Server Driver for JDBC and SQLJ, JDBC 4.0 Driver (db2jcc4.jar) > 4.19.26 / v10.5 FP6, 4.19.72 / v10.5 FP9 (2) > Notes: > (1) SELECT * FROM SYSIBMADM.ENV_INST_INFO > (2) java -cp ./db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -version > Reporter: Marcio Sugar > Assignee: Peter Wicks > Priority: Major > > I noticed that when an SQLException is thrown, at least in the situationĀ > described by NIFI-4926, QueryDatabaseTable still updates the stateĀ of the > Maximum-value Columns. It means that when something goes wrong, a potentially > big number of rows will be skipped pretty much silently. (Well, it will > appear in the Bulletin Board, but when the message disappears from the > Bulletin Board there will be no indication of the problem left. The processor > has no "terminate relationship" other than "Success".) -- This message was sent by Atlassian JIRA (v7.6.3#76005)