cancel
Showing results for 
Search instead for 
Did you mean: 

How to develope a file to file scenario in PI7 SP13

Former Member
0 Kudos

Can u pl point me to develop a File to File Sceanrio using PI7 SP13 without FTP?

Thanks

Ven

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ven !

You can do it 2 ways: one with repository objects and one without them. The first one allows you to make mappings between incoming and outgoing data. The second one, allows you to transfer even binary data (.zip, .jpeg, .pdf).

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/william.li/blog/2006/09/08/how-to-send-any-data-even-binary-through-xi-without-using-the-integration-repository

If you don't use FTP, you should use direct file system access. That is using the file system mode of the File/FTP adapter.

Regards,

Matias

PS: please award points if helpful.

Message was edited by:

Matias Denker

Former Member
0 Kudos

Matias,

I did the sceanrio based on this blog but the file is not getting picked.

Just wondering if the steps would be different for PI 7 SP13?

Thanks,

Ven

Former Member
0 Kudos

Hi Ven !

I don't think so. Check filename case sensitivity. Which mode are you using ? test? archive? delete?

Is the comm channel started? check via RWB.

Are there other scenarios with sender file adapter running in that server?

Regards,

Matias

Former Member
0 Kudos

Matias,

I tried all the options. When I tried Archive, it is writing tot eh archive folder but nothing goes into the target.

Pl advise.

Regards,

Ven

Former Member
0 Kudos

Hi Ven !

Well, that's good news. If the adapter is archiving the file, then it is picking it up.

Do you have file content conversion in the sender adapter?

Could you copy and paste the audit log of the message. You may look using Runtime Workbench (RWB) the message monitoring of the Adapter Engine (not the Integration Engine) and see the audit log to detect if there are any logged errors during the transfer of the file content to the Integration Engine.

Check this using RWB, under component monitoring, to see the log of the channel.

Regards,

Matias.

Former Member
0 Kudos

Hi Matias,

I am not sure about the File Content Conversion? I could not find this property to answer your question properly.

CommunicatioN Channel Log of Errors:

Time Stamp Status Description

2007-10-24 16:26:53 Success Channel BGSENDFILE: Send binary file "F:\ximb\input\inputfile.xml". Size 158 with QoS EO

2007-10-24 16:26:53 Success MP: Entering module processor

2007-10-24 16:26:53 Success MP: Processing local module localejbs/CallSapAdapter

2007-10-24 16:26:53 Success Application attempting to send an XI message asynchronously using connection File_http://sap.com/xi/XI/System.

2007-10-24 16:26:53 Success Trying to put the message into the send queue.

2007-10-24 16:26:53 Success The message was successfully retrieved from the send queue.

2007-10-24 16:26:53 Error Attempt to delete file "F:\ximb\input\inputfile.xml" after processing failed. Retry

2007-10-24 16:26:53 Success Message successfully put into the queue.

2007-10-24 16:26:53 Success MP: Leaving module processor

2007-10-24 16:26:53 Success The application sent the message asynchronously using connection File_http://sap.com/xi/XI/System. Returning to application.

2007-10-24 16:26:53 Success The message status set to DLNG.

2007-10-24 16:26:53 Error Transmitting the message to endpoint http://skzw26x:51000/sap/xi/engine?type=entry using connection File_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Received HTTP response code 404 : Not Found.

2007-10-24 16:26:53 Success The message status set to WAIT.

2007-10-24 16:26:53 Success The asynchronous message was successfully scheduled to be delivered at Wed Oct 24 16:31:53 EDT 2007.

2007-10-24 16:27:00 Success Channel BGSENDFILE: Send binary file "F:\ximb\input\inputfile.xml". Size 158 with QoS EO

2007-10-24 16:27:00 Success MP: Entering module processor

2007-10-24 16:27:00 Success MP: Processing local module localejbs/CallSapAdapter

2007-10-24 16:27:00 Success Application attempting to send an XI message asynchronously using connection File_http://sap.com/xi/XI/System.

2007-10-24 16:27:00 Success Trying to put the message into the send queue.

2007-10-24 16:27:00 Error Putting message into send queue failed, due to: com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID 75280510-826f-11dc-928e-00188be4eace(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C00147784) violated.

I tried a couple of times and so the error now is saying that it is a duplicate entry.Not sure where to check for the entry and delete it.

Pl advise.

Ven

nisarkhan_n
Active Contributor
0 Kudos

Is the file getting picked up?

check do you have the read acess to the source and write acess to the target directoy.

check-out SAP Notes Note 962578 - Wrong persist exception - duplicate detected

Former Member
0 Kudos

Hi Ven !

>>>> http://skzw26x:51000/sap/xi/engine?type=entry using connection

the 51000 port is not correct. You are using the J2EE port (51000) but it should be the HTTP port (80xx)

1. go to SLD

2. find your XI's business system

3. click on it and change the pipeline URL from J2EE port 51000 to http port (80XX) -

You can find http port under services in TCODE SMICM

please test and tell me how it was.

Regards,

Matias.

source:

nisarkhan_n
Active Contributor
0 Kudos

exactly the IS link is wrong

the port should be the ABAP port which can be found in SMICM tv->goto-Servicess

to chenge this lnk

goto the SLD-->BS (XI) check the details you will find the IS link there change here....

Message was edited by:

Nisar Khan

Former Member
0 Kudos

Matias,

Thanks for the quick pointer.

I changed the Port to 8010 as per my system but it is still throwing the same error showing 51000 port.

I refreshed every type of Cache that I know of in Integration Directory and Repsitory incluidng CAPCache and SXI_cache.

Do i need to delete and recreate the Business System for it to take proper effect?

Pl advise,

Ven

nisarkhan_n
Active Contributor
0 Kudos

paste the error details now after changing the port.

Former Member
0 Kudos

Nisar,

It is still the same error as before pointing to the old port only and not the new port.

Do I delete and recreate the Business System and Technical Systems?

--- Ven.

nisarkhan_n
Active Contributor
0 Kudos

where did you change the port list down the steps?

Former Member
0 Kudos

In the Business System of my integration Server.

Where all do I need to change?

Can u pl let me know?

-- Ven

nisarkhan_n
Active Contributor
0 Kudos

in the a SXMB_ADM check have you maintained the IS_URL value properly?

the port is not updated so that's y the error still occuring i belive.

Former Member
0 Kudos

Nisar,

It seems the port error is gone but I am still getting the following error:

2007-10-25 12:12:45 Success Trying to put the message into the send queue.

2007-10-25 12:12:45 Error Putting message into send queue failed, due to: com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID 75280510-826f-11dc-928e-00188be4eace(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C00147784) violated.

2007-10-25 12:12:45 Error Returning to application. Exception: com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID 75280510-826f-11dc-928e-00188be4eace(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C00147784) violated

2007-10-25 12:12:45 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID 75280510-826f-11dc-928e-00188be4eace(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C00147784) violated

2007-10-25 12:12:45 Error Attempt to delete file "F:\ximb\input\inputfile.xml" after processing failed. Retry

by the way what is the URl value for the IS in SXMB_ADM?

Pl advise,

Thanks,

Ven

nisarkhan_n
Active Contributor
0 Kudos

pls check my previous reply on the dublicate id...also the same link what you have given ther in BS IS link will be value of the paramter IS_URL that will be in sxmb_adm......

Former Member
0 Kudos

Hi Ven !

Check this thread:

Maybe there is a clue. Try to restart the J2EE. And check the dir permissions on the source folder to allow XI to delete the source file once picked up.

Regards,

Matias.

Former Member
0 Kudos

Nisar,

The note for duplicates is already in my system as I am at SP13.

Matias adn Nisar,

Thanks for all your help.

Not sure what happened suddenly, the file is being picked and deleted.

However it is not wriitng to the output folder. ia m checking the permissions as suggested by Matias.

I will get back to you as soon as I fix this and award points.

- Ven

Former Member
0 Kudos

Thanks matias,

It works now. It si the restarting of J2EE, the Port number and added full control for the folders at OS level.

Regards,

Ven

nisarkhan_n
Active Contributor
0 Kudos

good it works now.....so where are my points (-:

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

File to File real time scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/flatFILETOFLATFILE&

Without using FTP, you can chose NFS mode in your CC.

Regards,

Sarvesh

Former Member
0 Kudos

if u don't want to use FTP then what do u want to use?