View previous topic :: View next topic
|
Author |
Message |
ravven16
New User
Joined: 22 Aug 2006 Posts: 16
|
|
|
|
Hi guys,
when deleting a particular row in a table iam getting an -803 error. As I was able to view only the front end screen I was not able to provide the exact query which is running in the back end.
Can you please let me know when this situation will occur.
Thanks and regards |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Probably, when a row is deleted, deleted row is inserted in a history table and this not working properly or error not handled properly. You would need to get to know what application is doing and what SQL's are executed for this operation.
And here is what -803 is:
Code: |
-803 AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX
SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO
ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING
ROW IS Xrid
Explanation: The table that is the object of the INSERT or UPDATE
operation is constrained (by UNIQUE INDEX in the INDEX SPACE
indexspace-name to have unique values in certain columns. Completion of
the requested INSERT or UPDATE would result in duplicate values occurring
in row rid.
If a view is the object of the INSERT or UPDATE statement, the table that
defines the view is constrained. The update might also be caused by a
DELETE operation of a parent row that cascades to a dependent row with a
delete rule of SET NULL.
System Action: The INSERT, UPDATE, or DELETE statement cannot be
executed. The object table is unchanged.
Programmer Response: Examine the definitions for UNIQUE INDEX in the
INDEX SPACE indexspace-name to determine the uniqueness constraint
|
|
|
Back to top |
|
|
raviprasath_kp Warnings : 1 New User
Joined: 20 Feb 2005 Posts: 65 Location: chennai
|
|
|
|
Mainly this error occours because
IN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'rid' |
|
Back to top |
|
|
|