Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

amygenevarest (Programmer)
23 Jan 08 0:04

Hi,
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.
amygenevarest (Programmer)
24 Jan 08 8:18
Hi
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.
Amy
Helpful Member!  pmegan (Programmer)
25 Jan 08 14:51

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.

Pat

amygenevarest (Programmer)
27 Jan 08 0:20
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)
Amy
pmegan (Programmer)
15 Feb 08 13:34

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?

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