Issue connecting to Oracle-HPSM using NIFI

["Kilaru, Naveen Kumar" <NA...@capitalone.com>]

Hi Apache-Nifi Dev Team,


We are validating NIFI for our business solution and while we do a POC e are facing a strange issue using "nifi-1.1.1.0"


We are trying to load the data from Oracle HPSM source system and we see below error message we are getting while we try to execute the flow.


Query used : select query SELECT * FROM SERVICEMANAGER.DEVICE2M1


Unable to execute SQL select query SELECT * FROM SERVICEMANAGER.DEVICE2M1 due to org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Unsupported feature. No incoming flow file to route to failure:

org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Unsupported feature

Please help us with this issue as we would like to use NIFI in our tech stack for current implementation.

Note: Same flow was executed successfully with the query  "select * from sample"

Thanks,
Naveen
7326667677
________________________________________________________

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

Re: Issue connecting to Oracle-HPSM using NIFI

[Bryan Bende <bb...@gmail.com>]

Naveen,

Can you check nifi_home/logs/nifi-app.log to see if there is a full stack
trace beyond the message that says "unsupported feature"?

Would be curious to see what the full stack trace looks like.

-Bryan


On Mon, Feb 22, 2016 at 2:26 PM, Kilaru, Naveen Kumar <
NAVEENKUMAR.Kilaru@capitalone.com> wrote:

>
> Hi Apache-Nifi Dev Team,
>
>
> We are validating NIFI for our business solution and while we do a POC e
> are facing a strange issue using "nifi-1.1.1.0"
>
>
> We are trying to load the data from Oracle HPSM source system and we see
> below error message we are getting while we try to execute the flow.
>
>
> Query used : select query SELECT * FROM SERVICEMANAGER.DEVICE2M1
>
>
> Unable to execute SQL select query SELECT * FROM SERVICEMANAGER.DEVICE2M1
> due to org.apache.nifi.processor.exception.ProcessException:
> java.sql.SQLException: Unsupported feature. No incoming flow file to route
> to failure:
>
> org.apache.nifi.processor.exception.ProcessException:
> java.sql.SQLException: Unsupported feature
>
> Please help us with this issue as we would like to use NIFI in our tech
> stack for current implementation.
>
> Note: Same flow was executed successfully with the query  "select * from
> sample"
>
> Thanks,
> Naveen
> 7326667677
> ________________________________________________________
>
> The information contained in this e-mail is confidential and/or
> proprietary to Capital One and/or its affiliates and may only be used
> solely in performance of work or services for Capital One. The information
> transmitted herewith is intended only for use by the individual or entity
> to which it is addressed. If the reader of this message is not the intended
> recipient, you are hereby notified that any review, retransmission,
> dissemination, distribution, copying or other use of, or taking of any
> action in reliance upon this information is strictly prohibited. If you
> have received this communication in error, please contact the sender and
> delete the material from your computer.
>