processFileLines gel tag as per:https://docops.ca.com/ca-ppm/15-6/en/reference/xml-open-gateway-xog-development/xog-gel-scripting/xog-gel-tag-library/xog-file-tag-library#XOGFileTagLibrary-file:readFile-ReadingDelimitedFiles
It’s supposed to process each line in turn in order to keep memory low, by not reading in the whole file into memory.
In reality, due to failing to reset some array of each line’s values, it ends up reading the whole file into memory anyway, but makes it harder to work with than before, and just moves where the accumulation takes place.
Attached a zip with a gel script, a .csv file, and an example of its output in a text file.
1. Copy the GEL file attached
2. Go to a 15.6 system
3. Connect to Command Prompt and run from /bin directory:
This should be enough to reproduce the issue, if the csv is in the same location too.
Expected Results: Output the data without duplication, each line should be new without old data
Actual Results: Old data is pulled into the results and the tag is unusable as it iterates over the old rows
See attached csv and output
NOTE: It affects scripts executed by process steps too, it’s just quicker to reproduce the issue from the command prompt.