| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Aggregation error |
« View previous topic :: View next topic » |
| Author |
Message
|
| Lillian |
 Posted: Wed Dec 01, 2004 5:29 am Post subject: Aggregation error |
 |
|
Centurion
Joined: 15 Apr 2002
Posts: 102
|
Using wmqi 2.1 cd04
I simple flow fanning out 2 request to back end and each sending one reply. The responses come back but they either fail or propogated to unknown and timeout terminal
Exception on reply( one of the two replies - rolling back at the aggr reply node)
'[IBM][CLI Driver][DB2/SUN] SQL0803N One or more values in the INSERT statement, UPDATE statement, or f
oreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified b
y "1" constrains table "MQADMIN.BAGGREGATE" from having duplicate rows for those columns. SQLSTATE=23505
I have checked the values of correlid of reply and msgid of request and they match.
What am I overlooking? |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Dec 01, 2004 7:07 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
AFAIK, there are two conditions where this error occurs:
- At least two of the messages in the fan-out process have the same msgid attached
- One of the messages in the fan-out process has the same msgid as a previous message that was never resolved, and so a row remains on the BAGGREGATE table.
|
|
| Back to top |
|
|
| Lillian |
| Posted: Mon Dec 06, 2004 1:02 am Post subject: |
|
|
Centurion
Joined: 15 Apr 2002
Posts: 102
|
Thanks , the problem was related to the messages Id.
Please note that the aggregation assumes that the backend populates the corrleid of the reply with the msgid of request, otherwise the reply is UNKNOWN.
Regards
Lillian |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
