Bitnami Redmine Unable to connect: Adaptive Server

Keywords: Redmine - Windows - Technical issue - Connectivity (SSH/FTP)
Description:
Good day!
I am trying to install Redmine on a MS SQL 2107 server from a Windows 10 Pro computer.
This is a clean computer with no other versions of Redmine. Unfortunately, every time I try to execute the command bundle exec thin -e production start I get this error:

C:\Bitnami\redmine-4.1.1-8\apps\redmine\htdocs> bundle exec thin -e production start
Using rack adapter
Traceback (most recent call last):
        86: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/bin/thin:23:in `<main>'
        85: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/bin/thin:23:in `load'
        84: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/bin/thin:6:in `<top (required)>'
        83: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/runner.rb:159:in `run!'
        82: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/runner.rb:203:in `run_command'
        81: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/controllers/controller.rb:74:in `start'
        80: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/controllers/controller.rb:170:in `load_adapter'
        79: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:42:in `for'
        78: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:33:in `load'
        77: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:33:in `eval'
        76: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:1:in `<main>'
        75: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:1:in `new'
        74: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in `initialize'
        73: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in `instance_eval'
        72: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:3:in `block in <main>'
        71: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:3:in `require'
        70: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config/environment.rb:16:in `<top (required)>'
        69: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application.rb:361:in `initialize!'
        68: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:60:in `run_initializers'
        67: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:205:in `tsort_each'
        66: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:226:in `tsort_each'
        65: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in `each_strongly_connected_component'
        64: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in `call'
        63: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in `each'
        62: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:349:in `block in each_strongly_connected_component'
        61: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:431:in `each_strongly_connected_component_from'
        60: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
        59: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:228:in `block in tsort_each'
        58: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:61:in `block in run_initializers'
        57: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:32:in `run'
        56: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:32:in `instance_exec'
        55: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application/finisher.rb:69:in `block in <module:Finisher>'
        54: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application/finisher.rb:69:in `each'
        53: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:356:in `eager_load!'
        52: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:475:in `eager_load!'
        51: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:475:in `each'
        50: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:477:in `block in eager_load!'
        49: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:477:in `each'
        48: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:478:in `block (2 levels) in eager_load!'
        47: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:246:in `require_dependency'
        46: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:334:in `depend_on'
        45: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:356:in `require_or_load'
        44: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:37:in `load_interlock'
        43: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:13:in `loading'
        42: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/concurrency/share_lock.rb:151:in `exclusive'
        41: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:14:in `block in loading'
        40: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:37:in `block in load_interlock'
        39: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:378:in `block in require_or_load'
        38: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in `require'
        37: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:257:in `load_dependency'
        36: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in `block in require'
        35: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in `require'
        34: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:20:in `<top (required)>'
        33: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:36:in `<class:IssueQuery>'
        32: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:36:in `new'
        31: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/query.rb:31:in `initialize'
        30: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/query.rb:91:in `groupable'
        29: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/user.rb:816:in `current'
        28: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/user.rb:822:in `anonymous'
        27: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/scoping/default.rb:34:in `unscoped'
        26: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/core.rb:287:in `relation'
        25: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/inheritance.rb:84:in `finder_needs_type_condition?'
        24: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/inheritance.rb:78:in `descends_from_active_record?'
        23: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/model_schema.rb:336:in `columns_hash'
        22: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/model_schema.rb:456:in `load_schema'
        21: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/monitor.rb:235:in `mon_synchronize'
        20: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/model_schema.rb:459:in `block in load_schema'
        19: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/attribute_decorators.rb:51:in `load_schema!'
        18: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/attributes.rb:234:in `load_schema!'
        17: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/model_schema.rb:466:in `load_schema!'
        16: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_handling.rb:90:in `connection'
        15: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_handling.rb:118:in `retrieve_connection'
        14: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection'
        13: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
        12: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout'
        11: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection'
        10: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection'
         9: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection'
         8: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection'
         7: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/sqlserver_base.rb:13:in `sqlserver_connection'
         6: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/sqlserver_base.rb:13:in `new'
         5: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:64:in `initialize'
         4: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:365:in `connect'
         3: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:379:in `dblib_connect'
         2: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:379:in `new'
         1: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/tiny_tds-2.1.3-x64-mingw32/lib/tiny_tds/client.rb:60:in `initialize'
C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/tiny_tds-2.1.3-x64-mingw32/lib/tiny_tds/client.rb:60:in `connect': Unable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1) (TinyTds::Error) 

Here’s my full database/yml file:

production:
  adapter: sqlserver
  host: 127.0.0.1
  port: 1433
  database: DATABESE
  username: user
  password: "passwordpassword"
  encoding: utf8

I am trying to install the program on a production MS SQL server of our company so that we can keep track of the employees activities, and I would be grateful for any help.

Hi @efimov.glp

Thanks for using Bitnami Redmine!

Is your MS SQL server up & running? Can you connect to it using SQL Server Management Studio? I have found a similar issue in GitHub and apparently the user was lacking some configuration on the MS SQL server side, making TCP connection fail. Could you please take a look at it?

https://github.com/rails-sqlserver/tiny_tds/issues/280#issuecomment-220811925

Additionally, we have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please execute it on the machine where the stack is running by following the steps described in the guide below?

Please note that you need to paste the code ID that is shown at the end.

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

1 Like

Obviously, I made a mistake in specifying the dns name of my server. Anyway, I checked the connection through the TCP, made sure all required ports are available and then restarted the command bundle exec thin -e production start.

This time I got even more interesting error:

[details=Summary] C:\Bitnami\redmine-4.1.1-8\apps\redmine\htdocs> bundle exec thin -e production start
Using rack adapter
Traceback (most recent call last):
83: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/bin/thin:23:in <main>' 82: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/bin/thin:23:in load’
81: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/bin/thin:6:in <top (required)>' 80: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/runner.rb:159:in run!’
79: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/runner.rb:203:in run_command' 78: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/controllers/controller.rb:74:in start’
77: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/thin/controllers/controller.rb:170:in load_adapter' 76: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:42:in for’
75: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:33:in load' 74: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/thin-1.7.2-x64-mingw32/lib/rack/adapter/loader.rb:33:in eval’
73: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:1:in <main>' 72: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:1:in new’
71: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in initialize' 70: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/rack-2.2.3/lib/rack/builder.rb:125:in instance_eval’
69: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:3:in block in <main>' 68: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config.ru:3:in require’
67: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/config/environment.rb:16:in <top (required)>' 66: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application.rb:361:in initialize!’
65: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:60:in run_initializers' 64: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:205:in tsort_each’
63: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:226:in tsort_each' 62: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in each_strongly_connected_component’
61: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in call' 60: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:347:in each’
59: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:349:in block in each_strongly_connected_component' 58: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:431:in each_strongly_connected_component_from’
57: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:350:in block (2 levels) in each_strongly_connected_component' 56: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/tsort.rb:228:in block in tsort_each’
55: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:61:in block in run_initializers' 54: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:32:in run’
53: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/initializable.rb:32:in instance_exec' 52: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application/finisher.rb:69:in block in module:Finisher
51: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/application/finisher.rb:69:in each' 50: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:356:in eager_load!’
49: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:475:in eager_load!' 48: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:475:in each’
47: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:477:in block in eager_load!' 46: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:477:in each’
45: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/railties-5.2.4.2/lib/rails/engine.rb:478:in block (2 levels) in eager_load!' 44: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:246:in require_dependency’
43: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:334:in depend_on' 42: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:356:in require_or_load’
41: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:37:in load_interlock' 40: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:13:in loading’
39: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/concurrency/share_lock.rb:151:in exclusive' 38: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:14:in block in loading’
37: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:37:in block in load_interlock' 36: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:378:in block in require_or_load’
35: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in require' 34: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:257:in load_dependency’
33: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in block in require' 32: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:291:in require’
31: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:20:in <top (required)>' 30: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:36:in class:IssueQuery
29: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/issue_query.rb:36:in new' 28: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/query.rb:31:in initialize’
27: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/query.rb:91:in groupable' 26: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/user.rb:816:in current’
25: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/app/models/user.rb:822:in anonymous' 24: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation/finder_methods.rb:81:in find_by’
23: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation/finder_methods.rb:103:in take' 22: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation/finder_methods.rb:504:in find_take’
21: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation.rb:200:in records' 20: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation.rb:422:in load’
19: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation.rb:547:in exec_queries' 18: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation.rb:584:in skip_query_cache_if_necessary’
17: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/relation.rb:560:in block in exec_queries' 16: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/querying.rb:41:in find_by_sql’
15: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/query_cache.rb:106:in select_all' 14: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:68:in select_all’
13: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:482:in select_prepared' 12: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:15:in exec_query’
11: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:269:in sp_executesql' 10: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:370:in raw_select’
9: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:571:in log' 8: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activesupport-5.2.4.2/lib/active_support/notifications/instrumenter.rb:23:in instrument’
7: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:580:in block in log' 6: from C:/Bitnami/redmine-4.1.1-8/ruby/lib/ruby/2.5.0/monitor.rb:235:in mon_synchronize’
5: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:581:in block (2 levels) in log' 4: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:370:in block in raw_select’
3: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:375:in _raw_select' 2: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:396:in handle_to_names_and_values’
1: from C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:405:in handle_to_names_and_values_dblib' C:/Bitnami/redmine-4.1.1-8/apps/redmine/htdocs/vendor/bundle/ruby/2.5.0/gems/activerecord-sqlserver-adapter-5.2.1/lib/active_record/connection_adapters/sqlserver/database_statements.rb:405:in each’: TinyTds::Error: Incorrect syntax near ‘OFFSET’.: EXEC sp_executesql N’SELECT [users].* FROM [users] WHERE [users].[lastname] = @0 OFFSET 0 ROWS FETCH NEXT @1 ROWS ONLY’, N’@0 nvarchar(max), @1 int’, @0 = N’Anonymous’, @1 = 1 (ActiveRecord::StatementInvalid)[/details]

And here are my ID code from Bitnami Support Tool: 6f9076a2-f930-7de3-24c6-05d0d38f247d

Quite by accident, I managed to solve this problem myself.

  1. It is necessary to specify the DNS server name, and not its IP, as I did.
  2. After making all the changes to the adapter and connecting to the SQL server, you must run the procedure bundle update
  3. After this shut dawn all server connections from Bitnami Stack Manager Tool
  4. Run bundle exec rake db:migrate RAILS_ENV=production
  5. Re-start all server connections from Bitnami Stack Manager Tool

And that’s all about it.

Thanks for sharing your solution with the community!

Glad to see you were able to solve your issue! We are marking the previous answer as “Solution” and this topic as “Closed”.

If you have any other questions, please do not hesitate to let us know. Feel free to create a new topic referencing this one if necessary.

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

1 Like