topic Re: Some of the data file not getting inserted into database, but files moved to successful archive directory in Talend Studio https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309403#M80621 <P>what is the code you are using in tFileArchive to give the file path ?</P><P>also how you are reading the files in tDeliminited Input</P> Thu, 26 Nov 2020 09:32:05 GMT Prakhar1 2020-11-26T09:32:05Z Some of the data file not getting inserted into database, but files moved to successful archive directory https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309402#M80620 <P>Hi Experts,</P><P>I have a talend job which reads the files from directory , Insert into DB2 database and then move to archive directory.</P><P>When i have more files, some of the files not getting inserted, but files moved to successful archive directory and there is no error as well.</P><P>Please guide me is there any design issue. My design is below.</P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZrwoAAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144600iB6305C7C308281C2/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AZrwoAAD.png" alt="0693p00000AZrwoAAD.png" /></span></P> Thu, 26 Nov 2020 05:31:40 GMT https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309402#M80620 ganeshK 2020-11-26T05:31:40Z Re: Some of the data file not getting inserted into database, but files moved to successful archive directory https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309403#M80621 <P>what is the code you are using in tFileArchive to give the file path ?</P><P>also how you are reading the files in tDeliminited Input</P> Thu, 26 Nov 2020 09:32:05 GMT https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309403#M80621 Prakhar1 2020-11-26T09:32:05Z Re: Some of the data file not getting inserted into database, but files moved to successful archive directory https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309404#M80622 <P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZvLSAA1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144203i0186FBB43DEECBA0/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AZvLSAA1.png" alt="0693p00000AZvLSAA1.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZvLNAA1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154496i7947C5C060FA4BAE/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AZvLNAA1.png" alt="0693p00000AZvLNAA1.png" /></span>Hi,</P><P>Below are the properties and code i am using for tDelimitedInput and tFileArchive.</P><P>&nbsp;</P> Fri, 27 Nov 2020 10:58:48 GMT https://community.qlik.com/t5/Talend-Studio/Some-of-the-data-file-not-getting-inserted-into-database-but/m-p/2309404#M80622 ganeshK 2020-11-27T10:58:48Z