on 10-20-2011 3:10 PM
Hi experts,
There was a full log problem in production PI server (PI 7.1) yesterday nigh and some messages of a particular interface got stuck. The interface scenario is IDoc > PI > SQL.
After basis team checked that today morning, I see that for this interface, messages are not being processed and for each new IDoc sent, there is no new message in PI (maybe SMQ1 from ECC is stuck).
Now I can see that there are 3 messages in SXMB_MONI (the newest ones):
Status Start Time End Time
Still Awaiting Ack 16:30:52 08:10:15
Proc. Successfuly 16:30:52 16:30:52
Canceled Since Already Processed 16:30:52 08:10:15
How can I delete or fix the Canceled Since Already Processed?
This msg (EOIO), in the Message System, has status = Delivering and I don't have option to anything.
There is also a new message after that, with status = Holding, which gives me the option to Delete it, but when I try to do so, Message System shows me a Java error saying:
There was an error processing your request.
com.sap.engine.interfaces.messaging.api.message.MessageAccessException: Could not fail message. Reason: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not fail message 0050568e-327e-1ee0-bed3-335c7e2b3100(INBOUND), as triggered by admin action. Reason: Predecessor not in final state.
Could you please help on that urgent problem?
Tks!
Rafael,
It apeares to be no simple issue.
I'd open a VH message in BC-XI component.
BR,
Henrique.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Canceled msg, in SXMB_MONI, shows the following:
<SAP:Category>XIProtocol</SAP:Category>
<SAP:Code area="MESSAGE">DUPLICATE_DETECTED</SAP:Code>
<SAP:P1 />
<SAP:P2 />
<SAP:P3 />
<SAP:P4 />
<SAP:AdditionalText>com.sap.engine.interfaces.messaging.api.exception.DuplicateMessageException: Message Id 0050568e-327e-1ee0-bed3-3383d5007100(INBOUND) already exists in duplicate check table: com.sap.sql.DuplicateKeyException: Violation of PRIMARY KEY constraint 'PK__BC_MSG_D__99C1915D3336943B'. Cannot insert duplicate key in object 'SAPPP1DB.BC_MSG_DUP_CHECK'.</SAP:AdditionalText>
<SAP:Stack />
I've checked the thread and also without success.
Tks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The message with status Delivering in Message System, has the following audit log error:
"Putting message into receive queue failed, due to: com.sap.engine.interfaces.messaging.api.exception.DuplicateMessageException: Message Id 0050568e-327e-1ee0-bed3-3383d5007100(INBOUND) already exists in duplicate check table: com.sap.sql.DuplicateKeyException: Violation of PRIMARY KEY constraint 'PK__BC_MSG_D__99C1915D3336943B'. Cannot insert duplicate key in object 'SAPPP1DB.BC_MSG_DUP_CHECK'.."
And everything after that is stopped.
Nothing stopped at Inbound Queue.
Please help.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.