For some reason after I activated my Offline Database on the POS machine by running a Z report and ZZ report, now my POS application keeps putting out the message "The primary database is back online. Do you wish to return to online mode and recover backup data?" I already synchronized the Offline DB with the STore DB but I keep getting this message when I either close out of the software and re-launch or run a Z-report.
*This post is locked for comments
Hello Ladenna,
Thank you for your update.
I am glad to see that after the third attempt the offline data sync went through.
Please let us know if you continue to have problems.
You have a great weekend as well!
Thanks,
Nicole
Thanks for the additional table/Version correlation info. I will keep as a reference.
Ok, so my solution was to rebuild again and synchronize with another Z out. The new Offline DB did transfer the data from the store database to the Offline DB. The problem was determined to be a bad sync the 2nd time I tried to build it. The 3rd time did work. Had to put in a ticket to MS to find the solution but I am glad it was just an anomoly that sometimes takes several tries and nothing to do with the configuration or DB.
I put the ticket in because I worked with our partner when I noticed the Custom Buttons table not populating. The tech said MS has a paper out on what is not supported in "Offline" status and Custom Buttons was on the list. Well this never happened before on all the other times we made installations, but he was convinced this was why my tables did not load. So I then agreed to manually populate them and I tried again, and found the "Tenders" table also did not populate. So I knew then this could not be the reason the tables did not populate. After working with the MS tech and going through the same actions one more time, it took about 10 minutes to resolve just doing another sync that was successful.
Now just have 1 issue to resolve. So I will post it next on the Forum. Not sure there will be a fix for it though.
Thanks and have a great rest of the week!
Hello Ladenna,
Thanks for your update.
When you say you only see the Item and Cashier table updating, does this mean when you look at the tables the tables are missing or they simply have no data?
When the sync is going through do you see the tables listed that are being synced?
RMS 2.0.0155 is database version 2.04. I have listed the other versions below for your reference:
2.0.0116 is database version 2.01 (Service Pack 2)
2.0.0150 is database version 2.02 ( Feature Pack 1)
2.0.0151 is database version 2.03 ( this is the initial release of Service Pack 4, this version should NOT be used)
2.0.0155 is database version 2.04 (Service Pack 4)
2.0.1000 is database version 2.05 (Feature Pack 2)
2.0.2000 is database version 2.06 (Cumulative Update 5)
I look forward to your response.
Thanks,
Nicole
Ok, I rebuilt the offline db, and ran the Ad Hoc Queries on it to turn it on. I did find one issue that may have affected the original installation Offline, but now that I fixed this, it should not be an issue. So I ran the Z report to synchronize. One big problem is, not all contents from the server DB is tranferring to the new Offline tables. So I can see Items Table is updated and Cashiers, but not Custom Buttons. So I tried rebooting and running the Z still no transfer and also just closed it out with a ZZ and still the synchronization did not populate all the tables.
One thing I noticed, even though my installation is version 2.0.0155, the Offline DB is showing the version as 2.4. I don't know how this could be different but I did a check and that is what the Offline DB is saying on the register station.
Hello Ladenna,
Thanks for your update on both posts. I will just respond to this one in the future.
You should only have to run a Z report when creating an offline database, while I wouldn't think that a ZZ would be an issue, if you could I would suggest recreating the offline database and run just a Z vs. ZZ report.
Also what version of RMS are you running on?
You can also enable Ad Hoc Distributed Queries on the offline server. I have listed the steps below on how this can be done.
* I find it easiest to run these in SQL Server Management Studio, but if you do not have this you can run them in Store Operations Administrator; just make sure you are connecting to the offline server vs. the online server.*
Run the following SQL statements one at a time:
1. sp_configure 'show advanced options', 1
reconfigure
The return message from the above sql statements for a successful run is as;
"Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. "
2. sp_configure 'Ad Hoc Distributed Queries', 1
The returned message is :
"Configuration option 'Ad Hoc Distributed Queries' changed from 0 to 1. Run the RECONFIGURE statement to install."
3. reconfigure
Please go through the suggested troubleshooting and let me know whether you are still having an issue.
I look forward to your response.
Thanks,
Nicole
Yes I used the rmsdb.bck file in the Program Files/Microsoft RMS directory to create the offline DB. I originally synchronized by ZZ out and everything copied over. Then when I went to test the offline DB to make sure it would work like it was supposed to, I started getting these errors. I am using SQL 2008 R2 Express.
I thought about it and changed the object security on the POS User, SO Mgr and Admin user and this seemed to take care of things. But now when I go to test the offline db failover functioning, it does not synchronize to be updating the sales from Offline to StoreDB. It also hangs when you close out of the POS and try to relaunch.
Also, Yes I can connect to both OFFline DB in SOAdmin and STore DB when I have the server up and not testing.
Hello Ladenna,
Thank you for your post.
Did you make sure to use the rmsdb.bck when creating the offline database?
What version of SQL is the offline and online databases running on?
I look forward to your update.
Thanks,
Nicole
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154