Unable to start sambapos on live system HELP!

Ruben_Arellano · March 22, 2017, 11:07pm

Hello Everyone

I am unable to open Samba POS it keeps crashing.

The log i get is the following

Please help this is a live system and need it working asap

[General Info]

Application: SambaPOS
Version: 5.1.62
Region: en
DB: SQ
Machine: KACHI
User: Wing’s palace
Date: 22/03/2017
Time: 08:25 p. m.

User Explanation:

Wing’s palace said “”

[Exception Info 1]

Top-level Exception
Type: System.Reflection.TargetInvocationException
Message: Exception has been thrown by the target of an invocation.
Source: mscorlib
Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Delegate.DynamicInvokeImpl(Object args)
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)

Inner Exception 1
Type: System.Data.Entity.Core.EntityException
Message: The underlying provider failed on Open.
Source: EntityFramework
Stack Trace: at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery1.<>c__DisplayClass7.b__5()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func1 operation) at System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery1.<System.Collections.Generic.IEnumerable.GetEnumerator>b__0()
at System.Data.Entity.Internal.LazyEnumerator1.MoveNext() at System.Collections.Generic.List1…ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at Samba.Persistance.Data.Dao.Query[T](Expression1[] includes) at Samba.Persistance.Implementations.CacheDao.GetScreenMenus() at Samba.Services.Implementations.CacheService.get_ScreenMenus() in C:\Users\Emre\Documents\GitHub\SambaPOSPro\Samba.Services\Implementations\CacheService.cs:line 458 at Samba.Services.Implementations.CacheService.GetScreenMenuById(Int32 screenMenuId) in C:\Users\Emre\Documents\GitHub\SambaPOSPro\Samba.Services\Implementations\CacheService.cs:line 0 at Samba.Modules.PosModule.MenuItemSelectorViewModel.UpdateCurrentScreenMenu(Int32 screenMenuId) at Samba.Modules.PosModule.PosViewModel.OnTicketTypeChanged(EventParameters1 obj)
at Microsoft.Practices.Prism.Events.EventSubscription1.InvokeAction(Action1 action, TPayload argument)
at Microsoft.Practices.Prism.Events.EventSubscription1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] arguments) at Microsoft.Practices.Prism.Events.EventBase.InternalPublish(Object[] arguments) at Microsoft.Practices.Prism.Events.CompositePresentationEvent1.Publish(TPayload payload)
at Samba.Presentation.Services.Common.ExtensionMethods.Publish[TEventsubject](TEventsubject eventArgs, String eventTopic, Action expectedAction)

Inner Exception 2
Type: System.Data.SqlClient.SqlException
Message: Cannot open database “SambaPOS5” requested by the login. The login failed.
Login failed for user ‘Kachi\Wing’s palace’.
Source: .Net SqlClient Data Provider
Stack Trace: at System.Data.SqlClient.SqlInternalConnectionTds…ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.b__36(DbConnection t, DbConnectionInterceptionContext c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action2 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.EntityConnection.b__2()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.<>c__DisplayClass1.b__0()
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute(Action operation)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()

[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

[System Info]

Operating System
-Microsoft Windows 8.1 Pro
–CodeSet = 1252
–CSDVersion =
–CurrentTimeZone = -360
–FreePhysicalMemory = 8121808
–OSArchitecture = 64 bits
–OSLanguage = 3082
–ServicePackMajorVersion = 0
–ServicePackMinorVersion = 0
–Version = 6.3.9600

Machine
-KACHI
–Manufacturer = Gigabyte Technology Co., Ltd.
–Model = To be filled by O.E.M.
–TotalPhysicalMemory = 9874051072
–UserName = Kachi\Wing’s palace

JTRTech · March 22, 2017, 11:12pm

this sugests a database connection issue?

Ruben_Arellano · March 22, 2017, 11:16pm

ya i know, but when it first opens samba pos it opnes as trial and im only able to enter the default password. When i entered it it crashes and sampos pos closes. I am unable to check the connection string

Jesse · March 22, 2017, 11:53pm

Is your database on the same computer? Is the database running? Sambapos can’t connect to the database.

Hasa · March 23, 2017, 12:11am

Please make sure you setup your network properly, there are plenty of tutorials on here on how to set it all up. If you dont take these precautions before going live your going to have issues like this.

You can directly edit SambaSettings.txt file here: C:\ProgramData\SAMBAPOS\SambaPOS5

Make sure you firewall is off on server computer. Or if your concerned about completely turning off the firewall due to security concerns you need to configure it to allow samba to connect to ms sql database.
Set static ip address that is out of your dhcp scope for all stations and server.
For samba settings I personally stay away from inputing computer names but instead insert the exact static ip like this: Data Source=192.168.0.34\hasacorp
Open command prompt in station with issues and try to ping static ip address of your server. Make sure your getting a reply.

If your database is on the same computer then you shouldn’t need to worry about the firewall or static ip just set the connection string Data Source=localhost\YourMSSQLServerName

If everything fails:

uninstall samba software on station computer.
Delete C:\ProgramData\SAMBAPOS
Delete C:\Users\Admin\Documents\SambaPOS5 (if uninstalling doesn’t delete it)
Reinstall it again.

Dont think that stuff just doesn’t work. There is always a reason for it. So carefully check everything your definitely doing something wrong.

How did you install Ms Sql Server? Did you install it through the sambaPOS installation or did you install Sql Server 2016 Express. I recommend you do that depending on your setup. If you have a multi terminal setup I highly reccomend you get Sql server 2016 https://www.microsoft.com/en-us/sql-server/sql-server-editions-express and also download Microsoft Sql Server Management Studio.

If you got sql server express 2016 you have to make sure you enable connections to your server. Do this on your server machine!