on 10-24-2007 8:53 PM
Can u pl point me to develop a File to File Sceanrio using PI7 SP13 without FTP?
Thanks
Ven
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if u don't want to use FTP then what do u want to use?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.