Originally posted by: janhess

Mercator 6.7.1
Windows 2000

I have started getting this error returned from a map run under the Event Server and we haven't made any WTX changes. The map is calling a batch file to run ftp (done this way because we couldn't use the ftp adapter to send the files to a Fujitsu mainframe when written a few years ago).

If the map is rerun it works ok.

<TargetReport card="2" adapter="Batch File" bytes="0" adapterreturn="-6">
<Message>Error Executing Command (Return Code 2)</Message>
<Settings>-cmd "MERCCFR006Dftpcmd.bat e:\clasfiles65\POTENTIALREMOVALRESULTS.TXT" -tV -I</Settings>
</TargetReport>

Anyone got any ideas?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: TarunB

Could it be due to a transient network problem - either with the actual FTP attempt or with the e drive?

Do you think the adapter retry option will help in this case?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

Hi Tarun
The file that is being ftpd is produced by a web service. This also produces an ok file which triggers the map to run the batch process. We were considering the posibility that the webservice has held a lock on the file longer than normal (this map is running later in the day than normal when it fails). The error 2 from dos implies file not found.

The adapter retry may solve the problem but it's difficult to put changes live at this time of year without being able to prove it will fix the problem or not cause others. Fortunately the failure occurs at the end of the overnight batch processing and so can be picked up quickly in the morning.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

I used to do ftp batch files so much, I can't imagine there's a problem I didn't hit, but this was once upon a time. I used to get weird errors once in a while in the m4batch.mtr, mostly -1 if I can recall.

I don't know if adding a for loop to the batch file, like "IF ERRORLEVEL 2, trying it again x number of times" is better then adding the retry function.

Good luck with that.

Message was edited by: rep
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender