TABLE sqlplus_product_profile is not present in the DESTINATION database

Hello there,

I have a Sonarqube installation from zip (10.5) with an Oracle database that I’d like to transfer
to a Docker installation with a Postgresql database.

I did the following operations :

  • start from scratch Sonarqube 10.5 docker and Postgresql database. Log file regarding database initialisation attached.
  • stop Sonarqube Docker.
  • stop Sonarqube zip.
  • launch DB Copy. Full operation in attached file.

DB Copy finished with error TABLE sqlplus_product_profile is not present in the DESTINATION database and has not been copied.

Can someone please help with this error ?

DB COPY Sonarqube.txt (103.8 KB)
DB init Sonarqube.txt (32.1 KB)

Hey there.

If that’s the only error you got (and it appears to be), then it seems like this was a leftover table in your Oracle database that you can safely ignore. A quick google search shows it’s related to a “sqlplus” product I’m not personally familiar with.

Hi Colin,
After some good sleep, I have a better look at the logs now :).
So there’s only one table in error and I can probably safely ignore it. OK for that.
I would just confirm that migration tool didn’t stop in the middle of the process and it had nothing more to do after copying data.
Best regards,

At this point in the logs, it was just doing sanity checks, and it reports all the checks, so this was the only failing one and you should feel confident to move forward. :slight_smile:

Thanks for confirmation.
So, I did start my docker Sonar and changed base url. It seems ok, but I can see no projects on the home page. When browsing administration/projects, I can find my projects. Datas are the same as in the migrated server. But when I open the server as anonymous, the home page is empty (have the list of projects on source server) and when connected as admin, project page redirect to “create a project”.
note: this is an enterprise edition. I have a license wich is no more valid after migration “Your license is no longer valid because the ServerID has changed”. So I asked a grace period “Your grace period will end on August 5, 2024”.

I did a full reindex and everything is fine now.
Thanks for help.

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