VERIFIED SOLUTION i

Issue with Job Executor

Issue

Customer is running into an issue with JobExecutor while executing these command lines in a .bat file:
 
@echo off
 
echo job is running...
 
"E:\Program Files\Java\jre6\bin\java.exe" -jar "\\<directorypath>\jobexecutor.jar" -i10 -t30 -w -r -j Geocode_AlteryxDev -u hqran -p "r2july" -h pldh059.pedc.sbc.com -s 35353 "Read from File"="esclient:%1" "Write to File"="esclient:%2" stagename=filename
 
echo job is completed.

In Command Prompt, it states Java executable is not recognized and the job has completed:
 
User-added image

In the Management Console > Execution History, the status of the job is "running" without any exception or error in the comment section of the history.
 
User-added image

Cause

The jobexecutor.log has a copy of the error that jobexecutor throws where the file path is wrong:

ECHO is off.
java.util.concurrent.ExecutionException: com.g1.dcg.executor.FileConnectException: Error occurred accessing file C\some\path\that\does\not\exist\output.txt: C\some\path\that\does\not\exist\output.txt (The system cannot find the path specified)
    at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
    at java.util.concurrent.FutureTask.get(Unknown Source)
    at com.g1.dcg.executor.LocalFileHandler.handleLocalFiles(LocalFileHandler.java:83)
    at com.g1.dcg.executor.LocalFileHandler.call(LocalFileHandler.java:120)
    at com.g1.dcg.executor.LocalFileHandler.call(LocalFileHandler.java:34)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.g1.dcg.executor.FileConnectException: Error occurred accessing file C\some\path\that\does\not\exist\output.txt: C\some\path\that\does\not\exist\output.txt (The system cannot find the path specified)
    at com.g1.dcg.executor.FileConnectCommand.connectFile(FileConnectCommand.java:82)
    at com.g1.dcg.executor.FileConnectCommand.call(FileConnectCommand.java:114)
    at com.g1.dcg.executor.FileConnectCommand.call(FileConnectCommand.java:32)
    ... 5 more
Caused by: java.io.FileNotFoundException: C\some\path\that\does\not\exist\output.txt (The system cannot find the path specified)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.<init>(Unknown Source)
    at com.g1.dcg.executor.FileConnectCommand.connectFile(FileConnectCommand.java:76)
    ... 7 more
xxx_CopyJob|687|cancelled


Jobexecutor does throw a FileNotFoundException for the output location and waits for the job to finish on the server. The job on the server never finishes because it is waiting for somewhere to write the output records. The records are not written because the file path was wrong.

Resolution

UPDATED: April 5, 2017
This issue was fixed in Spectrum 8 SP3
Environment Details
Product Feature: Installation / Upgrade

Operating System: Windows 2008

Version: Spectrum 8 SP1