1973
Posts
1225
Kudos Received
124
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2453 | 04-03-2024 06:39 AM | |
| 3785 | 01-12-2024 08:19 AM | |
| 2049 | 12-07-2023 01:49 PM | |
| 3026 | 08-02-2023 07:30 AM | |
| 4149 | 03-29-2023 01:22 PM |
09-13-2023
05:48 AM
First backup your flows and settings. i don't think you can safely upgrade that many versions. Parameters, records, JSON format and so many other things have come. I would leave the old one running, backup all flows, run a new clean instance with JDK 11 or 17+ with NiFi 1.23.2 and see what is not working. https://www.datainmotion.dev/2020/06/no-more-spaghetti-flows.html See: https://community.cloudera.com/t5/Support-Questions/Nifi-Upgrade/m-p/346309#M234832
... View more
09-09-2023
09:39 AM
Can you upgrade to NiFi 1.23.2? If not, I would suggest opening a ticket with Cloudera. This maybe a bug. I would like to see full nifi logs though and which JDK you are. what language set? Did the source system change? https://support.oracle.com/knowledge/Oracle%20Cloud/2925617_1.html nothing in provenance, bulletins or nifi logs/? turn on debugging https://community.cloudera.com/t5/Community-Articles/NiFi-Debugging-Tutorial/ta-p/246082 perhaps a dump of the data, maybe some strange characters in there.
... View more
09-08-2023
04:25 AM
Could be sensitive column name? a typo somewhere.
... View more
09-08-2023
04:24 AM
Can you post full error, logs, the sql, table structure. What version of Oracle? Can you post your full NiFi settings. is it with all data, perhaps some nulls causing an issue. what is the settings for the Avro reader?
... View more
08-24-2023
07:22 AM
What database is that for, that is very weird SQL syntax, why are you making it JSON to convert to int? Trying upping the precision from 10 to 14. Default Decimal Precision
... View more
08-24-2023
06:41 AM
1 Kudo
I wonder if this was fixed 1.23.2. That seems like it shouldn't be too big, but it may be close. https://calcite.apache.org/docs/reference.html INTEGER, INT 4 byte signed integer Range is -2147483648 to 2147483647 try BIGINT
... View more
08-06-2023
06:07 PM
2 Kudos
You need to look at CDC tools like Cloudera Kafka Connect with Debezium or Cloudera SQL Streaming Builder with Debezium. Kafka Connect https://docs.cloudera.com/runtime/7.2.17/kafka-connect/topics/kafka-connect-connector-debezium-oracle.html SSB https://docs.cloudera.com/csa/1.10.0/how-to-ssb/topics/csa-ssb-cdc-connectors.html Or you can do Oracle GoldenGate with Kafka. I have some examples in this article https://medium.com/cloudera-inc/cdc-not-cat-data-capture-e43713879c03
... View more
08-02-2023
07:30 AM
1 Kudo
Under the cover this is just using Apache FTP Server Depends on passive ports https://mina.apache.org/ftpserver-project/configuration_passive_ports.html Send is over passive An example is here https://gist.github.com/tspannhw/43dbc81b1634a7acb61fada1a3c19a4e
... View more
06-06-2023
11:33 AM
1 Kudo
Check with your IBM documentation as this is not standard character sets that non-mainframe platforms deal with. You need this converted to UTF-8 or other modern formats. JMS_IBM_Character_Set: IBM424 JMS_IBM_Encoding: 785 Check with IBM support. If you can convert to Unicode before extracting https://www.ibm.com/docs/en/ibm-mq/7.5?topic=conversion-jms-client-message-encoding You may need another driver https://www.ibm.com/support/pages/apar/IT18078
... View more
04-19-2023
01:10 PM
3 Kudos
Cloudera DataFlow Connectors We would love to have you and your fellow colleagues attend this session. Please feel free to share this internally. We look forward to having you join us! Reading from Iceberg https://github.com/tspannhw/FLaNK-DataFlows/blob/main/jdbc/README.md Tip: if you have missing core-site / CDP Environmental settings then paste these in to deploy. /home/nifi/additional/secret/env_config/core-site.xml,/home/nifi/additional/secret/env_config/hive-site.xml,/home/nifi/additional/secret/env_config/ssl-client.xml May 12, 2023 Attend the Webinar . Rewatch on demand. Register for the Best in Flow Data Flow Sandbox Environment during the event or after via email you received when signing up. Work on the the tutorials to get familiar. Join my Zoom Sessions on May 4 @1pm EST, May 5 @ 9am EST, May 8 @11am EST, and May 9 @ 9am and more . I will start more on demand if there is need. Sign up for the slack group and post if you need help. Build your own flows and experiment. You can use one of the available data streams or bring your own public datasets. Submit your favorite two flows for the competition. Tutorials To Get You Started https://github.com/tspannhw/FLaNK-TravelAdvisory/blob/main/steps.md https://github.com/tspannhw/FLaNK-DataFlows/blob/main/finaltutorials/BestInFlowCompetitionTutorials03May2023.pdf https://github.com/tspannhw/FLaNK-DataFlows/blob/main/finaltutorials/CloudToolGuidance03May2023.pdf How to Start Video Additional Resources Best Practices Guide Meet the Committers Lab Prep Daily Zoom Guidelines Developer Home Page April 25, 2023 SF DataFlow Meetup Video ExamplesCloudera DataFlow Designer: The Key to Agile Data Pipeline Development Streaming Data Ingestion into an Open Data Lakehouse Made Easy with DataFlow Example Cloudera DataFlow Designer: Kafka to Iceberg in Cloudera Data Warehouse Serverless NiFi Flows with DataFlow Functions DataFlow Functions Technical Demo DataFlow Documentation https://www.slideshare.net/bunkertor/best-practices-for-workflow https://www.slideshare.net/bunkertor/meet-the-committers-webinar-lab-preparation https://www.slideshare.net/bunkertor/cloudera-sandbox-event-guidelines-for-workflow * https://www.datainmotion.dev/2023/05/best-in-flow-competition-tutorials-part.html * https://www.datainmotion.dev/2023/05/best-in-flow-competition-tutorials-part_2.html * https://www.datainmotion.dev/2023/05/best-in-flow-competition-tutorials-part_43.html * https://www.datainmotion.dev/2023/05/best-in-flow-competition-tutorials-part_45.html * https://github.com/tspannhw/FLaNK-DataFlows/tree/main/tutorials * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/BestInFlowCompetitionTutorials.epub * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/BestInFlowCompetitionTutorials.docx * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/BestInFlowCompetitionTutorials.zip * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/Cloud%20Tools%20Guidance.epub * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/Cloud%20Tools%20Guidance.pdf * https://github.com/tspannhw/FLaNK-DataFlows/blob/main/tutorials/Cloud%20Tools%20Guidance.zip https://www.datainmotion.dev/2023/05/cloud-tools-guidance-how-to-build-data.html https://www.datainmotion.dev/2023/05/cloud-tools-guidance-how-to-build-data_2.html https://www.datainmotion.dev/2023/05/cloud-tools-guidance-how-to-build-data_18.html https://www.datainmotion.dev/2023/05/best-in-flow-competition-bring-your-own.html https://www.datainmotion.dev/2023/05/best-in-flow-competition-streaming-data.html https://www.youtube.com/@nifinotes5127 Quick Tips DNS-based ad-blocker prevented some JavaScript from loading Use a Chrome Browser Turn off VPNs and ad-blockers Use a fast enough internet connection Login if you are idle for more than 15 minutes Stop, terminate and delete things once you aren't using them Download and document your flows Prefix your work with your userid like this tim_.
... View more
Labels: