Troubleshooting Tip: Playbook Step fails with Internal Server Error

[jhimanshu]

Description	This article describes how to troubleshoot Playbook failure for the error 'Internal Server Error'.
Scope	FortiSOAR.
Solution	Check if the Prod Log shows the error 'SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean/integer'. To resolve this issue: Log in to FortiSOAR and open the failing playbook in the Playbook Designer. Review the conditions applied to the step that's failing. Check for the following: Verify if any Integer-type field is being compared with a numeric value, not a String or other data type. Confirm that Boolean-type fields are only being evaluated against valid Boolean values, i.e., True or False.  In addition, to check for an empty field, use 'Null' instead of the Value '""'. Reach out to Fortinet Support if the issue persists.