|
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 05/12/2008 2:35:16 PM
Posts: 12, Visits: 48 |
| | 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
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926 |
| | 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. |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 05/12/2008 2:35:16 PM
Posts: 12, Visits: 48 |
| 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
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926 |
| The error that you are getting is coming from SQL Server....do you mind translating the error message? Sorry  |
| |
| | | 
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:54:54 PM
Posts: 551, Visits: 10,431 |
| | Invalid object. Extended properties are not allowed in 'dbo.sysProjetPropoestaBO_lkp' or the object doesn't exist. |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 05/12/2008 2:35:16 PM
Posts: 12, Visits: 48 |
| 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 |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926 |
| | 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. |
| |
| | | StrataFrame Beginner
Group: StrataFrame Users
Last Login: 05/12/2008 2:35:16 PM
Posts: 12, Visits: 48 |
| Sql Server 2005 Express
Strataframe 1.6.5 |
| |
| | |
|