Receiver JDBC adapter: Don't see any response

[Former Member]

Hi,

I implemented a synchronous scenario SOAP --> JDBC and use SQL XML.

My UPDATE_INSERT statement seems to be processed correctly:

Log says that the database query was processed successfully, message was transfered to endpoint <local> and the status was set to "DLVD".

The problem: I don't see any response in the message monitoring.

I already tried the following response structures:

DT_Auftrag_Resp

--- Statement_response

------- update_count

------- insert_count

DT_Auftrag_Resp

--- update_count

--- insert_count

What can be the reason for this?

I already developed another JDBC interface and the response structure was wrong. In that case I saw errors in the message log.

Thanks!

[Former Member · Accepted solution]

Hi Stefan

JDBC adapter will send the response back with the Message Type of same name as request message type with "_response" (Case Sensitive)

Make sure you create the response message type appended with "_response"

Check the following blog and help link.

Document Formats for the Receiver JDBC Adapter - SAP XI: Runtime - SAP Library

Regards

Osman

[Former Member · Accepted solution]

OK, that was the right hint. I was not aware of the fact, that the message type has to be named with "_response" at the end.

When response message is named MT_Message then response has to be named MT_Message_response.

Thank you very much!

[Muniyappan]

did you enable logging in your system. if you don't enable you wont be able to see the logs for successful messages.

regards,

Muni.

[former_member192892]

Have you kept the processing as best effort in the receiver jdbc channel?

Regards

Varun