no interface action for sender or receiver found - SMQ2 SYSFAIL

[former_member235717]

Hi All,

I have a Proxy to Proxy scenario in which data is coming from SRM and going to ECC.

The issue is messages are getting processed successfully in PI and in ECC the messages is stuck in SMQ2 showing SYSFAIL.

When I went and saw the trace it says "no interface action for sender or receiver found".

I took the payload and processed in sproxy and it executed successfully.

Not sure why the messages are getting stuck in the queue.

[former_member184720 · Accepted solution]

Hi Swetha - Can you check below thread if it helps..?

http://scn.sap.com/thread/2145373

[former_member235717 · Accepted solution]

I did check that Link. But in my case I have the status text as "The ABAP/4 Open SQL array insert results in duplicate"

[former_member184720 · Accepted solution]

It might be a duplicate record. You said you have executed the proxy manually and it was successful. So records might have inserted in the tables.

Can you ignore this message(move to smq3) and try processing the next message?

Are you getting this error in dumps(st22)? or in SXMB_MONI? will you be able to provide the complete log?

Message was edited by: Hareesh Gampa

[former_member235717 · Accepted solution]

This issue had been in Production. We are trying processing new data , but still the issue persists.

[former_member235717 · Accepted solution]

Here is the trace i'm seeing:

<Trace level="3" type="T">Persisting message Status = 001</Trace>

<Trace level="3" type="T">Message version 000</Trace>

<Trace level="3" type="T">Pipeline RECEIVER</Trace>

<Trace level="1" type="T">--start of determination of sender interface action</Trace>

<Trace level="1" type="T">select interface</Trace>

<Trace level="1" type="T">select interface namespace</Trace>

<Trace level="1" type="T">no interface action for sender found</Trace>

<Trace level="1" type="T">hence keep interface action INIT</Trace>

<Trace level="1" type="T">--end of determination of sender interface action</Trace>

<Trace level="1" type="T">--start of determination of receiver interface action</Trace>

<Trace level="1" type="T">number of services: 0000000001</Trace>

<Trace level="1" type="T">loop 0000000001</Trace>

<Trace level="1" type="T">select interface XXX_In</Trace>

<Trace level="1" type="T">select interface namespace http://XXX.com2</Trace>

<Trace level="1" type="T">end of loop 0000000001</Trace>

<Trace level="1" type="T">no interface action for sender or receiver found</Trace>

<Trace level="1" type="T">hence set interface action to DEL</Trace>

<Trace level="1" type="T">--end of determination of receiver interface action</Trace>

</SAP:Trace>

[Former Member · Accepted solution]

Hi Swetha

Where are you seeing the dump -

The ABAP/4 Open SQL array insert results in duplicate"

It would suggest that you are trying to insert duplicate data into the system .  Can you verify with the actual data.

Also in which system are you getting this problem. Sometimes the duplicate data problem comes in QA systems post client refresh due to number range issues.

Thanks

Rishi

[former_member184720 · Accepted solution]

Where are you getting this?

The ABAP/4 Open SQL array insert results in duplicate? in ST22?? or while executing the proxy?

[former_member235717 · Accepted solution]

This is when I open the Queue in SMQ2 and double click on the Queue name , I got that status text.

And when I drilled down further and went to sxmb_moni green flag is checked .

Actually this is an issue in production system. We then tried with multiple data entries in QA which are resulting with the same issue.

What exactly is the this trace message meant to be "no interface action for sender or receiver found".

I checked in the ID and everything looks good to me

[former_member235717 · Accepted solution]

In SMQ2 -->

Cl. Queue Name               Entries    Status   Date 1     Time 1   NxtDate           NxtTim                  Sender ID                        Wait for queue

XBTR0009                         1  SYSFAIL

And when I double click the queue name  I can see the below message :

Cl.       User                  Function Module                 Queue Name                Date        Time                       StatusText

The ABAP/4 Open SQL array insert results in duplicate

[Harish · Accepted solution]

Hi Swetha,

Please check the below links

Duplicate database records. | SCN

SR053: The ABAP/4 Open SQL array insert results in duplic ke | Enterprise Services in Purchasing Pr...

The issue seems to be more relevant to function data of the message. Please check in which process message in used (OTC, WMS etc) and check if you have any duplicate key with that data or process.

regards,

Harish

[Former Member · Accepted solution]

Hi Swetha,

Please check this link. It may help you.

Regards,

Reema