cancel
Showing results for 
Search instead for 
Did you mean: 

Proxy to JDBC no messages

Former Member
0 Kudos

Hi All,

I have written a program and called the proxy class and activated the proxy in SPROXY and when I execute the program it pick up records from the table and sends like 1000 records. I cannot see any message in SXMB_MONI.

Is there any other way to check if the outbound proxy is working fine?

Thanks,

Teresa

Accepted Solutions (1)

Accepted Solutions (1)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Proxy communication is happening through local integration engine of ECC system to PI. This local integration engine converts proxy messages to PI SOAP format which PI central integration engine can read and process. So check at ECC level first using sxi_monitor. if the messages are appearing in ecc side and not in PI, then you might have proxy configuration issue between ECC and PI.

Do transaction in PI like SLDCHECK, SLDAPICUST, LCRSAPRFC,SAPSLDAPI and see the configurations are in place.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Teresa,

If you have done the configuration through AAE then in that case you won't see any message in SXMB_MONI of PI system.

Check in MMonitoring or CChannel monitoring in RWB for JDBC channel. You can see the payload there also.

Regards,

Krishna Chauhan

Edited by: Krishna Chauhan on Dec 29, 2011 8:52 AM

Former Member
0 Kudos

I am not using AAE for configuration. When I went to SPROXY and double clicked on the outbound Service Interface and then went to Connection test . I got this message.

The address of the Enterprise Services Repository must be known in

the SAP system

The report SPROX_CHECK_IFR_ADDRESS says ok address maintained.

The HTTP Framework of the Web Application Server must function

The report SPROX_CHECK_HTTP_COMMUNICATION gives the following response

"HTTP communication contains errors (see long text

for diagnosis) "

Proxy generation must interpret the data of the Enterprise Services

Repository correctly

The report SPROX_CHECK_IFR_RESPONSE works correctly .

Edited by: Teresa lytle on Dec 29, 2011 4:51 PM

Former Member
0 Kudos

check [this|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15649?QuickLink=index&overridelayout=true]

it is quite close to your requirement.

At this point, connection setup from ECC to PI are not yet complete.

once they are done, proxy data will be moved to PI.

-santosh.

Former Member
0 Kudos

1)Look for messages in SXMB_MONI in ECC system.

2)if there is an issue in sending, they will show over therre.

Former Member
0 Kudos

Thanks Santosh . No XML messages are showing up in ECC when i go to SXMB_MONI. Part of the abap code is below.

TRY.

CREATE OBJECT cl_cogno.

CATCH cx_ai_system_fault.

ENDTRY.

  • get data from BKPF table

SELECT bukrs bldat budat belnr gjahr

INTO CORRESPONDING FIELDS OF TABLE it_bkpf

FROM bkpf

WHERE budat IN s_budat

AND bukrs IN s_bukrs.

  • get data from BSEG table

IF it_bkpf[] IS NOT INITIAL.

SELECT bukrs belnr gjahr saknr buzei kostl prctr sgtxt bschl wrbtr

INTO CORRESPONDING FIELDS OF TABLE it_bseg

FROM bseg

FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ it_bkpf-bukrs

AND belnr EQ it_bkpf-belnr

AND gjahr EQ it_bkpf-gjahr.

ENDIF.

SORT it_bkpf BY bukrs belnr.

SORT it_bseg BY bukrs belnr.

  • Prepare table for Proxy table

LOOP AT it_bseg INTO wa_bseg.

READ TABLE it_bkpf INTO wa_bkpf

WITH KEY bukrs = wa_bseg-bukrs

belnr = wa_bseg-belnr

BINARY SEARCH.

IF sy-subrc EQ 0.

MOVE wa_bkpf-bukrs TO wa_send-bukrs .

wa_send-bldat = wa_bkpf-bldat.

wa_send-budat = wa_bkpf-budat.

wa_send-saknr = wa_bseg-saknr.

wa_send-belnr = wa_bseg-belnr.

wa_send-buzei = wa_bseg-buzei.

wa_send-kostl = wa_bseg-kostl.

wa_send-prctr = wa_bseg-prctr.

wa_send-sgtxt = wa_bseg-sgtxt.

wa_send-bschl = wa_bseg-bschl.

wa_send-wrbtr = wa_bseg-wrbtr.

APPEND wa_send TO it_send.

CLEAR wa_send.

ENDIF.

ENDLOOP.

DESCRIBE TABLE it_send LINES v_cnt.

  • Move to Proxy table

output-mt_cognos-dt_item[] = it_send[].

  • Send Data thru Proxy

TRY.

CALL METHOD cl_cogno->si_eccql_async_out

EXPORTING

output = output.

CATCH cx_ai_system_fault .

CATCH cx_ai_application_fault .

ENDTRY.

WRITE:/ v_cnt, 'Records sent to PI' .

Former Member
0 Kudos

Do the debugging @ this point.

It seems, there is a mismatch with respect to it_send & proxy structure.

* Move to Proxy table
output-mt_cognos-dt_item] = it_send[.
* Send Data thru Proxy

Also, confirm, if output is filled with data below.

CALL METHOD cl_cogno->si_eccql_async_out
EXPORTING
output = output.
CATCH cx_ai_system_fault .
CATCH cx_ai_application_fault .

Former Member
0 Kudos

I will do the debugging. Thanks. Here is the definition below.

TYPES: BEGIN OF ty_bkpf,

bukrs TYPE bukrs,

bldat TYPE bldat,

budat TYPE budat,

belnr TYPE bkpf-belnr,

gjahr TYPE gjahr,

END OF ty_bkpf.

TYPES: BEGIN OF ty_bseg,

bukrs TYPE bseg-bukrs,

belnr TYPE bseg-belnr,

gjahr TYPE bseg-gjahr,

saknr TYPE bseg-saknr,

buzei TYPE bseg-buzei,

kostl TYPE bseg-kostl,

prctr TYPE bseg-prctr,

sgtxt TYPE bseg-sgtxt,

bschl TYPE bseg-bschl,

wrbtr TYPE bseg-wrbtr,

END OF ty_bseg.

----


  • Data Declaration

----


DATA: it_send TYPE zpidt_cognos_dt_item_tab,

it_bkpf TYPE STANDARD TABLE OF ty_bkpf,

it_bseg TYPE STANDARD TABLE OF ty_bseg,

wa_bkpf TYPE ty_bkpf,

wa_bseg TYPE ty_bseg,

wa_send TYPE zpidt_cognos_dt_item,

output TYPE zpimt_cognos,

cl_cogno TYPE REF TO zpico_si_ecc62mssql_cognos_asy,

v_cnt TYPE INT4.

Edited by: Teresa lytle on Dec 28, 2011 10:29 PM

Former Member
0 Kudos

Hello,

Check below link.

in R/3 in SPROXY after executing your outbound proxy, go to menu Extras -> click on Trigger Commit Work.....then you will not get Commit missing in SXMB_MONI for your msg

Regards,

Phani

Edited by: phani kumar on Dec 29, 2011 7:13 AM