Failed POS (Point of Sale Terminal and, well....)

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Failed POS (Point of Sale Terminal and, well....)

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 Name
2009-09-19 18:24:13,671 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 18:34:14,203 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 18:44:15,406 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 18:54:17,109 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 19:04:17,125 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 19:14:17,390 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 19:24:17,828 No Device found in the Name 'Server'
Please, Check Device Name
2009-09-19 19:34:18,187 No Device found in the Name 'Server'
Please, Check Device Name
2009-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).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources