I am new to Nifi.My requirement is to trigger Nifi process group using external scheduling tool called Control M. I tried using shell script to start and.stop the process group using curl command. Process group will fetch data from text file and writes into a database but unable to determine when the process group gets completed because I could see status like Started, Running and Stopped but not Completed state. Struck with this issue and need your valuable inputs on this of how to determine all the records got inserted into database placed inside process group.  ... View more

I am trying to load data from the below input to db.       My input is as shown below   i, John, $100   ii, Kevin, $150   iii, Steve, $200       Created getfile, ReplaceAttributes, Extracttext, Route to attributes, putsql flow       I have managed to parse fixed width file records and replaced with comma delimited values.  ExtractText processor with Enable Multiline Mode=true, Enable DOTALL Mode=true. After execution I see below in provenance event in attributes tab       line i   line.0 John   line.1 $100       Please advise how to load other two records which was not getting displayed in the attributes.  ... View more

I am using apache nifi to read csv file data and store the result in an Oracle Database. The dataflow i used in nifi is as follows:   GetFile ConvertRecord ( here just to convert csv to Json) ConvertJsonToSQL (just to convert Json to SQL INSERT query) UpdateAttribute (which formats CreateDate using the following format ${sql.args.5.value:toDate("dd-MMM-yy"):format("dd-MMM-yy")} PutSQL (to execute the insert statement created from previous flow)   Step 5 is where i encounter the error below and i've tried for a couple of resources online and it didn't help. I need some advice on how to properly configure and insert a data on a date column.   ERROR LOG    due to java.sql.SQLDataException: The value of the sql.args.5.value is '20-May-21', which cannot be converted to a timestamp; routing to failure: java.sql.SQLDataException: The value of the sql.args.5.value is '20-May-21', which cannot be converted to a timestamp DB Schema CreateDate DATE   UpdateAttribute Outgoing  Modified Data 20-May-21 Previous data 20-MAY-21   sql.args.39.type 93 sql.args.39.value 20-May-21   I tried removing update attribute and directly change the sql statement property using insert statement. That also didn't work. Encountered the same exception mentioned above. Please suggest with the solution   Insert into table(CreateDate,...)  Values ($CreateDate:toDate("dd-MMM-yy"):format("dd-MMM-yy") ... View more

I am trying to load csv file into oracle db using GetFile and PutDatabaseRecord processors using apache nifi   Able to read the csv file but unable to insert because of below error in the putdatabaserecord   Invalid conversion requested. Please help to resolve this issue ... View more