|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
Working1- Deploy with uncheckbox "schema-bound"2- Deploy again with "schema-bound" checkbox checked on |
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|