StrataFrame Forum

View in DDT with subquery

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

By Angela Sampaio - 5/8/2008

Hello!

I'm trying to create a view with subquery in DDT but when I see the fields of view, appears only in the field you search subquery.

It has another way to achieve this?

Thank you

By Trent L. Taylor - 5/9/2008

Well,

Don't rely on that message window nor the fields it may (or may not) show once the view is closed.  We have a simple RegEx pattern that attempts to parse out the table and some of the view details...but it is not 100% by any means.  We did not feel like going to the energy of SQL Server to totally and 100% validate and parse a view since there are so many combinations.  The important thing is...does it execute properly once deployed?  That is really all that matters.

By Angela Sampaio - 5/12/2008

Hi Trent,



When orders to deploy in a DDT, the deploy stop and appears a error message talking about this view.



Is attached the error message.



Thanks
By Trent L. Taylor - 5/12/2008

The error that you are getting is coming from SQL Server....do you mind translating the error message?  Sorry Ermm
By Ivan George Borges - 5/12/2008

Invalid object. Extended properties are not allowed in 'dbo.sysProjetPropoestaBO_lkp' or the object doesn't exist.
By Angela Sampaio - 5/12/2008

Oh, i'm sorry... Smile The message:



Invalid object. They are not allowed in properties extended dbo.SysProjetoPropostaBO_lkp or the object does not exist.



Wink



Thanks
By Trent L. Taylor - 5/12/2008

What version of SQL Server are you trying to deploy to?  First, try to deploy a new instance of your database to a SQL Server 2005 instance (Express is fine).  This will just prove that the package is fine.  If you are deploying to SQL Server 2000 then you will want to be sure and download either the latest 1.6.5 build or the 1.6.6 beta as there was an issue in regards to the extended properties at one point a while back.

When the DDT deploys, it flags the database, UDFs, views, and sprocs with an extended property that indicates that the component was deployed using the DDT, so if a DBA or some other IT person adds their own views, UDFs, sprocs, etc. it will not remove them when updating.  That is what is giving you the error it would seem.

So version details, etc. will be helpful.  Thanks.

By Angela Sampaio - 5/12/2008

Sql Server 2005 Express

Strataframe 1.6.5
By Trent L. Taylor - 5/13/2008

Did you deploy to another instance without issue?  In order to work through the problem, you will first need to deploy a clean instance (not upgrade an existing database).  This is only for troubleshooting purposes.  Please do that first and then let me know.  Thanks.