Fixed with flat file...need help

Hi,

I am using webMethods 8.0. I have a service that gets a fixed width flat file via FTP. When the file is ftp’ed, the service reads the first 3-4 lines correctly, but after that it outputs data randomly.

If I pass the same file to the service using getFile, then I get correct results.

Please see attached my test webservice and attached test file for reference.

Please help me find out where I am messing up when I pass the file thru FTP.

Thanks much!
Harish
RBCReleaseManagement.zip (17.8 KB)
test.txt (5.31 KB)

When I pass data via FTP below is my debug log for the data read

[392735]2011-06-08 10:23:14 CDT [ISP.0090.0003C] C37AE196
[392734]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 2701
[392733]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 2701
[392732]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 2701
[392731]2011-06-08 10:23:14 CDT [ISP.0090.0003C]
[392730]2011-06-08 10:23:14 CDT [ISP.0090.0003C]
[392729]2011-06-08 10:23:14 CDT [ISP.0090.0003C]
[392728]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 000003585370
[392727]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 000003585369
[392726]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 000003585368
[392725]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 000003585367
[392724]2011-06-08 10:23:14 CDT [ISP.0090.0003C] 000003585366

When the same file is passed using getFile, below is the debug log result.

[392744]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585374
[392743]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585373
[392742]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585372
[392741]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585371
[392740]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585370
[392739]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585369
[392738]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585368
[392737]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585367
[392736]2011-06-08 10:25:05 CDT [ISP.0090.0003C] 000003585366

As you can see in the FTP log, after the 5th record, the data comes out random. I hope this would help clarify the issue I am having.

Attached is the Pipeline data for the same file when passed via FTP. As you would see from the 5th record the Pipeline is messed up. I am not sure why this would happen.
harishDebug.txt (19.9 KB)

Hi Harish,
There shouldnt be any difference ideally even if use FTP polling or getFile.
I tried to import your package and test it. It produced same results.

Are you able to reproduce your issue?

here are the logs:
[19]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585374[18]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585373[17]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585372[16]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585371[15]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585370[14]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585369[13]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585368[12]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585367[11]2011-06-09 11:09:24 EDT [ISP.0090.0003C] 000003585366[10]2011-06-09 11:08:23 EDT [FF.0001.0032C] File polling processing service access denied. User Administrator not allowed to run service ReleaseManagement.work:sequenceSchedule866[9]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585374[8]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585373[7]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585372[6]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585371[5]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585370[4]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585369[3]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585368[2]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585367[1]2011-06-09 11:05:27 EDT [ISP.0090.0003C] 000003585366

attached is the pipeline I saved while using FTP polling.

-Srikanth G
ftp.xml (19.2 KB)

Srikanth

Did you have to modify any parameter in my package to make it work, other than the Pipeline debug file path.

One more thing I observe is that in your pipeline you are getting Content-Type = text/plain which I did not see in my pipeline output.

I am able to replicate the issue.

Thanks!
Harish

nope… i just had to change filepath accordingly…
and have added a savepipelinetoFile…

Donno if this will help, but just try reloading the package or restart the server.

Srikanth G

Actually it did work after I started my developer today. Amazing :rofl:

Thanks a lot.

Am glad it workd… :slight_smile:
BTW did u restart the developer or IS?

Designer.

I had restarted IS for quite a few times in between, but that did not fix it.