| Author | 
		  Message
		 | 
		
		  | amitkothari18 | 
		  
		    
			  
				 Posted: Sat Feb 12, 2011 12:42 pm    Post subject: Highly Urgent!!! Issue with SFTP using Fileoutput node | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 12 Feb 2011 Posts: 24
  
  | 
		  
		    
			  
				I am trying to use sftp transfer protocol to transfer a file from UNIX/WINDOWS to WINDOWS contact admin and getting below error:
 
 
Function:CHARACTER:transferToFtpServer
 
Type:CHARACTER:
 
Name:CHARACTER:
 
Label:CHARACTER:
 
Catalog:CHARACTER:BIPv610
 
Severity:INTEGER:3
 
Number:INTEGER:2115
 
Text:CHARACTER:
 
Insert
 
Type:INTEGER:5
 
Text:CHARACTER:FileOutput_EDIFECS
 
Insert
 
Type:INTEGER:5
 
Text:CHARACTER:EDI835_BS.Outbound_MF
 
Insert
 
Type:INTEGER:5
 
Text:CHARACTER:Unknown SFTP Exception: FTP protocol error
 
 
This is really critical for Production and any help is really appreciated.
 
WMBv6.1.0.5 and running on AIX5.1 and WINDOWS XP(I am have issues in both OS) | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Sat Feb 12, 2011 1:58 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				Are you sure the server is using SFTP, and not FTP or FTPS?  These are different, and only SFTP and FTP are supported by FileOutput.
 
 
Does a network level trace show you what the interactions look like? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | amitkothari18 | 
		  
		    
			  
				 Posted: Sat Feb 12, 2011 4:26 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 12 Feb 2011 Posts: 24
  
  | 
		  
		    
			  
				I tried to manually SFTP a file from unix server to the Windows server and it works fine.
 
I used:
 
$ sftp username@ipaddress
 
then it got connected and asked for password and on providing password,
 
I was able to transfer a file....
 
So, I believe the sftp is what we are using and it works fine.... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Sat Feb 12, 2011 4:56 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				What is the SFTP server on the remote end?
 
 
What is the full exception?  What is shown in the stderr/stdout or console.txt of the EG? What is shown in a service trace of the broker? What is shown in a network trace (Using perhaps, WireShark)?  
 
 
What does the log of the SFTP server say? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | zpat | 
		  
		    
			  
				 Posted: Sat Feb 12, 2011 11:54 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 19 May 2001 Posts: 5867 Location: UK 
  | 
		  
		    
			  
				If this is really an "urgent" production problem you should open a severity 1 PMR with IBM.
 
 
It is absurd to use this forum as a support service. I suppose it will be facebook next? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | ramires | 
		  
		    
			  
				 Posted: Sun Feb 13, 2011 4:13 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Knight
 
 Joined: 24 Jun 2001 Posts: 523 Location: Portugal - Lisboa 
  | 
		  
		    
			  
				@zpat: there is a facebook IBM Webspheree MQ page !    
 
 
@amitkothari18: did this worked before? The right thing to do is to open a PMR with IBM
 
 
Regards | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Sun Feb 13, 2011 6:11 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				
   
	| ramires wrote: | 
   
  
	@zpat: there is a facebook IBM Webspheree MQ page !     | 
   
 
 
 
And a twitter account.
 
 
Best of luck getting any kind of meaningful response from either. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | ramires | 
		  
		    
			  
				 Posted: Sun Feb 13, 2011 9:47 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Knight
 
 Joined: 24 Jun 2001 Posts: 523 Location: Portugal - Lisboa 
  | 
		  
		    
			  
				| I'm just saying it exists... not recommending it as support. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Sun Feb 13, 2011 3:28 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				
   
	| ramires wrote: | 
   
  
	| I'm just saying it exists... not recommending it as support. | 
   
 
 
     | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | amitkothari18 | 
		  
		    
			  
				 Posted: Sun Feb 13, 2011 8:33 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 12 Feb 2011 Posts: 24
  
  | 
		  
		    
			  
				Thanks everyone for their advices, I will surly do ahead an open a PMR.
 
I was using this forum to see if someone else also faced a similar problem while using SFTP transfer protocol using Fileoutput node. If I am missing some basic configuration. As when I try FTP transfer protocol with Fileoutput node it works absolutely fine, just when I try to use SFTP it is failing, I have taken care of basics like running the mqsisetdbparms command with "sftp::" and using the SFTP transfer protocol on the fileoutput node....do let me know if anyone has successfully used SFTP transfer protocol with fileoutput node... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | zpat | 
		  
		    
			  
				 Posted: Mon Feb 14, 2011 1:38 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 19 May 2001 Posts: 5867 Location: UK 
  | 
		  
		    
			  
				We use SFTP in fileoutput nodes.
 
 
Logon with the broker id (or sudo to it) and perform exactly the same SFTP manually. If it doesn't work....do the needful. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | napier | 
		  
		    
			  
				 Posted: Mon Feb 14, 2011 9:14 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 09 Oct 2007 Posts: 48 Location: USA 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Mon Feb 14, 2011 9:17 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				
 
 
That applies to FileInput node only - it has to do with trying to parse the directory listing that is returned over FTP/SFTP.
 
 
amitkothari18 is using FileOutput
 
   
	| Quote: | 
   
  
	| Text:CHARACTER:FileOutput_EDIFECS | 
   
 
 | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | amitkothari18 | 
		  
		    
			  
				 Posted: Mon Feb 14, 2011 9:40 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 12 Feb 2011 Posts: 24
  
  | 
		  
		    
			  
				@zpat: What version of WMB you are using?
 
 
I tried manually ftping using the username/password combination that I have used with security identity and it works fine... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Mon Feb 14, 2011 10:12 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				
   
	| amitkothari18 wrote: | 
   
  
	| I tried manually ftping using the username/password combination that I have used with security identity and it works fine... | 
   
 
 
 
FTP and SFTP are entirely different protocols. If you are able to establish a connection using a command line FTP program, you have made no progress in identifying why you can't establish an SFTP connection - except, perhaps, to cause a question about why you're trying to use SFTP at all. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |