About joshua_adeleke

joshua_adeleke · ‎01-26-2017

Hi everyone, i was trying to insert into Oracle 12c DB and i got the error "cannot create PoolableConnectionFactory (ORA-28000: the account is locked)". I have tried to run the insert statement generated manually and it worked fine but NiFi gives the account is locked error. What could possibly the cause of this error?

joshua_adeleke · ‎01-11-2017

I used the fragment.index attribute to remove the headers and successfully loaded into Oracle DB. Thank you @Matt and @Matt Burgess.

joshua_adeleke · ‎01-11-2017

@Matt I have not found a way to remove the headers in the csv file.

joshua_adeleke · ‎01-10-2017

@Matt Please how do i extract the headers without using the SplitText processor?

joshua_adeleke · ‎01-10-2017

Hi @Matt Burgess, the first SQL statement is the issue. I see it's taking the headers in the csv file even though i skipped the headers with the header line count parameter in SplitText. 2017-01-10 12:07:13,538 ERROR [Timer-Driven Process Thread-40] o.apache.nifi.processors.standard.PutSQL PutSQL[id=79bf32ff-e154-1a02-b109-ebd298dfab2e] Failed to update database due to a failed batch update. There were a total of 1 FlowFiles that failed, 0 that succeeded, and 99 that were not execute and will be routed to retry;

joshua_adeleke · ‎01-10-2017

Hi @Matt, there is no OOME error in the NiFi app log. Also, the SplitText processor is able to successfully split the files but the issue seems to be at the PutSQL processor. I can see that although i asked that SplitText processor skip 2 lines in the header line count parameter, the insert statements into the PutSQL have the csv file headers as the values.

joshua_adeleke · ‎01-09-2017

I have a flow diagram that picks zipped csv files and loads into a table in Oracle 12c. This has been tested successfully for 20 records but when i try it with a larger csv file (over 40k records), i get an error message "Failed to update DB due to a failed batch update. There were a total of 1 flowfiles that failed, 0 that succeeded and 99 that were not executed and will be routed to retry;". I currently have the batch size set to 100 for the PutSQL processor. Is there any setting i am missing? GetSFTP---UnpackContent---SplitText---ExtractText---ReplaceText---PutSQL

joshua_adeleke · ‎12-30-2016

@Chris Nauroth Then there must be an issue if after 7 hours there is still no reduction in HDFS storage and it still keeps the /trash/finalized folder...

joshua_adeleke · ‎12-30-2016

@Chris Nauroth Hi, how soon does the normal block deletion start once the upgrade is finalized?

joshua_adeleke · ‎12-22-2016

@David Kjerrumgaard I found out the issue was with my csv file. It had to do with the column names i was ingesting in the csv file. Also, the turning the Obtain Generated Keys property to false worked as well in my case.

Online	Offline
Last Visited	‎10-22-2024 02:03 PM

Member Since	‎04-05-2016 10:11 AM
Last Visited	‎10-22-2024 02:03 PM
Posts	188
Kudos received	19

Cloudera Community

Re: Not able to create Oracle table using Big Data...

Re: Error: Oracle SQL Connector for HDFS

Re: Error while configuring AD usersync on HDP 2.4...

Re: NiFi Error:failed to update database due to fa...

Re: Hive error: java.io.EOFException: Unexpected e...

PutSQL error: ORA-28000: the account is locked

Re: Loading csv files into Oracle DB with NiFi

Re: Loading csv files into Oracle DB with NiFi

Re: Loading csv files into Oracle DB with NiFi

Re: Loading csv files into Oracle DB with NiFi

Re: Loading csv files into Oracle DB with NiFi

Loading csv files into Oracle DB with NiFi

Re: HDFS Space Consumption During Rolling Upgrade

Re: HDFS Space Consumption During Rolling Upgrade

Re: nifi -Ingesting a file from SFTP and insert i...