Pos3/5/FNB: Sync Error because the ‘PRIMARY’ filegroup is full

From AutoCount Resource Center

Question :

When I was trying to sync, system prompts an error: …could not allocate space… because the 'PRIMARY' filegroup is full… ?


Error found while sync Pos from T01 to HQ. It will stop sync Pos for this session. Could not allocate space for object 'dbo.PosDtlPromotion'.'PK__PosDtlPr__FB997989FE63FED6' in database 'AED_xxx' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

000283-a.png


Solution :

Your Database or table size has reached maximum limit of Microsoft SQL Express edition and computer storage is full.


Solution :

1.Login your POS Backend or Accounting > Help > About AutoCount Accounting or POS > Server: Check Edition*

000283-b.png

  • You may refer to the following link:

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15

000283-c.png


2.After knowing your Microsoft SQL Server edition, check your Hard Drive (HDD) storage > make sure the drive that keeping Autocount Data folder still has free space (My sample is Local Drive (C:))

000283-d.png


3.Go in to AutoCount Data folder > find your Database Name (AED_xxx_Data) > check the Size (10,488,896KB = 10GB+)

000283-e.png


4.Should the database size exceeded Max limit, you may:

a. Purchase higher edition of MS SQL Server, such as Enterprise, Standard, etc…

b. Perform year end process, it will delete/purge old data and reduce the size of current database.

c. Create a new database or new account book.


By: CK 20211102, Jacky 20211123, P211125 [000283]


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations