Recently, when trying to upgrade the RMS database from 2.00 to 2.01, I ran
into a problem that I was surprised I found no posts or mention about
anywhere I searched. Because of that, I wanted to post to the newsgroup in
case anyone else ever has this problem:
Despite Z-ing out and backing up the database, I was unable to upgrade the
database from 2.00 to 2.01 in Administrator.
I do not use integrated card processing (EDC), but use a standalone terminal
for card transactions. Regardless, somehow, when first using RMS in 2005,
presumably with the sample database, I managed to record three EDC
transactions that were never settled. I do not have a way to settle them,
and never needed to, so they were left in the database and forgotten about.
This was highly problematic, as I had upgraded Manager and Store Ops POS on
both my machines, yet they could not connect with the old database version,
and Administrator could not update the database to allow them to connect.
After uninstalling and reinstalling RMS on one of the PCs, I was able to log
in to the database with an older version of Manager. Looking around at every
report and option for a clue about what else might prevent Administrator
from being able to update the database, I stumbled upon "Settle EDC Batch",
which as mentioned above, is not something I have ever used. That command
showed three batches, which I was unable to settle.
I discussed the problem with a friend with SQL experience, he remotely
(cool!) deleted the three offending batches in my database, after which,
Administrator WAS able to update the database (after I again backed it up).
I updated my version of RMS and now all machines can access the 2.01
If any consultants are helping clients who don't use EDC/integrated
processing, that doesn't mean that they don't HAVE unsettled batches
preventing certain Administrator actions like database udates.