[
https://issues.apache.org/jira/browse/NIFI-12014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17762010#comment-17762010
]
ASF subversion and git services commented on NIFI-12014:
--------------------------------------------------------
Commit 75cfe21e4c37cc4a7340e1a44d5a91fa2663889c in nifi's branch
refs/heads/main from krisztina-zsihovszki
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=75cfe21e4c ]
NIFI-12014 NullPointerException in PutSQL when adding error attributes
This closes #7666.
Signed-off-by: Peter Turcsanyi <[email protected]>
> NullPointerException in PutSQL when adding error attributes
> -----------------------------------------------------------
>
> Key: NIFI-12014
> URL: https://issues.apache.org/jira/browse/NIFI-12014
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.23.0, 1.23.1
> Reporter: Zsihovszki Krisztina
> Assignee: Zsihovszki Krisztina
> Priority: Major
> Attachments: PutSQL_-_Template.xml, testlog_putsql.log
>
>
> An issue was reported on NiFi developer mailing list about a
> NullPointerException which occurred in PutSQL. The error came when the error
> attributes were put to the flow files going to failure/retry relationships.
>
> {code:java}
> 2023-08-28 16:06:48,366 ERROR [Timer-Driven Process Thread-3]
> o.apache.nifi.processors.standard.PutSQL
> PutSQL[id=d9c76e5e-c708-3342-7592-f757fa0f3196] Failed to update database for
> StandardFlowFileRecord[uuid=f3504df1-a579-4805-b4a2-b566ccfd10ef,claim=StandardContentClaim
> [resourceClaim=StandardResourceClaim[id=1692950749660-1, container=default,
> section=1], offset=643,
> length=250],offset=0,name=b4bbe08f-c53b-4c50-a743-676446180061,size=250] due
> to java.sql.SQLDataException: The value of the sql.args.10.value is
> 'abc_user', which cannot be converted into the necessary data type; routing
> to failure
> java.sql.SQLDataException: The value of the sql.args.10.value is 'abc_user',
> which cannot be converted into the necessary data type
> at
> org.apache.nifi.util.db.JdbcCommon.setParameterAtIndex(JdbcCommon.java:731)
> at
> org.apache.nifi.util.db.JdbcCommon.setSensitiveParameters(JdbcCommon.java:704)
> at
> org.apache.nifi.util.db.JdbcCommon.setParameters(JdbcCommon.java:690)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$null$4(PutSQL.java:347)
> at
> org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:127)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$new$5(PutSQL.java:345)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$new$7(PutSQL.java:390)
> at
> org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91)
> at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:103)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$21(PutSQL.java:659)
> at
> org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:120)
> at
> org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184)
> at
> org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:659)
> at
> org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1360)
> at
> org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:246)
> at
> org.apache.nifi.controller.scheduling.AbstractTimeBasedSchedulingAgent.lambda$doScheduleOnce$0(AbstractTimeBasedSchedulingAgent.java:59)
> at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
> at
> java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:829)
> Caused by: java.lang.NumberFormatException: For input string: "abc_user"
> at
> java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.base/java.lang.Integer.parseInt(Integer.java:652)
> at java.base/java.lang.Integer.parseInt(Integer.java:770)
> at
> org.apache.nifi.util.db.JdbcCommon.setParameter(JdbcCommon.java:770)
> at
> org.apache.nifi.util.db.JdbcCommon.setParameterAtIndex(JdbcCommon.java:729)
> ... 22 common frames omitted
> 2023-08-28 16:06:48,393 ERROR [Timer-Driven Process Thread-3]
> o.apache.nifi.processors.standard.PutSQL
> PutSQL[id=d9c76e5e-c708-3342-7592-f757fa0f3196] Failed to execute due to
> java.lang.NullPointerException
> java.lang.NullPointerException: null
> at
> org.apache.nifi.processors.standard.PutSQL.addErrorAttributesToFlowFilesInGroup(PutSQL.java:497)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$onGroupError$12(PutSQL.java:490)
> at
> org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$0(ExceptionHandler.java:55)
> at
> org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$0(ExceptionHandler.java:54)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$onBatchUpdateError$15(PutSQL.java:573)
> at
> org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$0(ExceptionHandler.java:54)
> at
> org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$new$10(PutSQL.java:404)
> at
> org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:94)
> at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:103)
> at
> org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$21(PutSQL.java:659)
> at
> org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:120)
> at
> org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184)
> at
> org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:659)
> at
> org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1360)
> at
> org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:246)
> at
> org.apache.nifi.controller.scheduling.AbstractTimeBasedSchedulingAgent.lambda$doScheduleOnce$0(AbstractTimeBasedSchedulingAgent.java:59)
> at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
> at
> java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:829)
> 2023-08-28 16:06:48,394 ERROR [Timer-Driven Process Thread-3]
> o.apache.nifi.processors.standard.PutSQL
> PutSQL[id=d9c76e5e-c708-3342-7592-f757fa0f3196]
> org.apache.nifi.processors.standard.PutSQL$$Lambda$1653/0x0000000101649440@2e06e015
> failed to process due to java.lang.RuntimeException: Failed to execute due
> to java.lang.NullPointerException; rolling back session
> java.lang.RuntimeException: Failed to execute due to
> java.lang.NullPointerException
> at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:155)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
