New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rundeck using MSSQL datasource #848

Closed
zarry opened this Issue Jul 8, 2014 · 1 comment

Comments

Projects
None yet
3 participants
@zarry

zarry commented Jul 8, 2014

When connecting Rundeck to a MSSQL back-end I encountered some issues creating a project. I was using the merlia 7.05 jdbc driver.

Steps to recreate.

  1. Setup rundeck to use a MSSQL datasource
  2. Create a project, configuring it to use the winrm plugin
  3. Click Save to create project

Error
Request: /project/Tomcat/jobs
Message: [SQLVM82]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Caused by: [SQLVM82]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Class: MenuController
At Line: [194]
Code Snippet:

Datasource Config

dataSource.url = jdbc:inetdae7a:sqlvm82:1433?database=rundeck_test
dataSource.driverClassName = com.inet.tds.TdsDriver
dataSource.username = supersecretuser
dataSource.password = supersecretpass

Stacktrace

com.inet.tds.Tds4SQLException: Msg 306, Level 16, State 2, Line 1, Sqlstate 01000
[SQLVM82]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
    at grails.orm.HibernateCriteriaBuilder.invokeMethod(HibernateCriteriaBuilder.java:1618)
    at rundeck.services.ScheduledExecutionService.listWorkflows(ScheduledExecutionService.groovy:110)
    at rundeck.controllers.MenuController.listWorkflows(MenuController.groovy:285)
    at rundeck.controllers.MenuController$_closure9.doCall(MenuController.groovy:244)
    at rundeck.controllers.MenuController$_closure8.doCall(MenuController.groovy:194)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:539)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:288)
    at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:486)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
    at org.eclipse.jetty.server.Server.handle(Server.java:349)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)
    at java.lang.Thread.run(Thread.java:701)
@jasonhensler

This comment has been minimized.

Show comment
Hide comment
@jasonhensler

jasonhensler Sep 29, 2014

Contributor

Looks like table workflow_step.job_name should be a varchar instead of a text for the order by to work properly in the mssql world. Can't test this as temp tables are being create with type text.

Contributor

jasonhensler commented Sep 29, 2014

Looks like table workflow_step.job_name should be a varchar instead of a text for the order by to work properly in the mssql world. Can't test this as temp tables are being create with type text.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment