Skip to main content
Question

Excel read write works in workbench but fails with strange error when published

F
Forum|alt.badge.img

I have an input excel file that is the source some HTTP calls are made to fill in columns in the spreadsheet using a template file and a defined output file overwritten. It runs in workbench but fails when published with an error that I can't locate the function or () it is complaining about. I have searched the error log for the text in the error and can't find a parameter with out a ()?

Function `XLSXW_OUT_TEMPLATEFILE_XLSXW_1' must be called with any parameters enclosed in ( ), even if there are none

 

Some details are:

FME Server 2016.0.1.1 - Build 16177 - win32

 

Copyright (c) 1994 - 2016, Safe Software Inc.

Direct Url Example

http://CODC1ITS8SGS984:8080/fmedatadownload/fmeservices/rlc_routecm2rpt.fmw?ExcelAnswerrtcm2rpt=G%3A%5CRFWorkspace%5Crlcupload%5CrlcUpload1Answer.xlsx&ExcelInputrtcm2rpt=G%3A%5CRFWorkspace%5Crlclrs%5CrlcUpload1.xlsx&RLCExcelTemplateFile=G%3A%5CRFWorkspace%5CrlcTemplateFile%5CrlcUpload1Template.xlsx&opt_showresult=false&opt_servicemode=async&opt_requesteremail=xxxxxxx

Published Parameters

Description

Parameter Name

Type

Current Value

Default Value

Options

Destination Microsoft Excel File:

ExcelAnswerrtcm2rpt

FILENAME

G:\\RFWorkspace\\rlcupload\\rlcUpload1Answer.xlsx

G:\\RFWorkspace\\rlcupload\\rlcUpload1Answer.xlsx

 

Source Microsoft Excel File(s):

ExcelInputrtcm2rpt

MULTIFILE

G:\\RFWorkspace\\rlclrs\\rlcUpload1.xlsx

G:\\RFWorkspace\\rlclrs\\rlcUpload1.xlsx

 

Template File:

RLCExcelTemplateFile

FILENAME_MUSTEXIST

G:\\RFWorkspace\\rlcTemplateFile\\rlcUpload1Template.xlsx

G:\\RFWorkspace\\rlcTemplateFile\\rlcUpload1Template.xlsx

 

2 replies

H
Forum|alt.badge.img+2

Hi @fish1ric,

In FME Server file paths should be referenced using a UNC path rather than a mapped drive (https://knowledge.safe.com/articles/376/workspace-fails-using-fme-server-data-in-mapped-dr.html). Please could you try referencing the file paths using a UNC path ensuring the account running the FME Server Services has permissions to read/write to these locations. I'm not sure that is the issue here but it is good to be aware of.

Users have encountered similar errors when there is a problem with the published parameter configuration, can you confirm if you right click >Edit Definition on the Template file parameter that none of the parameters are red?

Also is your FME Desktop the same build number as FME Server? I would like to try and repro the error but have not yet been able to - if you could also share your workspace and a sample dataset this would be helpful here.

nielsgerrits
VIP
Forum|alt.badge.img+54

Not sure if this is your issue, but I had some problems when writing to excel which were related to technical fme attributes.

In my case I used an AttributeKeeper to remove fme_db_operation from a feature which was send to both a database and excel. The issue was that techical fme attributes are getting unexposed, not removed, by an AttributeKeeper. So the excelwriter wanted to react on the fme_db_operation, saying it needed to delete a row, but had no source file.

These kind of issues are always hard to track down, so you might want to check this out.

Reply


Helpful Members This Week

Community Stats

31,183
Posts
118,189
Replies
38,791
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.