Member since
01-23-2024
9
Posts
8
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
444 | 03-10-2024 06:13 AM |
07-06-2024
01:10 AM
2 Kudos
the above issue solved,. This idea is the picture will be sent through email , after we read and and convert to base64 String to we try to sent to oracle db by put sql process and insert statement , but we the received the following issues : java.sql.BatchUpdateException: ORA-01704: string literal too long Note : The type of picture filed is long raw
... View more
04-18-2024
04:02 AM
2 Kudos
@ALWOSABY Dog likes best wrote: is there way can Dashboard/monitor report which showing statistical report for running NIFI Template/process for example how many success/failure messages are processing and how many message in queue and ....etc. Thank you in advance. Hello, Yes, Apache NiFi provides several options for monitoring the status and performance of your data flows. Here are some ways you can create a dashboard or monitor reports for your running NiFi templates and processes: Reporting Tasks: NiFi includes Reporting Tasks that run in the background to provide statistical reports about what is happening in the NiFi instance. You can configure these in the UI by accessing the upper right dropdown, clicking on Controller Settings, and then selecting Reporting Tasks. Bulletin Board: The bulletin board in NiFi shows the latest ERROR and WARNING messages generated by NiFi processors in real-time. You can access the bulletin board from the right-hand dropdown menu and select the Bulletin Board option. It allows you to navigate to the actual processor by double-clicking the error. Data Provenance UI: To monitor events occurring on any specific processor or throughout NiFi, you can access the Data Provenance from the same menu as the bulletin board. This feature lets you filter events in the data provenance repository by various fields such as component name, type, etc. NiFi Summary UI: Apache NiFi summary can also be accessed from the same menu as the bulletin board. This UI contains information about all the components of that particular NiFi instance or cluster. They can be filtered by name, type, or URI. External Tools: There are also some external tools like MonitoFi that can be used to monitor Apache NiFi deployments on Azure, providing alerts and displaying health and performance information in dashboards. I hope the information may helps you.
... View more
04-01-2024
06:48 AM
1 Kudo
@ALWOSABY This looks related to the driver version you may be using in the processor. Perhaps trying a different driver version may resolve you issue. Perhaps try ojdbc6 version 11.1.0.7.0? Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped. Thank you, Matt
... View more
03-10-2024
06:13 AM
2 Kudos
we update the "JSON Handling Strategy" property to Nested into AttributesToJSON , then it's working . thank your for all
... View more
02-09-2024
04:31 AM
1 Kudo
The error you're encountering indicates that there's an issue with the syntax of your DDL (Data Definition Language) statement, specifically related to the SHOW VIEWS IN clause. Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement If you are trying to show the views in a particular database, the correct syntax would be: SHOW VIEWS IN your_database_name; Replace your_database_name with the actual name of the database you want to query. Ensure that there are no typos or extraneous characters in the statement. If you are not using a specific database and want to see all views in the current database, you can use: SHOW VIEWS; Double-check your SQL statement for correctness and make sure it adheres to the syntax rules of the database you are working with.
... View more
02-01-2024
06:38 AM
@ALWOSABY The putHDFS processor has properties for changing the Remote Owner and Remote Group, but in order to use these properties certain condition must be met: If you found any of the suggestions/solutions provided helped you with your issue, please take a moment to login and click "Accept as Solution" on one or more of them that helped. Thank you, Matt
... View more
01-26-2024
01:33 AM
2 Kudos
Hi @ALWOSABY , What is the value of the FF_Content? is it the entire JSON record ? if so - as it appears from the specified path - Why not use the EvaluateJsonPath to get whatever values that are needed and store as attributes by setting the Destination property to flowfile-attribute. See the following post to learn more: https://community.cloudera.com/t5/Support-Questions/How-to-handle-json-using-EvaluateJsonPath-processor-in-NiFi/m-p/295335 If that helps please accept solution. Thanks
... View more