Microsoft Dynamics RMS (Archived)

Error #-2147217900 DURING CASH REGISTER OPS

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Suggested answer

Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: Error #-2147217900 DURING CASH REGISTER OPS

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.
Suggested answer

TheNeos 1,335 on at

Like (0)

Report

RE: Error #-2147217900 DURING CASH REGISTER OPS

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