cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver JDBC Adapter testing?

Former Member
0 Kudos

Hi

Can any one tell me ..how do I test specific adapter w'ther it is connected or not?

I have cross checked using adapter monitor, my jdbc adapter doesn't showing specific error(red) or success(green),in same JDBC monitor remainig channels showing all information..i thought it unable to connect?Am I correct?

Did i do any specific settings in JDBC receiver communcication channel?

I left default settings as it is in CC..

after giving driver details...i left default settings ..

1. Interpretation of empty string values = Null value

2. Persistance = Local

3. Conflict resolution = Redo

and my datatype structure like this:

<StatementName>

<table>Payment_ReceiptFromSAP</table>

<dbTableName action=”INSERT”>

<access>

<col1>ComapnyCode</col1>

<col2>PaidDate</col2>

<col3>PaidAmount</col3>

</access>

</dbTableName>

</StatementName>

mapping is working fine, tested! RFC sender channel working fine, picking the data from SAPR/3.

SXMB _MONI -- I haven't find any payload ..why? I thought if RFC is picking the daata properly then XI will hold that data into integration server?..how do i find this data?

It would be appriciated and rewarded , if you make me clear in this situvation..thanks in advance.!

Regards..rambarki!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

>>I have cross checked using adapter monitor, my jdbc >>adapter doesn't showing specific error(red) or >>success(green),in same JDBC monitor remainig channels >>showing all information..i thought it unable to connect?Am >>I correct?

you will see in adapter monitoring only after the first time the call is made, the bean in generated and you will be able to see in atapter monitoring.

>>SXMB _MONI -- I haven't find any payload ..why?

is ur scenaio synchronous?? if so then make sure you have logging set in sxmb_adm

Configuration -> Integration Engine Configuration -> Change Specific Configuration Data.

Category : Runtime

Parameter : LOGGING_SYNC

value : 1 (activated)

Cheers,

Naveen

Former Member
0 Kudos

Hi Naveen

I found my Receiver JDBC adapter is connected , it showing green in adapter monitor, but it is not processing any data. that the reason I haven't found any payload.

My sender RFC is connecting properly..so i need to check w'ther this RFC retriving the data or not from SAP R/3..so where do i check ?..because i haven't find any message in message monitor and sxmb_moni.

My scenrio is Asynchronous only...

It seems to be both adapters are connected properly but not processing the data.. Am i correct?

So let me know your idea..then based on i'll check it..

Thank You..

Regards..rambarki

Former Member
0 Kudos

HI,

try writing a simple abap report in which you fill in the data and make the call to the RFC.

cheers,

naveen

Answers (1)

Answers (1)

Former Member
0 Kudos

hi

After restart the server, The receiver JDBC adapter is connected properly, showing "UP and running but messages not processed upto to now", tell me what is the cause for not processing message,,

Sender rfc adapter also showing up and running ..but where do i find w'ther rfc adpter properly messages passed or not in ?

even i didn't find any payload in SXMB_MONI..and message monitor..i thought both adapters are connected but not processingthe data? am i right/

regards

rambarki!