Create View Fails


Author
Message
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
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 Crazy
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search