can anyone pls. help me : facing problem while fetching the data from BAPI

[Former Member]

Hi all,

we have installed xMII in a new server. In this new server I am trying to fetch data from a BAPI & write it into a file thru a transaction, but i cant see the data in the tracer, & neither is the file created. But with the same configuration & connection am able to get the data in the old server. Can anyone pls. tell me wat could be the problem?? or is there anything else that we might have forgotten while installing xMII in the new server.

ur help would be greatly appreciated.

Thanks,

Sushma.

[Former Member]

Hi,

Can u give me further details like what it is showing in the tracer.whether it is showing the xml table structure for that bapi atleast or not.......?

[Former Member]

Hi Ravi,

no am not able to see the table structure also. This is what it is showing in the tracer :

[INFO ]: Execution Started At: 17:24:17

[DEBUG]: 00000.03100 Begin Transaction 'TMP99A51958-5BAE-CDE0-0DB5-A3A8C72BC297'

[DEBUG]: 00000.03100 Begin Sequence Sequence : ()

[DEBUG]: 00000.03100 Begin Action SAPJCOInterface_0 : (SAP JCO Interface)

[DEBUG]: 00006.43700 Connection Took 6406 mS

[DEBUG]: 00009.82800 Function Creation Took 3391 mS

[DEBUG]: 00010.25000 Execution Took 422 mS

[DEBUG]: 00010.25000 End Action SAPJCOInterface_0 : (SAP JCO Interface)

[DEBUG]: 00010.25000 Begin Sequence Sequence_0 : ()

[DEBUG]: 00010.25000 Begin Action Repeater_0 : (Repeater)

[DEBUG]: 00010.26600 End Action Repeater_0 : (Repeater)

[DEBUG]: 00010.26600 End Sequence Sequence_0 : ()

[DEBUG]: 00010.26600 End Sequence Sequence : ()

[DEBUG]: 00010.26600 End Transaction 'TMP99A51958-5BAE-CDE0-0DB5-A3A8C72BC297'

[INFO ]: Execution Completed At: 17:24:28 Elapsed Time was 10235 mS

I doubt the repeater is not working, becoz i checked the JCO connection & thats fine..

Thanks,

Sushma.

[Former Member]

Hi Sushma,

I had asked for the tracer info when u map response of the jco to the tracer message,whether u r getting or not......?

If u r getting table structure atleast then there may be no data or inputs mapped may be not sufficient.if u get the table structure along with data then from what u say there may be something wrong while giving xpath in repeater.

[Former Member]

ohh... am sorry...

Yes am able to see the table structure while mapping the data. iam using a repeater,so am passing the response of the repeater to the tracer. & the response of the JCO is mapped to repeater.

As i said earlier, the same transaction is working fine in the old server. I've copied the transaction as it is, but unable to see the data... there are nearly 10 rows of data in the table. am confused as to y the same configuration is not working in the new server??

[Former Member]

Hi Sushma,

Can you map JCO output to the tracer and paste it to the notepad and open as xml. Then you can get idea that JCO block is working 100% fine. Then after that what you can do is start the debugging from the repeater.

Thanks,

Rajesh.

[Former Member]

Hi Sushma,

U haven't mentioned whether it is data available or not when u mapped entire bapi response into a tracer.Dont use a repeater for this.

There might be another reason why u were not getting the data(as ur saying there is actual data existing in the server).

May be while configuring the sap-jco block for bapi,u might have unchecked the ExecuteFunction .U see whether it is checked or not.it should be checked.

May be instead of mapping an item in a table for the response from bapi u might hav mapped the entire table and used the repeater.

regards,

Ravi Kumar

[Former Member]

Hi Rajesh,

I've tried pasting the data from the tracer to a notepad, but even this action is not taking place. I've copied the message that i got in the tracer in my earlier reply, i think it is not entering into the loop.

how can i debug?? is there any other option to see the step by step execution apart from using a tracer ??

For testing purpose, i created a Z Function Module & executed with the transaction in the same server.. i could see the output & also could write it into a file. the problem is only with this BAPI.

Ravi,

yes i did check ExecuteFunction option & also have mapped the item node only.

how do i write data into file if i have more no. of rows without using repeater??

[Former Member]

Hi Sushma,

You should be able to write the JCO output to the tracer. Anyway leave it. First let us debug only from JCO side. Do one thing have only JCO in your transaction. And after that add a tracer for checking the success flag of JCO. After that part create transaction variable type xml. Map the complete JCO output to the variable. Next add the create file block, there map the variable into the file.

I hope first clear the doubt that JCO is working properly or not.

You said you have copied the transaction from some where else. Then once go to the configure tab and select the BAPI once again and execute.

Thanks,

Rajesh.

[Former Member]

Sushma,

Check you General log. It may give some clues.

Thanks,

Sara