Samba Crashing on Loading Screen: New Custom Report Module Possible Culpret

OK i am getting a crash on first Loading of Samba. I had created a test custom report using the new module. I had a sql script setup to pull tickets.

I ran a clear transactional data script …quit Samba started it and got this error.

I cannot recover it yet. I am not sure how. I may have to start over from scratch and attempt to load a backup DB. But the bad thing is I was almost completion of a feature and had not backed up yet :frowning: spent a lot of time on it too.

EDIT: I restored to a previous DB manually using Management Studio and its now running. However I lost all progress I made since 5pm :frowning: Its now 12:35 am

EDIT: I know what it is now. Anyone that has installed the new Custom Reports module BEWARE until its figured out!!!
If you use a SQL script to clear transactional data… it can cause this crash…I am not sure which data is causing it yet.

[General Info]

Application: SambaPOS
Version:     4.1.48
Region:      en
DB:          SQ
Machine:     *****
User:        *****
Date:        8/15/2014
Time:        5:05 AM

User Explanation:

***** said ‚Äú‚ÄĚ

[Exception Info 1]

Top-level Exception
Type:        System.ComponentModel.Composition.CompositionException
Message:     The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

  1. Object reference not set to an instance of an object.

Resulting in: An exception occurred while trying to create an instance of type ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.

Resulting in: Cannot activate part ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.
Element: Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† AssemblyCatalog (Assembly=‚ÄúSamba.Addon.CustomReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ)‚Äô from part ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.
Element: Samba.Addon.CustomReports.CustomReportViewerViewModel (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ) -->¬† Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† AssemblyCatalog (Assembly=‚ÄúSamba.Addon.CustomReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.BasicReports.ReportFactory.Reports (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.BasicReports.ReportFactory‚Äô.
Element: Samba.Modules.BasicReports.ReportFactory.Reports (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ) -->¬† Samba.Modules.BasicReports.ReportFactory -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.BasicReports.ReportFactory (ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.BasicReports.ReportFactory‚Äô.
Element: Samba.Modules.BasicReports.ReportFactory (ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ) -->¬† Samba.Modules.BasicReports.ReportFactory -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Ķctor (Parameter=‚ÄúreportFactory‚ÄĚ, ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Äô.
Element: Samba.Modules.BasicReports.ActionProcessors.PrintReport‚Ķctor (Parameter=‚ÄúreportFactory‚ÄĚ, ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ) -->¬† Samba.Modules.BasicReports.ActionProcessors.PrintReport -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Äô.
Element: Samba.Modules.BasicReports.ActionProcessors.PrintReport (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ) -->¬† Samba.Modules.BasicReports.ActionProcessors.PrintReport -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Services.Common.RuleActionTypeRegistry.ActionTypes (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ)‚Äô on part ‚ÄėSamba.Services.Common.RuleActionTypeRegistry‚Äô.
Element: Samba.Services.Common.RuleActionTypeRegistry.ActionTypes (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ) -->¬† Samba.Services.Common.RuleActionTypeRegistry -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Services.Common.RuleActionTypeRegistry (ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ)‚Äô from part ‚ÄėSamba.Services.Common.RuleActionTypeRegistry‚Äô.
Element: Samba.Services.Common.RuleActionTypeRegistry (ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ) -->¬† Samba.Services.Common.RuleActionTypeRegistry -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Ķctor (Parameter=‚ÄúruleActionTypeRegistry‚ÄĚ, ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ)‚Äô on part ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Äô.
Element: Samba.Services.Implementations.AutomationModule.AutomationService‚Ķctor (Parameter=‚ÄúruleActionTypeRegistry‚ÄĚ, ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ) -->¬† Samba.Services.Implementations.AutomationModule.AutomationService -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService (ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ)‚Äô from part ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Äô.
Element: Samba.Services.Implementations.AutomationModule.AutomationService (ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ) -->¬† Samba.Services.Implementations.AutomationModule.AutomationService -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Ķctor (Parameter=‚ÄúautomationService‚ÄĚ, ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Äô.
Element: Samba.Modules.AutomationModule.AutomationModule‚Ķctor (Parameter=‚ÄúautomationService‚ÄĚ, ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ) -->¬† Samba.Modules.AutomationModule.AutomationModule -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.AutomationModule.AutomationModule (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModule‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Äô.
Element: Samba.Modules.AutomationModule.AutomationModule (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModule‚ÄĚ) -->¬† Samba.Modules.AutomationModule.AutomationModule -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: An exception occurred while initializing module ‚ÄėAutomationModule‚Äô.
    - The exception message was: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

  1. Object reference not set to an instance of an object.

Resulting in: An exception occurred while trying to create an instance of type ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.

Resulting in: Cannot activate part ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.
Element: Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† AssemblyCatalog (Assembly=‚ÄúSamba.Addon.CustomReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ)‚Äô from part ‚ÄėSamba.Addon.CustomReports.CustomReportViewerViewModel‚Äô.
Element: Samba.Addon.CustomReports.CustomReportViewerViewModel (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ) -->¬† Samba.Addon.CustomReports.CustomReportViewerViewModel -->¬† AssemblyCatalog (Assembly=‚ÄúSamba.Addon.CustomReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.BasicReports.ReportFactory.Reports (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.BasicReports.ReportFactory‚Äô.
Element: Samba.Modules.BasicReports.ReportFactory.Reports (ContractName=‚ÄúSamba.Presentation.Common.Reports.IReport‚ÄĚ) -->¬† Samba.Modules.BasicReports.ReportFactory -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.BasicReports.ReportFactory (ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.BasicReports.ReportFactory‚Äô.
Element: Samba.Modules.BasicReports.ReportFactory (ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ) -->¬† Samba.Modules.BasicReports.ReportFactory -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Ķctor (Parameter=‚ÄúreportFactory‚ÄĚ, ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Äô.
Element: Samba.Modules.BasicReports.ActionProcessors.PrintReport‚Ķctor (Parameter=‚ÄúreportFactory‚ÄĚ, ContractName=‚ÄúSamba.Presentation.Common.IReportFactory‚ÄĚ) -->¬† Samba.Modules.BasicReports.ActionProcessors.PrintReport -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.BasicReports.ActionProcessors.PrintReport‚Äô.
Element: Samba.Modules.BasicReports.ActionProcessors.PrintReport (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ) -->¬† Samba.Modules.BasicReports.ActionProcessors.PrintReport -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Services.Common.RuleActionTypeRegistry.ActionTypes (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ)‚Äô on part ‚ÄėSamba.Services.Common.RuleActionTypeRegistry‚Äô.
Element: Samba.Services.Common.RuleActionTypeRegistry.ActionTypes (ContractName=‚ÄúSamba.Services.Common.IActionType‚ÄĚ) -->¬† Samba.Services.Common.RuleActionTypeRegistry -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Services.Common.RuleActionTypeRegistry (ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ)‚Äô from part ‚ÄėSamba.Services.Common.RuleActionTypeRegistry‚Äô.
Element: Samba.Services.Common.RuleActionTypeRegistry (ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ) -->¬† Samba.Services.Common.RuleActionTypeRegistry -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Ķctor (Parameter=‚ÄúruleActionTypeRegistry‚ÄĚ, ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ)‚Äô on part ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Äô.
Element: Samba.Services.Implementations.AutomationModule.AutomationService‚Ķctor (Parameter=‚ÄúruleActionTypeRegistry‚ÄĚ, ContractName=‚ÄúSamba.Services.Common.RuleActionTypeRegistry‚ÄĚ) -->¬† Samba.Services.Implementations.AutomationModule.AutomationService -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService (ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ)‚Äô from part ‚ÄėSamba.Services.Implementations.AutomationModule.AutomationService‚Äô.
Element: Samba.Services.Implementations.AutomationModule.AutomationService (ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ) -->¬† Samba.Services.Implementations.AutomationModule.AutomationService -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot set import ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Ķctor (Parameter=‚ÄúautomationService‚ÄĚ, ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ)‚Äô on part ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Äô.
Element: Samba.Modules.AutomationModule.AutomationModule‚Ķctor (Parameter=‚ÄúautomationService‚ÄĚ, ContractName=‚ÄúSamba.Services.IAutomationService‚ÄĚ) -->¬† Samba.Modules.AutomationModule.AutomationModule -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Resulting in: Cannot get export ‚ÄėSamba.Modules.AutomationModule.AutomationModule (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModule‚ÄĚ)‚Äô from part ‚ÄėSamba.Modules.AutomationModule.AutomationModule‚Äô.
Element: Samba.Modules.AutomationModule.AutomationModule (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModule‚ÄĚ) -->¬† Samba.Modules.AutomationModule.AutomationModule -->¬† DirectoryCatalog (Path=‚ÄúC:\Program Files (x86)\SambaPOS4\SambaPOS4‚ÄĚ)

Check the InnerException property of the exception for more information. If the exception occurred
    while creating an object in a DI container, you can exception.GetRootException() to help locate the
    root cause of the problem.

Resulting in: An exception occurred while calling the ‚ÄėOnImportsSatisfied‚Äô method on type ‚ÄėMicrosoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager‚Äô.

Resulting in: Cannot activate part ‚ÄėMicrosoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager‚Äô.
Element: Microsoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager -->¬† Microsoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager -->¬† AssemblyCatalog (Assembly=‚ÄúMicrosoft.Practices.Prism.MefExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35‚ÄĚ)

Resulting in: Cannot get export ‚ÄėMicrosoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModuleManager‚ÄĚ)‚Äô from part ‚ÄėMicrosoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager‚Äô.
Element: Microsoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager (ContractName=‚ÄúMicrosoft.Practices.Prism.Modularity.IModuleManager‚ÄĚ) -->¬† Microsoft.Practices.Prism.MefExtensions.Modularity.MefModuleManager -->¬† AssemblyCatalog (Assembly=‚ÄúMicrosoft.Practices.Prism.MefExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35‚ÄĚ)

Source:      System.ComponentModel.Composition
Stack Trace: at System.ComponentModel.Composition.Hosting.CompositionServices.GetExportedValueFromComposedPart(ImportEngine engine, ComposablePart part, ExportDefinition definition)
   at System.ComponentModel.Composition.Hosting.CatalogExportProvider.GetExportedValue(CatalogPart part, ExportDefinition export, Boolean isSharedPart)
   at System.ComponentModel.Composition.Hosting.CatalogExportProvider.CatalogExport.GetExportedValueCore()
   at System.ComponentModel.Composition.Primitives.Export.get_Value()
   at System.ComponentModel.Composition.ExportServices.GetCastedExportedValue[T](Export export)
   at System.ComponentModel.Composition.Hosting.ExportProvider.GetExportedValueCore[T](String contractName, ImportCardinality cardinality)
   at Microsoft.Practices.Prism.MefExtensions.MefBootstrapper.InitializeModules()
   at Samba.Presentation.Bootstrapper.InitializeModules()
   at Microsoft.Practices.Prism.MefExtensions.MefBootstrapper.Run(Boolean runWithDefaultConfiguration)
   at Samba.Presentation.App.RunInReleaseMode()


[Assembly Info]

Samba.Services, Version=1.0.0.0
mscorlib, Version=4.0.0.0
System, Version=4.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Samba.Infrastructure.Data, Version=1.0.0.0
PresentationFramework, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
FluentValidation, Version=3.4.0.0
Samba.Domain, Version=1.0.0.0
DevExpress.Xpf.Grid.v14.1, Version=14.1.5.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.5.0
PresentationCore, Version=4.0.0.0
Stateless, Version=1.0.0.0
System.Core, Version=4.0.0.0
System.Drawing, Version=4.0.0.0
System.Windows.Forms, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
Samba.Localization, Version=1.0.0.0
Microsoft.CSharp, Version=4.0.0.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.5.0
PropertyTools, Version=2012.4.14.1


[System Info]

Operating System
-Microsoft Windows 8.1 Pro
‚ÄďCodeSet = 1252
‚ÄďCSDVersion =
‚ÄďCurrentTimeZone = -300
‚ÄďFreePhysicalMemory = 11712936
‚ÄďOSArchitecture = 64-bit
‚ÄďOSLanguage = 1033
‚ÄďServicePackMajorVersion = 0
‚ÄďServicePackMinorVersion = 0
‚ÄďVersion = 6.3.9600

Machine
-*****
‚ÄďManufacturer = ***
‚ÄďModel = All Series
‚ÄďTotalPhysicalMemory = 17115684864
‚ÄďUserName =****


Here is the Script I used.

DELETE FROM [TicketEntities]
GO

DELETE FROM [Tickets]
GO

DELETE FROM [AccountTransactionDocuments]
GO
 
DELETE FROM [AccountTransactions]
GO
 
DELETE FROM [AccountTransactionValues]
GO
 
DELETE FROM [Calculations]
GO
 
DELETE FROM [CostItems]
GO
 
DELETE FROM [InventoryTransactionDocuments]
GO
 
DELETE FROM [InventoryTransactions]
GO
 
DELETE FROM [Orders]
GO
 
DELETE FROM [PaidItems]
GO
 
DELETE FROM [PeriodicConsumptionItems]
GO
 
DELETE FROM [PeriodicConsumptions]
GO
 
DELETE FROM [ProductTimerValues]
GO
 
DELETE FROM [Payments]
GO

DELETE FROM [WarehouseConsumptions]
GO
 
DELETE FROM [WorkPeriods]
GO

 
UPDATE [Numerators] SET Number = 0
GO

UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%'
GO

Thank you for reporting it. I think I know why it happened.

Let me know if its a fix I can do in my script… I really want to delete my transaction data :stuck_out_tongue:

Use database tools to clear your transaction data and start a work period before re-starting Sambapos.

K thanks was afraid to try it again until I knew it wouldnt crash lol.