DDT Deployment Error - SQL 2000


Author
Message
Tim Dol
Tim Dol
StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)StrataFrame User (408 reputation)
Group: Forum Members
Posts: 340, Visits: 1.4K
I'm deploying to a SQL 2000 DB and I receive the following error on 2 tables.  Cannot access property XmlSchemeNamespace.   The tables only have two or three fields.

 The table 'sys_ActiveUsers' is being prepared to be modified.
X 09/02/2007 8:44:35 PM -> Altering table 'sys_ActiveUsers' failed.
X 09/02/2007 8:44:35 PM -> FailedOperationException       
X 09/02/2007 8:44:35 PM ->  Alter failed for Table 'dbo.sys_ActiveUsers'.        
X 09/02/2007 8:44:35 PM -> UnknownPropertyException       
X 09/02/2007 8:44:35 PM ->  Cannot access property XmlSchemaNamespace.This property is not available on SQL Server 2000.       
X 09/02/2007 8:44:35 PM ->        
X 09/02/2007 8:44:35 PM -> Source     : Microsoft.SqlServer.Smo       
X 09/02/2007 8:44:35 PM ->        
X 09/02/2007 8:44:35 PM -> Stack Trace:        
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)       
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.Column.ScriptAlter(StringCollection alterQuery, ScriptingOptions so)       
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.PropagateScript(StringCollection query, ScriptingOptions so, PropagateAction action)       
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()       
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()       
X 09/02/2007 8:44:35 PM ->    at Microsoft.SqlServer.Management.Smo.Table.Alter()       
X 09/02/2007 8:44:35 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)       
X 09/02/2007 8:44:35 PM ->        
• 09/02/2007 8:44:36 PM -> The table 'sys_Users' is being prepared to be modified.
• 09/02/2007 8:44:37 PM -> The table 'sys_Users' was successfully altered.
• 09/02/2007 8:44:37 PM -> The table 'sys_Licence' is being prepared to be modified.
X 09/02/2007 8:44:37 PM -> Altering table 'sys_Licence' failed.
X 09/02/2007 8:44:37 PM -> FailedOperationException       
X 09/02/2007 8:44:37 PM ->  Alter failed for Table 'dbo.sys_Licence'.        
X 09/02/2007 8:44:37 PM -> UnknownPropertyException       
X 09/02/2007 8:44:37 PM ->  Cannot access property XmlSchemaNamespace.This property is not available on SQL Server 2000.       
X 09/02/2007 8:44:37 PM ->        
X 09/02/2007 8:44:37 PM -> Source     : Microsoft.SqlServer.Smo       
X 09/02/2007 8:44:37 PM ->        
X 09/02/2007 8:44:37 PM -> Stack Trace:        
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)       
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.Column.ScriptAlter(StringCollection alterQuery, ScriptingOptions so)       
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.PropagateScript(StringCollection query, ScriptingOptions so, PropagateAction action)       
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()       
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()       
X 09/02/2007 8:44:37 PM ->    at Microsoft.SqlServer.Management.Smo.Table.Alter()       
X 09/02/2007 8:44:37 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)       

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Tim Dol - 17 Years Ago
Tim Dol - 17 Years Ago
StrataFrame Team - 17 Years Ago
Tim Dol - 17 Years Ago
StrataFrame Team - 17 Years Ago
                         ("")
Tim Dol - 17 Years Ago
                             Ah, remove that from the default value... or change it to (''), single...
StrataFrame Team - 17 Years Ago
                                 Thanks Ben, that seemed to correct my problem. :hehe: I really...
Tim Dol - 17 Years Ago
                                     Excellent, let's get the other one fixed, too ;)
StrataFrame Team - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search