×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Jobs

Micros 3700 problems with AutoSequence app

Micros 3700 problems with AutoSequence app

Micros 3700 problems with AutoSequence app

(OP)
Hey guys,

We are having a few problems with our micros 3700 system ver. 5.2 closing reports and adding menu items, both seems to be tied to the autosequencing app. The closing reports problem is solvable by stopping and restarting the service on the database server, but adding menu items fails consistently. An upgrade from 2700 to 3700 was performed by an outside consultant in April of last year, and it's been problematic since.

For the menu items problem,the sequence numbering seems a little off, this is what it looks like when it fails:



The UID for the mi_def table it references seems a little out of whack, which might be part of the problem, it looks like it was manually shifted during the upgrade:



Sybase says the UID for the table (mi_seq) has a range of -9999999 to 999999, so is this a limitation in Micros that is causing problems at the 250k mark (its obviously not a database sequence limitation)? Also, if there is an upper limit to the range, is it possible to shift new items into the 209k-200k range that we know hasn't been used yet (and would this even help)?

Thanks





RE: Micros 3700 problems with AutoSequence app

It looks like you tried to change the Number of the menuitem. your are not allowed to have 1 number twice

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