Project

General

Profile

Feature #546

Updated by Tomer Brisker over 6 years ago

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

Back