# DB migration debug : Unable to view projects in sonarqube after migration

**URL:** <https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949>\
**Category:** SonarQube Server / Community Build\
**Tags:** migration, sonarqube\
**Created:** [February 1, 2023, 7:29pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949 "2023-02-01T19:29:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jay98661](https://avatars.discourse-cdn.com/v4/letter/j/85f322/32.png) [@jay98661](https://community.sonarsource.com/u/jay98661)\
**Post date:** [February 1, 2023, 7:29pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949/1 "2023-02-01T19:29:00Z")

</div>

HI, I completed a sonarqube migration to enterprise edition, we did migrate on prem db postgres to aurora postgres in cloud. I did setup username password and URL to connect to DB. connection works but projects are not showing up in the UI. Can you anyone help me to debug the issue ? what check list do I have to do to verify this error ? I don’t see any error in web.log , it replaced new server ID that we have on prem.

---

<div class="post-metadata">

**Author:** ![ganncamp](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/ganncamp/32/1261_2.png) [@ganncamp](https://community.sonarsource.com/u/ganncamp)\
**Post date:** [February 2, 2023, 7:11pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949/2 "2023-02-02T19:11:45Z")

</div>

Hi,

Welcome to the community!

You say the projects aren’t showing up. Is that on the list of projects page or in the individual project homepages? The list of projects page is populated from the Elasticsearch indices, so you may need to force a reindexing. To do that

- shut the server down
- delete `$SONARQUBE-HOME/data/es7`
- restart the server

&nbsp;  
HTH,  
Ann

---

<div class="post-metadata">

**Author:** ![jay98661](https://avatars.discourse-cdn.com/v4/letter/j/85f322/32.png) [@jay98661](https://community.sonarsource.com/u/jay98661)\
**Post date:** [February 2, 2023, 7:40pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949/3 "2023-02-02T19:40:13Z")

</div>

I mean list of project pages in home screen. But I was able to update the db creating manual projects.

---

<div class="post-metadata">

**Author:** ![jay98661](https://avatars.discourse-cdn.com/v4/letter/j/85f322/32.png) [@jay98661](https://community.sonarsource.com/u/jay98661)\
**Post date:** [February 2, 2023, 8:17pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949/4 "2023-02-02T20:17:44Z")

</div>

It worked thank you Ann.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/system/32/31083_2.png) [@system](https://community.sonarsource.com/u/system)\
**Post date:** [February 9, 2023, 8:18pm UTC](https://community.sonarsource.com/t/db-migration-debug-unable-to-view-projects-in-sonarqube-after-migration/82949/5 "2023-02-09T20:18:37Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.