# Random DBI::DatabaseError while querying SqlServer **URL:** \ **Category:** Rails\ **Created:** [February 27, 2009, 8:30pm UTC](https://www.ruby-forum.com/t/random-dbi-databaseerror-while-querying-sqlserver/161611 "2009-02-27T20:30:04Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Seyit\_Caglar\_Abbaso](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9e8a1a/32.png) [@Seyit\_Caglar\_Abbaso](https://www.ruby-forum.com/u/Seyit_Caglar_Abbaso)\ **Post date:** [February 27, 2009, 8:30pm UTC](https://www.ruby-forum.com/t/random-dbi-databaseerror-while-querying-sqlserver/161611/1 "2009-02-27T20:30:04Z")
_First some background:_ Application is running on a windows XP I’m currently using Ruby version 1.8.6-26 with easy installer (I couldn’t manage to manually install 1.8.7) Rails version is 2.2.2 activerecord version 2.2.2, 1.15.6 activerecord-sqlserver-adapter is version 1.0.0.9250 ADO.rb version is 0.1.0 (couldn’t find anything newer, is it abandoned or something?) SqlServer 2000 (I tried with sql server 2005 same problem continues) I don’t know it’s related but as session store I’m using active\_record\_store _Problem_: Database queries are generally working fine, but sometimes (lets say once in 30-40 queries) I get a strange error at sqlserver\_adapter.rb, the error message and stack trace is as follows. DBI::DatabaseError: Value OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server IÄ°ÅŸlem::Kaydet veya IÄ°ÅŸlem::Durdur çaÄŸrıldı ve nesne meÅŸgul durumda. HRESULT error code:0x80020009 ?zel durum olu?tu.: SELECT \* FROM [product] WHERE ([product].[isActive] = 1 AND [product].[useInMobileOrder] = 1) C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:188:in `log' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0.9250/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in`execute’ C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0.9250/lib/active\_record/connection\_adapters/sqlserver\_adapter.rb:538:in `select' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in`select\_all\_without\_query\_cache’ C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/connection\_adapters/abstract/query\_cache.rb:60:in `select_all' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in`cache\_sql’ C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/connection\_adapters/abstract/query\_cache.rb:60:in `select_all' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in`find\_by\_sql’ C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/base.rb:1490:in `find_every' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:589:in`find’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/base.rb:1253:in `send' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in`perform\_action\_without\_filters’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/filters.rb:617:in `call_filters' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:638:in`run\_before\_filters’ C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/callbacks.rb:178:in `send' C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/callbacks.rb:178:in`evaluate\_method’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/filters.rb:186:in `call' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:635:in`run\_before\_filters’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/filters.rb:615:in `call_filters' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:610:in`perform\_action\_without\_benchmark’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/benchmarking.rb:68:in `perform_action_without_rescue' C:/ruby/lib/ruby/1.8/benchmark.rb:293:in`measure’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/benchmarking.rb:68:in `perform_action_without_rescue' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/rescue.rb:136:in`perform\_action\_without\_caching’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/caching/sql\_cache.rb:13:in `perform_action' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in`cache’ C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/query\_cache.rb:8:in `cache' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:12:in`perform\_action’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/base.rb:524:in `send' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in`process\_without\_filters’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/filters.rb:606:in `process_without_session_management_support' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in`process’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/base.rb:392:in `process' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in`handle\_request’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/dispatcher.rb:110:in `dispatch_unlocked' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in`dispatch’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/dispatcher.rb:122:in `synchronize' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in`dispatch’ C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/dispatcher.rb:132:in `dispatch_cgi' C:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:in`dispatch’ C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick\_server.rb:103:in `handle_dispatch' C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:74:in`service’ C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in`run’ C:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in`start’ C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' C:/ruby/lib/ruby/1.8/webrick/server.rb:95:in`start’ C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in`start’ C:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' C:/ruby/lib/ruby/1.8/webrick/server.rb:82:in`start’ C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick\_server.rb:60:in `dispatch' C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/servers/webrick.rb:66 C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in`gem\_original\_require’ C:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `require' C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in`require’ C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/dependencies.rb:521:in `new_constants_in' C:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in`require’ C:/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/server.rb:49 C:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `gem_original_require' C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in`require’ _Translation of Error message_ The error message seems to be coming from Microsoft provider so it’s message is localized to Turkish. A direct translation would be something like DBI::DatabaseError: Value OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server _ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state._ Any ideas to solve the problem? Thx in advance