Kbase P21780: Referencing a non existing sequence causes JDBC -1214 error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
=== 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);
CAUSE:
PUB.SequenceName does not exist or not spelled correctly.
FIX:
Ensure that The seuqnece PUB.SequenceName exists and is spelled correctly.