Azure devops build pipeline fails for Userdefined Data types.

Shailaja

Build job failed with the following error messages. I have included User defined datatypes in the filters section when committing changes to source control. In my build job I have selected Build a SQL Change Automation project under operations.

Sergio R

When you say you included User defined datatypes in the filters section, do you mean that you excluded them using a filter? If that's the case then they shouldn't be in the repository and as a result shouldn't be part of the build. To get to the bottom of this we will probably need to try to reproduce this using the scripts folder. I am going to contact you directly shortly.

Sergio R

It looks like this was caused by SQL code in Post-Deployment script, the user has resolved this by adding and object existence check