What are the challenges you face when working across database platforms? Take the survey
Options

Azure devops build pipeline fails for Userdefined Data types.

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.
Tagged:

Answers

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    It looks like this was caused by SQL code in Post-Deployment script, the user has resolved this by adding and object existence check
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.