Zsihovszki Krisztina created NIFI-12014:
-------------------------------------------
Summary: 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.1, 1.23.0
Reporter: Zsihovszki Krisztina
Assignee: Zsihovszki Krisztina
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.
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)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
