Create View Fails

StrataFrame Forum

Back

Create View Fails

Author	Message
Charles R Hankey	Charles R Hankey posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 524, Visits: 30K	It's a crutch for people too lazy to use the debugger
	Reply Like 0
Keith Chisarik	Keith Chisarik posted 14 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 939, Visits: 40K	What's is this "documentation" thing you speak of? Keith Chisarik Sigma Data Systems
	Reply Like 0
Edhy Rijo	E Edhy Rijo posted 14 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Bill Cunnien (04/22/2010) There's documentation?!? Where? Edhy Rijo
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	There's documentation?!?
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	I should probably read the documentation some time Whoa! Let's not get carried away....
	Reply Like 0
Larry Caylor	Larry Caylor posted 14 Years Ago Post Details Share Post
Group: Awaiting Activation Posts: 592, Visits: 3.7K	I should probably read the documentation some time Thanks Edhy.
	Reply Like 0
Edhy Rijo	E Edhy Rijo posted 14 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	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
	Reply Like 0
Larry Caylor	Larry Caylor posted 14 Years Ago Post Details Share Post
Group: Awaiting Activation Posts: 592, Visits: 3.7K	I should have posted this in the DDT secition. Feel free to move it.
	Reply Like 0
Larry Caylor	Larry Caylor posted 14 Years Ago Post Details Share Post
Group: Awaiting Activation Posts: 592, Visits: 3.7K	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.
	Reply Like 0
Larry Caylor	Larry Caylor posted 14 Years Ago Topic Details Share Topic
Group: Awaiting Activation Posts: 592, Visits: 3.7K	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
	Reply Like 0