StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Create View Fails

Create View Fails

Larry Caylor — Thu, 22 Apr 2010 17:25:36 GMT

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:

RE: Create View Fails

Charles R Hankey — Thu, 22 Apr 2010 17:25:36 GMT

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

RE: Create View Fails

Keith Chisarik — Thu, 22 Apr 2010 16:33:02 GMT

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

RE: Create View Fails

Edhy Rijo — Thu, 22 Apr 2010 15:58:00 GMT

[quote][b]Bill Cunnien (04/22/2010)[/b][hr]There's documentation?!? :w00t:
[/quote]

Where? :hehe:

RE: Create View Fails

Bill Cunnien — Thu, 22 Apr 2010 15:27:21 GMT

There's documentation?!?
:w00t:

RE: Create View Fails

Greg McGuffey — Thu, 22 Apr 2010 15:15:16 GMT

[quote]I should probably read the documentation some time :blush:[/quote]

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

RE: Create View Fails

Larry Caylor — Thu, 22 Apr 2010 10:22:16 GMT

I should probably read the documentation some time :blush: Thanks Edhy.

RE: Create View Fails

Edhy Rijo — Wed, 21 Apr 2010 21:20:41 GMT

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.

RE: Create View Fails

Larry Caylor — Wed, 21 Apr 2010 18:59:42 GMT

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

RE: Create View Fails

Larry Caylor — Wed, 21 Apr 2010 18:16:44 GMT

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.