Rake + SQL Server + Migrations == Errors. Help?!

Hello all,

I’m trying to initialize my migrations against a current database
implementation.

rake db:schema:dump runs without error.
The resulting schema.rb is pasted below, along with my database.yml

Can one of you point me in the direction of enlightenment?

Apple MacBook. Black. It’s the new White!

Peter F.
================== database.yml =================

================== end database.yml ===============
development:
adapter: sqlserver
database: buildview_dev
host: localhost
username: user
password: password

Warning: The database defined as ‘test’ will be erased and

re-generated from your development database when you run ‘rake’.

Do not set this db to the same as development or production.

test:
adapter: sqlserver
database: buildview_test
host: localhost
username: user
password: password

production:
adapter: sqlserver
database: buildview_rails
host: production
username: user
password: password

============== schema.rb ==================

This file is autogenerated. Instead of editing this file, please use

the

migrations feature of ActiveRecord to incrementally modify your

database,
and

then regenerate this schema definition.

ActiveRecord::Schema.define() do

Could not dump table “SalesCustomers” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “SalesPlans” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “community_news” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex community_news

Could not dump table “community_news_users” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “disclaimers” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex disclaimers

Could not dump table “home_milestones” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “homes” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex homes

Could not dump table “homes_users” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “lots” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex lots

Could not dump table “milestone_fixture” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “milestone_masters” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex milestone_masters

Could not dump table “permissions” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex permissions

Could not dump table “permissions_roles” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “plans” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex plans

Could not dump table “roles” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex roles

Could not dump table “roles_users” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “sales_lot_status” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “salescancellations” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex salescancellations

Could not dump table “salescommunities” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “salesconfigurations” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “salesconstructionstages” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “saleslots” because of following

DBI::DatabaseError

EOF

OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

Could not dump table “subdivisions” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex subdivisions

Could not dump table “user_login_history” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex user_login_history

Could not dump table “users” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex users

Could not dump table “workflows” because of following

ActiveRecord::StatementInvalid

DBI::DatabaseError: Count

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.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex workflows

end
================ end schema.rb =================

I have run into the zombie transaction before. Add this to your
environment.rb:

#uncomment this for dumping schema with rake, comment out afterwards,
otherwise migrations don’t work
#ActiveRecord::Base.connection.instance_variable_get("@connection")[“AutoCommit”]
= false

and uncomment the second line before running rake and comment out
after rake finishes.

Hope it helps

raf