Kbase P19167: Duplicate key error not reported by Oracle DataServer.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Oracle 8.x
Progress 9.1D
SYMPTOM(s):
Duplicate key error not reported by Oracle DataServer.
When creating duplicate record (with the existing value for unique index) in
Oracle (via the DataServer) the Oracle message is passed encapsulated into Progress 1502 error.
**unique constraint (user.table##field) violated (1502).
No relevant Progress error is generated (132, 2471,1443).
CAUSE:
The use of the "error 1502 context" to communicate error conditions raised by ORACLE is intentional, and is not "reserved for 'native' messages Progress cannot 'understand' ". This practice is used for a great many ORACLE errors, and is intended to provide additional, more precise information to the user, to aid in diagnosing and correcting the problem. This practice was instituted as a result of numerous customer requests.
FIX:
This is an expected behavior.