topic Re: ERROR WHILE LOADING DATA INTO DATABASE in Talend Studio https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223779#M16760 <P>in this scenarion Combination of company product salt is unique.</P> <P>&nbsp;but I tried other by adding surrogate key s.no using tmap even though same error came</P> Fri, 24 Apr 2020 14:20:13 GMT sam473 2020-04-24T14:20:13Z ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223777#M16758 <P>Hi,</P> <P>I am getting following error when execute ,someone can help me how to sort these type of errors.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="INPUT DATA" style="width: 969px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Gq.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153664i3CEE9B9D35952171/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Gq.jpg" alt="0683p000009M9Gq.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">INPUT DATA</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JOB DESIGN" style="width: 991px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9rw.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147133i40B2E6390111AB26/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9rw.jpg" alt="0683p000009M9rw.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">JOB DESIGN</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SCHEMA" style="width: 976px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA8R.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143677iBD0A232B144F311B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA8R.jpg" alt="0683p000009MA8R.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">SCHEMA</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SQL_ERROR" style="width: 836px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA8W.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129901iE260C23C8D6C8AFB/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA8W.jpg" alt="0683p000009MA8W.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">SQL_ERROR</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SQL ERROR" style="width: 837px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA8b.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129155i90483D29727F5673/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA8b.jpg" alt="0683p000009MA8b.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">SQL ERROR</SPAN></SPAN></P> Thu, 23 Apr 2020 22:31:03 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223777#M16758 sam473 2020-04-23T22:31:03Z Re: ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223778#M16759 <P><A href="https://community.qlik.com/s/profile/0053p000007LR5BAAW">@sam473</A>&nbsp;, do you have duplicate records based on company, product, and salt ?</P> Fri, 24 Apr 2020 04:58:05 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223778#M16759 manodwhb 2020-04-24T04:58:05Z Re: ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223779#M16760 <P>in this scenarion Combination of company product salt is unique.</P> <P>&nbsp;but I tried other by adding surrogate key s.no using tmap even though same error came</P> Fri, 24 Apr 2020 14:20:13 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223779#M16760 sam473 2020-04-24T14:20:13Z Re: ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223780#M16761 Then you have duplicates. Sun, 26 Apr 2020 16:21:55 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223780#M16761 manodwhb 2020-04-26T16:21:55Z Re: ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223781#M16762 <P>what is the solution if my data is having duplicates and i want to store the data in database without error</P> Thu, 25 Jun 2020 09:46:43 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223781#M16762 sam473 2020-06-25T09:46:43Z Re: ERROR WHILE LOADING DATA INTO DATABASE https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223782#M16763 <P><A href="https://community.qlik.com/s/profile/0053p000007LR5BAAW">@sam473</A>&nbsp;, first you need to eliminate duplicates and load the data into the table.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 26 Jun 2020 08:09:07 GMT https://community.qlik.com/t5/Talend-Studio/ERROR-WHILE-LOADING-DATA-INTO-DATABASE/m-p/2223782#M16763 manodwhb 2020-06-26T08:09:07Z