2020-04-29 13:07:10,470 : ERROR : KNIME-Worker-13 : Node : Database Writer : 0:10 : Execute failed: Incorrect syntax near '501'. 2020-04-29 13:07:10,470 : DEBUG : KNIME-Worker-13 : Node : Database Writer : 0:10 : Execute failed: Incorrect syntax near '501'. com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '501'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729) at org.knime.core.node.port.database.writer.DBWriterImpl.lambda$0(DBWriterImpl.java:294) at org.knime.core.node.port.database.DatabaseConnectionSettings.execute(DatabaseConnectionSettings.java:684) at org.knime.core.node.port.database.writer.DBWriterImpl.writeData(DBWriterImpl.java:108) at org.knime.base.node.io.database.DBWriterNodeModel.execute(DBWriterNodeModel.java:250) at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567) at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1186) at org.knime.core.node.Node.execute(Node.java:973) at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:559) at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95) at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179) at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110) at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328) at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123) at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246) 2020-04-29 13:07:10,470 : DEBUG : KNIME-Worker-13 : WorkflowManager : Database Writer : 0:10 : Database Writer 0:10 doBeforePostExecution 2020-04-29 13:07:10,470 : DEBUG : KNIME-Worker-13 : NodeContainer : Database Writer : 0:10 : Database Writer 0:10 has new state: POSTEXECUTE 2020-04-29 13:07:10,470 : DEBUG : KNIME-Worker-13 : WorkflowManager : Database Writer : 0:10 : Database Writer 0:10 doAfterExecute - failure 2020-04-29 13:07:10,471 : DEBUG : KNIME-Worker-13 : Node : Database Writer : 0:10 : reset 2020-04-29 13:07:10,471 : DEBUG : KNIME-Worker-13 : Node : Database Writer : 0:10 : clean output ports. 2020-04-29 13:07:10,471 : DEBUG : KNIME-Worker-13 : WorkflowDataRepository : Database Writer : 0:10 : Removing handler 6fda77ab-2ff0-4574-86d1-5afb2ef704ad (Database Writer 0:10: ) - 1 remaining 2020-04-29 13:07:10,471 : DEBUG : KNIME-Worker-13 : NodeContainer : Database Writer : 0:10 : Database Writer 0:10 has new state: IDLE 2020-04-29 13:07:10,476 : WARN : KNIME-Worker-13 : Node : Database Writer : 0:10 : Existing table "PFS_Inv_Weekly_Week_Over_Week" will be dropped! 2020-04-29 13:07:10,476 : DEBUG : KNIME-Worker-13 : Node : Database Writer : 0:10 : Configure succeeded. (Database Writer) 2020-04-29 13:07:10,476 : DEBUG : KNIME-Worker-13 : NodeContainer : Database Writer : 0:10 : Database Writer 0:10 has new state: CONFIGURED 2020-04-29 13:07:10,476 : DEBUG : KNIME-Worker-13 : NodeContainer : Database Writer : 0:10 : PFS_Weekly_Trending_Copy 0 has new state: CONFIGURED 2020-04-29 13:07:10,476 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: IDLE