JDBC to PROXY, payload missing in soap receiver

[former_member457843]

Hi Experts,

I got a problem during JDBC sender to PROXY receiver:

Our scenario is select data from oracle and then send to SAP system.

At first I config ICO without receiver like this

Then I found no receiver component in monitor and got error message like this:

Still, I can see payload here is correct.

OK, so I add a receiver in ICO like this.

And found the receiver component came out in monitor and message inbound into EWM successfully. but the payload missing this time.

Anyone can help?

[manoj_khavatkopp · Accepted solution]

Hi Cao,

• Check if you have any condition in interface determination if yes then check if the incoming xml satisfies it.
• In your Sender channel you need to enter the message type name and namespace that should match with your message type of source service interface in ESR.
• Try Removing the SWCV from inbound and Receiver interface tab.

Br,

Manoj

[former_member457843 · Accepted solution]

No condition in interface determination, and the sender JDBC channel seems no error.

[manoj_khavatkopp · Accepted solution]

Can you please put the namespace as well of your sender message type.

[former_member457843 · Accepted solution]

Hi Manoj,

You got the point, now it works fine.

Thank you.

[former_member190293]

Hi Cao!

Just for case: first time you selected data from DB.

Didn't you set any flag for that data that marked it as processed? Are you sure there is any data to select with your next queries?

Regards, Eugene.

[former_member457843]

First question,once I got the data, record will be delete from database.

Second question, Yes, for next query with virtual receiver , I just insert a new record in DB. I think for the JDBC to PI part it's right because the payload is correctly but the PI to PROXY part seems not work fine.