Skip to main content
Question

2018 fme server job submitter failing on user parameters.

Q
Forum|alt.badge.img

Good afternoon,

I am currently experiencing a issue with fme server job submitter and feeding user parameters via a csv file.

I have a workspace on a 2018 server that works fine if the user runs the work space directly from the repository and within the workspace the user can select from a variety of user parameters to extract data based on date, format, projection etc.

when i try to run that workspace via a server job submitter using a csv file containing all the parameter details it appears that the server job submitter is truncating or moving the parameters to the next parameter. This appears to be happening with part of the date formatting.

if i remove the date formatting out of the csv then the server job submitter appears to run correctly.

the date format is needed as our data base is quite particular about extracting in that particular format.

below is a snip from the log file. you can see that the server job submitter appears to moving the data within the parameter to the next parameter.

FMEServerJobSubmitter(ServerFactory): Unable to process parameter '00:00:00' with type 'Perferred_Format'FMEServerJobSubmitter(ServerFactory): Unable to process parameter 'TAB' with type 'File_Path'FMEServerJobSubmitter(ServerFactory): Unable to process parameter '/dsupply/DATADUMP/QA_Output/Nov_2018' with type 'Coordinates'

 

FMEServerJobSubmitter(ServerFactory): http://srv-bx-fmed:8080 - Running workspace 'LGA_DTDB_EXTRACTION_2018_FME_SERVER.fmw' in repository 'Test'...FMEServerJobSubmitter(ServerFactory): http://srv-bx-fmed:8080 - Job #1080 finished running with errorsFMEServerJobSubmitter_Failed: Feature is:Feature Type: `FMEServerJobSubmitter_Failed_LOGGED'Attribute(string) : `Coordinates' has value `MGA94-55'Attribute(string) : `File Path' has value `/dsupply/DATADUMP/QA_Output/Nov_2018'Attribute(string) : `Job Folder' has value `BERRIGAN_topo20181101'Attribute(string) : `Job_Extraction_Date' has value `2018-11-01 00:00:00'Attribute(string) : `LGA' has value `BERRIGAN'Attribute(string) : `Preferred Format' has value `TAB'Attribute(string) : `Topographical Features' has value `aggregatedway_nd'

any help on this would be great.

4 replies

david_r
Evangelist
  • david_rEvangelist
  • October 30, 2018

Can you post some lines from the CSV that triggers the error, as well as a screenshot of your CSV reader configuration?

virtualcitymatt
Celebrity
Forum|alt.badge.img+34

I've seen this issue before. In the past for me it's because I was using 'Text' as the Parameter type when 'Text (Multi-line) worked better.

 

My guess is that the space n the 'Job_Extraction_Date' is what is causing the problem. If the published parameter which is receiving that `2018-11-01 00:00:00' is set to 'Text' then it may be seeing the space between the date and the time as a problem. One possible solution is to change that Parameter to Text(multi-line). Give it a try to see if it help.

 

 

H
Forum|alt.badge.img+2

Hi @qmangaming,

This was a known issue for some of the early versions of FME 2018.1 where FMESJS throws the warning message that indicated FME wasn't parsing the list of parameter values inside the JobSubmitter correctly, instead FME was picking up the part after the space (your time) as the next parameter value.

This has been verified fixed on 2018.1 b18535 for win64 and linux and 2019.0 b19087 on win64 and linux so please try upgrading FME Server to resolve the issue.

Q
Forum|alt.badge.img
  • qmangaming
  • Author
  • October 30, 2018

HI All, thank you for the responses. I will change the parameter to text line and report back on how i go

i will talk to the server admin about updating the server as well.

cheers

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,436
Replies
38,765
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.