jira.codehaus.org

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What?s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Sonar
  • SONAR-292

Can not install with SQL Server 2005

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

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

Description

Email from gommo :

I can't get Sonar to update our 1.2.1 MsSQL sonar database to 1.3

This is the error I get
2008.06.26 13:40:30 ERROR rails.sonar

ActiveRecord::StatementInvalid (ActiveRecord::ActiveRecordError: Table
INFORMATION_SCHEMA. does not exist: SELECT CONSTRAINT_NAME FROM
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = 'projects' and
COLUMN_NAME = 'group_id'):

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
`log'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:520:in
`execute'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:580:in
`select'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/jdbc_adapter/jdbc_mssql.rb:253:in
`remove_check_constraints'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/jdbc_adapter/jdbc_mssql.rb:239:in
`remove_column'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:275:in
`method_missing'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:259:in
`say_with_time'

file:/E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/lib/jruby-complete-1.1.1.jar!/benchmark.rb:293:in
`measure'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:259:in
`say_with_time'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:273:in
`method_missing'

E:/BuildServer/sonar-1.3/war/sonar-web/app/controllers/../../db/migrate/035_projects_to_entities.rb:48:in
`up'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:212:in
`migrate'

file:/E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/lib/jruby-complete-1.1.1.jar!/benchmark.rb:293:in
`measure'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:212:in
`migrate'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:335:in
`migrate'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:330:in
`each'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:330:in
`migrate'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:297:in
`up'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:288:in
`migrate'

E:/BuildServer/sonar-1.3/war/sonar-web/app/controllers/setup_controller.rb:48:in
`setup_database'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
`perform_action'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in
`call_filters'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in
`perform_action_with_filters'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'

file:/E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/lib/jruby-complete-1.1.1.jar!/benchmark.rb:293:in
`measure'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in
`perform_action_with_rescue'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
`process'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in
`process_with_filters'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in
`process_with_session_management_support'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in
`process'

E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/rails-1.2.6/lib/dispatcher.rb:41:in
`dispatch'

file:/E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/lib/goldspike-1.6.1.jar!/builtin/rails-integration/session/java_servlet_store.rb:1

I also tried with a blank database and it failed as well.

Is it known to work on SQL Server 2005

Activity

  • All
  • Comments
  • Work Log
  • History
  • Activity
There are no comments yet on this issue.

People

  • Assignee:
    Simon Brandhof
    Reporter:
    Simon Brandhof
Vote (0)
Watch (0)

Dates

  • Created:
    27/Jun/08 1:19 AM
    Updated:
    03/Jul/08 8:17 AM
    Resolved:
    02/Jul/08 2:58 AM
  • Atlassian JIRA (v5.0.4#731-sha1:3aa7374)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.