SteelCentral AppInternals 10.x CALLS Analysis operator does not show the full length SQL command

Categories:
Solution Number:
S32149
Last Modified:
2018-04-06
Issue
We have SteelCentral AppInternals 10.x Analysis Server and we are running the | calls operator. The output however does not display the complete SQL command assiocated with call. How can we view the complete SQL command and is there a configuration setting to change of the length of SQL statement displayed?

Example:


In the highlighted example you can see that the first and last SQL statements are not complete and missing some details in the middle.
Solution
When you the run the CALLS operator without excluding any columns from the display, we are capped at 104 characters at this time. If you hover over the SQL statement though you can see the full SQL statement as long as it is less than 256 characters.

Screenshot1:


In the above screenshot the SQL highlighted in Red shows truncated output for the operator results. However when you hover over SQL statement you can see the complete SQL as highlighted in Green.
The above is true only because the full SQL is less than 255 characters.

Now look at the SQL highlighted below

Screenshot2:

The above screenshot shows SQL that is result of the output is truncated at 104 characters but when you hover over the SQL statement you can see *more* of the characters but even that is truncated at 255 characters.

If you however do not want to hover over the SQL statement to look into the statement which is less than 255 but still not displayed completely then you need to exclude certain columns from call operator so we can display the statement without hovering (as long as it is less than 255 characters and more than 104 characters)

The below screenshot shows the same SQL which was truncated in Screenshot1 with excluding one column from display for the operator.
Screenshot3:



Currently there is no configuration setting accessible to use to control the length of the SQL statement that is displayed. There is an open bug to address the issue.
Bug 297442 - [Analysis Operator]: Ability to configure the analysis operator output sql column length to display the entire SQL

 
Environment
SteelCentral AppInternals 10.x
Attachments
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Can't find an answer? Create a case