Hi Bilal,
Can you please provide the full stack trace from nifi-app.log and the flow/use case you faced this issue with? I will file a NIFI ticket with the provided info and will try to reproduce the issue and fix it asap. Or if it's more convenient for you, can create the ticket in https://issues.apache.org/jira with the collected info and you can assign it to me. Thank you and regards, Krisztina On Mon, Aug 21, 2023 at 3:01 PM Bilal Bektaş <[email protected]> wrote: > Hi Dev Team, > > NiFi environment was upgraded from 1.19.1 to 1.23.1. The following > situation has occurred with the PutSQL processor: > > > PutSQL[id=9187f6ec-8c1a-3358-8381-afe4b1cdacf8] Failed to execute due to > java.lang.NullPointerException: Cannot invoke "java.util.List.stream()" > because "flowFilesOnRelationship" is null: java.lang.NullPointerException: > Cannot invoke "java.util.List.stream()" because "flowFilesOnRelationship" > is null > > PutSQL[id=9187f6ec-8c1a-3358-8381-afe4b1cdacf8] Failed to update database > for FlowFile[filename=da19e35f4-f8e0-4c3a-9bc4-4330f7fc331226.xml] due to > The value of the sql.args.10.value is 'abc_user', which cannot be converted > into the necessary data type; routing to failure: > java.sql.SQLDataException: The value of the sql.args.10.value is > 'abc_user', which cannot be converted into the necessary data type > - Caused by: java.lang.NumberFormatException: For input string: "abc_user" > > > > Secondly, PutSQL penalizes All FlowFiles (contain wrong data type and > correct data type) in single transaction. I think this situation occurs, > after the following improvement on NiFi 1.21.0: > > "PutSQL should return error messages and error codes in an attribute" > https://issues.apache.org/jira/browse/NIFI-4651 > > Thirdly, This situation has been tested on different NiFi version. > > Briefly, PutSQL works correctly on NiFi 1.19.1 and 1.20.0 but NiFi 1.21.0, > 1.22.0, 1.23.0 and 1.23.1 gives the above error. Could you help in order > to resolve this situation? > > Thank you in advance, > > --Bilal > > > obase > TEL: +90216 527 30 00 > FAX: +90216 527 31 11 > [http://www.obase.com/images/signature/home.png]<http://www.obase.com> [ > http://www.obase.com/images/signature/facebook.png] < > https://www.facebook.com/obasesocial> [ > http://www.obase.com/images/signature/twitter.png] < > https://twitter.com/obasesocial> [ > http://www.obase.com/images/signature/linkedin.png] < > https://tr.linkedin.com/in/obase> > [http://www.obase.com/images/signature/obaselogo.png]<http://www.obase.com > > > > Bu elektronik posta ve onunla iletilen bütün dosyalar sadece göndericisi > tarafindan almasi amaclanan yetkili gercek ya da tüzel kisinin kullanimi > icindir. Eger söz konusu yetkili alici degilseniz bu elektronik postanin > icerigini aciklamaniz, kopyalamaniz, yönlendirmeniz ve kullanmaniz > kesinlikle yasaktir ve bu elektronik postayi derhal silmeniz gerekmektedir. > OBASE bu mesajin icerdigi bilgilerin dogrulugu veya eksiksiz oldugu > konusunda herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin ne > sekilde olursa olsun iceriginden, iletilmesinden, alinmasindan ve > saklanmasindan sorumlu degildir. Bu mesajdaki görüsler yalnizca gönderen > kisiye aittir ve OBASE görüslerini yansitmayabilir. > > Bu e-posta bilinen bütün bilgisayar virüslerine karsi taranmistir. > > This e-mail and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you are not the intended recipient you are hereby notified > that any dissemination, forwarding, copying or use of any of the > information is strictly prohibited, and the e-mail should immediately be > deleted. OBASE makes no warranty as to the accuracy or completeness of any > information contained in this message and hereby excludes any liability of > any kind for the information contained therein or for the information > transmission, recepxion, storage or use of such in any way whatsoever. The > opinions expressed in this message belong to sender alone and may not > necessarily reflect the opinions of OBASE. > > This e-mail has been scanned for all known computer viruses. >
