Hello,
When I try to see DASHBOARD page, Foreman gives out the "Error 500"

Processing DashboardController#index (for 172.30.64.135 at 2010-12-17 11:19:39) [GET]

ActiveRecord::StatementInvalid (OCIError: ORA-00936: missing expression: SELECT count(*) AS count_all FROM "HOSTS" WHERE (((puppet_status > 0) and
((puppet_status >> 12 & 63) != 0) or
((puppet_status >> 18 & 63) != 0) or
((puppet_status >> 24 & 63) != 0)) AND (last_report > TO_TIMESTAMP('2010-12-17 07:44:39:555877','YYYY-MM-DD HH24:MI:SS:FF6'))) ):
/usr/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:948:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:906:in `select'
app/controllers/dashboard_controller.rb:39:in `prefetch_data'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /var/rails/foreman/public/500.html (500 Internal Server Error)

I have not understood your SELECT design:
((puppet_status >> 12 & 63) != 0) or
((puppet_status >> 18 & 63) != 0) or
((puppet_status >> 24 & 63) != 0))
and have no work variants this condition in PL/SQL