Troubleshooting Tip: Playbook Step fails with Internal Server Error

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:

1. Log in to FortiSOAR and open the failing playbook in the Playbook Designer.
2. Review the conditions applied to the step that's failing. Check for the following:
   
   1. Verify if any Integer-type field is being compared with a numeric value, not a String or other data type.
   2. 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.