About SAMSAL

SAMSAL · ‎08-07-2020

Hi, Im trying to utilize the rety relation of the PutSQL processor by redirecting it to the RetryFlowFile processor. However nothing seem to trigger this relationship. My understanding is that the retry is triggered when the DB could not be reached such as bad connection string, sql server is down...etc. but no matter what I do on the sql server to test this scenario, the retry is not triggered, instead an an exception is thrown (jdbc.SQLServerException) and the flowfile is pushed back to the queue and penalized! Here is what I did on my sql server express instance to test: - Disable the SQL Server service. - Changing the connection string in the JDBC connection pool service to be incorrect. - Taking the Database instance offline - Even blocking the target table by doing select inside transaction with wait time None of the above seem to trigger the Retry. The failure relation seem to be triggered by query error and is working fine. My question is why the Retry is not getting triggered and what condition triggers it? Thanks

SAMSAL · ‎08-07-2020

Thank you very much! After installing the proper java version the Groovy script started to work.

SAMSAL · ‎08-06-2020

OK, will try to install the required java version. My bad, I did not think that would cause the problem. Do I have to uninstall nifi and reinstall everything or just uninstalling\reinstalling java would suffice.? Thanks for your help

SAMSAL · ‎08-06-2020

Im using single instance. I just ran the "java -version" command, and here is what I have: java version "14.0.1" 2020-04-14 Java(TM) SE Runtime Environment (build 14.0.1+7) Java HotSpot(TM) 64-Bit Server VM (build 14.0.1+7, mixed mode, sharing)

SAMSAL · ‎08-06-2020

Thanks for attending to my ticket. Im using what I think the latest nifi version 1.11.4. Running on windows 10 for testing. I was using script similar to what is provided in (https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-1/ta-p/248922 ) which seems to be outdated because the scripting languages there doesnt match what I see in the latest version of Nifi. None the less when I try your script it still fails with the same error (other scripts engine like python works fine): ExecuteScript[id=c461682d-0173-1000-f3bb-1a7ace8e772d] ExecuteScript[id=c461682d-0173-1000-f3bb-1a7ace8e772d] failed to process session due to Could not initialize class org.codehaus.groovy.classgen.Verifier; Processor Administratively Yielded for 1 sec: java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.classgen.Verifier

SAMSAL · ‎08-06-2020

Anybody can help with this please? I cant progress without resolving this error which seems to be related to Nifi\groovy configuration that prevents me from running any kind of groovy script from nifi. Thanks

SAMSAL · ‎08-03-2020

Hi, Im new to Nifi and Groovy. I have been trying to run a groovy script using the ExecuteScript Processor but not matter what my groovy code is I keep getting the exception "Java.Lang.NoClassDefFoundError: Couldnot Initialize class groovy.lang.groovySystem" not sure why? I have installed the groovy sdk and set the environment variable PATH accordingly. Not sure what else I have to do? Thanks for your help.

SAMSAL · ‎07-31-2020

Thanks Bender for your help. I think your previous answer put me on the right path because I found that my issue was a combination of figuring out the correct encoding and bad formatting. My statement about other parser was inaccurate because even though the conversion to json happened without errors but some records were incorrect, so Kodos for Nifi for capturing the inconsistencies despite error message did not provide much info on which record\filed where inconsistencies happened. I'm still carious to know what the red dot that shows in the beginning of the text in the content viewer means since I did not see it with other contents.Can you elaborate on this? Also I would like to know what encoding values the "Character Set" in the CSV reader supports and I wish if that is listed in the CSV Reader manual (https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-record-serialization-services-nar/1.5.0/org.apache.nifi.csv.CSVReader/index.html) Thank you.

SAMSAL · ‎07-30-2020

Hi Bender, Thanks for the reply. I found a way to find the encoding and set it accordingly in the CSV reader character set field, that worked for some files but not other still getting errors that I dont get with other CSV parser online like (https://csvjson.com/csv2json). Is there a way I can upload the file for you to check? I cant go back to the vendor and tell them there is a formatting issue if it works fine with other parsers. Thanks

SAMSAL · ‎07-29-2020

Hi, Im new to Nifi. Im trying to parse csv records with the SplitRecord Processor utilizing the CSVReader controller service, however Im getting IllegalArgumentException an exception on the file despite the CSV seems to be well formatted and Im able to parse\read through other means. Im getting the file through the GetFile processor and when I view the content from the queue I notice a red dot (see screenshot) in the beginning which seems to indicate invalid character but when I open the file in a text editor I dont see anything abnormal. This file is coming from a third party and it would be hard to change. When I copy the content and place it into other file and save, the new file works! Can someone help please to find what is causing the issue and how to fix? Thanks

Online	Offline
Last Visited	‎12-21-2024 07:10 AM

Member Since	‎07-29-2020 02:31 PM
Last Visited	‎12-21-2024 07:10 AM
Posts	574
Kudos received	319

Cloudera Community

Re: CSVReader and CSVRecordSetWriter doesn't consi...

Re: Jolt spec to flatten the nested JSON

Re: CSVReader and CSVRecordSetWriter doesn't consi...

Re: Converting Nested JSON to Flat JSON using JOLT

Re: NIfi: javax.security.auth.login.LoginExceptio...

PUTSQL Retry Relation is not triggered

Re: ExecuteScrip Groovy ClassNotFound Exception

Re: ExecuteScrip Groovy ClassNotFound Exception

Re: ExecuteScrip Groovy ClassNotFound Exception

Re: ExecuteScrip Groovy ClassNotFound Exception

Re: ExecuteScrip Groovy ClassNotFound Exception

ExecuteScrip Groovy ClassNotFound Exception

Re: Illegal Arg Exception when parsing CSV file t...

Re: Illegal Arg Exception when parsing CSV file t...

Illegal Arg Exception when parsing CSV file thoug...