Ad Account creation is 2 phase process. Initial account gets created with basic attributes like dn and few others and then other attributes are populated. There is possible aftercreate and after modify scripts are failing but if this issue is only in create then aftermodify is not in picture.
You can enable flag which will delete the account on AD side if whole provisioning is not successful.
Rollback of Created Account
The Active Directory source supports rollback of created account in case provisioning of one or more requested attribute/s fails during the provisioning operation. Set the rollbackCreatedAccountOnError attribute as True.
You need to use PATCH api and put this under connectorAttributes map.
For Servicenow I do not think we have this option but I have rarely seen this happening this kind of issues on SNOW create operations.