Kbase P15510: [JDBC Driver]:Internal error 2 ... convert_buffer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/10/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error on CREATE VIEW
SQLState=HY000
ErrorCode=-219901
[JDBC Progress Driver]:Internal error 2 (A buffer other than the NLS system handle memory was not large enough) in SQL from subsystem NLS SERVICES function convert_buffer called from ssm_get_tree on . for . Save log for Progress technical support.
CAUSE:
Bug# 20030528-036
CAUSE:
Error message complains about"NLS Buffers" (NLS = Native Language Support)
FIX:
There are three workarounds.
1. Rebuilding the convmap.cp with a utf-8.dat that has the newly added conversion table between the codepage and UTF-8. Here are the steps:
1) Save $DLC/prolang/convmap/utf-8.dat
2) Save the attached file as $DLC/prolang/convmap/utf-8.dat
3) Run
proutil -C codepage-compile $DLC/prolang/convmap/convmap.dat <newconvmap>.cp
where <newconvmap>.cp can be convmap.cp or another name.
4) Either place convmap.cp into $DLC, or use the environment variable, PROCONV to point to the new .cp file.
5) Restart database.
2. Use an ODBC client instead of SQL Explorer which is JDBC.
For this to work with an ODBC client and an ISO8859-15 database, you need to set the SQL_CLIENT_CHARSET environment variable to SQL_CLIENT_CHARSET=ISO8859-15 before starting up your ODBC client (WinSQL for example).
3. Convert the db to ISO8859-1 (or 1252) by doing:
1) proutil [db name] -C convchar convert ISO8859-1
2) proutil [db name] -C idxbuild