Sonar

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3
• Fix Version/s: 1.3
• Component/s: Web
• Labels:

  None
• Environment:

  sonar with embedded Derby DB, running on JOnAS 4.8.6d

Hello,

I'm getting the following error when clicking on the small magnified icon in "measure breakdown > comments" in the "package" column. IMHO, these icons can be removed in this column as there is no "zoom" here.

Michel

—

ActiveRecord::ActiveRecordError: Syntax error: Encountered "NULL" at line 1, column 72.: SELECT * FROM project_measures WHERE (project_measures.snapshot_id IN (NULL) AND project_measures.metric_id = 33 AND project_measures.rules_category_id IS NULL AND project_measures.rule_id IS NULL) ORDER BY value

—

2008.06.11 15:26:30 ERROR rails.sonar

ActiveRecord::StatementInvalid (ActiveRecord::ActiveRecordError: Syntax error: Encountered "NULL" at line 1, column 72.: SELECT * FROM project_measures WHERE (project_measures.snapshot_id IN (NULL) AND project_measures.metric_id = 33 AND project_measures.rules_category_id IS NULL AND project_measures.rule_id IS NULL) ORDER BY value):
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:520:in `execute'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/base.rb:427:in `find_by_sql'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/base.rb:995:in `find_every'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/base.rb:418:in `find'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/models/breakdown_column.rb:37:in `initialize'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/models/breakdown.rb:32:in `new'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/models/breakdown.rb:32:in `initialize'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/models/breakdown.rb:29:in `upto'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/models/breakdown.rb:29:in `initialize'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/controllers/breakdown_controller.rb:38:in `new'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/app/controllers/breakdown_controller.rb:38:in `measures'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in `perform_action'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in `call_filters'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in `perform_action_with_filters'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in `perform_action_with_benchmark'
file:/D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/lib/jruby-complete-1.1.1.jar!/benchmark.rb:293:in `measure'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in `perform_action_with_benchmark'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in `perform_action_with_rescue'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in `process'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in `process_with_filters'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in `process_with_session_management_support'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in `process'
D:/melusine/Jonas/jonasbase1/work/webapps/jonas/single/sonar/WEB-INF/gems/gems/rails-1.2.6/lib/dispatcher.rb:41:in `dispatch'
:1

• Assignee:

  Simon Brandhof

  Reporter:

  Michel Pawlak

• Created:

  11/Jun/08 8:33 AM

  Updated:

  12/Aug/08 2:39 PM

  Resolved:

  13/Jun/08 7:47 AM