Error on stating Table Input Process at agent server

The process works at the studio, but it gives an error when trying to Strat it from the portal at the agent server:

Error : Workflow Execution failed. An error occurred, processing will be stopped:
Error occurred while trying to connect to the database

Driver class ‘net.sourceforge.jtds.jdbc.Driver’ could not be found, make sure the ‘MS SQL Server’ driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver

Step [Table input] failed to initialize!

I have already inserted the jtds-1.3.1.jar in the lib and also psplugins directory but still getting the same error message.

Support gave me this steps and it worked for me.

Do the following changes:

  • Stop agent
  • After agent stop, copy the jtds -1.3.1.jar into agent/lib directory.
  • Restart the agent and try to run the process.

Best Regards,
AutomationEdge Support

2 Likes

Thanks Fernando for sharing answer on the community. Helps us grow knowledge base as well troubleshoot things rapidly. Appreciate your gesture!