When I recently moved our production environment to a new server and was working on deploying the entire data warehouse in TimeXtender I had some difficulties. First I did a complete (full?) and managed deploy which seemed to be successful. When I then tried to run a few execution packages one of them said it was missing a view. Then I did a differential managed deploy and it listed a lot of objects not already deployed!! OK, so I ran that which seemed to succeed as well. Tried the execution package that failed again but with the same result.

Third time I did a differential deploy but this time after the deploy was done I noticed that the scrollbar in the results dialog was not all the way up! There at the top an error message was hiding. I had guard on deploy on some tables which was highlighted and hence covering up the error message.

The actual error was that a view was not able to deploy because of a user defined function was missing. This UDF is defined in TimeXtender so why does it not get deploy with the rest of the objects?

And also, make sure all error messages are highlighted in the deploy results dialog and not the guarded objects please. :)