Error trying to write to a file

I have written a simple process to run a query and write to a file. However, I cannot figure out why I am getting the following error message. I have attached screen shots of the flow. I am starting the flow from Rich Client.

Activity Assign9060: Error evaluating expression: vOutput = NotificationQuery_CSV.replace(/"/g,"");; Error: org.mozilla.javascript.EcmaError: ReferenceError: "NotificationQuery_CSV" is not defined. (threadScript#1)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3687)

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

jreese

Are you sure the name of the SQL query is named NotificationQuery and not just labeled with that name?

All comments

unknown

Does your query contain a field called CSV?

Inquiry Tab Placement.docx

unknown

The only reference is what I put in the original post where vOutput = NotificationQuery_CSV.replace(/"/g,"");

in the FileAccess node.

unknown

The error is saying that there is no string variable called Notification_Query_CSV and therefore the .replace is not valid. Are you trying to do your replace on the entire result of your query or a specific field?

unknown

replacing "/" in all date fields of each records. We copied this command from another process that works and had no other reference or variable to the xxxx_CSV . NotificationQuery is the name I gave the Query Node if you look at the original post. Trying to just take records retrieved from my query and write to a file.

Copyright © 2025 Infor. All rights reserved.