[NIFI-6775] "ExecuteSQL" Processor failed to convert Oracle Float type to Avro type.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: Core Framework
• Assignee: Unassigned
• Reporter: Atul
• Created: 14/Oct/19 10:08
• Updated: 05/Nov/19 21:53
• Resolved: 05/Nov/19 21:53

Description

Observed that "ExecuteSQL" process  failed to convert Oralce FLOAT datatype to Arvo type.Observed that "ExecuteSQL" process  failed to convert Oralce FLOAT datatype to Arvo type.Getting the error saying "Invalid decimal scale: -127 (must be positive); routing to failure: "

 

Here is the full stack trace :org.apache.nifi.processor.exception.ProcessException: java.lang.IllegalArgumentException: Invalid decimal scale: -127 (must be positive); routing to failure: org.apache.nifi.processor.exception.ProcessException: java.lang.IllegalArgumentException: Invalid decimal scale: -127 (must be positive)org.apache.nifi.processor.exception.ProcessException: java.lang.IllegalArgumentException: Invalid decimal scale: -127 (must be positive) at org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$1(AbstractExecuteSQL.java:273) at org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:2627) at org.apache.nifi.processors.standard.AbstractExecuteSQL.onTrigger(AbstractExecuteSQL.java:269) at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1162) at org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:209) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:117) at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Issue Links

• links to: GitHub Pull Request #3812