Database error sambapos 4.1.82

Hello I got the following message. How to resize the database?


[General Info]

Application: SambaPOS
Version: 4.1.82
Region: en
DB: CE
Machine: DESKTOP-62V21J2
User: FERI
Date: 2017. 08. 17.
Time: 3:57

User Explanation:

FERI said “”

[Exception Info 1]

Top-level Exception
Type: System.Data.EntityCommandExecutionException
Message: An error occurred while reading from the store provider’s data reader. See the inner exception for details.
Source: System.Data.Entity
Stack Trace: at System.Data.Common.Internal.Materialization.Shaper1.StoreRead() at System.Data.Common.Internal.Materialization.Shaper1.RowNestedResultEnumerator.MoveNext()
at System.Data.Common.Internal.Materialization.Shaper1.ObjectQueryNestedEnumerator.TryReadToNextElement() at System.Data.Common.Internal.Materialization.Shaper1.ObjectQueryNestedEnumerator.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 predictate, Expression`1[] includes)
at Samba.Modules.BasicReports.ReportContext.GetTickets() in c:\Users\Emre\Documents\GitHub\SambaPOS-Gold\Samba.Modules.BasicReports\ReportContext.cs:line 168
at Samba.Modules.BasicReports.ReportContext.get_Tickets() in c:\Users\Emre\Documents\GitHub\SambaPOS-Gold\Samba.Modules.BasicReports\ReportContext.cs:line 66
at Samba.Modules.BasicReports.Reports.EndOfDayReport.EndDayAbstractReportViewModel.GetReport() in c:\Users\Emre\Documents\GitHub\SambaPOS-Gold\Samba.Modules.BasicReports\Reports\EndOfDayReport\EndDayReportViewModel.cs:line 59
at Samba.Presentation.Common.Reports.AbstractReport.b__2()

Inner Exception 1
Type: System.Data.SqlServerCe.SqlCeException
Message: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 257 ]
Source: SQL Server Compact ADO.NET Data Provider
Stack Trace: at System.Data.SqlServerCe.SqlCeDataReader.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeDataReader.IsEndOfRowset(Int32 hr)
at System.Data.SqlServerCe.SqlCeDataReader.Move(DIRECTION direction)
at System.Data.SqlServerCe.SqlCeDataReader.Read()
at System.Data.Common.Internal.Materialization.Shaper`1.StoreRead()


[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.6.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.6.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
DevExpress.Xpf.Core.v14.1, Version=14.1.6.0
EntityFramework, Version=4.4.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
PropertyTools, Version=2012.4.14.1


[System Info]

Operating System
-Microsoft Windows 10 Pro
–CodeSet = 1250
–CSDVersion =
–CurrentTimeZone = 120
–FreePhysicalMemory = 1642332
–OSArchitecture = 64 bites
–OSLanguage = 1038
–ServicePackMajorVersion = 0
–ServicePackMinorVersion = 0
–Version = 10.0.15063

Machine
-DESKTOP-62V21J2
–Manufacturer = MSI
–Model = MS-7996
–TotalPhysicalMemory = 4117008384
–UserName = DESKTOP-62V21J2\FERI


Seems your sql ce database is to small. try looking at https://stackoverflow.com/questions/2408480/increase-the-size-of-sql-compact-3-5-sdf-file-using-c-sharp maybe it will help.

Don’t even bother with that, I’d strongly recommend converting to SQL express if you are using CE…
Kendash dos a good tutorial on converting CE to SQL Express.

1 Like