undefined_method 'postgresql_connection'
30 views
Skip to first unread message
Paul nop
Oct 4, 2013, 8:50:42 AM10/4/13
to activewareh...@googlegroups.com
Hi. I`m trying to run activewarehouse-etl and i`m getting error:
Starting ETL process
initializing ETL engine
Processing batch etl/process_all.ebf
Executing batch
Processing control etl/upsert_products.ctl
Source: localhost/shop/products
/home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.6/lib/active_record/dynamic_matchers.rb:50:in `method_missing': undefined method `postgresql_connection' for #<Class:0x00000003b1cf30> (NoMethodError)
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:212:in `establish_connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:143:in `connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:219:in `connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:213:in `query_rows'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:100:in `columns'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:160:in `block (2 levels) in write_local'
from /home/r90t/.rvm/rubies/ruby-1.9.3-p448/lib/ruby/1.9.1/csv.rb:1354:in `open'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:159:in `block in write_local'
from /home/r90t/.rvm/rubies/ruby-1.9.3-p448/lib/ruby/1.9.1/benchmark.rb:295:in `realtime'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:158:in `write_local'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:115:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:333:in `each_with_index'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:333:in `block in process_control'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:327:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:327:in `process_control'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:275:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:272:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/directives.rb:41:in `do_execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/directives.rb:15:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:90:in `block in execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:89:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:89:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:300:in `process_batch'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:276:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:272:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:55:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:82:in `block in execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:80:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:80:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:90:in `<top (required)>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `block in require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:236:in `load_dependency'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/bin/etl:28:in `<top (required)>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/etl:19:in `load'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/etl:19:in `<main>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/ruby_noexec_wrapper:14:in `eval'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/ruby_noexec_wrapper:14:in `<main>'
My database.yml is looks like this:
etl_source:
adapter: postgresql
encoding: unicode
database: shop
hostname: localhost
username: r90t
password: pass
etl_execution:
adapter: mysql2
database: shop_dwh
hostname: 127.0.0.1
username: r90t
password: pass
What should i do to resolve the problem?
Starting ETL process
initializing ETL engine
Processing batch etl/process_all.ebf
Executing batch
Processing control etl/upsert_products.ctl
Source: localhost/shop/products
/home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.6/lib/active_record/dynamic_matchers.rb:50:in `method_missing': undefined method `postgresql_connection' for #<Class:0x00000003b1cf30> (NoMethodError)
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:212:in `establish_connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:143:in `connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:219:in `connection'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:213:in `query_rows'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:100:in `columns'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:160:in `block (2 levels) in write_local'
from /home/r90t/.rvm/rubies/ruby-1.9.3-p448/lib/ruby/1.9.1/csv.rb:1354:in `open'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:159:in `block in write_local'
from /home/r90t/.rvm/rubies/ruby-1.9.3-p448/lib/ruby/1.9.1/benchmark.rb:295:in `realtime'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:158:in `write_local'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/control/source/database_source.rb:115:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:333:in `each_with_index'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:333:in `block in process_control'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:327:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:327:in `process_control'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:275:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:272:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/directives.rb:41:in `do_execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/directives.rb:15:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:90:in `block in execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:89:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/batch/batch.rb:89:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:300:in `process_batch'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:276:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:272:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/engine.rb:55:in `process'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:82:in `block in execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:80:in `each'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:80:in `execute'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/lib/etl/commands/etl.rb:90:in `<top (required)>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `block in require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:236:in `load_dependency'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/gems/activewarehouse-etl-1.0.0/bin/etl:28:in `<top (required)>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/etl:19:in `load'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/etl:19:in `<main>'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/ruby_noexec_wrapper:14:in `eval'
from /home/r90t/.rvm/gems/ruby-1.9.3-p448/bin/ruby_noexec_wrapper:14:in `<main>'
My database.yml is looks like this:
etl_source:
adapter: postgresql
encoding: unicode
database: shop
hostname: localhost
username: r90t
password: pass
etl_execution:
adapter: mysql2
database: shop_dwh
hostname: 127.0.0.1
username: r90t
password: pass
What should i do to resolve the problem?
Reply all
Reply to author
Forward
0 new messages