Server Issues

When I try and execute my workflows I keep getting an error as follows.
It appears there’s an issue with my user but I cant figure out what and neither can IT at my company. I have the latest version update. Any ideas?

ERROR Microsoft SQL Server Connector 3:5 Execute failed: (“SQLException”): null
WARN Excel Reader (XLS) (deprecated) 3:1 DataSpec generated by configure does not match spec after execution.
ERROR Microsoft SQL Server Connector 4:1 Execute failed: (“SQLException”): null
ERROR Microsoft SQL Server Connector 5:5 Execute failed: (“SQLException”): null
ERROR Microsoft SQL Server Connector 6:1 Execute failed: (“SQLException”): null

Hello,

Thank you for contacting KNIME regarding this issue.

My understanding of the issue is that you are attempting to execute a workflow that connects to a database using the Microsoft SQL Server Connector node, but it is receiving an SQLException error of ‘null’.

  • Is this a workflow being executed straight from the Analytics Platform (AP), or is it a deployed workflow being executed on a KNIME server?

  • What version of KNIME Analytics Platform (AP) is being used?

If there is a server being used,

  • What version of KNIME Server (KS)/KNIME Executor (KE) are being used?

  • Does the issue affect one user, multiple users, or all users?

I look forward to helping you resolve this issue!

Regards,

Nickolaus

1 Like