https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246599#M32071 <P><A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;</P> <P>HI sir now i git this error</P> <PRE>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]</PRE> <P>&nbsp;</P> Thu, 02 Jul 2020 16:52:48 GMT MoodyEngineer14 2020-07-02T16:52:48Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246587#M32059 <P>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</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>[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]</PRE> <P>what seems to be the issue here?</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>and this is my tmap expression setting</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaOl.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130044i8775D3101AA685AC/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaOl.png" alt="0683p000009MaOl.png" /></span></SPAN></P> Sat, 16 Nov 2024 01:59:34 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246587#M32059 MoodyEngineer14 2024-11-16T01:59:34Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246588#M32060 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 Thu, 02 Jul 2020 12:18:31 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246588#M32060 TRF 2020-07-02T12:18:31Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246589#M32061 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 Thu, 02 Jul 2020 12:18:31 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246589#M32061 TRF 2020-07-02T12:18:31Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246590#M32062 <P><A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;</P> <P>Hi sir this is the only thing in the expression</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.PNG" style="width: 200px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaY2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134876i3E7AF104F3634D73/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaY2.png" alt="0683p000009MaY2.png" /></span></SPAN></P> Thu, 02 Jul 2020 14:13:32 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246590#M32062 MoodyEngineer14 2020-07-02T14:13:32Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246591#M32063 <P><A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;</P> <P>Hi sir this is the only thing in the expression</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.PNG" style="width: 200px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaY2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134876i3E7AF104F3634D73/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaY2.png" alt="0683p000009MaY2.png" /></span></SPAN></P> Thu, 02 Jul 2020 14:13:32 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246591#M32063 MoodyEngineer14 2020-07-02T14:13:32Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246592#M32064 i've tried putting this code row1,glocation .substring(0,11) but it doesnt work Thu, 02 Jul 2020 14:15:23 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246592#M32064 MoodyEngineer14 2020-07-02T14:15:23Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246593#M32065 i've tried putting this code row1,glocation .substring(0,11) but it doesnt work Thu, 02 Jul 2020 14:15:23 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246593#M32065 MoodyEngineer14 2020-07-02T14:15:23Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246594#M32066 Has changed since the previous capture Thu, 02 Jul 2020 14:39:34 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246594#M32066 TRF 2020-07-02T14:39:34Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246595#M32067 Has changed since the previous capture Thu, 02 Jul 2020 14:39:34 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246595#M32067 TRF 2020-07-02T14:39:34Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246596#M32068 Use StringHandling.LEFT(row1,glocation, 11). <BR />If length of row1,glocation is greater than 11, it return the 11 first char, else it returns row1,glocation Thu, 02 Jul 2020 14:42:20 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246596#M32068 TRF 2020-07-02T14:42:20Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246597#M32069 Use StringHandling.LEFT(row1,glocation, 11). <BR />If length of row1,glocation is greater than 11, it return the 11 first char, else it returns row1,glocation Thu, 02 Jul 2020 14:42:20 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246597#M32069 TRF 2020-07-02T14:42:20Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246598#M32070 <P><A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;</P> <P>HI sir now i git this error</P> <PRE>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]</PRE> <P>&nbsp;</P> Thu, 02 Jul 2020 16:52:48 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246598#M32070 MoodyEngineer14 2020-07-02T16:52:48Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246599#M32071 <P><A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;</P> <P>HI sir now i git this error</P> <PRE>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]</PRE> <P>&nbsp;</P> Thu, 02 Jul 2020 16:52:48 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246599#M32071 MoodyEngineer14 2020-07-02T16:52:48Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246600#M32072 Share your job design Thu, 02 Jul 2020 16:54:54 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246600#M32072 TRF 2020-07-02T16:54:54Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246601#M32073 Share your job design Thu, 02 Jul 2020 16:54:54 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246601#M32073 TRF 2020-07-02T16:54:54Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246602#M32074 <P>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</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.PNG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ma80.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152409iA1FCCD32EDE86C84/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ma80.png" alt="0683p000009Ma80.png" /></span></SPAN></P> Thu, 02 Jul 2020 23:17:15 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246602#M32074 MoodyEngineer14 2020-07-02T23:17:15Z https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246603#M32075 <P>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</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.PNG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ma80.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152409iA1FCCD32EDE86C84/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ma80.png" alt="0683p000009Ma80.png" /></span></SPAN></P> Thu, 02 Jul 2020 23:17:15 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tMap-1-data-warehousing-facility/m-p/2246603#M32075 MoodyEngineer14 2020-07-02T23:17:15Z