Inventory Erro, help find it please

Oh no! Apparently there is something wrong with my Samba, most products show as if the recipe for it does not exist.

I didn’t notice this until too late, whenever I click find missing recipes it shows me a huge list, even though I have items added the system does not see them.

I suspect it might be because I used Bulk Importer Tool from @QMcKay with SambaPOS5 5.1.60 and later upgraded to latest version (download and install on top) … could this be the issue?

It would be great if anyone can help me solve this, or else I’ll have to re-do everything. I tried deleting recipes and re creating them, the problem persist, Samba does not see them, I dont know why. I tried creating a brand new item, inventory and recipe. Still same problem, when I click required recipe it shows me a list with:

[name of product].Normal

And there is nothing I can do to solve it. Here is the error from log when I try to open warehouse.

[General Info]

Application: SambaPOS
Version: 5.1.62
Region: en
DB: SQ
Machine: DESKTOP-C2F7MLL
User: User
Date: 8/8/2017
Time: 11:09 AM

User Explanation:

User said “”

[Exception Info 1]

Top-level Exception
Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Samba.Services
Stack Trace: at Samba.Services.Implementations.CacheService.<>c__DisplayClass217_0.b__0(Recipe x) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\CacheService.cs:line 832
at System.Linq.Enumerable.Single[TSource](IEnumerable1 source, Func2 predicate)
at Samba.Services.Implementations.CacheService.GetRecipe(String portionName, Int32 menuItemId) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\CacheService.cs:line 832
at Samba.Services.Implementations.InventoryModule.ConsumptionBuilder.UpdateConsumption(PeriodicConsumption pc, Int32 warehouseId, IEnumerable1 tickets, IList1 recipes) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\InventoryModule\ConsumptionBuilder.cs:line 136
at Samba.Services.Implementations.InventoryModule.ConsumptionBuilder.CreatePeriodicConsumptionItems(Int32 wid, PeriodicConsumption pc, IList1 inventoryItems, PeriodicConsumption previousPc, IList1 tickets, IList1 recipes) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\InventoryModule\ConsumptionBuilder.cs:line 119 at Samba.Services.Implementations.InventoryModule.ConsumptionBuilder.CreateWarehouseConsumption(Int32 warehouseId) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\InventoryModule\ConsumptionBuilder.cs:line 90 at Samba.Services.Implementations.InventoryModule.InventoryService.GetCurrentWarehouseConsumptionFor(WorkPeriod currentWorkPeriod, WorkPeriod previousWorkPeriod, Int32 warehouseId) in C:\Users\emree\Documents\Github\SambaPOSPro\Samba.Services\Implementations\InventoryModule\InventoryService.cs:line 135 at Samba.Modules.InventoryModule.WarehouseInventoryViewModel.UpdateSelectedWarehouse(Int32 warehouseId) at Samba.Modules.InventoryModule.WarehouseInventoryViewModel.OnWarehouseSelected(Warehouse obj) at Microsoft.Practices.Prism.Commands.DelegateCommand1.<>c__DisplayClass6.<.ctor>b__2(Object o)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.System.Windows.Input.ICommand.Execute(Object parameter)
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.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
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.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
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.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
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)


[Assembly Info]

mscorlib, Version=4.0.0.0
Samba.Services, Version=1.0.0.0
Samba.Domain, Version=1.0.0.0
Samba.Infrastructure.Data, Version=1.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
System.Core, Version=4.0.0.0
PresentationCore, Version=4.0.0.0
DevExpress.Xpf.LayoutControl.v14.1, Version=14.1.13.0
System.Xml, Version=4.0.0.0
DevExpress.Xpf.Grid.v14.1, Version=14.1.13.0
System, Version=4.0.0.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.13.0
WindowsBase, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
PresentationFramework, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
System.Runtime.Serialization, Version=4.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.13.0
System.Windows.Forms, Version=4.0.0.0
System.Drawing, Version=4.0.0.0
Samba.Persistance, Version=1.0.0.0
Stateless, Version=1.0.0.0
PropertyTools, Version=2012.4.14.1
Samba.Localization, Version=1.0.0.0
ReachFramework, Version=4.0.0.0
EntityFramework, Version=6.0.0.0
FluentValidation, Version=3.4.0.0
Microsoft.CSharp, Version=4.0.0.0
Omu.ValueInjecter, Version=2.3.0.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0