# DB insert - Error

**URL:** <https://forum.knime.com/t/db-insert-error/21007>\
**Category:** KNIME Analytics Platform\
**Tags:** database\
**Created:** [February 13, 2020, 12:47pm UTC](https://forum.knime.com/t/db-insert-error/21007 "2020-02-13T12:47:20Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rawan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@Rawan](https://forum.knime.com/u/Rawan)\
**Post date:** [February 13, 2020, 12:47pm UTC](https://forum.knime.com/t/db-insert-error/21007/1 "2020-02-13T12:47:20Z")

</div>

Hello,

I am trying to insert data to SQL DB but I faced below error.

ERROR DB Insert 0:245 Execute failed: Error while adding rows #-1000 - #0, reason: Data truncation

I changed all varchar to longvarcart but still the same issue.

can someone help me to understand the issue and fix it.

thanks

---

<div class="post-metadata">

**Author:** ![AlexanderFillbrunn](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alexanderfillbrunn/32/357_2.png) [@AlexanderFillbrunn](https://forum.knime.com/u/AlexanderFillbrunn)\
**Post date:** [February 13, 2020, 1:39pm UTC](https://forum.knime.com/t/db-insert-error/21007/2 "2020-02-13T13:39:14Z")

</div>

Hi @Rawan,  
what database system are you trying to insert data into?  
Kind regards  
Alexander

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [February 13, 2020, 1:45pm UTC](https://forum.knime.com/t/db-insert-error/21007/3 "2020-02-13T13:45:06Z")

</div>

I have the same issue with SQL server DB Writer. In old version it worked as I mapped input string to varchar(6000)

---

<div class="post-metadata">

**Author:** ![Rawan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@Rawan](https://forum.knime.com/u/Rawan)\
**Post date:** [February 16, 2020, 7:45am UTC](https://forum.knime.com/t/db-insert-error/21007/4 "2020-02-16T07:45:41Z")

</div>

hello,  
I am trying to connect to sql server.

---

<div class="post-metadata">

**Author:** ![Rawan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@Rawan](https://forum.knime.com/u/Rawan)\
**Post date:** [February 16, 2020, 7:46am UTC](https://forum.knime.com/t/db-insert-error/21007/5 "2020-02-16T07:46:48Z")

</div>

did you use “DB insert” or legacy node.

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [February 16, 2020, 1:36pm UTC](https://forum.knime.com/t/db-insert-error/21007/6 "2020-02-16T13:36:11Z")

</div>

In old version I used Database Writer. In new one DB Writer.

---

<div class="post-metadata">

**Author:** ![Rawan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@Rawan](https://forum.knime.com/u/Rawan)\
**Post date:** [February 17, 2020, 6:39am UTC](https://forum.knime.com/t/db-insert-error/21007/7 "2020-02-17T06:39:49Z")

</div>

Hello,  
DB Writer it is fixed, I can only chose VARCHAR or LONGVARCHAR. and both didn’t work.

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [February 17, 2020, 8:24am UTC](https://forum.knime.com/t/db-insert-error/21007/8 "2020-02-17T08:24:21Z")

</div>

Hello,  
if you need to specify specific data types you need to use the _[DB Table Creator](https://docs.knime.com/latest/db_extension_guide/index.html#db_creator)_ and the _[DB Insert](https://docs.knime.com/latest/db_extension_guide/index.html#db_insert)_ node instead of the _[DB Writer](https://docs.knime.com/latest/db_extension_guide/index.html#db_writer)_ node. The _DB Table Creator_ node allows you to specify the type of each column to write whereas the _DB Writer_ node uses a default mapping that can not be changed in the node for simplicity.  
Bye  
Tobias

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [August 17, 2020, 8:24pm UTC](https://forum.knime.com/t/db-insert-error/21007/9 "2020-08-17T20:24:21Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.
