Navigation and Dashboard - refreshing
Hi,
I've got up to 1000 entries in MSSQL DB.
After add new I don't see new entry. The same happens when I delete old entry from DB is deleted but still exist in Navigation pane. Refresh nothing change.
Sometimes refresh work when I change data source.
Regards,
Grzegorz
All Comments (4)
From what I gather from your other post, you are copying your production DB over to your local machine to test the upgrade. Correct?
The issue you are seeing is because we of the way SQL Server manages "timestamp" see: https://msdn.microsoft.com/en-us/library/ms182776(v=SQL.90).aspx
We use a few timestamp columns to detect delta changes between the server and client so that we don't have to push all the data from server to client on every request.
When you create a new DB from script and transfer the data over you reset the timestamp to 0x0000000000000000 this causes the change detect script to freak out and not work.
There is a work around...
WARNING! DO NOT DO THIS IN PRODUCTIONupdate ConnectionHistory set Version = 0x0000000000000000
This should resolve the issue.
Best regards,
Stéfane Lavergne
Forgot to mention, once you've run the script on the server, hit CTRL+refresh in RDM to reload the data. You can now test the add/delete of sessions, all should work properly.
Best regards,
Stéfane Lavergne
Thanks ctr+refresh works without DB update.
What is difference between Refresh and ctr + refresh?
Refresh : is a cached refresh, it sends a token to the server and the server will reply with a delta of changes (add/edit/delete) of sessions to be applied on the client.
CTRL+refresh : clear the local cache and fetch all the data from the server.
Best regards,
Stéfane Lavergne