Data Missing JDBC Sender Adpater

[Former Member]

Hi Folks,

I am running a JDBC->XI->RFC->XI->JDBC scenario using BPM.

Interesting thing is i can see the record being picked from Table(as flag getting changed) but not all the times the entry is coming in SXMB_MONI and also records are not passing in that case all the way.

what could be the possible reasons kindly come up with ideas...

Regards,

[Former Member]

Problem was from oracle client's side after making the oracle client work in auto commit mode ...scenario started working in desired fashion..:-)

[former_member189387]

Hi Santhosh ,

I haope that you have gone through the links related to JDCB Sender like

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

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Nice blog from srinivas

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

Note : When you are using JDBC Sender . The data Type 's Element XML Format should match the Columns of SQL Table . If it miss data won't pickup .Please refer the above blogs

As per pretak's reply please refer the RWB .

Regards.,

V.Rangarajan

[prateek]

The message could get stuck in the queue. Thats y u could see it in moni sometimes. Check the status and flow in RWB. Also chaeck smq1 and smq2 for the stuck messages

Regards,

Prateek