web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Error in Post Transact...
Microsoft Dynamics RMS (Archived)

Error in Post Transactionentries

(0) ShareShare
ReportReport
Posted on by Hong Nguyen 35

I'm using Microsoft Dynamics Retail Management System on a SQL Express 2005 engine, Window XP Sp2. When i finished transaction to print the bill i have an error:

1. Database connection lost, application will be closed Error  #-2147467259.
Connection failure (Source: Microsoft OLE DB provider for SQL Server) (SQL State: 08501) (NativeError: 0) No file available. SELECT GETDATE() AS CurrentDateTime
 2. Error #-214747259 An inconsistancy was detected during an internal operation in database RMS_DOSGS1 (ID 6) on page (1:19928). Please contact technical support. Reference number 4 (Source: Microsoft OLE DB provider)
Complete a full database consistency check (DBCC CHECKDB).....

I tried to use DBCC CHECKDB (dbname, REPAIR_REBUILD), but it couldn't fix the problem. And then i used DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS), It's ok but data was lost that i couldn't control.

Please help me!

 

 

*This post is locked for comments

I have the same question (0)
  • dvdash Profile Picture
    dvdash 20 on at

    I am having the exact same problem with virtually the same setup for a system. To try to narrow down what was happening I duplicated everything in the last transaction to see if it was a particular item causing the problem. I scanned and totaled out every item individually until one item caused the error. I duplicated the same error every time that I "sold" this item. I went into Operations Manager and brought up the item. If I change anything in this item (quantity, for example) and then save the item...POOF. The exact same error. I even tried to delete the item and it crashed. Any ideas here folks?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Open the Administrator program and run the database check from there.  Also I suggest a reindex from there.

    This is usually item related.  Take notice of the items on that particular sale and then check the item table from the Administrator.  Select * from Item within a query window.  Check for null or corrupt fields.

    I have also seen this when the collation for the database has been changed after creation.  If this is the case then make sure to change it back to latin1 CP1_CI_AS which is the default.

    Please note the item if corrupted can not be deleted from the Manager or POS program because it performs a check on the entry prior to deletion and will give an error.

  • Shawn Meade Profile Picture
    Shawn Meade on at

    It seems that this issue could be caused by an issue that was found with the Windows XP SP2.  I would recommend downloading the following update.  This has been known to fix some issues similar to this and might prove helpful.

    Microsoft has identified a compatibility issue that occurs when you run Microsoft Dynamics Retail Management System RMS Store Operations, Microsoft Dynamics POS 2009, or Microsoft Dynamics - Point of Sale on a computer that runs any of the following Windows Operating Systems:

    " Windows Server 2008

    " Windows Vista Service Pack 1 SP1

    " Windows XP Service Pack 3 SP3

    " Windows XP Service Pack 2 SP2 with hotfix 940569

    We strongly recommend that you apply all Windows Critical Updates with Microsoft Update or Windows Update. This will install a fix for this issue automatically together with other important Critical Updates that are missing from your computer. At a minimum, all users who are running any of these Windows Operating Systems should install the following Microsoft Hotfix:

    support.microsoft.com

    Do not run Store Operations, POS 2009, or Point of Sale until you have installed the fix. This compatibility issue may cause data loss in Store Operations, POS 2009, or Point of Sale databases. For more information about specific problems that may occur in Microsoft Dynamics RMS, refer to the following CustomerSource Hot Topic:

    mbs.microsoft.com/.../rms_xp_sp3_vista_sp1_compatibility.htm

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans