| Author |
Message
|
| amitkan2000 |
 Posted: Mon Feb 22, 2010 1:31 pm Post subject: Get File using FileInput Node with remote FTP option |
 |
|
Novice
Joined: 22 Feb 2010
Posts: 12
|
Hi,
I am trying to create a Message Flow which will get the File using FTP option of FileInput Node. Flow is like this ---
FileIn --> Compute --> MQOut
I have defined the FTPServer configurations at my broker ..
| Code: |
1. mqsisetdbparms WBRK61_DEFAULT_BROKER -n ftp::secId -u userName -p password
2. mqsicreateconfigurableservice WBRK6_DEFAULT_BROKER -c FtpServer -o Server01 -n serverName,securityIdentity -v myFTP,secId |
On my flow I have set following properties of the FileInput node.
| Code: |
Input Directory -- C:\MBTest
File name or Pattern --- InputMsg.xml
Input Message Parsing -- XMLNSC
Action on successful parsing -- Add Timestamp and Move to Archive sub directory
Parser Options -- Immediate |
FTP ----
| Code: |
Remote Transfer -- Checked
Transfer Protocol -- FTP
Server and Port -- Server01
Security Identity -- secId
Server Directory -- .
Transfer Mode -- Binary
Scan Delay -- 20 |
My Environment --
MB Tool kit - 6.1.0.4
OS - Windows XP SP 3
Remote FTP Server - Windows XP SP 3
Problem --
My problem is when I deployed the flow, FileInput node is picking the file and processing this, but it is not removing the file from the FTP Server, this leads to reprocessing the same file by picking that from remote server again.
Below Options I have tried ---
1. Increasing the poll time of FTP option from 20 to 40 and then to 60.
2. Changed the Action on Successful Parsing to - Delete.
But with both the options, the problem does not get resolved. Also there is no error reported in the Event Viewer of Windows as well.
Can somebody give some pointers on to this problem? or is this a windows environment specific problem. In my case File Size -- 351 KB, which is not so big.
Thanks in advance.
Regards,
Amit |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Feb 22, 2010 1:55 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Do you have permission to delete the file on the remote server? |
|
| Back to top |
|
|
| amitkan2000 |
| Posted: Mon Feb 22, 2010 2:24 pm Post subject: |
|
|
Novice
Joined: 22 Feb 2010
Posts: 12
|
| Yes on the FTP Site Properties of IIS, All 3 Read, Write, Log Visits permissions are given... |
|
| Back to top |
|
|
| amitkan2000 |
| Posted: Tue Feb 23, 2010 11:48 am Post subject: |
|
|
Novice
Joined: 22 Feb 2010
Posts: 12
|
I thought that there might be some problem with MB 6.1.0.4 so I upgraded to 6.1.0.5 but still the problem is same...
Does anybody face this problem before? or I am the lucky one.  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Feb 23, 2010 1:34 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Do you have anothe FTP Server you can point the FileInput Node at?
If I were you, I'd setup a Linux Server that I had root access to ( A Live Fedora or Ubuntu CD would do fine) or running it in a Virtual Machine. Then I'd try your flow against it setting the various file & directory & user permissions, not forgetting the 'umask' value for the user
This way, you have complete control of the FTP end of things. You will find out what works and what does not.The System Logs will also help here.
Sometimes, the OOTB settings on ftp directories are not quite right.
One last point, IIRC, the File Input Node can be set to move the file into another directory. Why not try that if deletion fails. Does the user have the abilty to create directories on the FTP side of things?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| amitkan2000 |
| Posted: Wed Feb 24, 2010 11:09 am Post subject: |
|
|
Novice
Joined: 22 Feb 2010
Posts: 12
|
Hi smdavies99,
Thanks for your response.
In my post I have mentioned that I have tried with both the options, i.e. 1. Move file to archive directory from FTP directory
2. Delete file from the FTP directory
The FTP Client user is added on the server folder security settings.
On windows environment I am facing this problem with other FTP Server as well. But we do not have UNIX based environment. I think that always we might not have UNIX environment for each and every project, and typically this should work with windows as well..
I was trying to figure out that if this is a known problem or somebody has faced this before, or is there are some pointers towards resolution.
Thanks & Regards,
Amit |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Feb 24, 2010 11:13 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Amit - Either the user DOESN'T actually have permission to delete the file even though you THINK it does, or you have run into a defect.
It is *much* more likely to be the former. If you have really done everything possible to eliminate that as a possibility, including using an FTP command line to log into the FTP server as the same user and are able to delete the file, then take a startup trace and open a PMR.
It is also possible that it is not actually "the same" file that is getting processed, just that the sending application is putting PART of the file out, which is getting read and deleted, and then MORE of the file is being put out, which is getting read and deleted.... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Feb 24, 2010 11:15 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Also, you say you upgraded from 6.1.0.4 to 6.1.0.5, but you only listed your TOOLKIT version, so please make sure that your *runtime* is at 6.1.0.5.
Secondly make sure that you are not trying to read the same file from two separate brokers. There's no way that the two brokers can tell that the other one is trying tto read the same file at the same time. |
|
| Back to top |
|
|
| amitkan2000 |
| Posted: Tue Mar 02, 2010 12:12 pm Post subject: Problem resolved |
|
|
Novice
Joined: 22 Feb 2010
Posts: 12
|
Hi,
The problem is resolved, as it was correctly stated by all the Gurus that user must have the rights.
I was checking the rights for the broker user, but rights need to be define for the FTP user. Once defined the problem is resolved.
Thanks once again for the help.
Regards,
Amit |
|
| Back to top |
|
|
| CAONIMA |
| Posted: Tue Apr 21, 2015 6:35 am Post subject: Re: Problem resolved |
|
|
Acolyte
Joined: 03 Dec 2014
Posts: 65
|
| amitkan2000 wrote: |
Hi,
The problem is resolved, as it was correctly stated by all the Gurus that user must have the rights.
I was checking the rights for the broker user, but rights need to be define for the FTP user. Once defined the problem is resolved.
Thanks once again for the help.
Regards,
Amit |
Hi
How to define the rights for the FTP user |
|
| Back to top |
|
|
|
|
