Error DDT Deploy in Create View "Extended properties are not...

Author Message
 Posted 2/5/2013 10:33:30 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 1/14/2014 5:19:34 AM
Posts: 12, Visits: 326
Extended properties are not supported

->    en Microsoft.SqlServer.Management.Smo.View.Create()        
->    en MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)        
-> 
-> An error occurred while deploying the meta-data to the server.
-> SqlException        
->   Objeto no válido. 'config.vc_Ciudad' no admite propiedades extendidas o el objeto no existe.        
->         
-> Source     : .Net SqlClient Data Provider

The error only occurs when I change the view schema of "dbo" to another scheme in this case "config"

Please help me
Post #31782
Add to Twitter Add to Facebook
 Posted 2/6/2013 2:51:20 AM
StrataFrame Developer

StrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame Developer

Group: StrataFrame Developers
Last Login: 5/16/2018 3:20:37 AM
Posts: 2,982, Visits: 2,482
Do you have the schema-bound checkbox checked on the view?
Post #31783
Add to Twitter Add to Facebook
 Posted 2/6/2013 6:25:50 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 1/14/2014 5:19:34 AM
Posts: 12, Visits: 326
Hi Ben,

Yes, I have the schema-bound checkbox checked on the view

I tried uncheckbox and work fine, but i need  "schema-bound" checkbox checked on

Working
1- Deploy with  uncheckbox "schema-bound"
2- Deploy again with "schema-bound" checkbox checked on


Thank Ben
Post #31784
Add to Twitter Add to Facebook
 Posted 2/6/2013 6:28:24 AM
StrataFrame Developer

StrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame Developer

Group: StrataFrame Developers
Last Login: 5/16/2018 3:20:37 AM
Posts: 2,982, Visits: 2,482
OK, looks like there is a setting we're not putting on the schema when we first create it, but we are if the schema is already existing.  I'll take a look and see what I can find.
Post #31785
Add to Twitter Add to Facebook
 Posted 2/6/2013 6:33:53 AM
StrataFrame Developer

StrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame Developer

Group: StrataFrame Developers
Last Login: 5/16/2018 3:20:37 AM
Posts: 2,982, Visits: 2,482
Jose,

Do you have tables in the schema as well, or just views?  I see the logic where we are explicitly creating the schemas for SQL 2005+, but it only gets called for tables, not for views.
Post #31786
Add to Twitter Add to Facebook
 Posted 2/6/2013 9:27:25 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 1/14/2014 5:19:34 AM
Posts: 12, Visits: 326
Hi Ben,


Yes, I have tables in Scheme, and the views in the schema.

Working with MSSQL 2008r2. Image shows the tables and views

http://forum.strataframe.net/Uploads/Images/0600e914-8e51-4b89-9b12-8b7f.png
Post #31787
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.