Computers & Internet Logo
Luke Przekwas Posted on Jan 14, 2014

Having problems clearing a database

Our cafe's RPE has been hanging for very long periods of time after any transaction, cash or card, before it prints a receipt. So I have taken it upon myself to help my boss speed it up. I have upgraded the computer's RAM, gotten a new USB interface card for our Epson TM-88IV printers (instead of our old parallel one!!), deleted and reinstalled the printers and drivers, and am now attempting to clear the database. I have backed up the current on another hdd for safety, restored it to a new database called "previousnumbers" so we can access old sales data, and am now trying to clear transaction history on cresql hoping it can speed up our transactions. However, RPE will freeze every time I click on clear transactions. Is there a way to do it via SQL or am I going to have to make a new database entirely? If I have to - will I have to reconfigure our drinks and food menu or is there a way to keep that? Any assistance would be very appreciated. Thanks!!

1 Answer

dokn

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 4 Answers
  • Posted on Jan 14, 2014
dokn
Contributor
Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Sep 03, 2009
Answers
4
Questions
0
Helped
3057
Points
23

How long has this system been in use? Just trying to gauge if it's the amount of records that is really your problem.

Perform a scandisk on the HDD. Perhaps the hangs are due to corrupt hard-drive issues. It's easy to cause corrupt areas - rebooting or powering off while the hard drive is in use is enough to cause issues. That alone will fix 80% of the problems out there.

To check the hard disk drive integrity in Windows:

  1. Double-click My Computer, and then right-click the hard disk drive you want to check.
  2. Click Properties, and then click Tools.
  3. In Error-checking, click Check Now.
In many cases, it will ask to be scheduled - go ahead and schedule the scandisk and then reboot. This process can take 20 minutes to finish - let it finish and see if your performance improves.

5 Related Answers

Anonymous

  • 1 Answer
  • Posted on Apr 13, 2009

SOURCE: Screen hangs after cash transaction or credit card transaction

Is the problem you're having with a computer running Windows Server?

Ad

Anonymous

  • 1 Answer
  • Posted on Jul 20, 2009

SOURCE: Sales wrong on Shift Report!

cALL pca AND cOMPLAIN tHEY KNOW ABOUT THIS AND HAVE NOT FIXED THE ISSUE, tHEY JUST COST ME SEVERAL THOUSAND DOLLARE IN LOSSES BECAUSE THEY COULD NOT MAKE THERE SOFTWARE DO MATH CORRECTLY.

Butch Mattern

  • 310 Answers
  • Posted on Aug 04, 2010

SOURCE: If you clear database does

It depends on the version you are running. Always backup your database before doing this. When you clear database, another screen appears with options. You can then choose between several things including just sales/invoices or A/R transactions.

B Mattern
sysadmin@ccybernet.com

Butch Mattern

  • 310 Answers
  • Posted on May 13, 2011

SOURCE: Friends have purchased a used

The exiting user(cashier) can be corrected by going to OPTIONS, SETUP, SETUP SCREEN, INVOICE SETTINGS tab. Uncheck Prompt for Cashier ID. Then UPDATE.
Your other problems will require someone with knowledge of RPE version 11 because there is no tutorial or even a good user manual. If you need to register software, be fore warned. You will need previous company name, address, phone number and a contact name to get a reset. The software will never be yours unless you officially transfer it and that is costly. Your almost better off buying new. And good luck with printer drivers. Certain versions require the exact driver to be totally functional. You have your work cut out for you. I can help, but not for free.

B Mattern
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.

Testimonial: "Quick response and very informative! Thanks. I have friends that are BIG STEELERS FANS!"

Anonymous

  • 32 Answers
  • Posted on Jun 07, 2011

SOURCE: We are on the latest

what URLs are you using? try: netconnect1.paymentech.net (no HTTP or anything like that) and netconnect2.paymentech.net

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

113 views

Ask a Question

Usually answered in minutes!

Top Pc America Computers & Internet Experts

Don A
Don A

Level 3 Expert

5185 Answers

Butch Mattern

Level 2 Expert

310 Answers

Anonymous

Level 1 Expert

32 Answers

Are you a Pc America Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...