Cloudera Community
mayank_rathi
user rank
New Member
My Accepted Solutions
Show All

PutSQL error: java.lang.String cannot be cast to ...

by New Member in Support Questions
‎09-04-2017 02:21 PM
‎09-04-2017 02:21 PM
Hello All, I am passing sql.args.1.type = 2005 and sql.args.1.value as a CLOB value to PutSQL and it is throwing below error. How do I resolve this error? 2017-09-04 10:17:24,924 INFO [StandardProcessScheduler Thread-5] o.a.n.c.s.TimerDrivenSchedulingAgent Scheduled PutSQL[id=69534f73-821e-1782-ffff-fffffabb94fb] to run with 1 threads 2017-09-04 10:17:25,009 ERROR [Timer-Driven Process Thread-4] o.apache.nifi.processors.standard.PutSQL PutSQL[id=69534f73-821e-1782-ffff-fffffabb94fb] org.apache.nifi.processors.standard.PutSQL$$Lambda$653/696434096@771333e failed to process due to org.apache.nifi.processor.exception.ProcessException: Failed to process StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1502123289026-125, container=default, section=125], offset=71441, length=39],offset=0,name=5936554321553480,size=39] due to java.lang.ClassCastException: java.lang.String cannot be cast to oracle.sql.CLOB; rolling back session: {} org.apache.nifi.processor.exception.ProcessException: Failed to process StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1502123289026-125, container=default, section=125], offset=71441, length=39],offset=0,name=5936554321553480,size=39] due to java.lang.ClassCastException: java.lang.String cannot be cast to oracle.sql.CLOB at org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnGroupError$14(ExceptionHandler.java:226) at org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnError$13(ExceptionHandler.java:179) at org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) at org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) at org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148) at org.apache.nifi.processors.standard.PutSQL.lambda$new$72(PutSQL.java:283) at org.apache.nifi.processors.standard.PutSQL.lambda$new$75(PutSQL.java:324) at org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91) at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:101) at org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$86(PutSQL.java:544) at org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114) at org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184) at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:544) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to oracle.sql.CLOB at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8874) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8396) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8980) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:242) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166) at org.apache.nifi.processors.standard.PutSQL.setParameter(PutSQL.java:888) at org.apache.nifi.processors.standard.PutSQL.setParameters(PutSQL.java:677) at org.apache.nifi.processors.standard.PutSQL.lambda$null$71(PutSQL.java:285) at org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:127) ... 19 common frames omitted ... View more
Labels:

Re: Hortonworks DataFlow platform: What's included...

by New Member in Support Questions
‎08-16-2017 10:51 PM
‎08-16-2017 10:51 PM
Sales team confirmed that Kafka Streams, Connect and MirrorMaker are supported in HDF. ... View more

Re: NiFi: Pivot: Columns to Rows

by New Member in Support Questions
‎08-10-2017 10:42 PM
‎08-10-2017 10:42 PM
Thanks Sonu ... View more

NiFi: Pivot: Columns to Rows

by New Member in Support Questions
‎08-10-2017 04:41 PM
‎08-10-2017 04:41 PM
Hello All, How can I pivot record based data from columns to rows. Here is an example of what I want to achieve: Input: A,B,C M,N,O Output: A,B A,C M,N M,O Thanks!! ... View more
Labels:

Re: How to send data stored in Kafka from beginnin...

by New Member in Support Questions
‎08-07-2017 06:34 PM
‎08-07-2017 06:34 PM
Thanks Bryan !! ... View more

How to send data stored in Kafka from beginning to...

by New Member in Support Questions
‎08-07-2017 01:55 PM
‎08-07-2017 01:55 PM
Hello All, How can I add a new NiFi consumer to a Kafka topic and send data from beginning? I do not see any setting in ConsumerKafkaRecord_0_10 processor to accomplish this. I am looking for functionality similar to --from-beginning parameter in Kafka Console Consumer. "./bin/kafka-console-consumer --zookeeper zk1:2181,zk2:2181,zk3:2181/kafka --topic LCL_LANG_DSTRBTN1 --from-beginning" Thanks!! ... View more
Labels:

Re: NiFi 1.4.0-SNAPSHOT build failing

by New Member in Support Questions
‎08-04-2017 10:15 PM
‎08-04-2017 10:15 PM
Thanks. It worked. ... View more

NiFi 1.4.0-SNAPSHOT build failing

by New Member in Support Questions
‎08-04-2017 08:42 PM
‎08-04-2017 08:42 PM
Hello All,I am trying to build NiFi 1.4.0-SNAPSHOT from Git and I am getting below error. Does anyone know how to resolve this error?Thanks in advance !! [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.18:test (default-test) on project nifi-grpc-processors: There are test failures. [ERROR] [ERROR] Please refer to /opt/nifi-master/nifi-nar-bundles/nifi-grpc-bundle/nifi-grpc-processors/target/surefire-reports for the individual test results. [ERROR] -> [Help 1] [ERROR] Running org.apache.nifi.processors.grpc.TestInvokeGRPC Tests run: 12, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 2.726 sec <<< FAILURE! - in org.apache.nifi.processors.grpc.TestInvokeGRPC testSecureOneWaySsl(org.apache.nifi.processors.grpc.TestInvokeGRPC) Time elapsed: 0.747 sec <<< ERROR! java.lang.IllegalArgumentException: Jetty ALPN/NPN has not been properly configured. at io.grpc.netty.GrpcSslContexts.selectApplicationProtocolConfig(GrpcSslContexts.java:174) at io.grpc.netty.GrpcSslContexts.configure(GrpcSslContexts.java:151) at io.grpc.netty.GrpcSslContexts.configure(GrpcSslContexts.java:139) at org.apache.nifi.processors.grpc.TestGRPCServer.start(TestGRPCServer.java:130) at org.apache.nifi.processors.grpc.TestInvokeGRPC.testSecureOneWaySsl(TestInvokeGRPC.java:464) testSecureTwoWaySsl(org.apache.nifi.processors.grpc.TestInvokeGRPC) Time elapsed: 0.018 sec <<< ERROR! java.lang.IllegalArgumentException: Jetty ALPN/NPN has not been properly configured. at io.grpc.netty.GrpcSslContexts.selectApplicationProtocolConfig(GrpcSslContexts.java:174) at io.grpc.netty.GrpcSslContexts.configure(GrpcSslContexts.java:151) at io.grpc.netty.GrpcSslContexts.configure(GrpcSslContexts.java:139) at org.apache.nifi.processors.grpc.TestGRPCServer.start(TestGRPCServer.java:130) at org.apache.nifi.processors.grpc.TestInvokeGRPC.testSecureTwoWaySsl(TestInvokeGRPC.java:420) ... View more
Labels:

Re: Hortonworks DataFlow platform: What's included...

by New Member in Support Questions
‎08-01-2017 05:13 PM
‎08-01-2017 05:13 PM
Kafka Streams, Connect and MirrorMaker are part of Apache Kafka and should be supported. Right? ... View more

Hortonworks DataFlow platform: What's included?

by New Member in Support Questions
‎08-01-2017 04:59 PM
‎08-01-2017 04:59 PM
Hello All, Does anyone know if HDF ( Hortonworks DataFlow ) platform includes MirrorMaker, Kafka Connect, Kafka Streams and Kafka Python API for Consumer and Producers? Thanks!! ... View more
Contact Me
Online
Offline
Last Visited
‎12-10-2018 12:40 PM
Community Statistics
Member Since ‎07-03-2017 12:08 AM
Last Visited ‎12-10-2018 12:40 PM
Posts 48
Kudos received 3