Dashboards are not updated after restoring RTC db online backups
a) JTS (JTS db) b) JAZZ (for RTC) c) RICM (RRDI content store db) and d) RIDW (dataware house db)
Recently, we have tried restoring this online db's to one of the test server to do some tests with production data. But dashboards does not appear to be updated as like in production. The remaining data like WorkItems, SCM etc..looks good.
Here are the steps followed:
a) Restore online backup db's JTS, JAZZ, RICM and RIDW db's to test server
b) Rebuild the indices
./repotools-jazz.sh -rebuildTextIndices
./repotools-jts.sh -rebuildTextIndices
c) Run the reindexes
./repotools-jazz.sh -reindex all
./repotools-jts.sh -reindex all
Do we missed something here? any thoughts would really help us. Thanks
One answer
Comments
Yes Stephanie. Production is based on 'Basic' and Test is on 'Form' based authentication. Is this really matters on dashboard issue? If then, it will effect only personal dashboards in my opinion. But, I see the same problem with Project dashboards as well.
Here is the related defect for the personal dashboards:
https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=279722
I agree that this shouldn't affect project dashboards, but since your test is not an exact replication of your production, that may be why. Is the public URI/hostname different? If so, you will need to do a server rename.
Yes, Public URI is different for test server as per the teamserver properties was set.
After db restore, only thing i did was change of "friends" and "registered applications" related to test server from production server on admin page.
Is this dashboards link to public URI? do we need to keep same public URI as production? What is the ideal way that we can replicate as same as production?
Yes, you can't just change the teamserver.properties file for a different public URI. We save most of the artifacts with the URI information. You will need to do a full server rename.