Tem 31, 2014

3694 görüntüleme

İtibar: 55

Acil yardım lütfen: SambaPOS V4 Kurulumunda Database Sorunu

Etiketler:

Merhaba,

SambaPOS3 kullanırken biraz önce SambaPOS4 kurdum. SQL Server kullanıyorum. SambaPOS4 standart şifre ile açıldı. Bir takım ürünler görülse de diğerlerini göremedim. Ayarlara "Data Source=SAMSUNGPC; User Id=sa; Password=1234; Database=SambaPOS3;" bilgilerini girerek sistemden çıktım ve girdim. Önce bu konfigürasyon ile database'e bağlanamadığını söylüyor. Sonra da sistem hatasını log'a kaydettiğini söyleyerek kapanıyor. Dolayısı ile SambaPOS'a giremiyorum.

İLGİLİ LOG FILE:

-----------------------------

[General Info]

Application: SambaPOS

Version: 4.1.39

Region: en

DB: CE

Machine: SAMSUNGPC

User: Samsung

Date: 6.7.2014

Time: 09:33

User Explanation:

Samsung said ""

-----------------------------

[Exception Info 1]

Top-level Exception

Type: System.Data.Entity.Infrastructure.DbUpdateException

Message: An error occurred while updating the entries. See the inner exception for details.

Source: EntityFramework

Stack Trace: at System.Data.Entity.Internal.InternalContext.SaveChanges()

at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()

at System.Data.Entity.DbContext.SaveChanges()

at Samba.Infrastructure.Data.SqlData.EFWorkspace.CommitChanges()

at Samba.Presentation.Common.ModelBase.EntityCollectionViewModelBase`2.DoDeleteItem(TModel item)

at Samba.Presentation.Common.ModelBase.EntityCollectionViewModelBase`2.OnDeleteItem(Object obj)

at Microsoft.Practices.Prism.Commands.DelegateCommand`1.<>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.Documents.Hyperlink.OnClick()

at System.Windows.Documents.Hyperlink.DispatchNavigation(Object sender)

at System.Windows.Documents.Hyperlink.DoUserInitiatedNavigation(Object sender)

at System.Windows.Documents.Hyperlink.OnMouseLeftButtonUp(Object sender, MouseButtonEventArgs e)

at System.Windows.Documents.Hyperlink.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.ContentElement.RaiseTrustedEvent(RoutedEventArgs args)

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 MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)

at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)

at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)

at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)

at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)

at System.Windows.Threading.Dispatcher.Run()

at System.Windows.Application.RunDispatcher(Object ignore)

at System.Windows.Application.RunInternal(Window window)

at System.Windows.Application.Run(Window window)

at Samba.Presentation.App.Main()

Inner Exception 1

Type: System.Data.UpdateException

Message: An error occurred while updating the entries. See the inner exception for details.

Source: System.Data.Entity

Stack Trace: at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)

at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)

at System.Data.Entity.Internal.InternalContext.SaveChanges()

Inner Exception 2

Type: System.Data.SqlServerCe.SqlCeException

Message: The primary key value cannot be deleted because references to this key still exist. [ Foreign key constraint name = FK_dbo.RecipeItems_dbo.InventoryItems_InventoryItem_Id ]

Source: SQL Server Compact ADO.NET Data Provider

Stack Trace: at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)

at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)

at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)

at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()

at System.Data.SqlServerCe.SqlCeMultiCommand.ExecuteNonQuery()

at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)

at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

-----------------------------

[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.4.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

DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.4.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.4.0

PropertyTools, Version=2012.4.14.1

-----------------------------

[System Info]

Operating System

-Microsoft Windows 8 Single Language

--CodeSet = 1254

--CSDVersion =

--CurrentTimeZone = 180

--FreePhysicalMemory = 1535860

--OSArchitecture = 64 bit

--OSLanguage = 1055

--ServicePackMajorVersion = 0

--ServicePackMinorVersion = 0

--Version = 6.2.9200

Machine

-SAMSUNGPC

--Manufacturer = SAMSUNG ELECTRONICS CO., LTD.

--Model = 370R4E/370R4V/370R5E/3570RE/370R5V

--TotalPhysicalMemory = 4174950400

--UserName = SamsungPc\Samsung

-----------------------------

######################### E N D #########################

-----------------------------

[General Info]

Application: SambaPOS

Version: 4.1.42

Region: en

DB: SQ

Machine: SAMSUNGPC

User: Samsung

Date: 31.7.2014

Time: 11:37

User Explanation:

Samsung said ""

-----------------------------

[Exception Info 1]

Top-level Exception

Type: System.Data.ProviderIncompatibleException

Message: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Source: EntityFramework

Stack Trace: at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)

at System.Data.Entity.ModelConfiguration.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)

at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)

at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)

at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)

at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()

at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)

at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()

at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()

at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()

at System.Linq.Queryable.Count[TSource](IQueryable`1 source)

at Samba.Infrastructure.Data.SqlData.EFWorkspace.Count[T]()

at Samba.Presentation.Services.Common.DataGeneration.DataCreationService.ShouldCreateData()

at Samba.Presentation.Services.Common.DataGeneration.DataCreationService.CreateData()

at Samba.Presentation.Bootstrapper.InitializeShell()

Inner Exception 1

Type: System.Data.ProviderIncompatibleException

Message: The provider did not return a ProviderManifestToken string.

Source: System.Data.Entity

Stack Trace: at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)

at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)

Inner Exception 2

Type: System.Data.SqlClient.SqlException

Message: Login failed for user 'sa'.

Source: .Net SqlClient Data Provider

Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions)

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, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions)

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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)

at System.Data.SqlClient.SqlConnection.Open()

at System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)

at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)

at System.Data.SqlClient.SqlProviderServices.GetDbProviderManifestToken(DbConnection connection)

at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)

-----------------------------

[Assembly Info]

PresentationFramework, Version=4.0.0.0

System.Xaml, Version=4.0.0.0

Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0

mscorlib, Version=4.0.0.0

System, Version=4.0.0.0

WindowsBase, Version=4.0.0.0

System.Configuration, Version=4.0.0.0

Samba.Services, Version=1.0.0.0

Samba.Presentation.Services, Version=1.0.0.0

Samba.Presentation.Common, Version=1.0.0.0

Samba.Domain, Version=1.0.0.0

PresentationCore, Version=4.0.0.0

DevExpress.Xpf.Core.v14.1, Version=14.1.5.0

Microsoft.Practices.ServiceLocation, Version=1.0.0.0

Samba.Infrastructure, Version=1.0.0.0

Microsoft.Practices.Prism, Version=4.0.0.0

System.ComponentModel.Composition, Version=4.0.0.0

System.Core, Version=4.0.0.0

Samba.Localization, Version=1.0.0.0

FastButton, Version=1.0.0.0

-----------------------------

[System Info]

Operating System

-Microsoft Windows 8 Single Language

--CodeSet = 1254

--CSDVersion =

--CurrentTimeZone = 180

--FreePhysicalMemory = 1528784