Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
veryimportantdude
Contributor III
Contributor III

tJavaRow if statement causes Error with tFileInputXml : Exceed the limit of 65535 bytes

I have the following question...

This error occures when I added one small if statement in my tJavarow component

The code that causes error:

//Code generated according to input schema and output schema

output_row.st = input_row.st;

output_row.izdelekID = input_row.izdelekID;

output_row.VendorItemNo_ = input_row.VendorItemNo_;

output_row.WarrantyCustomer = input_row.WarrantyCustomer;

output_row.izdelekIme = input_row.izdelekIme;

output_row.opis = input_row.opis;

output_row.url = input_row.url;

output_row.BRICK_ID = input_row.BRICK_ID;

output_row.UM = input_row.UM;

output_row.PRODUCER = input_row.PRODUCER;

output_row.BRAND_ID = input_row.BRAND_ID;

output_row.PRODUCER_ITEM_CODE = input_row.PRODUCER_ITEM_CODE;

output_row.WEEKS_OF_DELIVERY = input_row.WEEKS_OF_DELIVERY;

output_row.PACKAGING_TYPE = input_row.PACKAGING_TYPE;

output_row.PACKAGING_QTY = input_row.PACKAGING_QTY;

output_row.PACKAGING_QTY_UM = input_row.PACKAGING_QTY_UM;

output_row.dodatneLastnosti = input_row.dodatneLastnosti;

output_row.slikaVelika = input_row.slikaVelika;

output_row.dodatneSlike = input_row.dodatneSlike;

output_row.dodatnaSlika1 = input_row.dodatnaSlika1;

output_row.dodatnaSlika2 = input_row.dodatnaSlika2;

output_row.dodatnaSlika3 = input_row.dodatnaSlika3;

output_row.dodatnaSlika4 = input_row.dodatnaSlika4;

output_row.dodatnaSlika5 = input_row.dodatnaSlika5;

output_row.dodatnaSlika6 = input_row.dodatnaSlika6;

output_row.dodatnaSlika7 = input_row.dodatnaSlika7;

output_row.dodatnaSlika8 = input_row.dodatnaSlika8;

output_row.dodatnaSlika9 = input_row.dodatnaSlika9;

output_row.dodatnaSlika10 = input_row.dodatnaSlika10;

output_row.dodatnaSlika11 = input_row.dodatnaSlika11;

output_row.dodatnaSlika12 = input_row.dodatnaSlika12;

output_row.dodatnaSlika13 = input_row.dodatnaSlika13;

output_row.dodatnaSlika14 = input_row.dodatnaSlika14;

output_row.dodatnaSlika15 = input_row.dodatnaSlika15;

output_row.dodatnaSlika16 = input_row.dodatnaSlika16;

output_row.dodatnaSlika17 = input_row.dodatnaSlika17;

output_row.dodatnaSlika18 = input_row.dodatnaSlika18;

output_row.dodatnaSlika19 = input_row.dodatnaSlika19;

output_row.PPC = input_row.PPC;

output_row.cenaAkcijska = input_row.cenaAkcijska;

output_row.nabavnaCena = input_row.nabavnaCena;

output_row.DC = input_row.DC;

output_row.davcnaStopnja = input_row.davcnaStopnja;

output_row.kategorija = input_row.kategorija;

output_row.blagovnaZnamka = input_row.blagovnaZnamka;

output_row.skupinaIzdelka = input_row.skupinaIzdelka;

output_row.dobava = input_row.dobava;

output_row.zaloga = input_row.zaloga;

output_row.EAN = input_row.EAN;

output_row.brutoDolzina = input_row.brutoDolzina;

output_row.brutoSirina = input_row.brutoSirina;

output_row.brutoVisina = input_row.brutoVisina;

output_row.brutoTeza = input_row.brutoTeza;

/*Krajjšamo string za polje Ime izdelka*/

String ime_izdelka = input_row.izdelekIme;

String ime_izdelka2 = "N/P";

if(input_row.izdelekIme.length() > 40) {

String ime_izdelka_temp = input_row.izdelekIme.substring(0,40);

int sepPos = ime_izdelka_temp.lastIndexOf(" ");

  if (sepPos == -1) {

   ime_izdelka = input_row.izdelekIme.substring(0,35);

   ime_izdelka2 = input_row.izdelekIme.substring(35);

   }

else {

ime_izdelka = input_row.izdelekIme.substring(0,sepPos);

int sepPos2 = sepPos + 1;

   ime_izdelka2 = input_row.izdelekIme.substring(sepPos2);

}

}

globalMap.put("ime_izdelka",ime_izdelka);

globalMap.put("ime_izdelka2",ime_izdelka2);

/*Krajšamo ID izdelka, ostanek se ne piše nikamor*/

String izdelek_ID = input_row.izdelekID;

//String Izdelek_ID2 ="NP";

if (input_row.izdelekID.length() > 18) {

izdelek_ID = input_row.izdelekID.substring(0,18);

}

globalMap.put("izdelek_ID", izdelek_ID);

If I change the if statement to not check the int sepPos = ime_izdelka_temp.lastIndexOf(" ");

so I only leave

ime_izdelka = input_row.izdelekIme.substring(0,sepPos);

int sepPos2 = sepPos + 1;

   ime_izdelka2 = input_row.izdelekIme.substring(sepPos2);

I do not get the error.

Any ideas why this is happening.

Thank you

Labels (2)
1 Reply
gjeremy1617088143

Hi @none yebach​ , (great alias by the way 🙂 ) , does your subjob contain a lot of components ? cause java 65535 byte limit exception can be caused by too many components in a subjob.