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]

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

[MoodyEngineer14]

@TRF 

HI sir now i git this error

Starting job data_warehousing_facility_dimension at 23:49 02/07/2020.
[statistics] connecting to socket on port 3911
[statistics] connected
Data truncated for column 'facility_psgc' at row 73
[statistics] disconnected

Job data_warehousing_facility_dimension ended at 23:49 02/07/2020. [Exit code  = 0]

[MoodyEngineer14]

@TRF 

HI sir now i git this error

Starting job data_warehousing_facility_dimension at 23:49 02/07/2020.
[statistics] connecting to socket on port 3911
[statistics] connected
Data truncated for column 'facility_psgc' at row 73
[statistics] disconnected

Job data_warehousing_facility_dimension ended at 23:49 02/07/2020. [Exit code  = 0]

[TRF]

Share your job design

[TRF]

Share your job design

[MoodyEngineer14]

Hi Sir This is my Job Design is there something missing in it sir sorry i am new to talend so i dont know what is missing if theres any

[MoodyEngineer14]

Hi Sir This is my Job Design is there something missing in it sir sorry i am new to talend so i dont know what is missing if theres any