topic Getting parsing error on Alteryx server in Alteryx Server Discussions

Getting parsing error on Alteryx server

hemal91 — Mon, 12 Dec 2022 16:27:22 GMT

Hello,

I recently deployed one workflow to server and it's failing with parsing error. The workflow runs without error on my desktop.

Below is the logic and error message on server.

if datetimeformat(DATEADD(DateTimeToday(),-4,"Days"),"%Y-%m-%d") == [HOLIDAY] then DateTimeFormat(DATEADD(DateTimeToday(),-3,"Days"),"%Y-%m-%d") else DateTimeFormat(DATEADD(DateTimeToday(),-2,"Days"),"%Y-%m-%d") endif

if DateTimeFormat([hldy_adj],"%u") IN ("1","2","6","7") then DATEADD([hldy_adj],-3,"Days") else DATEADD([hldy_adj],-1,"Days") endif

DATEADD([tera_date_b],-1,"Days")

-----------------------------------------------------------------------------------

Error
278 Parse Error at char(18): Unknown function "DATEADD" (Expression #1)
Error
278 Parse Error at char(19): Unknown variable "hldy_adj" (Expression #2)
Error
278 Parse Error at char(62): Unknown function "DATEADD" (Expression #3)
Error
278 Parse Error at char(62): Unknown function "DATEADD" (Expression #4)
Error
278 Parse Error at char(18): Unknown function "DATEADD" (Expression #5)
Error
278 Parse Error at char(62): Unknown function "DATEADD" (Expression #6)
Error
278 Parse Error at char(54): Unknown function "DATEADD" (Expression #7)
Error
278 Parse Error at char(0): Unknown function "DATEADD" (Expression #8)

Re: Getting parsing error on Alteryx server

PanPP — Mon, 12 Dec 2022 18:06:20 GMT

Hi @hemal91

1) Does the server machine have access to the file that is being used in the workflow?

- if not, I would recommend storing all files in a network location.

2) Did you mean to use the formula DateTimeAdd instead of DateAdd?

3) Is this a regular workflow or an analytic app?

Hope this helps.

Re: Getting parsing error on Alteryx server

TimN — Mon, 12 Dec 2022 18:02:21 GMT

There is no such function DATEADD. Maybe some one used the SDK and created it locally? That's the only thing I can think of. I see this for SDK info

https://help.alteryx.com/developer-help/build-custom-formula-functions

Re: Getting parsing error on Alteryx server

hemal91 — Mon, 12 Dec 2022 18:07:28 GMT

Hi,

1) I am using the macro which is stored on shared network location and a text input which is statically mentioned in workflow.

2) It is a regular workflow.

Re: Getting parsing error on Alteryx server

PanPP — Thu, 15 Dec 2022 02:26:16 GMT

The dateadd isn't a function.

Can you provide a sample workflow with data that processes this formula tool?

Text input --> Formula tool example