Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Mikie
Starting Member
1 Post |
Posted - 2009-09-19 : 10:36:20
|
Hello,Sorry to be an immediate tax on the forum.I am a Linux guy. I have a friend in India who is going nuts with a brand new POS with Microsoft SQL 2005 issues. I have an extensive error dump. Any clues on how I (we) may help her?2009-09-19 18:06:01,671 System.Data.SqlClient.SqlException: Failed to update database "FR6RootDB" because the database is read-only. 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.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at FusionRetail.clsDataAccess.ExecuteNonQuery(String sConnString, String sCommandText, Int32 iTimeOut)2009-09-19 18:06:01,671 <Sql> <Update Table="registration"> <edition>Enterprise</edition> <noofusers>3</noofusers> <isactive>False</isactive> <daysleft>-1</daysleft> <Where><![CDATA[1=1]]></Where> </Update></Sql>2009-09-19 18:06:01,671 System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "SaveXmlData":System.IO.FileLoadException: Could not load file or assembly 'System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)System.IO.FileLoadException: at XMLUtility.clsXmlUtility.SaveXmlData(String sXML, String sExportTableName, String sExportTableColumnName, String sEndPointColumnName, Boolean bFromFrontEnd, Int32 iMLDataType, Int32 iCreateLocationID, Int32 iModifyLocationID, Int32 iForOrToLocationID, Int32 iFromLocationID, String strReturnKey, Object& Output1). 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at FusionRetail.clsDataAccess.ExecuteNonQuery(String sConnString, String spName, IList`1 sqlParams, Int32 iTimeOut)2009-09-19 18:14:12,656 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 18:24:13,671 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 18:34:14,203 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 18:44:15,406 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 18:54:17,109 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 19:04:17,125 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 19:14:17,390 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 19:24:17,828 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 19:34:18,187 No Device found in the Name 'Server'Please, Check Device Name2009-09-19 19:44:18,453 No Device found in the Name 'Server'Please, Check Device Name |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-19 : 10:56:07
|
Well, the first line is pretty interesting:quote: Failed to update database "FR6RootDB" because the database is read-only
My first recommendation is to change that to a writable status and go from there. You can do that by running ALTER DATABASE FR6RootDB SET READ_WRITE in a query window (Management Studio). |
|
|
|
|
|
|
|