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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Error#-2147467259 drop...
Microsoft Dynamics RMS (Archived)

Error#-2147467259 dropped transactions

(0) ShareShare
ReportReport
Posted on by Chris Rayment

We have 14 stores and about 22 Microsoft RMS POS lanes.

A few of the POS computers are receiving this error on a very random basis.  The error will occur at the end of a transaction and will "drop" the transaction from the journal viewer and the X-Report will show a discrepancy between the Total Sales and the Dept Sales. The Dept Sales will be higher by the amount of the transaction that "dropped".  This then causes the Over/short to be wrong as well as our perpetual inventory which is extremely annoying and time consuming to fix.

Error#-2147467259 (DBNETLIB)(ConnectionOpenConnect()) General Network Errro. Check your network documentation. Select GetDate()AS Current DateTime.

This was occuring at two of our stores with one back office computer acting as the server and one RMS POS lane.  We moved the database from the back office computer to the POS and it fixed the problem. This made us think its a server or network problem until I had this problem happen in a two lane environment and only affect one lane.

I now have another store with two RMS lanes and it is now getting this error on only one lane and not the other. The back computer is a HP RP5700 with RAID1 and Windows XP Pro SP3. The registers are different. One is a HP R5700 with RAID1 and Windows XP Pro SP3, and the second register is an HP RP5700 with Windows 7 Pro 32.

The register that is getting the above error is the HP RP5700 Windows XP Pro SP3 station. The register running Windows 7 Pro 32 is NOT getting this error.

When we had this occur on the one lane environment at two other stores, I sent everything to Microsoft and they concluded that it must be a hardward related problem. I have since quit trying to solve the problem because putting the database locally on the one lane environment fixed the problem.

I can't do the same thing in a two lane environment so I need to fix this problem.

I have followed every KB article on troubleshooting general network errors as well as setting up SQL Aliases and all required SQL settings for RMS.

It is interesting to note that on this current problem register, if I set an SQL alias using the IP address of the server, then the POS will not connect to the database and it will open in Offline mode. If I set the SQL alias using the server computer name, then the POS opens just fine.  Not sure if this has any correlation to the problem or not.

I would appreciate anyone's insight or help on this.

Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: Error#-2147467259 dropped transactions

    Any chance you're running serial-usb adaptors on any of these systems? I fought for months in disbelief with an issue that manifested with the same behaviors you describe. It didn't go away until I got rid of all of my serial-usb adaptors. I'm still scratching my head but glad to have it behind me.

  • Chris Rayment Profile Picture
    Chris Rayment on at
    Re: Error#-2147467259 dropped transactions

    Thanks for the reply, but we dont have any Serial-usb adaptors. We have the printer (Epson TM88IV) using parallel. The Ingenico i6550 using Serial. I disabled the serial Pole display because that was suggested. Microsoft suggested that the RAID 1 could be the culprit, but we have about 10 other stores using RAID 1 with no problems at all.

  • Community Member Profile Picture
    Community Member on at
    Re: Error#-2147467259 dropped transactions

    Here's another thought that someone suggested a couple of years ago. Dells running serial add-in cards have also displayed some significantly quirky behavior along the same lines.

  • Community Member Profile Picture
    Community Member on at
    Re: Error#-2147467259 dropped transactions

    Oh, and any chance you've had any corresponding BSOD's?

  • Chris Rayment Profile Picture
    Chris Rayment on at
    Re: Error#-2147467259 dropped transactions

    No, not at all. The error just shuts down POS and we have to reopen it without any problem.

  • Community Member Profile Picture
    Community Member on at
    Re: Error#-2147467259 dropped transactions

    Well Chris, I know this problem and i had faced it for years and I see that you described it very well, I have some recommendations that I tried myself in a 40 store environment with heavy transactions load and with a considerable number of 'incomplete' transactions every month, my recommendations below decreased the monthly average of incomplete transactions by 90% and it became very rare, so give it a try on one database and see

    install the latest SQL SP

    on the sql server engine level, go to properties|advanced|query timeout, make it '1' instead of' '-1'

    on the database level, make sure that "auto shrink" is false

    on the database level, make sure that the recovery model is simple

    create a clustered index on Item.ID field

    create a clustered index on Transaction.TransactionNumber

    create a clustered index on TransactionEntry.TransactionNumber

    create a non-clustered index on TransactionEntry.ItemID

  • Community Member Profile Picture
    Community Member on at
    Re: Error#-2147467259 dropped transactions

    I seen same error when Ii chnaged my main server xp to 7 . You should log in to mssqltips.com. You can find lots  of sql tips.

    Pls see below sql tips

    www.mssqltips.com/.../configuring-sql-server-to-use-multiple-ports

  • tahir Profile Picture
    tahir on at
    RE: Error#-2147467259 dropped transactions

    Check your hold transactions if there are nay hold transactions cancel them and check your scanner settings.

  • LanceM Profile Picture
    LanceM on at
    RE: Error#-2147467259 dropped transactions

    Hi Chris,

    Were you ever able to resolve the problem? I've experienced the same thing at 1 of my 3 locations for a long time and have tried every suggested solution to no avail. If you discovered a solution I'd great appreciate hearing it. Thanks!

  • Chris Rayment Profile Picture
    Chris Rayment on at
    RE: Error#-2147467259 dropped transactions

    Our dropped transactions have cleared up. We have changed our environment and honestly since it was a random problem I don't know what fixed the problem. I'll explain our current hardware and software setup.

    We previously had HPrp5700 computers with WinXP Pro and RAID1 hard drives and now we have HP computers with Win7Pro and NO RAID1 hard drives. Microsoft tech support suggested the RAID1 setup could be causing the problem but we had RAID1 on all computers and some were fine whIle others were not.

    We are now running SQL Express 2008 R2.

    We are upgraded to RMS Cumulative update 5 (CU5).

    We have USB scanners, no pole displays, using Net display, Magtek IPad SC.

    Let me know if you have addition questions.

    Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October 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