Feature #545

Updated by Tomer Brisker over 8 years ago

Hello, 
 
 I try to see all puppet classes for ENVIRONMENT (http://srv2-itd-sag04.net.billing.ru:3000/environments) page. After click in "http://srv2-itd-sag04.net.billing.ru:3000/puppetclasses?search[environments_id_equals]=10000" link Foreman is returning Internal Error 500. In error_log: 
 
 Processing PuppetclassesController#index (for 172.30.64.135 at 2010-12-17 10:40:01) [GET] 
   
   Parameters: {"search"=>{"environments_id_equals"=>"10000"}} 

 

 ActiveRecord::StatementInvalid (OCIError: ORA-00918: column ambiguously defined: select * from (SELECT "PUPPETCLASSES".* FROM "PUPPETCLASSES"     INNER JOIN "ENVIRONMENTS_PUPPETCLASSES" ON "ENVIRONMENTS_PUPPETCLASSES".puppetclass_id = "PUPPETCLASSES".id    INNER JOIN "ENVIRONMENTS" ON "ENVIRONMENTS".id = "ENVIRONMENTS_PUPPETCLASSES".environment_id    WHERE (environments.id = 10000)    ORDER BY name) where rownum <= 20): 
   
   /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/puppetclasses_controller.rb:8:in `index' 
   
   app/controllers/puppetclasses_controller.rb:5:in `index' 
   
   /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) 

 

 Working request on PL/SQL looks as: 
 
 SELECT * FROM (SELECT "PUPPETCLASSES".* FROM "PUPPET"."PUPPETCLASSES" 
 
 INNER JOIN "PUPPET"."ENVIRONMENTS_PUPPETCLASSES" ON "ENVIRONMENTS_PUPPETCLASSES".puppetclass_id = "PUPPETCLASSES".id   
   
 INNER JOIN "PUPPET"."ENVIRONMENTS" ON "ENVIRONMENTS".id = "ENVIRONMENTS_PUPPETCLASSES".environment_id   
   
 WHERE (environments.id = 10000)    ORDER BY environments.name) where rownum <= 20; 
 
 Couldn't you editing in used controllers?

Back