[
https://issues.apache.org/jira/browse/NIFI-6775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16951723#comment-16951723
]
Amol Dixit commented on NIFI-6775:
----------------------------------
Support for Oracle Float type in Avro much needed... Is any fix available?
> "ExecuteSQL" Processor failed to convert Oracle Float type to Avro type.
> ------------------------------------------------------------------------
>
> Key: NIFI-6775
> URL: https://issues.apache.org/jira/browse/NIFI-6775
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.9.2
> Reporter: Atul
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
