Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Micros 3700 System

Micros 3700 System

Micros 3700 System


I am pretty new to Micros, and need some assistance, please! We have paid alot of money to Micros for tech support in the past. The system just got updated from micros today to protect customer cc information. We have updated some prices on our menu. And changed them in the system. Now, we would like to conquer "clean up" some old menu items that are no longer used out of the system. Also  add hard key buttons on the food server screen (where appetizers, entrees, desserts are listed, not menu items, like the categories) I have been nominated to take on this task, I am wondering if there is a manual online or some websites with frequently asked questions for general use of the back office part of micros. I do know how to delete an item, but some items come with a error message. Since this system was install years ago, there hasnt really been anyone in the restaurant keeping info up to date or really managing the system. We have frequent crashes. Where the system needs to be restarted. Micros doesnt have anything listed on their website(duh... cuz they want you to pay for their high priced support) I would also really like to know what steps should be taken to protect the system and its database (daily, montly, etc) so we can have this system running smoothly again. With less crashes. I think the one gentlemen that came out once said the system should be rebooted daily? I thank you for your help.

RE: Micros 3700 System

The exact message I am getting when trying to delete menu items is:
Key Violation. [Sybase][ODBCdriver][Adaptive Server Anywhere][Integrity constrant violation]Primary key for Row in Table'mi_def' is General SQL error. referenced in another table.
Any advice would be greatly appreciated.
Thanks for your time.

RE: Micros 3700 System

Hi Amy,

The error you're getting is a database relationship violation. It's most likely due to historical totals. You can't delete an item until all sales for it have been purged from the database.

Here's how to determine how long your totals are being held:
Open the POS Configurator.
Go to the Reporting tab, Historical Totals button.
Look at the Class Name for each Historical Total Definition that has Menu Item in the name. They may all be the same.
Click on the Classes tab.
Each class has a Number of Days History box. This is how long totals are held before they're purged.

To find out what items still have totals associated with them, run a consolidated system menu item sales report with a date range from 1/1/07 through today. (This can be pretty labor intensive and slow down your system, so do it when you're restaurant is closed just to be safe.) Menu items that show up on the report have totals and cannot be deleted.

As far as maintenance goes, what version & OS are you on, and what kind of server do you have? You should be backing up the database least once a day, and the logs and journals should be rotating and purging.

Normal windows maintenance should be done regularly, antivrus scans, scheduled defrags, etc... I have our stores reboot the server weekly. This is mainly to keep the time needed to reboot to a minimum. There's nothing worse than having to do a quick reboot and it takes 10 minutes to shut down because the last reboot was 3 months ago.

Hope that helps get you started.


RE: Micros 3700 System

Thank you for the information Pat, when I go back to the restaurant I will let you know what we are running. Just not sure what OS means, could you please tell me?
By Server, you mean the computer in the back of house, right? Sounds like I will be working a very long night very soon to do these steps you have given me. Like I said, there as been minimal maintenance done on the system. But it's a must and I guess I will be the one to do it. I hope I can count on you and others to see me through this horrible ordeal. Thank You So Much for taking your time to explain this to me, I sincerely do appreciate it:0)

RE: Micros 3700 System

Sorry about the delayed response. I was out of town for a few weeks and didn't have time to check the forums. Were you able to get everything straightened out?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close