Exception in component tMap_1 (data_warehousing_facility_dimension) java.lang.StringIndexOutOfBoundsException: String index out of range: 11

[MoodyEngineer14]

HI i am new to talend i am currently trying to integrate a database to database integration of data and i am stuck on this error

[statistics] connecting to socket on port 4062
[statistics] connected
Exception in component tMap_1 (data_warehousing_facility_dimension)
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(Unknown Source)
	at data_integration.data_warehousing_facility_dimension_0_1.data_warehousing_facility_dimension.tDBInput_1Process(data_warehousing_facility_dimension.java:4686)
	at data_integration.data_warehousing_facility_dimension_0_1.data_warehousing_facility_dimension.runJobInTOS(data_warehousing_facility_dimension.java:6064)
	at data_integration.data_warehousing_facility_dimension_0_1.data_warehousing_facility_dimension.main(data_warehousing_facility_dimension.java:5912)
[statistics] disconnected

Job data_warehousing_facility_dimension ended at 17:34 02/07/2020. [Exit code  = 1]

what seems to be the issue here?

and this is my tmap expression setting

[TRF]

Can you share the complete expression for field facilty_psgc. It seems you're trying to access a string position which is greater than the string length

[TRF]

Can you share the complete expression for field facilty_psgc. It seems you're trying to access a string position which is greater than the string length

[MoodyEngineer14]

@TRF 

Hi sir this is the only thing in the expression

[MoodyEngineer14]

@TRF 

Hi sir this is the only thing in the expression

[MoodyEngineer14]

i've tried putting this code row1,glocation .substring(0,11) but it doesnt work

[MoodyEngineer14]

i've tried putting this code row1,glocation .substring(0,11) but it doesnt work

[TRF]

Has changed since the previous capture

[TRF]

Has changed since the previous capture

[TRF]

Use StringHandling.LEFT(row1,glocation, 11).
If length of row1,glocation is greater than 11, it return the 11 first char, else it returns row1,glocation