Re-upgrade Delphi database

Created by QNE Software Sdn bhd, Modified on Fri, 1 Oct, 2021 at 2:14 PM by QNE Software Sdn bhd

Scenario 

Delphi database upgrade process was interrupted, maybe due to Server machine suddenly restart/shut down or connection to server machine was lost but when login database no longer prompts upgrade database message.

Recommended to perform re-upgrade database because you may encounter errors

Solution 

  1. Make sure all users have logout the database
  2. You alone login to the database
  3. Find out your current database version
  4. Go to Help > About
  5. In this example, my current Database version is 2014.5.0.752

 

6. Click OK to close

7. Go to File > Utilities > QNE Management Tools

8. Once QNE Management Tools opened up

9. Go to Tools > Intelligence SQL Queries

10. Tick “Overwrite Generated SQL”

11. Copy and paste below query into query box

12. “SET SYSTEMDATAVALUE =” to your previous database version 

13. “WHERE SYSTEMDATAVALUE =” to your current database version

UPDATE SYSTEMDATA 

SET SYSTEMDATAVALUE = '2014.5.0.751' 

WHERE SYSTEMDATAVALUE = '2014.5.0.752'

14. Click “Execute SQL” button and click “Exit” button

15. Close QNE Management Tools

16. Re-login your database

17. Delphi will prompt request upgrade message again

18. Click “Yes” to upgrade database


** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article