ReferenceError: "NotifQuery_CSV" is not defined.

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

I initially had this error message, but resolved it and the process worked fine. All I did was change the SQL on the QUERY node and I get this error again. It does not make sense. When I put the old SQL query back, it works fine. Any suggestions.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

rmbell

Can we see the SQL queries? If the query node is called NotifQuery and the field name in the SQL is CSV, then it should not matter as long as there is a value in the query's results.

0911060553270289.pdf

unknown

The query code is a little long. Here is the messages after the query code in the run. I ran the code through SQL Management Studio and it ran w/o errors.

NotifQuery_errorCode = 0
NotifQuery_informationCode = 0
NotifQuery_returnMessage = SQL query NotifQuery: Execution complete.
NotifQuery_outputData =
Activity completed: NotifQuery
NotifQuery_RETURN_MSG = Success
NotifQuery_RETURN_CODE = 0
NotifQuery_errorCode = 0
NotifQuery_informationCode = 0
NotifQuery_returnMessage = SQL query NotifQuery: Execution complete.
NotifQuery_outputData =
NotifQuery_RECORD_COUNT = 581
SQL Query NotifQuery: Executing loop 1 of 581

Activity started: NotifQuery (Run Id: 1)
NotifQuery_RECORD_COUNT = 0

Activity started: End-NotifQuery (Run Id: 0)

rmbell

Was the field name in the query called CSV? If I make changes to a query and I don't alias the same field name, the result will bomb if it calls that field. Also, if there are no results(this case there appears to be 581 so that is good), the output will be undefined and will bomb on reference.

unknown

The CSV is not referenced in the query. It is referenced in the ASSIGN node displayed below.

john-miller

What version of IPA/Landmark are you running. I believe the issue is that there are some types joins that IPA had an issue making the CSV variable for. I believe the issue is resolved, although I'm not positive if it has been or which version it's been resolved in. That's why if you have one SQL query it works fine, and if you put in a different one (With the joins it can't seem to handle) you wont get the NotifQuery_CSV variable. You'll be able to tell in the Designer in the Log window, the _CSV variable should be created when the SQLNode runs.

KB: 1945086 - SQL Query Node Does Not Return Result for LEFT OUTER JOIN statement with 'Generate CSV from resultset' enabled.

JT-1101326

unknown

john-miller

Russ Had this answer last time the _CSV question came up. Perhaps this is your issue as well:

From: community.inforxtreme.com/.../has-anyone-used-the-sql-node-feature-generate-csv-from-resultset

@ChrisM

KB 1945086 - was tied to a JT which was closed working as designed.

In the incident which generated the KB article there was trailing whitespaces in the first select statement, when the trailing whitespaces were removed it then executed normally.

@Everyone RE: SQL Query Node

The SQL Node is not available in Multi-tenant Cloud; it won't disappear from ST cloud nor On-Premise installations

For those of you on newer versions Landmark 11, there is new functionality build into the Admin Console called Replication Dataset. This essentially uses database level tools to pull Landmark Data and generate a csv file from it. I believe you can set this so it either generates a full replication set each time it runs, or you can set it to only create a csv from records that have changed since the last run.

In other words, if I want to run this flow on every employee that has changed today ... I think you could create a replication set to generate a csv file daily only on records that were changed since the last time the rep set executed. I haven't played much with it, but it definitely warrants some testing/playing to see what we can accomplish with it

Copyright © 2025 Infor. All rights reserved.