1.6.5 install error when deploying meta-data


Author
Message
Andria Jensen
Andria Jensen
Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)
Group: Forum Members
Posts: 336, Visits: 497
When running the install package for 1.6.5, it gets past the 'Install Visual Studio Templates' step successfully, but each time it gets about 75% done with 'Build StrataFrame Databases' and I get an error which says "An error occurred while deploying the meta-data to the server.  Please help so that I can get the new version installed.  Thanks.
Replies
Andria Jensen
Andria Jensen
Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)Advanced StrataFrame User (600 reputation)
Group: Forum Members
Posts: 336, Visits: 497
Here is the info from the log file which shows the error during installation:

• 3/10/2008 1:06:56 PM -> Deploying meta-data for database 'StrataFrame'
• 3/10/2008 1:06:57 PM -> Ensuring Filegroups exist on database 'StrataFrame'
• 3/10/2008 1:06:57 PM -> Filegroup verification complete.
• 3/10/2008 1:06:57 PM -> Ensuring Tables exist on database 'StrataFrame'
• 3/10/2008 1:07:09 PM -> Table verification complete.
• 3/10/2008 1:07:09 PM -> Dropping unneeded filegroups for 'StrataFrame'
• 3/10/2008 1:07:09 PM -> Unneeded filegroups dropped on database 'StrataFrame'
• 3/10/2008 1:07:09 PM -> Ensuring Indexes exist on database 'StrataFrame'
• 3/10/2008 1:07:13 PM -> Index verification complete.
• 3/10/2008 1:07:13 PM -> Ensuring Foreign Keys exist on database 'StrataFrame'
• 3/10/2008 1:07:17 PM -> Foreign Key verification complete.
• 3/10/2008 1:07:17 PM -> Ensuring Views, Stored Procedures, and UDFs exist on database 'StrataFrame'
X 3/10/2008 1:07:17 PM -> An error occurred while deploying the meta-data to the server.SqlException
  Invalid object name 'fn_listextendedproperty'.

Source     : .Net SqlClient Data Provider

Stack Trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AreExtendedPropertiesDeployed(DatabaseInfo dbInfo)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.GetListOfViewsSprocsAndUdfsToDrop(DatabaseInfo dbInfo)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DropAllDeployedViewsSprocsAndUdfs(DatabaseInfo dbInfo)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureViewsSprocsUdfs(Database parent, DatabaseInfo dbInfo)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Are you running SQL Server 2000 or 2005? We starting using an extended property in this reelase, and though our research indicated that the fn_listextendedproperty was support in 2000 we did not actually setup a 2000 server for testing and only test on 2005 and above servers.  So my guess would be that you are on 2000 and this property is not supported.  Confirm this and we can go from there.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search