… column headings with a “Value” containing more than 8000 characters will be truncated to 8000 characters in this view
‘’
I know it is for retrieved properties, but I don’t know whether we have this limitation for analysis result. My plan is to have an analysis which will return the content of a log file and display the result at console, so the size of the analysis could be pretty large.
The database stores long results in a different database table (LONGQUESTIONRESULTS) and the console knows how to retrieve this data… So longer results should work fine (although you need to be careful because they can have a performance penalty and potential scaling issues).
Any ideas regarding how to overcome size limitations inherent to the ‘line of file’ inspector? @JasonWalker taught me it has a limit of 2,048 characters and my expected results are close to 4,200.
The query below finds the newest line in the file I need it from but the analysis result gives the infamous … error description.
line (maximum of line numbers of lines containing "ServerEPS_LaneServiceStatusUpload MESSAGE" of it) of file whose (name of it starts with "jrnl" AND (name of it does not contain "-")) of folder "C:\Program Files\MicroTrax\OpenEPS"
Can you provide more details on what you are trying to achieve? That context would be helpful for providing guidance/recommendations.
That said, without such context, one potential approach might be to run an action to copy the file, insert line feeds/carriage returns with something like powershell, and then parsing the output with a property.
Note this would also give an error on any machine missing that directory path or file. You may be encountering the line length limit issue, but that is not the only potential error.
Sorry, I’m not sure what changed (I’m not the only one with access) but “error” is no longer what I see in the Analysis Results, I now see “multiple results”.
Here is what I see when expanding the Analysis Property within the Summary tab of a target (within the Results tab of the Analysis “multiple results” is what I see), or when hovering over “multiple results”.
So far the correct file is always found, but I’m not sure what the additional quotation marks are all about at the end of the answer…
This is the “it” in my query: file whose (name of it starts with “jrnl” AND (name of it does not contain “-”)) of folder “C:\Program Files\MicroTrax\OpenEPS”
The extra “” are because you’re looking at the file object, not just ‘name of file’. If the file had a version, publisher, etc. tgose would be in the additional fields.
Ok so that’s a single line that seems to have been split up in reporting the result. Congrats, you seem to have hit both a client inspector limit and a console display limit.
I could probably send you a sticker if you find the workaround
I’d probably take that line and parse it into separate results for each field of interest, if that is useful at all. Or possibly use a Dashboard rather than an Analysis to view the result, so you could combine that in session relevance.
