Rails - Jun 2006 - 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 Fitzgibbons
================== 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 ================-------------- next part
--------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060626/d589a0b1/attachment-0001.html

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