CODEWITHSUNDEEP
databasesonarqubesonarqube5.3sonarqube-ops
AmitP
AmitP

Reputation: 21

Broken project links post data copy from existing database to new database with collation change

We have recently upgraded Sonar to 5.3 version. Sonar has collation requirement (Latin1_General_CS_AS). Collation on our existing DB is - Latin1_General_CI_AS

Followed below steps: 1. Got a new DB with new collation. 2. Setup the Sonar instance on the new DB. This created the required tables. 3. Truncated data on the new DB(basically drop and recreated tables) 4. Did a SELECT INSERT to copy data from existing DB to new DB.

I am aware of Sonar DB copy tool but I believe this is only for Enterprise version. (http://docs.sonarqube.org/display/SONAR/Sonar+DB+Copy+Tool)

Sonar is up and running but we see the project links are broken. Is there a proper method to migrate data from old DB to new DB in Sonar?

I see below error in sonar log:

2016.07.07 14:59:29 ERROR web[o.s.s.ui.JRubyFacade] Fail to render: http://:42224/dashboard/index/20464 undefined method project' for nil:NilClass <INSTALL PATH>/web/WEB-INF/app/controllers/dashboard_controller.rb:53:inindex'

Upvotes: 0

Views: 153

Answers (1)

Simon Brandhof
Simon Brandhof

Reputation: 5136

DB collation is automatically fixed in version 5.6, so I recommend to upgrade to this version instead of 5.3. It will avoid potential corrupted data introduced with your copy operation (for instance are the IDs correctly copied) ?

Upvotes: 1

Related Questions