Unicode Database Upgrade (SQL Financial Accounting 5)

From eStream Software

Must Do List

1. Backup all the databases from Version 4 before upgrade.
2. Remove/Uninstall the previous Firebird version installed, ie. 1.5, 2.0, 2.5.
3. Install Firebird 3.0.1.
4. Install SQL Financial Accounting 5 (32 bits), version: 5.2016.790.737.
5. For Windows XP user ONLY, a minimum requirement must have Service Pack 3 (SP 3). To download the SP3 click here.
How to check the Service Pack in Windows XP?
1. Click on Windows Start.
2. Right click on My Computer.
3. Select Properties.
4. Check and make sure it is Service Pack 3.
Core-Unicode 32.jpg


6. Check the System Locale in Regional setting.
6.1 Go to Control Panel.
6.2 Look for Regional setting. See screenshot below.
Core-Unicode 14.jpg


6.3 Click on Administrative tab. Check the Language for non-Unicode programs, eg. English (United States) or Chinese (Simplified, China).
Core-Unicode 15.jpg


Important:
To ensure the encoding conversion correctly, please ask the user the following questions:
 1. Do you key-in any Chinese or other than English words in the database?. 
 2. What type of language input using? Simplified or Traditional Chinese?


7. Check Local C drive free spaces (follow the Windows drive). Recommended 25GB free space or more.
8. Restore the database from the backup file.


Unicode Upgrade Steps (applicable to SQL Financial Accounting version 5.2016.793.738)

Before start upgrade, please make sure all the database has BACKUP.

1. Check your current DB folder directory by right click on database group properties.
Core-Unicode 40.jpg


2. Rename your current DB folder which has stored all the database files. For example, rename the existing DB folder to DB_Old.
Core-Unicode 38.jpg


3. Uninstall the previous Firebird and SQL Financial Accounting version 4.
4. Install the Firebird 3.0.1. Click here to get Firebird 3.0.1 installation guide.
5. Install the SQL Financial Accounting version 5 (NEW).
6. Execute the SQL Financial Accounting 5 (Version: 5.2016.790.737 and above).
7. Right click on the existing Database Group. Select to Remove Database Group to remove.
Core-Unicode 39.jpg


8. Click Create Group to replace the existing Default.dcf.
9. At the Database Group properties (default.dcf), the folder should point to the c:\eStream\SQLAccounting\DB.
Core-Unicode 40.jpg


10. Restore the database from the backup file.
11. Login the database restored.
12. Click on Yes to confirm proceed the database upgrade.
Core-Unicode 01a.jpg


13. Choose an appropriate encoding. Select Default - Windows 1252 ANSI if your server current language for non-Unicode programs is "English (United States)".
Core-Unicode 02.jpg


14. For more info about choosing a correct encoding, see the check list table below.
No. SQL encoding Regional setting (non-Unicode language)
1. Defaul-Windows 1252 ANSI All English, ie. English (United Kingdom), English (Malaysia), English (Singapore), etc.
2. Simplified Chinese 简体中文 Chinese Simplified ONLY, ie. Chinese (Simplified, China), Chinese (Simplified, Singapore)
3. Traditional Chinese 繁体中文 Chinese Traditional ONLY, ie. Chinese (Traditional, Hong Kong SAR), Chinese (Traditional, Taiwan)
4. Firebird NONE character set NONE encoding (Not recommended to use). For Firebird programmer use.
5. Database Encoding Diagnosis (For Chinese only To analyse the encoding (for Chinese character) able to read by your eyes.


15. Upgrade database started.
Core-Unicode 03.jpg


16. Transliterate to Unicode sample list out.
Core-Unicode 04.jpg


17. Click on Yes to proceed upgrade if you are confirm the characters are meaningful to read.
Core-Unicode 05.jpg


Note:
If you have click on No, you will get prompt an operation aborted. Press Ok to exit the message.
Core-Unicode 06.jpg
18. Upgrade database continue... (estimate upgrade duration : 15 -30 mins per database)
Core-Unicode 07.jpg


19. Database upgrade successfully, Old Database link will be DROP and New Database link will be ADD (new database file created automatically).
Core-Unicode 08a.jpg


20. Re-login with New Database. Usually you can identify the new database at the remark, eg. Unicode from Old Database filename.
Core-Unicode 09.jpg


Example:
OLD database filename: ACC-0003.FDB (DROP)
NEW database filename: ACC-0001.FDB (ADD)


At the new database file (ACC-0001), you will see a remark displayed as Unicode from ACC-0003.


Possible Error and Solution

1. Unsupported on-disk structure for file (found 11.2, support 12.0)

Core-Unicode 22.jpg


Solution:
Restore the database from the backup file.


2. Unable to find vendor library of database with ODS version 11.2

Core-Unicode 23b.jpg


Solution:
Restore the database from the backup file.



3. Access violation at address....in module msxml6.dll

Core-Unicode 23.jpg


Solution:
Retry to upgrade the database again.


4. The following error(s) have occured invalid class typecast

Core-Unicode 24.jpg


Solution:
Uninstall the previous SQL Account (64 bits). Download the setup-x86 file (32 bits) and install again.


5. Cannot transliterate character between character sets

Core-Unicode 25.jpg


Solution:
Run the Database Encoding Diagnosis (For Chinese only).


6. Cannot make field X_CODE of table AGENT NOT NULL because there are NULLs present at procedure MIGRATE line:32,col:5

Core-Unicode 33.jpg


Solution:
Make sure you have upgrade the database from Version 3 to 4 first. Next, backup the database from Version 4 and restore into Version 5 to start upgrade.


7. Malformed String message at Supplier Contra

Edit the Supplier Contra and get prompt this error.
Core-Unicode 34.jpg


Solution:
Re-download the latest SQL Financial Accounting. Uninstall and install the SQL Financial Accounting.


8. Application Error while try to run the SQL Accounting in Windows XP

Core-Unicode 35.jpg


Solution:
Update the Windows XP to Service Pack 3. To download the SP3 click here.
How to check the Service Pack in Windows XP?
1. Click on Windows Start.
2. Right click on My Computer.
3. Select Properties.
4. Check and make sure it is Service Pack 3.
Core-Unicode 32.jpg


9. You are trying to login "" database

Core-Unicode 36.jpg


Solution:
Firstly, uninstall the SQL Financial Accounting. Check the ...\SQL Financial Accounting\Bin folder. If you have found any filename with extension ie. bpl, dll and exe in that folder, please remove it completely. Lastly, re-install the SQL Financial Accounting again.


10. Unable To Locate Component (MSVCR100.dll) database

Core-Unicode 37.jpg


Solution:
You may uninstall any existing Microsoft Visual C++ Redistributable Package and install the latest Microsoft Visual C++ 2010 Redistributable Package and check if it helps.
Step 1:
Uninstall the package:
a. Open Programs and Features.
b. From the list, find Microsoft Visual C++ Redistributable Package and click on it.
c. Click Uninstall at the top of the list.


Step 2:
Microsoft Visual C++ 2010 Redistributable Package (x86). Download for Windows 32 bits, click HERE.
Microsoft Visual C++ 2010 Redistributable Package (x64). Download for Windows 64 bits, click HERE.


11. Prompt access violation on module vcl240.bpl

This norm happen on the pc with old version (eg windows xp below service pack3 or Windows Server 2003).

Solution

Just download & install
Windows Imaging Component => https://www.microsoft.com/en-us/download/details.aspx?id=32

Advantages of Unicode Database

1. No longer need to set your system locale

You able to read, key-in and store the Chinese Simplified characters without change the system locale.
Core-Unicode 10a.jpg


2. Multi-Language Support in Single Database

2.1 Capable to store different language characters (ie. English, Simplified Chinese, Traditional Chinese, Vietnamese, Japanese, Arabic, etc...) in a database.
Core-Unicode 11.jpg


2.2 All reports are support multi-languages.
Core-Unicode 13.jpg


3. Free to search any characters in single database

You are free to search the keyword from the language that has stored in the database.
Core-Unicode 12c.jpg


Optional: Database Encoding Diagnosis (For Chinese only)

Reason to use

Failed to perform database upgrade due to the database could have contains other characters (eg. UTF-8 character set which is copy from others source eg. internet webpage).


Steps

1. Select encoding option: Database Encoding Diagnosis (For Chinese only).
Core-Unicode 26.jpg


2. Select Simplified Chinese 简体中文 - GB18030.
Core-Unicode 27.jpg


3. For example, if you have found the value is not meaningful to read in Converted Value (By Encoding) column, then you have to fix it.
Core-Unicode 28.jpg


Note:
1. If you have found the value is meaningful to read in Converted Value (By Encoding) column, then do not fix it. 
2. Click on Cancel button to exit.
Core-Unicode 29a.jpg


4. Click on Fix All button to fix the value in the list. It will converted as shown in the Fix Value (UTF8) column.
Core-Unicode 29.jpg


Note: 
You can choose to delete the line from the list that you do not wish to fix it.


5. Click on No to proceed the fixing database encoding.
Core-Unicode 30.jpg


6. Click on Yes to confirm the fixing database encoding.
Core-Unicode 31.jpg


7. After this, repeat the Unicode Database Upgrade Step 3 onwards.

See also

Retrieved from "https://wiki.sql.com.my/index.php?title=Unicode_Database_Upgrade_(SQL_Financial_Accounting_5)&oldid=6510"
Last modified
This page was last edited on 20 December 2016, at 01:46.