In File-XI-MSAccess Scenerio, File is not Moving

[Former Member]

Dear All,

I am having one .XML file in one folder & i m trying to move it to MS Access table. But it is not moving to MS Access. I have checked the adapters & FIle Adapter & JDBC Adapters are working fine ie. they are green. Also, when i am seeing in SXMB_MONI there are no messages processed it is showing. Plz guide me where to see and check.

thanks in advance,

nishu

[bhavesh_kantilal · Accepted solution]

Nishu,

In your Sender File adapter, make the processing mode as DELETE. as and when the file is picked up from the folder, the file will be deleted.

Also, make sure that you have entered the valid file name and directory in the file adapter and the polling interval is also correct.

for info on the file adapter fields,

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

Regards,

Bhavesh

[Former Member]

hi,

in details it is showing error with foloowin description

" Error Transmitting the message to endpoint http://trexserver:8000/sap/xi/engine?type=entry using connection AFW failed, due to: Received HTTP response code 403..".

so what might be the error.

nishu

[Former Member]

Hey

>>Received HTTP response code 403

denotes

This code indicates that the resource cannot be accessed, regardless of any authentication credentials. For example, this happens if a directory or file is unreadable due to file permissions.

So jus check whether the file sent has read and write permission.

cheers

jithesh

[Former Member]

Hi,

I m seeing in the message monitoring, there it is showing System Error in Status coloumn.

Plz guide me how to go further on this.

nishu

[Former Member]

Hi Nishu,

In msg monitoring just beside the START tab there is a DETAILS tab. Select ur msg and click that tab.

There u will get the exact reason for ur error.

Regards

Neetu

[Former Member]

Hi All,

now the message is moving from the source folder but it is not getting to target system ie. to MSAccess table. Also when i m goin to SXMB_MONI there are no messages. Also, please tell me since we are updating an MSAccess table so should we have to write any query for that?

Waiting for ur replies

nishu

[Former Member]

Hi Nishu,

If messages are not seen in the SXMB_MONI, Please do as below:

Increase logging and trace level in:

SXMB_ADM -> Integration Engine Configuration -> Specific Configuration

Also create entries as follows in it:

LOGGING = 1

LOGGING_SYNC = 1

TRACE_LEVEL = 3

TRACE_LEVEL_PROPAGATION = 1

Also refer <a href="/people/michal.krawczyk2/blog/2005/05/10/xi-i-cannot-see-some-of-my-messages-in-the-sxmbmoni: I cannot see some of my messages in the SXMB_MONI</a>

Regards,

Abhy

[Former Member]

Nishu,

First the data from i/p has to come to XI server and then it has to be moved to target. Now in your case, the data is not coming into XI server itself. Lets first check that.

If your i/p file is getting picked up, go to RWB and msg monitoring and see yuor msg details. There should be an error.

Regards,

Jai Shankar.

[Former Member]

Hi Nishu,

The best way to check if your file is being picked is to,

1)keep processing mode as delete.if file is deleted from the specified location then u can confirm that file is picked by XI server.

2)If u keep processing mode in test mode then go to runtime workbench>componenet monitoring>select componenet with status(All)-->click on display button.

Go to Integration server->Adapter engine.

In status tab->adapter monitoring.then select ur file adapter and check ur communication channel.

hope this is sufficient.

Pls go through the explanation of a simmilar scenario that i have explained below anmd compare it with what u have done.It should help you clear all your doubts regarding the scenario that you are doing and also will help u find a solution to your problem.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step -- JDBC receiver adapter (synchronous step by step)

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn -- Connect to MS Access database using reciever JDBC

For Configuring jDBC adapter -

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

For anything related to scenatios involving sender or receiver file adapters, please go thru the following links and clear all your doubts.

Communication channel:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/65/b11c409ce22402e10000000a1550b0/frameset.htm">Assigning Communication Channels</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2b/d5653fd1d3b81ae10000000a114084/content.htm">Communication Channel</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm">Configuring the Sender File/FTP Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm">Configuring the Receiver File/FTP Adapter</a>

Receiver agreement:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/56/02e63f48e58f15e10000000a155106/frameset.htm">Receiver Agreement</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/c1/5194426b44c56ae10000000a155106/frameset.htm">Creating a Receiver Agreement</a>

Sender agreement:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/db/73e03fc2269615e10000000a155106/frameset.htm">Sender Agreement</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/22/522041cfb7f423e10000000a155106/frameset.htm">Creating a Sender Agreement</a>

For detailed info, I would suggest that you go through these weblogs:

<a href="/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1">Introduction to simple(File-XI-File)scenario for Starters</a>

<a href="/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2">Introduction to simple (File-XI-File)scenario for starters part2</a>

I hope it helps.

Regards,

Abhy

[Former Member]

Hi,

Please can you check if the file is picked up. If not then chck the parameters of File adapter.

If the file is picked up and you cannot see message in SXMB_MONI, please check in the Runtime workbench Message monitoring if its gone into error.

Regards

Vijaya