Error loading products

Answered
Follow
Avatar
Ibrahim

Hi Aronium team,

Thank you for your great solution and support.

Today I had an issue in Aronium POS, suddenly stopped working today (it was working fine without any issue for a year). 

Can you please help me with this? 

 

Error Message:

Error loading products.

Some products may not be eligible for sale. Check failed products and try again.

 

Below is the log detail:

2022-05-06 01:53:05.042 INFO Aronium.Storage.Local.Services.CashRegisterService - Closing register and creating Z report
2022-05-06 01:53:05.222 INFO Aronium.Storage.Local.Services.CashRegisterService - Z report created.
    Number: 324
    From: 19944
    To: 20018
2022-05-06 11:15:09.694 ERROR Aronium.Pos.MainWindow - The process cannot access the file 'C:\Users\USER\AppData\Local\Aronium\Application.xml' because it is being used by another process.
2022-05-06 16:52:41.073 ERROR Aronium.Storage.Local.Data.OrderRepository - disk I/O error
disk I/O error
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteTransaction.Commit()
   at Aronium.Storage.Local.Data.OrderRepository.Save(Order order)
2022-05-06 16:52:41.082 ERROR Aronium.Storage.Local.Data.OrderRepository - Error occured while trying to rollback transaction
unknown error
No transaction is active on this connection
   at System.Data.SQLite.SQLiteTransactionBase.IsValid(Boolean throwError)
   at System.Data.SQLite.SQLiteTransactionBase.Rollback()
   at Aronium.Storage.Local.Data.OrderRepository.Save(Order order)
2022-05-06 16:52:42.110 ERROR Aronium.Pos.App - Unhandled exception caught!
disk I/O error
disk I/O error
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteTransaction.Commit()
   at Aronium.Storage.Local.Data.OrderRepository.Save(Order order)
   at Aronium.Pos.Common.Tasks.CreateOrder.Execute()
   at Aronium.Workflow.Task.ExecuteNext(Task task)
   at Aronium.Workflow.Task.MoveToTransition(Transition transition)
   at Aronium.Workflow.Task.ChooseTransition()
   at Aronium.Workflow.StartTask.Execute()
   at Aronium.Workflow.WorkflowContext.Run()
   at Aronium.Pos.ViewModels.MainViewModel.OnCreateOrder()
   at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
   at System.Windows.Controls.Primitives.ButtonBase.OnClick()
   at System.Windows.Controls.Button.OnClick()
   at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
2022-05-07 02:04:37.057 INFO Aronium.Storage.Local.Services.CashRegisterService - Closing register and creating Z report
2022-05-07 02:04:37.222 INFO Aronium.Storage.Local.Services.CashRegisterService - Z report created.
    Number: 325
    From: 20019
    To: 20104
2022-05-07 17:57:53.088 ERROR Aronium.Pos.Common.Tasks.Bootstrap.VersionChangeTask - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.<Select>d__25`1.MoveNext()
   at Aronium.Data.SQLite.DataRepository`1.<All>d__19.MoveNext()
   at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at Aronium.Storage.Local.Services.ApplicationService.GetProperty(String name)
   at Aronium.Pos.Common.Tasks.Bootstrap.VersionChangeTask.Execute()
2022-05-07 17:57:53.119 ERROR Aronium.Pos.Common.Tasks.Bootstrap.BackupDatabaseTask - database disk image is malformed
database disk image is malformed
2022-05-07 17:57:55.025 ERROR Aronium.Pos.Common.Tasks.Bootstrap.ProductLoader - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.<SelectInternal>d__15`1.MoveNext()
   at Aronium.Data.SQLite.Connector.<Select>d__26`1.MoveNext()
   at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
   at Aronium.Storage.Local.Services.ProductService.GetRootGroup()
   at Aronium.Pos.Facade.ProductFacade.LoadProducts()
   at Aronium.Pos.Common.Tasks.Bootstrap.ProductLoader.<>c__DisplayClass1_0.<Execute>b__0(Object sender, DoWorkEventArgs e)
2022-05-07 17:58:09.931 ERROR Aronium.Pos.Common.Tasks.Bootstrap.VersionChangeTask - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.<Select>d__25`1.MoveNext()
   at Aronium.Data.SQLite.DataRepository`1.<All>d__19.MoveNext()
   at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at Aronium.Storage.Local.Services.ApplicationService.GetProperty(String name)
   at Aronium.Pos.Common.Tasks.Bootstrap.VersionChangeTask.Execute()
2022-05-07 17:58:09.946 ERROR Aronium.Pos.Common.Tasks.Bootstrap.BackupDatabaseTask - database disk image is malformed
database disk image is malformed
2022-05-07 17:58:11.118 ERROR Aronium.Pos.Common.Tasks.Bootstrap.ProductLoader - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.<SelectInternal>d__15`1.MoveNext()
   at Aronium.Data.SQLite.Connector.<Select>d__26`1.MoveNext()
   at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
   at Aronium.Storage.Local.Services.ProductService.GetRootGroup()
   at Aronium.Pos.Facade.ProductFacade.LoadProducts()
   at Aronium.Pos.Common.Tasks.Bootstrap.ProductLoader.<>c__DisplayClass1_0.<Execute>b__0(Object sender, DoWorkEventArgs e)
2022-05-07 17:58:14.196 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:15.993 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:17.258 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:17.836 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:18.086 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:18.290 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:18.508 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()
2022-05-07 17:58:18.665 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed
database disk image is malformed
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Aronium.Data.SQLite.Connector.SelectValueInternal[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, Object obj, SQLiteConnection connection)
   at Aronium.Data.SQLite.Connector.SelectValue[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper, SQLiteConnection connection)
   at Aronium.Data.SQLite.Repository.Get[T](String query, IEnumerable`1 args, IRowMapper`1 rowMapper)
   at Aronium.Storage.Local.Data.PrinterRepository.GetPrinterSelection(String key)
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_PrinterSelection()
   at Aronium.Pos.ReceiptPrinter.Services.ReceiptPrinterService.get_IsPrinterEnabled()
   at Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus.Execute()

 

Related issue:

https://help.aronium.com/hc/en-us/community/posts/5163953179026

 

Product details:

Standalone version

version 1.38.0.2

I have 1 windows user, not changed

I didn't change the database location manually 

I can see data base file available in C:\Users\USER\AppData\Local\Aronium\Data with 6 MB size

 

Can you please help me with this, I tried to search on all topics inside Aronium Community and I didn't find any article related to the same of this issue.

Thanks,   

 

0

Comments

3 comments

Sort by Date Votes
  • Avatar
    Aronium Support
    • Edited

    Hi Ibrahim,

    We are sorry to hear you have troubles with the database. 

    What we can see from the logs are two different issues. The first one seems like the application files are being used by some other application instance when Aronium is trying to access it:

    2022-05-06 11:15:09.694 ERROR Aronium.Pos.MainWindow - The process cannot access the file 'C:\Users\USER\AppData\Local\Aronium\Application.xml' because it is being used by another process.
    2022-05-06 16:52:41.073 ERROR Aronium.Storage.Local.Data.OrderRepository - disk I/O error
    disk I/O error

    If this is the case, it could be solved by simply restarting your PC to make sure no application is accessing the database and try again. 

    However, there is another error that doesn't sounds good, as it indicates a corrupted database file:

    2022-05-07 17:58:18.665 ERROR Aronium.Pos.FiscalPrinter.Tasks.Bootstrap.CheckStatus - database disk image is malformed

    If you wish, you can send us your database to support@aronium.com, but there are no guarantees we can recover it.

    Finally, the best we can suggest is to restore the most recent backup by following instructions at https://help.aronium.com/hc/en-us/articles/115003477932-Restore-database, if you have one.

    Thanks, Aronium team.

    0
    Comment actions Permalink
  • Avatar
    Ibrahim
    • Edited

    Hi All,

    Thank you for your quick reply, there were two issues, first one, database was corrupted. The second issue with me, I didn't make a backup and I didn't go with the NETWORKING VERSION :( 

    How to fix it:

    • Download sqlite-tools from http://www.sqlite.org/download.html
    • Unpack it and place the corrupted database file into the same directory as sqlite3.exe (You will find it in "C:\Users\YourAccountName\AppData\Local\Aronium\Data")
    • Start “cmd” and navigate to the directory with the corrupted file
    • Run
    • >sqlite3.exe filename.db "PRAGMA integrity_check"

      to verify the database. The result will be probably an error message Error: database disk is malformed.

      • Then Run
      >sqlite3.exe filename.db ".dump" | sqlite3 new.db

    Then you need to rename the new DB "new.db" with the original name and replace it with the original DB in the path below: 

    C:\Users\YourAccountName\AppData\Local\Aronium\Data

    However, this procedure is not always successful. The easiest and most reliable way is to restore the database file from the backup.

     

    Thanks, 

    0
    Comment actions Permalink
  • Avatar
    Aronium Support

    Hi Ibrahim,

    Thanks for sharing the details and we hope that the recovery managed to get the data back.

    One important note on the Networking version, it is an offline application, too, and the database would be also stored on one of your computers, so making sure that the backup process in in place is the most important thing you should take care of.

    Hope this clarifies things and clears any doubts you may have around Networking version and the database it is using.

    Thanks, Aronium team.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post