When ringing up customer, one register shows this error:
Server Failure 111: A sever failure occurred while attempting to create
a journal entry.
Error #-2147217900
Could not allocate space for object “dboJournal” in database
“GWPOS02” 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.
(Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 42000)
(NativeError: 12105)
No help file available
SET NOCOUNT ON
INSERT INTO Journal (StoreID, Batch Number, TransactionType,
ReferenceID, OrderHistoryID, Cashier ID, CustomerID, ReceiptText,
ReceiptCompressed, Compressed)
VALUES (??????????)
SELECT @@IDENTITY As JournalID
This error along with "ok" option stays on screen until ok is clicked. Transaction gets cleared out, and register receipt tape prints aborted transaction. I was able to recreate this by ringing up a mock transaction with multiple items, then pressing escape button.
*This post is locked for comments
If you upgrade your database to SQL 2008 R2 or higher, the free Express version limit is 10GB.
FWIW, we are using SQL 2014 Express SP1 on all new installs.
Database file may be full. If you work with an RMS Partner seek their advice.
If you are confident in using RMS administrator you can do it yourself.
In RMS Administrator > DataBase > Properties Usage is given as %, if it is like 99% you need to free space. Size gives the capacity of the database which is 2GB in SQL 2005 express and 4GB SQL 2008 Express.
The best approach to free space is to delete journal entries say anything older then 1 year. I used this for a few years in single shop set up.
Thinks to take care before attempting this Take a backup. Then decide the cut off date for receipts to keep. In these to be deleted images are there any pending actions like payments? these you may want to print and keep. Do these before deleting.
The deletion of journal entries will only delete the images of receipts sales, drops, payouts, payments, z & x reports, it will not delete anything else.
In RMS Administrator do the following SQL queries by typing the text as it is within the "" , time is YYYYMMDD format:
1 - "select min(time) from journal" this will get the earliest journal entry
2 - "delete from journal where time<'20131231' " this will delete images any dated earlier then 2013 dec 31
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,912 Super User 2024 Season 2
Martin Dráb 229,355 Most Valuable Professional
nmaenpaa 101,156