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
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?