Feature #546

Updated by Tomer Brisker over 8 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