Kbase P23577: Connecting to UTF-8 database via SQL-92 and getting Internal error -1214 (see dsmret.h)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/3/2009 |
|
Status: Verified
SYMPTOM(s):
Connecting to UTF-8 database via SQL-92 and getting Internal error -1214 (see dsmret.h)
Using Sequences.
Client is SQL-92.
Database is UTF-8.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210051
[JDBC Progress Driver]:Internal error -1214 (see dsmret.h) in SQL from subsystem
DSM SERVICES function dsmSeqGetID called from seq_get_seq_id on for . Save log
for Progress technical support.
Executing SQL-92 statements like:
SELECT PUB.SequenceName.CURRVAL FROM PUB.TableName; or
SELECT PUB.SequenceName.NEXTVAL FROM PUB.TableName; or
INSERT INTO PUB.TableName(FieldName) VALUES (PUB.SequenceName.CURRVAL ); or
INSERT INTO PUB.TableName(FieldName) VALUES PUB.SequenceName.NEXTVAL);
FACT(s) (Environment):
Progress 9.1D
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1E
CAUSE:
Incorrect startup parameters are being used for the database.
FIX:
Use the proper startup parameters for a UTF-8 database.
If the utf8.pf file was copied to the DLC directory and renamed to startup.pf the proper startup parameters would have been used. If this was not done -cpinternal, -cpstream, and -codepage should be set as in the example below.
proserve db-name -cpinternal utf-8 -cpstream utf-8 -cpcase basic