Receiver JDBC Adapter - Acknowledgment capability

[Former Member]

Is it possible to receive acknowledgement in XI by Receiver JDBC adapter whether database is updated or not?

If yes, how we can achieve it? Do we need to do any settings in JDBC adapter to achieve it. We have used parameter "Transport" in the Acknowlegement of the SEND step of BPM.

Thanks in advance!

Mrudula

[Former Member]

Hi Mridula

In Receiver we will do the operations like INSERT, UPDATE, DELETE

for more details follow theses links

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

your error seems to be connection error it seems that you dont have rights for connection

kindly check the connection and user credentials

this will help you

Regards

Sandeep

if helpful kindly reward points

[STALANKI]

Please check https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2476. [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

[Former Member]

Sameer,

That error is due to expiration of certificate in our Dev XI system. We are working on it.

Please read following link for more information.

http://help.sap.com/saphelp_erp2004/helpdata/en/e8/1f1041a0f6f16fe10000000a1550b0/frameset.htm

How can I check whether XI is "closing the JDBC connection, once I make update the database"?

Thanks for your reply!

Mrudula

[Former Member]

Hi Mrudula,

i have the following questions for you

1. Does your scenario involve Certificates

2. Is the update to the database successfull, is ur scenario failing after the database update or before database update.

In Visual Admin, turn on logging to debug for adapter framework, it that way you can see all the steps taken.

(Visual Admin -> server-> services -> log configurator

->locations -> com -> sap -> aii ->adaptor -> jdbc )

Naveen

[Former Member]

Hi Naveen,

This problem is not yet resolved but I would give you points for your helpful and quick replies. I would work on it the direction you showed me.

I hope you would help with my future questions also!

Thanks a lot!

Mrudula

[Former Member]

hi,

keep the thread appraised of your finding

Cheers,

naveen

[Former Member]

Hi Mrudula

I guess you are getting the error because while getting the acknowledgement for the request, the connection must have been lost, for some reason.

So look in that angle, are you closing the JDBC connection, once you make update the database??

Hope this helps.

cheers

Sameer

is ur problem resolved ??

[Former Member]

Naveen,

This is the error found by our basis team in visual admin tool. They could not find any JDBC errors. I would go and check with them again.

Thanks for your help.

Mrudula

[Former Member]

Hi,

Hope you have resolved the issue!! could you close this thread, and assign some points.

cheers,

naveen

[Former Member]

Naveen,

Here is the error in detail from Visual admin.

Date : 10/06/2005

Time : 15:12:11:504

Category :

Message ID : 0003BA715041000B000000F400000AA80004027B8A4EF139

Severity : Error

Location : com.sap.aii.af.ra.ms.impl.core.queue.SendConsumer.onMessage(QueueMessage)

Source Name : com.sap.aii.af.ra.ms.impl.core.queue.SendConsumer

Thread : SAPEngine_System_Thread[impl:5]_47

Message : Transmitting the message to endpoint https://nero.corp.bcm.tmc.edu:4443/sap/xi/engine?type=entry using connection AFW failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.RuntimeException: Error while silently connecting: org.w3c.www.protocol.http.HttpException: iaik.security.ssl.SSLException: Server certificate rejected by ChainVerifier.

Datasource : 216701650:/usr/sap/DXI/DVEBMGS21/j2ee/cluster/server0/log/defaultTrace.trc

Application :

Argument Objs : AFW,com.sap.aii.af.ra.ms.api.RecoverableException: com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.RuntimeException: Error while silently connecting: org.w3c.www.protocol.http.HttpException: iaik.security.ssl.SSLException: Server certificate rejected by ChainVerifier,https://nero.corp.bcm.tmc.edu:4443/sap/xi/engine?type=entry,

Arguments : AFW,com.sap.aii.af.ra.ms.api.RecoverableException: com.sap.aii.af.ra.ms.api.RecoverableException: java.lang.RuntimeException: Error while silently connecting: org.w3c.www.protocol.http.HttpException: iaik.security.ssl.SSLException: Server certificate rejected by ChainVerifier,https://nero.corp.bcm.tmc.edu:4443/sap/xi/engine?type=entry,

Dsr Component :

Dsr Transaction : d80e01e0342211da8acd0003ba715041

Dsr User :

Indent : 0

Level : 0

Message Code :

Message Type : 1

Relatives :

Resource Bundlename :

Session :

Source : com.sap.aii.af.ra.ms.impl.core.queue.SendConsumer

ThreadObject : SAPEngine_System_Thread[impl:5]_47

Transaction :

User :

[Former Member]

hi,

is the error relevant to your interface?? i thought you were ahveing problems with JDBC ??? look for jdbc errors in your log.

naveen

[Former Member]

Naveen,

I found following error in visual admin tool.

"Attempting to create outgoing ssl connection without trusted certificates"

Do you know what it could be? And in which direction we need move to resolve it?

Thanks in advance!

Mrudula

[Former Member]

Hi Naveen,

I don't go anywhere when click on "Detail" of the failed messages in the Runtime workbench. Even I don't get anything when I click on "Error Log" for the failed message. Is there other way to check it?

Is it possible for you to call me?

Please let me know!

Thanks!

Mrudula

[Former Member]

hi,

the other way to view the error message is by going to visual admin -> log viewer

look for JDBC error in the log viewer

Naveen

[Former Member]

Hi Naveen,

In runtime workbench, Adapter engine monitoring message, Now I see successful message to databse system but I see message in "System Error" from databse system to XI-BPM as the receiver. What I need to do to make this in successful status?

Please help me!

Thanks!

Mrudula

[Former Member]

hi,

open up the message, go to details and message content. see what exception it got from the Database.

naveen

[Former Member]

Hi Naveen,

Data are intserted to database successfully.

In runtime workbench, Adapter engine monitoring message, I see successful message to databse system but I see message in "waiting status" from databse system to XI-BPM as the receiver.

How I can check the adapter monitoring for JDBC communication channel?

Thanks you very much for helping me!

Mrudula

[Former Member]

Naveen,

In the Tcode-SXMB_MONI, I see the Ack status "still waiting acknowledgment(?) in the send step.

Following is the payload of the message.

Can you please tell what is going wrong?

Why am I not getting acknowlegement?

Thanks you very much!

<?xml version="1.0" encoding="UTF-8" ?>

- <ns2:MT_ECA_GROUPCHG_INBOUND xmlns:ns2="http://bcm.edu/xi/MS">

- <Statement>

- <ECA_AG_CHG action="INSERT">

- <access>

<AG_SYSTEM>SAP_R3</AG_SYSTEM>

<ACTION_CODE>MAP</ACTION_CODE>

<SAP_USER_ID>CM144293</SAP_USER_ID>

<AG_NAME>ZES.E.ESS_PAY</AG_NAME>

<ECA_USER_ID />

</access>

</ECA_AG_CHG>

</Statement>

</ns2:MT_ECA_GROUPCHG_INBOUND>

Mrudula

[Former Member]

hi,

1. check the database to see if the insert was successfull

2. check runtime workbench for any errors

3. in adapter monitoring , check if the JDBC communcation channel is in red/green

Naveen

[Former Member]

Naveen,

Thanks for your reply!

I am using Asychronous send step and I am using "Transport level" acknowledgment in it. Do I need to do any other configuration in JDBC adapter or at database level to receive acknowledgment?

Please let me know!

Thanks!

Mrudula

[Former Member]

Hi Mrudula,

You dont have to do anything at the database or JDBC level. Be aware of the fact that transport acknowledgment does not necessarly mean the update was successful, it only means that the call to the database was successfull.

Cheer,

Naveen

[Former Member]

Can we configure in BPM's send step to receive acknowlegement from database by using receiver JDBC adapter whether database is updated or not? If yes, how and what we need to do?

Please help me!

Thanks!

Mrudula

[Former Member]

Hi Mrudula,

There are two types of JDBC acknowledgements Transport level and application level.

IF the JDBC call is asynchronous you can set up for transport level acknowlegement in the send step in ur BPM.

if the JDBC call is synchronous then JDBC adaptor will generate a response message with a tag update count, which gives you the number of rows that were updated.

refer to the following link, which details about reciever jdbc

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

let me know if you need more info

cheers,

Naveen