Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Error #-2147217900 DURING CASH REGISTER OPS

Posted on by 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

  • Suggested answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    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 Profile Picture
    TheNeos 1,335 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans