# SQL error Object reference not set to an instance of an object **URL:** \ **Category:** V5 Question\ **Created:** [August 10, 2018, 3:41pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984 "2018-08-10T15:41:26Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 10, 2018, 3:41pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/1 "2018-08-10T15:41:26Z")
I have a setup with one server and one terminal. It was working fine then when I went to edit a menu on the server I get a flashing error box with the message “Object reference not set to an instance of an object.”. This appears to be flashing as though the system encounters an error and keeps retrying. This is confirmed by the error log which has multiple repetitions of the same error. When I connect to the server from the terminal I can edit the menu with no problem. When I disconnect the network and try to edit at the server the problem is still there which implies it is a local issue at the server. The error report is as follows, any suggestions would be most welcome. ## 8/10/2018 10:15 PM [General Info] Application: SambaPOS Version: 5.2.7 Region: en DB: SQ Machine: OGB-ON-13-SERVE User: OGB\_System Date: 8/10/2018 Time: 3:15 PM User Explanation: ## OGB\_System said “” [Exception Info 1] Top-level Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Source: Samba.Presentation.ClientLibrary Stack Trace: at Samba.Presentation.ClientLibrary.Modules.PosModule.SubButtonColorDef.AreColorsValid(String colorDef) in C:\Users\vehbi\Source\Repos\sambapos-v5-pro\Samba.Presentation.ClientLibrary\Modules\PosModule\SubButtonColorDef.cs:line 67 at Samba.Management.MenuModule.ScreenMenuValidatior.\<\>c.\<.ctor\>b\_\_0\_5(ScreenMenuCategory y) at System.Linq.Enumerable.All[TSource](IEnumerable`1 source, Func`2 predicate) at Samba.Management.MenuModule.ScreenMenuValidatior.\<\>c.\<.ctor\>b\_\_0\_4(IList`1 x) at FluentValidation.DefaultValidatorExtensions.<>c__DisplayClass1`2.b\_\_0(T x, TProperty val) at FluentValidation.DefaultValidatorExtensions.\<\>c\_\_DisplayClass4`2.b__3(T x, TProperty val, PropertyValidatorContext propertyValidatorContext) at FluentValidation.DefaultValidatorExtensions.<>c__DisplayClass7`2.b\_\_6(Object instance, Object property, PropertyValidatorContext propertyValidatorContext) at FluentValidation.Validators.PredicateValidator.IsValid(PropertyValidatorContext context) at FluentValidation.Validators.PropertyValidator.Validate(PropertyValidatorContext context) at FluentValidation.Internal.PropertyRule.InvokePropertyValidator(ValidationContext context, IPropertyValidator validator, String propertyName) at FluentValidation.Internal.PropertyRule.d\_\_8.MoveNext() at System.Linq.Enumerable.d\_\_17`2.MoveNext() at System.Collections.Generic.List`1…ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at FluentValidation.AbstractValidator`1.Validate(ValidationContext`1 context) at FluentValidation.AbstractValidator`1.Validate(T instance) at Samba.Presentation.Common.ModelBase.EntityViewModelBase`1.Validate() at Samba.Presentation.Common.ModelBase.EntityViewModelBase`1.CanSave(String arg) at Microsoft.Practices.Prism.Commands.DelegateCommand`1.\<\>c\_\_DisplayClass6.\<.ctor\>b\_\_3(Object o) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.CanExecute(Object parameter) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.System.Windows.Input.ICommand.CanExecute(Object parameter) at MS.Internal.Commands.CommandHelpers.CanExecuteCommandSource(ICommandSource commandSource) at System.Windows.Controls.Primitives.ButtonBase.UpdateCanExecute() at System.Windows.Controls.Primitives.ButtonBase.HookCommand(ICommand command) at System.Windows.Controls.Primitives.ButtonBase.OnCommandChanged(DependencyObject d, DependencyPropertyChangedEventArgs e) at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e) at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e) at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args) at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType) at System.Windows.DependencyObject.InvalidateProperty(DependencyProperty dp, Boolean preserveCurrentValue) at System.Windows.Data.BindingExpressionBase.Invalidate(Boolean isASubPropertyChange) at System.Windows.Data.BindingExpression.TransferValue(Object newValue, Boolean isASubPropertyChange) at System.Windows.Data.BindingExpression.Activate(Object item) at System.Windows.Data.BindingExpression.AttachToContext(AttachAttempt attempt) at System.Windows.Data.BindingExpression.MS.Internal.Data.IDataBindEngineClient.AttachToContext(Boolean lastChance) at MS.Internal.Data.DataBindEngine.Task.Run(Boolean lastChance) at MS.Internal.Data.DataBindEngine.Run(Object arg) at MS.Internal.Data.DataBindEngine.OnLayoutUpdated(Object sender, EventArgs e) at System.Windows.ContextLayoutManager.fireLayoutUpdateEvent() at System.Windows.ContextLayoutManager.UpdateLayout() at System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg) at System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork() at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks() at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget) at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget) 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.v16.2, Version=16.2.6.0 System.Xml, Version=4.0.0.0 DevExpress.Xpf.Grid.v16.2, Version=16.2.6.0 System, Version=4.0.0.0 DevExpress.Xpf.Grid.v16.2.Core, Version=16.2.6.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.v16.2, Version=16.2.6.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 DevExpress.Data.v16.2, Version=16.2.6.0 WindowsInput, Version=1.0.4.0 * * * [System Info] Operating System -Microsoft Windows 10 Home Single Language –CodeSet = 1252 –CSDVersion = –CurrentTimeZone = 420 –FreePhysicalMemory = 1361192 –OSArchitecture = 64-bit –OSLanguage = 1033 –ServicePackMajorVersion = 0 –ServicePackMinorVersion = 0 –Version = 10.0.17134 Machine -OGB-ON-13-SERVE –Manufacturer = HP –Model = HP All-in-One 22-c0xx –TotalPhysicalMemory = 4156342272 ---
**Author:** ![VehbiEmiroglu](https://forum.sambapos.com/user_avatar/forum.sambapos.com/vehbiemiroglu/32/64590_2.png) [@VehbiEmiroglu](https://forum.sambapos.com/u/VehbiEmiroglu)\ **Post date:** [August 10, 2018, 3:54pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/2 "2018-08-10T15:54:32Z")
> [@stevew](#): > > AreColorsValid Its about your button colors i saw. Can you check it again? ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 10, 2018, 4:13pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/3 "2018-08-10T16:13:15Z")
It was working OK. I guess I must have changed something but I cant remember what but it definitely wasn’t colours. I have checked the colours via the terminal and it all looks OK. What should I be looking for? ---
**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\ **Post date:** [August 10, 2018, 4:39pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/4 "2018-08-10T16:39:49Z")
> [@stevew](#): > > Samba.Presentation.ClientLibrary.Modules.PosModule.SubButtonColorDef.AreColorsValid(String colorDef) in This suggests a menu button colour issue. Guessing its maybe something to do with the validation added in a recent release maybe. What version of Samba is installed? ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 10, 2018, 4:45pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/5 "2018-08-10T16:45:33Z")
The latest one I think, 5.2.7. The file path C:\Users\vehbi\Source\Repos\sambapos-v5-pro\Samba.Presentation.ClientLibrary\Modules\PosModule\SubButtonColorDef.cs doesn’t exist. There is no vehbi as a user so this doesn’t make much sense ---
**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\ **Post date:** [August 10, 2018, 5:55pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/6 "2018-08-10T17:55:13Z")
That directory doesn’t make much sense all together, perhaps the directory has been mistakenly hardcoded on update compile? ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [August 10, 2018, 8:19pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/7 "2018-08-10T20:19:09Z")
That’s just a repository link. It’s a Sub Button color set to NULL but it can’t be NULL. Run through and choose a color for all Sub Button color sections in Menu ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 2:40am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/8 "2018-08-11T02:40:19Z")
Problem is that I can’t get into the menu to look at anything because the error prevents the screen from loading. Looking at the database in HeidiSQL shows the sub-button colours are all NULL, but that is the default setting ![image](https://forum.sambapos.com/uploads/default/original/3X/9/8/985df98283142ec014cef17e086c88b1d47e03db.png) I have rebuilt the entire menu as a duplicate and so far seems OK. Now going through and adjusting the different settings to see if I can determine the problem in case it happens again. ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [August 11, 2018, 4:27am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/9 "2018-08-11T04:27:55Z")
Do not adjust setting in the DB. You will break something for sure. Instead try running the Maintenence Tasks in settings - program settings ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 4:31am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/10 "2018-08-11T04:31:02Z")
Tried that. It didn’t solve the problem ---
**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\ **Post date:** [August 11, 2018, 8:19am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/11 "2018-08-11T08:19:45Z")
That is the table schema rather than actual values? ---
**Author:** ![VehbiEmiroglu](https://forum.sambapos.com/user_avatar/forum.sambapos.com/vehbiemiroglu/32/64590_2.png) [@VehbiEmiroglu](https://forum.sambapos.com/u/VehbiEmiroglu)\ **Post date:** [August 11, 2018, 8:24am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/12 "2018-08-11T08:24:17Z")
Can you send a screenshot of colours ScreenMenu ---
**Author:** ![VehbiEmiroglu](https://forum.sambapos.com/user_avatar/forum.sambapos.com/vehbiemiroglu/32/64590_2.png) [@VehbiEmiroglu](https://forum.sambapos.com/u/VehbiEmiroglu)\ **Post date:** [August 11, 2018, 8:25am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/13 "2018-08-11T08:25:19Z")
Not mistakenly hardcoded. It’s source code’s directory. Dotnet shows it in error logging. It’s not problem. Its regular. ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 8:39am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/14 "2018-08-11T08:39:09Z")
@VehbiEmiroglu I’m not sure what you want. There is a ScreenMenus table but it doesn’t tell us much ![image](https://forum.sambapos.com/uploads/default/original/3X/a/b/ab4fd9a87e22c22f6eec0d28b51a69e7739f7b12.png) Or there is ScreenMenuCategories which I think is probably what you are looking for (if not, please let me know) ![image](https://forum.sambapos.com/uploads/default/original/3X/6/5/654b4c84129dab6b1013eef8ed4d4756bcb999a3.png) ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 8:40am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/15 "2018-08-11T08:40:10Z")
@JTRTech it is indeed,. It was to say the NULL values are the norm rather than a problem. ---
**Author:** ![VehbiEmiroglu](https://forum.sambapos.com/user_avatar/forum.sambapos.com/vehbiemiroglu/32/64590_2.png) [@VehbiEmiroglu](https://forum.sambapos.com/u/VehbiEmiroglu)\ **Post date:** [August 11, 2018, 8:40am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/16 "2018-08-11T08:40:42Z")
Ok i will check it again ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [August 11, 2018, 11:46am UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/17 "2018-08-11T11:46:13Z")
It should work fine on next update. ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 12:45pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/18 "2018-08-11T12:45:52Z")
OK, thanks… So if I roll back to a previous version will that resolve the problem in the short term? ---
**Author:** ![VehbiEmiroglu](https://forum.sambapos.com/user_avatar/forum.sambapos.com/vehbiemiroglu/32/64590_2.png) [@VehbiEmiroglu](https://forum.sambapos.com/u/VehbiEmiroglu)\ **Post date:** [August 11, 2018, 12:47pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/19 "2018-08-11T12:47:29Z")
Yes it solved, after tests we will publish it ---
**Author:** ![stevew](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stevew](https://forum.sambapos.com/u/stevew)\ **Post date:** [August 11, 2018, 2:19pm UTC](https://forum.sambapos.com/t/sql-error-object-reference-not-set-to-an-instance-of-an-object/17984/20 "2018-08-11T14:19:22Z")
You might also like to look at the colour selector at the same time. With standard or theme colours it works fine but if we click on “more colors” it defaults to RGBA with the alpha channel set to zero meaning the colour is transparent and therefore can’t be seen. It would be better if the default was 255. Not a major issue, more of a minor inconvenience. ![image](https://forum.sambapos.com/uploads/default/original/3X/c/c/ccfb4b5b58a85435bdfe924e6972b1323abf65ba.png)