Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)
Super Guru

I have a Phoenix PutSQL that worked in the past, but not today. From the error box, not much help. Thought maybe Hbase or Phoenix was done. Turned out one field was missing. How to investigate this issue?

10337-error.png

Digging through the logs I quickly found it:

Caused by: java.sql.SQLException: ERROR 218 (23018): Constraint violation. DRONEDATA1.DATEKEY may not be null

That would be nice in the error listed in NiFi.

If something seems like an odd error, dig into the logs for more detailed descriptions.

Also the Summary Screen is pretty awesome and will let you find a lot of information for debugging and fixing problems.

10338-connectionsqueuesize.png

The Connections tab will let you sort by Queue Size and you can see if things are backed up.

10339-systemdiag1.png

If you click the system diagnostics link you will see two tabs of useful information. The first has memory usage and garbage collection.

10340-systemdiag2.png

The System tab has your usage for FlowFile and Content Repositories, processors and process load.

For more details, check out the following references.

Reference:

https://nifi.apache.org/docs/nifi-docs/html/developer-guide.html

https://nifi.apache.org/docs/nifi-docs/html/administration-guide.html#flowfile-repository

https://nifi.apache.org/docs.html

https://community.hortonworks.com/questions/71001/debugging-nifi-flow.html

https://community.hortonworks.com/questions/69004/nifi-monitoring-processor-and-nifi-service.html#an...

1,793 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 07:25 AM
Updated by:
 
Contributors
Top Kudoed Authors