StrataFrame Forum

Create View Fails

http://forum.strataframe.net/Topic26949.aspx

By Larry Caylor - 4/21/2010

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 Crazy
By Larry Caylor - 4/21/2010

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.
By Larry Caylor - 4/21/2010

I should have posted this in the DDT secition. Feel free to move it.
By Edhy Rijo - 4/21/2010

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.
By Larry Caylor - 4/22/2010

I should probably read the documentation some time Blush Thanks Edhy.
By Greg McGuffey - 4/22/2010

I should probably read the documentation some time Blush




Whoa! Let's not get carried away....Wink
By Bill Cunnien - 4/22/2010

There's documentation?!?

w00t
By Edhy Rijo - 4/22/2010

Bill Cunnien (04/22/2010)
There's documentation?!? w00t

Where? Hehe

By Keith Chisarik - 4/22/2010

What's is this "documentation" thing you speak of?
By Charles R Hankey - 4/22/2010

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