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

Version 4 V4 Issue
1

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 =****

2

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
3

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

4

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

5

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

6

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