StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Database Deployment Toolkit
»
Issues
»
Error DDT Deploy in Create View "Extended properties are not...
Error DDT Deploy in Create View "Extended properties are not supported"
Post Reply
Like
1
Error DDT Deploy in Create View "Extended properties are not...
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Jose Bressan(1)
Jose Bressan(1)
posted 11 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
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
Reply
Like
1
StrataFrame Team
S
StrataFrame Team
posted 11 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
Do you have the schema-bound checkbox checked on the view?
Reply
Like
1
Jose Bressan(1)
Jose Bressan(1)
posted 11 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
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
Reply
Like
1
StrataFrame Team
S
StrataFrame Team
posted 11 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
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.
Reply
Like
1
StrataFrame Team
S
StrataFrame Team
posted 11 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
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.
Reply
Like
1
Jose Bressan(1)
Jose Bressan(1)
posted 11 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
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
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search