ERROR in XI TO BI INTEGRATION

[Former Member]

Hi all

i am doing XI to BI configuration as per given in "HOW TO GUIDE" of SAP

my scenario is JDBC(SQL) to BI (ABAP proxy)

i am picking data from SQL datbase table and sending to BI

source structure is as follows:

DT_Sender

DATA 1:unbounded

Currency 1:1

Material 1:1

Target structure RFC

/BIC/CCUSTDATA

DATA 0:unbounded

Currency 1:1

Material 1:1

if i send the data through testing tool in RWB then it goes successful in XI and data come in BI

if i send the data from database table using JDBC adapter then it went succesful in XI and data replicates but while i check in BI side through SXMB_MONI it shows chequered flag but while checking paylaod inside the message it does not replicate the data

any body plz give your inputs how the data can come coorectly in BI message payload

Thanks

sandeep sharma

[Former Member · Accepted solution]

Hi Sandeep,

In SXMB_ADM --> Integartion Engine Configuration --> Specific Configuration add entry,

LOGGING with value 1 of category RUNTIME

Is this set?

Thanks,

Vijaya.

[Former Member · Accepted solution]

Hi Vijaya

i did this step

now i am getting one more pipeline step call inbound proxy with status "log version"

but payload is still empty

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns1:_-BIC_-CFCUSTDATA xmlns:ns1="urn:sap-com:document:sap:rfc:functions">
  <DATA /> 
  </ns1:_-BIC_-CFCUSTDATA>

you can see that there is no value in data tab while this code should be like this:

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

- <ns1:_-BIC_-CFCUSTDATA xmlns:ns1="urn:sap-com:document:sap:rfc:functions">
- <DATA>
- <item>
  <CURRENCY>inr</CURRENCY> 
  <MATERIAL>cat1</MATERIAL> 
  </item>
  </DATA>
  </ns1:_-BIC_-CFCUSTDATA>

any more input???

Thanks

sandeep

Edited by: sandeep sharma on Apr 29, 2009 2:27 PM

[Former Member · Accepted solution]

Hi,

Cross check the occurences of the nodes DATA and ITEM and the occurences of the elements mapped to them.

Regards,

Reyaz

[Former Member]

Hi all

My issue is solved .thanks everybody for their valuable inputs

solution: as per suggested by Vijaya i have matched both payload one which i am sending from RWB and one which is coming from JDBC

Than i came to know that the payload coming from JDBC does not contain namesapcee

that means i had not added namespace in sender JDBC channel

which i added and issue solved

Thanks

sandeep sharma

[Former Member]

Hi Sandeep,

Is the Payload you tried from RWB same as the one that is posted in to XI from JDBC sender adapter?if not try taking the payload of your input(from JDBC sender) from SXMB_MONI and try it from RWB.If you face the same problem,I think there should be some problem at ur JDBC sender end.

Thanks,

Vijaya.

[Former Member]

Hi All

as per suggested by Vijaya

i have switched on logging by putting parameter 1

now i can see in the sxmb_moni following pipelinesteps

Inbound Message ( CENTRAL )

Receiver Identification

Interface Determination

Receiver Grouping

Message Branch According to Receiver List

Request Message Mapping

Technical Routing

calladapter

response

i can see payload in each step which is fine, starting from inbound message step to Message Branch According to Receiver List step,

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:MT_Sender xmlns:ns0="http://groupsoft.in/XIBITEST">
- <row>
  <CURRENCY>dgs</CURRENCY> 
  <MATERIAL>sxdfgs</MATERIAL> 
  <STATUS /> 
  </row>
  </ns0:MT_Sender>

while in the next step Request Message Mapping i can see in the payload

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns1:_-BIC_-CFCUSTDATA xmlns:ns1="urn:sap-com:document:sap:rfc:functions">
  <DATA /> 
  </ns1:_-BIC_-CFCUSTDATA>

that means my data is not reflecting on the receiver side

source structure is as follows:

MT_Sender 1:1

row 1:unbounded

Currency 1:1

Material 1:1

Target structure RFC

/BIC/CCUSTDATA 1:1

DATA 1:1

item 0:unbounded

Currency 1:1

Material 1:1

can anybody suggest me in this regards what change should i do to reflect accurate data in receiver side

Thanks

sandeep

[JoelTrinidade]

Hi Sandeep,

Do you mean that in your BI system the payload is empty.

Regards

joel

PS: please give the link of the guide that you are following.

[Former Member]

HI joel trinidade ,

yes you are right , if i use JDBC adapter on sender side then in BI paylaod is empty.but if i test message through RWB then it comes correctly in BI

i have tested for third party by using file adapter and in that case this scenario is working fine, its perfectly picking file and data correctly coming in BI . but in case of JDBC ........ not coming correctly in BI

i am following this guide.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40574601-ec97-2910-3cba-a0fdc10f...

Thanks

sandeep

[Former Member]

Hi Sandeep,

I have the same scenario, but I've a problem in a previous step with proxy generation on BW.

The XI software component are not visible in SPROXY transaction and a message says: Local objects only (No connection to ESR).

Have you had the same problem?

thanks

Daniele

[Former Member]

Hi Daniele,

Luckily ,I never had this problem.

first you need to make some basic configuration in BI side

make RFC in BI with destnation your XI server and then in BI side give settings in Tcode SLDAPICUST for your Xi servers

search some basic scenario for abap proxy and then make basic configuration

goodluck.

thanks

sandeep

Edited by: sandeep sharma on Apr 29, 2009 6:49 AM

[Former Member]

Hi,

check your payload before request mapping and after request mapping in XI (sxmb_moni)

take that payload and test mapping.

it seems to be problem in sender sturcture and receiver structure.

[jyothi_anagani]

Hi,

Kindly Refer This. [How To u2026Push data from BI to XI (including receiver examples)|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e698aa90-0201-0010-7982-b498e02af76b]

Thanks.

[Former Member]

Hi jyoti

thanks for reply

i have already gone through with this guide

can u suggest me something else?

Thanks

sandeep sharma

[Former Member]

Hi Daniele,

follow this guide

Internal Communication: ABAP Proxy and Process Integration

by Vikas Jain, Milan Thaker

this will help you how to give basic configuration for ABAP proxy

thanks

sandeep