Posts

Troubleshooting EOIO stuck messages

Image
 Sometimes, we get multiple messages stuck in PO in ' To be Delivered' status.  The culprit here is that one message which is in System error (or in some rare cases Delivering status) We have to find out that faulty message and resolve the error or we should cancel that message itself only if its a genuine error. Go to Monitoring -> Adapter engine -> Additional Data -> Queues  Here, check for any entries in the queue.  Sometimes, we get multiple messages stuck in PO in ' To be Delivered' status.  The culprit here is that one message which is in System error (or in some rare cases Delivering status) We have to find out that faulty message and resolve the error or we should cancel that message itself only if its a genuine error. Go to Monitoring -> Adapter engine -> Additional Data -> Queues  Here, check for any entries in the queue. Check for any entries here, if the message stuck in the file adapter then check the Filesystem queue & fo...

Common SFTP channel errors/issues

Image
  Dangling Meta character issue : Solution for Dangling Meta character issue : Follow the below SAPNote.   Basically this issue occurs due to filenaming convention scheme. Like file adapter, in SFTP * does not mean that it will accept all files. In SFTP,    .*  is equal to * (as in FTP) Cannot create target directory: Limit operation failed Resolution: This issue too is related to file naming convention in the receiver channel. By putting a Tilde operator (~) in the beginning we can resolve this issue. ~ operator represents the Home directory for the user used in the channel configuration. Ideally, without ~ operator too it should work but in some cases, we get the limit operation error. Faulty path:  /To_FM Corrected path:  ~/To_FM --------------------------------------------------AMOR FATI---------------------------------------------------------

Delete Suppress

Image
 Sometimes we get SUPPRESS entries which causes wrong results in the mapping. Below UDF can be used to remove those entries: for(int i=0; i<a.length; i++) { if(!a[i].equals(ResultList.SUPPRESS)) result.addValue(a[i]); }   ------------------------------------------------AMOR FATI----------------------------------------------

Senderport + Idoc number in Filename

Image
 Requirement is to place the file with the below naming convention: " senderport " + ORDERS + " IDoc Number " + .eof ex.  PRD ORDERS_ 1192934631 .EOF Here, the sender port is    SAPPRD To achieve this: Use a UDF  Use FORMATNUMBER function to remove the leading zeroes. UDF Code: String name = null; name =  a + "ORDERS_" + b + ".EOF"; DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION); if(conf!=null) { DynamicConfigurationKey filename = DynamicConfigurationKey.create( "http://sap.com/xi/XI/System/File", "FileName"); conf.put(filename, name); } return a;   --------------------------------------------------AMOR FATI---------------------------------------------------

File to Mail (with static Filename)

Image
This can be useful for requirements when the user/business wants the payload file during testing or for other purposes. No ESR Objects involved. In ID, Create File/NFS/SFTP sender channel: Enable ASMA RECEIVER MAIL CHANNEL: OUTPUT MAIL: This will work for Text files or XML files at Sender side. For pdf's,  change content type to application/pdf  and filename =   sample.pdf For CSV files, FCC has to be used at the sender side along with the above module. For SFTP sender, Messagetransform bean module can be used for FCC as well as configuring the content type & disposition. Content - Disposition  response header is a header indicating if the  content  is expected to be displayed inline in the browser, that is, as a Web page or as part of a Web page, or as an attachment, that is downloaded and saved locally. The  Content - Type  entity header is used to indicate the media  type  of the resource. In responses, a  Content - Type...