I'm using DDT v 1.7.0.7.  I've created some views in the DDT that use user defined functions. When I try to deploy the package the creation of the views fail because they can't find the referenced UDF. It appears the reason for this is that the DDT creates the views prior to the UDF. In an attempt to get around this I removed the view and redeployed. When the job finished the UDF was in the database. Next I put the views back in but the deployment failed since it appears that the DDT deletes the UDF, views and other objects before it recreates anything. So when it tried to create the view the UDF wasn't there and it failed. In an attempt to get around that issue I deleted the UDF from the DDT redeployed and then added it manually and tried once more. Unfortunately it appears the the DDT "Remembers" objects even after they have been deleted and it is now deleting my manually added UDF and the creation of the views still fail. This wasn't an issue before and I'm thinking it must have started with one of the 1.7.x releases. HELP

I verified the DDT 'Remembering' issue by renaming my UDF and adding to the DB manually. The DDT now leaves that alone and I can modify my view to reference the new name. it's a workaround but kind of messy. What's needed is some way to define a dependency between a UDF and a view and have the DDT take that into account when it deploys or have multiple deployment passes for objects and be able to specify what pass they are deployed in.

I should have posted this in the DDT secition. Feel free to move it.

Hi Larry,



All objects in the DDT have a "Priority" field which allows you to set which object should be created first. By default it will assign the number 10, but you could use whatever value to get the DDT to work on your objects based on this priority order, so in your case you should have assigned a lower priority to your UDF 9 or less and then left your view with 10 this way the DDT will always work on the UDF before the View.

Edhy Rijo

I should probably read the documentation some time Thanks Edhy.

Whoa! Let's not get carried away....

There's documentation?!?

Where?

Edhy Rijo

What's is this "documentation" thing you speak of?

Keith Chisarik

It's a crutch for people too lazy to use the debugger