DB Writer Does Not Finish Executing MSQL Server

KNIME Analytics Platform
1

DB Writer Does not work

I am trying to load a table to Microsoft SQL Server, but DB Writer node never finishes executing. A coworker sent me a workflow he is using and that matched my parameters, so I have no idea what could be wrong.

My workflow is just this:

image
image759×694 41.9 KB

Is there something wrong in the settings?

image
image1410×1045 129 KB

2

@yojed welcome to the KNIME forum

  • “CB.” you have a dot at the end of your schema. Is this right? Would not use that.
  • Then you tell the node to delete the existing table. Is this what you want?
  • You could disable the option to write a status column
  • at least one columns has a “#” maybe try to avoid that

How large is this data and have you tried to just load a few lines?

Another approach might be to first create an empty table with the structure, see if that does work and then add data later ([L4-BD] exercise 1 odyssey - #2 by mlauber71).

2 Likes
3

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