View previous topic :: View next topic
|
Author |
Message |
Gopal Tripathi
New User
Joined: 16 Sep 2009 Posts: 15 Location: Hyd,Ind
|
|
|
|
Hi,
We are getting below error in one of our application team-
"File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0723N An error occurred in a triggered SQL statement in trigger "D2UHR01.PAYERN_N". Information returned for the error includes SQLCODE "23505", SQLSTATE "PSRA1VRI,000022520E" and message tokens "2". SQLSTATE=09000
(SQLSTAT
Failed SQL stmt:UPDATE D2UHR01.PS_PAY_EARNINGS SET PAY_LINE_STATUS ='F' WHERE PAY_END_DT < '2011-05-15' AND PAY_LINE_STATUS NOT IN ('F','V')"
This is a probable error in one of the triggers of the table due to which the specified row is not getting inserted into the table.
Please help asap.
Thanks,
Gopal |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
1 - we do not do asap: we do as and when
2- you have been a member for almost 2 years, in that time there have been numerous posts telling members NOT to post attachments. If you are concientious about your job you would be reading all posts and you would have taken notice of this. |
|
Back to top |
|
|
Gopal Tripathi
New User
Joined: 16 Sep 2009 Posts: 15 Location: Hyd,Ind
|
|
|
|
Hi Nic,
sorry about the error log.
Thanks,
Gopal. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Quote: |
-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 X rid |
so see which columns are in index PSRA1VRI (probably PAY_LINE_STATUS)
and if you're lucky you can see which row with
Code: |
select * from D2UHR01.PS_PAY_EARNINGS A
where hex(rid(a)) = '000022520E' |
|
|
Back to top |
|
|
|