Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 620
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

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 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

  • 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?

  • Bob Johnson Profile Picture
    Bob Johnson 620 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.

  • Community Member Profile Picture
    Community Member Microsoft Employee 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 620 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 Microsoft Employee 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)

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans