topic t_map java.lang.ArrayIndexOutOfBoundsException in Talend Studio

t_map java.lang.ArrayIndexOutOfBoundsException

Anonymous — Sat, 24 Nov 2018 08:07:27 GMT

I 'm using three t_map to lookup from three different postgres tables and than insert into one postgres table .

But I'm getting the error below :

Exception in component tMap_3 (Load_DimSong)
java.lang.ArrayIndexOutOfBoundsException: 1
at decisionalproject.load_dimsong_0_1.Load_DimSong.tDBInput_3Process(Load_DimSong.java:3293)
at decisionalproject.load_dimsong_0_1.Load_DimSong.runJobInTOS(Load_DimSong.java:6365)
at decisionalproject.load_dimsong_0_1.Load_DimSong.main(Load_DimSong.java:6214) .

DB Version : v9.X

This is my job Load_DimSong.

Thank you .

Re: t_map java.lang.ArrayIndexOutOfBoundsException

TRF — Sat, 24 Nov 2018 11:19:48 GMT

So, what in tMap_3 ?

Re: t_map java.lang.ArrayIndexOutOfBoundsException

Anonymous — Sat, 24 Nov 2018 11:29:16 GMT

this is what in tmap3 :

Re: t_map java.lang.ArrayIndexOutOfBoundsException

TRF — Sun, 25 Nov 2018 18:00:49 GMT

The expressions for local variables are not visible.

Do we have to guess them?

Re: t_map java.lang.ArrayIndexOutOfBoundsException

Anonymous — Sun, 25 Nov 2018 18:10:20 GMT

I'm sorry .

my date_release is in this format yyyy-mm-jj
and I want to extract month , year and month+year from this date .
here are my expressions :
lookup_release_dates_album.date_release.split("-")[0] for variable dateYear
lookup_release_dates_album.date_release.split("-")[1] for variable dateMonth
lookup_release_dates_album.date_release.split("-")[0] +lookup_release_dates_album.date_release.split("-")[1] for variable datemonthYear.

Re: t_map java.lang.ArrayIndexOutOfBoundsException

TRF — Sun, 25 Nov 2018 18:17:49 GMT

Is lookup_release_dates_album.date_release allways populated?

I suggest you to transform the expression like this in case of:

lookup_release_dates_album.date_release != null ? lookup_release_dates_album.date_release.split("-")[1] : null

You may also refer to this link for a technic to avoid multiple calls to the String.split() method

https://community.talend.com/t5/Design-and-Development/extract-fullname-to-firstname-and-middlename-and-lastname/m-p/142507#M88000

Re: t_map java.lang.ArrayIndexOutOfBoundsException

TRF — Sun, 25 Nov 2018 18:18:10 GMT

Is lookup_release_dates_album.date_release allways populated?

I suggest you to transform the expression like this in case of:

lookup_release_dates_album.date_release != null ? lookup_release_dates_album.date_release.split("-")[1] : null

You may also refer to this link for a technic to avoid multiple calls to the String.split() method

https://community.talend.com/t5/Design-and-Development/extract-fullname-to-firstname-and-middlename-and-lastname/m-p/142507#M88000

Re: t_map java.lang.ArrayIndexOutOfBoundsException

Anonymous — Mon, 26 Nov 2018 10:02:42 GMT

Thank you so much !

I also added a condition song.date_release.length()>4 when I want to extract the month because sometimes the date comes with this format YYYY so my condition becomes :

(song.date_release!=null &&
song.date_release.length()>4 )?
song.date_release.split("-")[1]:null

Thank you again ! you helped me a lot .

I 'll try to change my splitted strings in the same way in the link u provided me with .

Re: t_map java.lang.ArrayIndexOutOfBoundsException

TRF — Tue, 27 Nov 2018 08:53:36 GMT

Thank's to mark your cas as solved.