StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?) / View in DDT with subquery / Latest Posts

RE: View in DDT with subquery

Trent L. Taylor — Tue, 13 May 2008 09:48:28 GMT

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.

RE: View in DDT with subquery

Angela Sampaio — Mon, 12 May 2008 11:09:15 GMT

Sql Server 2005 Express
Strataframe 1.6.5

RE: View in DDT with subquery

Trent L. Taylor — Mon, 12 May 2008 09:07:08 GMT

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.

RE: View in DDT with subquery

Angela Sampaio — Mon, 12 May 2008 08:35:28 GMT

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

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

;)

Thanks

RE: View in DDT with subquery

Ivan George Borges — Mon, 12 May 2008 08:17:22 GMT

Invalid object. Extended properties are not allowed in 'dbo.sysProjetPropoestaBO_lkp' or the object doesn't exist.

RE: View in DDT with subquery

Trent L. Taylor — Mon, 12 May 2008 08:04:56 GMT

The error that you are getting is coming from SQL Server....do you mind translating the error message? Sorry :ermm:

RE: View in DDT with subquery

Angela Sampaio — Mon, 12 May 2008 07:38:49 GMT

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

RE: View in DDT with subquery

Trent L. Taylor — Fri, 09 May 2008 09:45:54 GMT

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.

View in DDT with subquery

Angela Sampaio — Thu, 08 May 2008 13:37:50 GMT

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