Exact Financials

Technical manuals Exact Financials - Database migration 7.x to 7.27 Progress (Change codepage to UTF-8)

Exact Financials UTF-8 Migration manual

When Exact Financials is updated to 7.25 you also need to change the codepage of your databases. In this manual the databases are named 'exactcs' and 'edis'.
After installing an upgrade you normally start the AppServer. However when updating from a version equal to or lower than 7.24 the Appserver will refuse to start. In the AppServer server log you will find a message like: 'Database 'exactcs' has codepage 'ISO8859-1', it should be 'UTF-8' - quitting to prevent data corruption.'

To resolve this you need to change the codepage of the database from ISO8859-1 to UTF-8. This manual will explain how to achieve this for Progress OpenEdge Database. The codepage should be changed before the regular conversionscripts are run.

Progress OpenEdge:

1. Make sure there a full backup of the database has been made.
2. Make sure your database is in single-user mode.
3. Open the progress command line utility 'proenv' from Start/Progress.
4. Change the directory to the databasedirectory.
• For example: cd C:\exact\financials\db
5. Now execute the command below where exactcs is the filename.db of the database you wish to convert. This will convert the database.
• Proutil exactcs -C convchar convert utf-8
6. Now execute the command below to open the Progress Data Administration.
• Prowin -p _admin -db exactcs -1
7. In the Progress Data Administration go to "Admin: Load Data and Definitions, Data Definition (.df file)...".
8. Load the definition from %DLC%\prolang\utf\_tran.df. %DLC% is the Progress Openedge installation directory. Per default this is "C:\Progress\OpenEdge".
9. After the load has been completed exit the Progress Data Administration.
10. From proenv execute the command below to rebuild all indexes.
• proutil exactcs -C idxbuild -cpinternal utf-8.
11. Repeat the steps above for the EDIS database.
12. You can now execute the required update scripts from "\\<Install directory Exact Financials>\cd\db\mss" or let the system handle this by starting the Appserver, WebSpeed, PASOE or Scheduler.