If you have changed your SQL capture settings from filter parameter values to capture raw SQL, longer SQL queries are now truncated to 999 characters. To change this character limit within the Controller, edit or register a new node property.
In the Controller UI, click on Tiers and Nodes in the left navigation bar. Then double click on the node you'd like to configure, and click Agents > App Server Agent > Configure. This will open the App Server Configuration window.
At the node level, click on the Use Custom Configuration button. Then either search for the max-length-batch-sql
property and double click on it, or click on the gray plus sign to create a new agent property if the max-length-batch-sql
property does not already exist.
In the Create Agent Property window, provide values for the name, description, type, and value of the new property (see example and screenshot below). Click the save button to close the window.
Then click the save button after adding the new configuration. A "saved successfully" message should appear in the top right corner of the window when done correctly.
Lastly, exit the App Server Configuration window and click the reset button. This will allow the agent to inherit the new changes.
For additional information, see documentation on how to add a registered node property.
Example:
Name = max-length-batch-sql
Description = Increases character limit for SQL queries
Type = Integer
Value = 2000