Installation Error - An error occurred while deploying the data to the server.
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Installation Error - An error occurred while...Expand / Collapse
Author
Message
Posted 01/19/2008 12:17:32 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 01/22/2008 11:04:32 PM
Posts: 3, Visits: 6
I get an error when installing Strataframe.

Here is the log file:

• 1/19/2008 10:11:57 AM -> Deploying meta-data for database 'StrataFrameSample'
X 1/19/2008 10:11:58 AM -> Creating database 'StrataFrameSample' failed.FailedOperationException
  Create failed for Database 'StrataFrameSample'.
ExecutionFailureException
  An exception occurred while executing a Transact-SQL statement or batch.
SqlException
  CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StrataFrameSample_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.

Source     : Microsoft.SqlServer.Smo

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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
   at Microsoft.SqlServer.Management.Smo.Database.Create()
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType)

• 1/19/2008 10:11:58 AM -> Finished verifying databases on server.
• 1/19/2008 10:11:58 AM -> The meta data conversion to the SQL Server has been completed.
X 1/19/2008 10:11:58 AM -> An error occurred while deploying the data to the server.NullReferenceException
  Object reference not set to an instance of an object.

Source     : MicroFour StrataFrame DBEngine

Stack Trace:
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.TurnOffAllForeignKeys(String DatabaseName)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()

Post #13574
Posted 01/19/2008 9:39:00 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:47:41 AM
Posts: 4,104, Visits: 4,175
This is a common issue that can creep up on you when using SQL Server.  More than likely, you either uninstalled SQL Server or manually detached the StrataFrameSample database.  However, neither of these will delete the mdf and ldf files.  So when you then turn back around and try to install, it will attempt to create those files but they already exist on disk and thus the error.  To get around this, make sure that the StrataFrameSample database is not attached to your SQL Server, and then go to the c:\program files\microsoft sql server\... (wherever you install SQL Server) and go to the data directory and manually delete the StrataFrameSample.mdf and StrataFrameSample.ldf files...then try again
Post #13579
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 10:03am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 8 queries. Compression Enabled.
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.