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) / SOPOS freeze and lost ...
Microsoft Dynamics RMS (Archived)

SOPOS freeze and lost transaction

(0) ShareShare
ReportReport
Posted on by Bob Johnson 624
I am currently chasing an issue that store ops froze as it was printing and posting a transaction, and now the transaction isn't showing up in journal and our drawer is over the amount of the sale. SOPOS display error messages box popped open with error # 2147217871 (timeout error) and then another one popped up with error message # 5.and close. The transaction will show up in HQ. This has happened in several stores a 6 or so times over the last 2 years in various stores. Any Ideas 0f what could be causing or how to fix?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: SOPOS freeze and lost transaction

    this is a common problem and has been answered many times.  Here is text from one recent posting:

    If 1.3R or 2.0 and using SQL 2005,

    Start | Programs | SQL Server 2005 | Configuration Tools | double click on
    SQL Native Client Configuration on the left | double click Client Protocols
    |
    make sure that Named Pipes is enabled | right click on Named Pipes and
    select
    Order | change so the order is 2 if Shared Memory is #1, TCP/IP should be #3
    | close

    Start | Programs | SQL Server 2005 | Configuration Tools | SQL Surface Area
    Configuration | Surface Area Configuration for Services and Connections |
    select Remote Connections on the left | make sure that Local & Remote
    connections and Using both TCP/IP and Named Pipes is selected | close this
    screen  Select Surface Area Configuration for Features | select Enable
    OPENROWSET and ... | close entirely

    For all machines with RMS installed;

    Start | Programs | Microsoft Dynamics RMS or Retail Management System |
    Client Network Utility | move TCP/IP and Named Pipes to the right hand box,
    making sure that Named Pipes is on top | select the Alias tab | Add button |
    put either the computer name of the database server machine or the IP
    address
    of the server machine | close (The database server machine should always
    have
    a static IP address, that's another post)

  • Bob Johnson Profile Picture
    Bob Johnson 624 on at
    Re: Re: SOPOS freeze and lost transaction
    I will make the changes at close tonight. Is there anyway to get the transaction to show in the store database? Thanks for the response.
  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: SOPOS freeze and lost transaction

    When I have run into this problem, the fix for that day has always been to remove whatever was left of the failed transaction and then create it again.  You will need to look at [transaction] and transactionentry, possibly taxentry, tenderentry, and dailysales. obviously not journal, and maybe the quantity of the items involved.  Sometimes I have also had to adjust the sales total in the batch record as well. Be careful not to double charge the customer if EDC has already obtained a credit card approval.

  • Bob Johnson Profile Picture
    Bob Johnson 624 on at
    Re: Re: Re: SOPOS freeze and lost transaction

    should these settings be applied to hq server and manager workstations.  I have changed these systems and now we are getting Run-time error -2147217865 Invalid object name '#Temp'. Errors on the workstations.  So either this work around is only for SOPOS workstations or I have something misconfigured in the HQ manager systems.

  • Danny1120 Profile Picture
    Danny1120 265 on at
    RE: SOPOS freeze and lost transaction

    When you click on "ADD BUTTON" to enter the Server name which option should i choose on the left? Name pipes OR TCP/IP?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    RE: SOPOS freeze and lost transaction

    Do both;

    Name of the Server for Named Pipes

    IP address of the Server for TCP/IP

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