sonar runner - Update SonarQube 3.7.4 to 5.0 AddNetworkUseSubCharacteristic: Fail to upgrade database -


hi: both have errror when migrating:

the log:

2015.07.16 15:36:57 info  app[o.s.p.m.monitor] process[web] 2015.07.16 15:40:54 info  web[dbmigration]  ==  replacekeyregexpbykeysearchinmeasurefiltersdata: migrating ================ 2015.07.16 15:40:54 info  web[dbmigration]  ==  replacekeyregexpbykeysearchinmeasurefiltersdata: migrated (0.0150s) ======= 2015.07.16 15:40:54 info  web[dbmigration]   2015.07.16 15:40:55 info  web[dbmigration]  ==  addprovisioningpermission: migrating ====================================== 2015.07.16 15:40:55 info  web[dbmigration]  ==  addprovisioningpermission: migrated (0.1250s) ============================= 2015.07.16 15:40:55 info  web[dbmigration]   2015.07.16 15:40:55 info  web[dbmigration]  ==  addtechnicaldebttoissue: migrating ======================================== 2015.07.16 15:40:55 info  web[dbmigration]  -- add_column("issues", "technical_debt", :integer, {:null=>true}) 2015.07.16 15:40:55 info  web[dbmigration]     -> 0.0940s 2015.07.16 15:40:55 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:55 info  web[dbmigration]  ==  addtechnicaldebttoissue: migrated (0.0940s) =============================== 2015.07.16 15:40:55 info  web[dbmigration]   2015.07.16 15:40:55 info  web[dbmigration]  ==  renamewidgetsqalepyramidtotechnicaldebtpyramid: migrating ================= 2015.07.16 15:40:55 info  web[dbmigration]  ==  renamewidgetsqalepyramidtotechnicaldebtpyramid: migrated (0.0160s) ======== 2015.07.16 15:40:55 info  web[dbmigration]   2015.07.16 15:40:55 info  web[dbmigration]  ==  resizetimelinewidgets: migrating ========================================== 2015.07.16 15:40:55 info  web[dbmigration]  ==  resizetimelinewidgets: migrated (0.1090s) ================================= 2015.07.16 15:40:55 info  web[dbmigration]   2015.07.16 15:40:55 info  web[dbmigration]  ==  adduniqueconstrainttogroupsusers: migrating =============================== 2015.07.16 15:40:55 info  web[dbmigration]  -- remove duplications 0 user group associations 2015.07.16 15:40:55 info  web[dbmigration]     -> 0.0000s 2015.07.16 15:40:55 info  web[dbmigration]  -- add_index(:groups_users, [:group_id, :user_id], {:name=>"groups_users_unique", :unique=>true}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.6080s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  ==  adduniqueconstrainttogroupsusers: migrated (0.6240s) ====================== 2015.07.16 15:40:56 info  web[dbmigration]   2015.07.16 15:40:56 info  web[dbmigration]  ==  addcharacteristicscolumns: migrating ====================================== 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :parent_id, :integer, {:null=>true}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0160s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :root_id, :integer, {:null=>true}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0310s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :function_key, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0160s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :factor_value, :decimal, {:null=>true, :precision=>30, :scale=>20}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0150s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :factor_unit, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0160s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :offset_value, :decimal, {:null=>true, :precision=>30, :scale=>20}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0160s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :offset_unit, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0150s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :created_at, :datetime, {:null=>true}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0310s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  -- add_column("characteristics", :updated_at, :datetime, {:null=>true}) 2015.07.16 15:40:56 info  web[dbmigration]     -> 0.0160s 2015.07.16 15:40:56 info  web[dbmigration]     -> 0 rows 2015.07.16 15:40:56 info  web[dbmigration]  ==  addcharacteristicscolumns: migrated (0.1720s) ============================= 2015.07.16 15:40:56 info  web[dbmigration]   2015.07.16 15:40:56 info  web[dbmigration]  ==  migratecharacteristics: migrating ========================================= 2015.07.16 15:41:13 info  web[dbmigration]  ==  migratecharacteristics: migrated (17.1290s) =============================== 2015.07.16 15:41:13 info  web[dbmigration]   2015.07.16 15:41:13 info  web[dbmigration]  ==  addadministerissuesperm: migrating ======================================== 2015.07.16 15:41:28 info  web[dbmigration]  ==  addadministerissuesperm: migrated (14.7110s) ============================== 2015.07.16 15:41:28 info  web[dbmigration]   2015.07.16 15:41:28 info  web[dbmigration]  ==  removeuselesscharacteristicsdata: migrating =============================== 2015.07.16 15:41:28 info  web[dbmigration]  -- remove_column("characteristics", "quality_model_id") 2015.07.16 15:41:28 info  web[dbmigration]     -> 0.5300s 2015.07.16 15:41:28 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:28 info  web[dbmigration]  -- remove_column("characteristics", "depth") 2015.07.16 15:41:28 info  web[dbmigration]     -> 0.0940s 2015.07.16 15:41:28 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:28 info  web[dbmigration]  -- remove_column("characteristics", "description") 2015.07.16 15:41:28 info  web[dbmigration]     -> 0.0930s 2015.07.16 15:41:28 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:28 info  web[dbmigration]  -- drop_table(:characteristic_properties) 2015.07.16 15:41:29 info  web[dbmigration]     -> 0.5460s 2015.07.16 15:41:29 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:29 info  web[dbmigration]  -- drop_table(:characteristic_edges) 2015.07.16 15:41:29 info  web[dbmigration]     -> 0.0780s 2015.07.16 15:41:29 info  web[dbmigration]  -- drop_table(:quality_models) 2015.07.16 15:41:29 info  web[dbmigration]     -> 0.0780s 2015.07.16 15:41:29 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:29 info  web[dbmigration]  ==  removeuselesscharacteristicsdata: migrated (1.5290s) ====================== 2015.07.16 15:41:29 info  web[dbmigration]   2015.07.16 15:41:29 info  web[dbmigration]  ==  addpermtemplatekeypatterncolumn: migrating ================================ 2015.07.16 15:41:29 info  web[dbmigration]  -- add_column("permission_templates", :key_pattern, :string, {:null=>true, :limit=>500}) 2015.07.16 15:41:29 info  web[dbmigration]     -> 0.0150s 2015.07.16 15:41:29 info  web[dbmigration]     -> 0 rows 2015.07.16 15:41:29 info  web[dbmigration]  ==  addpermtemplatekeypatterncolumn: migrated (0.0150s) ======================= 2015.07.16 15:41:29 info  web[dbmigration]   2015.07.16 15:41:29 info  web[dbmigration]  ==  addnetworkusesubcharacteristic: migrating ================================= 2015.07.16 15:41:30 error web[o.s.s.ui.jrubyfacade]  fail upgrade database error has occurred, later migrations canceled:  activerecord::jdbcerror: ora-00904: "description": identificador no vĂ¡lido : insert characteristics (quality_model_id, kee, name, rule_id, depth, characteristic_order, description, enabled, parent_id, root_id, function_key, factor_value, factor_unit, offset_value, offset_unit, created_at, updated_at, id) values(null, 'network_use_efficiency', 'network use', null, null, null, null, 1, 10734, 10734, null, null, null, null, null, to_timestamp('2015-07-16 15:41:30:245000','yyyy-mm-dd hh24:mi:ss:ff6'), to_timestamp('2015-07-16 15:41:30:245000','yyyy-mm-dd hh24:mi:ss:ff6'), ?)     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb:183:in `ora_insert'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.rb:26:in `insert_with_query_dirty'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2967:in `create'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/timestamp.rb:53:in `create_with_timestamps'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/callbacks.rb:266:in `create_with_callbacks'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2933:in `create_or_update'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/callbacks.rb:250:in `create_or_update_with_callbacks'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2583:in `save'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/validations.rb:1089:in `save_with_validation'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/dirty.rb:79:in `save_with_dirty'     org/jruby/rubykernel.java:2227:in `send'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:182:in `transaction'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:196:in `save_with_transactions'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:196:in `save_with_transactions'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:727:in `create'     c:/program files (x86)/sonarqube-5.0/web/web-inf/config/../lib/../db/migrate/466_add_network_use_sub_characteristic.rb:42:in `up'     org/jruby/rubykernel.java:2223:in `send'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282:in `migrate'     jar:file:/c:/program%20files%20(x86)/sonarqube-5.0/lib/server/jruby-complete-1.7.9.jar!/meta-inf/jruby.home/lib/ruby/1.8/benchmark.rb:293:in `measure'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282:in `migrate'     org/jruby/rubykernel.java:2227:in `send'     c:1:in `migrate'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:491:in `migrate'     org/jruby/rubyproc.java:290:in `call'     org/jruby/rubyproc.java:224:in `call'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:576:in `ddl_transaction'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:490:in `migrate'     org/jruby/rubyarray.java:1613:in `each'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:477:in `migrate'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:401:in `up'     c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:383:in `migrate'     c:/program files (x86)/sonarqube-5.0/web/web-inf/config/../lib/database_version.rb:62:in `upgrade_and_start'     c:/program files (x86)/sonarqube-5.0/web/web-inf/app/models/database_migration_manager.rb:109:in `start_migration'     org/jruby/rubyproc.java:290:in `call'     org/jruby/rubyproc.java:228:in `call' 

it insert not deletes fields. failing in class addnetworkusesubcharacteristic can not find problem. , try several times backup , restore.

i migrating basis of oracle another, , same. error persists. !!


Comments

Popular posts from this blog

php - Zend Framework / Skeleton-Application / Composer install issue -

c# - Better 64-bit byte array hash -

python - PyCharm Type error Message -