Problem:
When a SQL statement is truncated, the full statement is not displayed in a snapshot. By default, a snapshot will only display up to 999 characters from a SQL statement.
Solution:
Create a node property with the following information, and set it to a higher value than 999 in order to display the complete SQL statement.
property: max-length-batch-sql
desc: max-length-batch-sql
type: Integer
value: 2000