XI BW integration

[asgarali_mia]

Hi

We are trying to integrate an oracle database and BW 7 using XI. we are however succesfully getting the data from the Oracle database but are experiencing issues when sending the data through to BW. We used the HOW to integrate BW and XI found on the HOW section of the SDN site.

<b>Requirement</b>

We are required to pull data from an Oracle Database to BW 7 system. We can successfully connect and pull data from the database via an sql statement (JDBC adapter)

<b>Integration Repository Setup</b>

- We have created on the BW system a data source and made it available to the integration repository in XI.

- An interface object occup_sql_in has been created and assigned data types as per the sql result = inbound, async

- An interface object ofoOccupation has been created with message type as per the datasource downloaded from BW = inbound, async

<b>BW system</b>

- We created a proxy for ofoOccupation

<b>Integration Directory Setup</b>

- We have maintained our BW system BWD_300

- And have created a communication channel as follows:

- Name; occup_bw_out_com

- Adapter type: XI, Transport Protocol HTTP 1.0, Message Protocol XI 3.0

- Adapter engine Integration Server

- Address Type URL Address

- Targethost : <hostname of our BW system>

- Service ; 8000

- Path :/sap/xi/engine?type=entry

- Authentication type = Use Logon Data for Sap System and we maintained the username and password, client 300

We then created the following:

<b>Sender Agreement</b>

- service BS_JDBC_SENDER

- interface ofoOccupation

- Communication channel occup_sql_in_comm

<b>Receiver Determination</b>

- Sender – service BS_JDBC_SENDER

- Sender interface – ofoOccupation

- Configured Recievers – BWD_300

<b>

Interface determination</b>

- Sender Service BS_JDBC_SENDER

- Sender Interface – ofoOccupation

- Reciever service – BWD_300

- Inbound interface : occup_sql_in

<b>Recciever Agreement</b>

Sender service BS_JDBC_SENDER

- Reciever service BWD_300

- Interface occup_sql_in

- Communication Channel occup_bw_out_comm

<b><i><u>Problem</u></i></b>

The system stays on status to be delivered. Please assist

Regards

Ronny<b></b>

[Former Member · Accepted solution]

Hi,

You have to activate them in Integration Directory-----Configuration and the try ...hope it wil work this time..

Reward With points

Regards

Sai Ganesh

[Former Member]

hi

first check your credntials and then check right on your input and output folder

sometimes files gets stuck in RWB in the to be delivering status due to large file size or due to unavailable service at that time.

if you find this file in RWB in the status to be delievering then click on the left of the row showing your message and select it then click on resend it

It may ask you for your password

give the right credentials hope it may be successful

thanks

Sandeep Sharma

PS:reward with points if helpful

[asgarali_mia]

Hi Sandeep,

The data gets to BW now (i.e I can see it in both the XI and the BW system's sxmb_moni transaction). The problem I am facing now is it does not seem to be going through my mapping program. so my proxy is failing.

It takes the data as raw as it is, and tries to enter it into my datasource (via the proxy). So the structures are different, as the BW structure requires <Datasource> field to be present and my result set doesnt.

I followed the trace and picked up that my Mapping program that is defined in the Repository is not used at all. When I try to specify it on the Config Side (creating interface determination), it is not picked up either.. the screen is blank (f4).

Please assist

Regards

Ronny

[asgarali_mia]

Hi

I have solved the problem of the mapping program, i had to refresh my cache. THank you so much for you help.

Regards

Ronny

[asgarali_mia]

Hi

Thank you all for such a speedy response. I have gone and activated all the queues, however I am now getting teh following error on

SAP:Stack>Proxy calls are not permitted on sender or receiver side on the IS (client)</SAP:Stack

My XI System is setup as an Integration Server and my BW system (where the proxy is activated) is set to Application server

Please assist.

Regards

Ronny

[Former Member]

Hi,

If You Installed the XI Server Newly means Please Register QUEUES in SXMB_ADM.

1) go to SXMB_ADM

2) Select Manage Queues

3) Select Register Queues.

It Should Work

Regards

Giri

[asgarali_mia]

Hi Giri

I have gone and carried out your steps below and yes, it does work now. But the data is not showing on BW, i.e the data source is not pupulated in transaction RSA7

I could be my proxy, the code is as follows, please advice if something is incorrect.

Regards

Ronny

method ZII_OFO_OCCUPATION~EXECUTE_ASYNCHRONOUS.

DATA: l_text TYPE string,

l_s_data TYPE ZOXBWD0003,

l_t_data TYPE TABLE OF ZOXBWD0003.

FIELD-SYMBOLS <l_line> LIKE LINE OF input-controller.

LOOP AT input-controller ASSIGNING <l_line>.

MOVE-CORRESPONDING <l_line> TO l_s_data.

APPEND l_s_data TO l_t_data.

ENDLOOP.

CALL FUNCTION '/BI0/QI6AZXMLBWDS_RFC'

EXPORTING

datasource = '6AZXMLBWDS'

TABLES

data = l_t_data

EXCEPTIONS

OTHERS = 1.

IF sy-subrc NE 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4 INTO l_text.

• RAISE EXCEPTION TYPE ZCX_OFO_OCCUPATION_FAULT_MESSA.

*

*EXPORT data l_s_data = l_text.

*

endif.

endmethod.

[Former Member]

Hi

The above code seems fine.Just check out whether you have done all the steps correctly

Thanks

[Former Member]

hi ,

i am nt very sure abt this but you are using XI adapter so just give the details in <b>Header Mapping in receiver Agreement in ID</b>

also clear your queues.

hope this will help

regards

HONEy

[Shabarish_Nair]

go to smq2 in XI and check if there are any entries. In case there is, then activate them all.