ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
processFileLines gel tag is broken
Article ID: 129868
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
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.
STR:
1. Copy the GEL file attached
2. Go to a 15.6 system
3. Connect to Command Prompt and run from /bin directory:
gel fault.gel
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.
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.
STR:
1. Copy the GEL file attached
2. Go to a 15.6 system
3. Connect to Command Prompt and run from /bin directory:
gel fault.gel
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.
Environment
Release: CODSFF99100-15.6-PPM SAAS-Full Function User
Component:
Component:
Resolution
This is reported as DE48306, fixed in 15.6.1
Additional Information
It’s similar to DE37803 reported previously for reading of multiple files (fixed in 15.4) except that this affects the reading of multiple lines within a single file. Reference:
https://comm.support.ca.com/kb/filereadfile-that-uses-jellycomnikuuniongelfiletaglibrary-retains-data-from-files-that-it-read-before/kb000009130
https://comm.support.ca.com/kb/filereadfile-that-uses-jellycomnikuuniongelfiletaglibrary-retains-data-from-files-that-it-read-before/kb000009130
Attachments
Feedback
Yes
No
Powered by
