Saving offline file?

avatar

Hello,

I have changed RDM to use the Devolutions Server as Datasource. Before, we had SQL Server 2014 without it.
Now, changing the DS, brings up "Saving Offline Data". It does not go away, most of my collegues don't wait and kill the process, me, too.
What does the client do in background? Even we cannot cancel this.

Regards,
Georg

All Comments (16)

avatar

Could you post a print screen of this dialog. It should not be visible.

David Hervieux

avatar

On every version since 11.1.11.0 (this is the first one I've used) it appeared when we colse the application and do this what I described.
I will go back to 11.1.0.0 since it does not appear there.

21-04-2016 10-56-48.png

avatar

Hi,
Could you go in Help->Diagnostic and select the Data Source tab page? Just post the information or sent me a private message. I want to verify which cache system you use. It should be OpenMCDF.

Regards

David Hervieux

avatar

Hi David,

I downgraded alredy on most machines.
But I can have a look at one that is not on the 11.1.
I tried the same scenario with the old version and there it does not happen.

Regards,
Georg

avatar

Georg,

Do you still have 15,000 sessions in your data source?

The cache system is multithreaded and writes to the cache subsystem in the back ground. It could be that since you have 15,000 (if that is the case) that the offline engine hasn't yet written all information to the offline file when you close RDM. In the case, RDM will wait until this is done before closing the application. This, however, should only be the first time.

Could you please try the following.
- install v11.1.15.0
- run RDM with the /Profiler switch "[color=rgb(0, 0, 0)][font='Courier New', Courier, 'Lucida Sans Typewriter', 'Lucida Typewriter', monospace]RemoteDesktopManager.exe /Profiler[/font][/color]"
- open your data source
- "Clear Log" on the profiler window
- CTRL + Refresh, this will clear the memory, clear the cache and start overthe profiler should start logging information, look for lines like:
## - ThreadQueue.AddRow : 168 ms - Count : 512We process offline rows in batches of 512, you should see many batches like the one above. Once you see on that doesn't end in 512 then the background job is done.
- close RDM, the "Saving Offline file..." message should no longer appear
- reopen RDM
- close RDM, should also close normally
Killing the process prior to RDM having a chance to write to the offline file means that it will need to do it again on next close and drag on the process longer and longer. Keep in mind the offline engine isn't designed to handle 15,000 rows. Near the 6,000 mark performance degradation is an issue.

Best regards,

Stéfane Lavergne

avatar

Hi David,

currently, I do not have 15k connections. I stripped it down to at least 3k, this works all right now. If I do not change the datasource, RDM does not want to save the offline file and everything is fine now.
But I send you the Data Source file tab content via private message.

Regards,
Georg

avatar

sorry... only near 2k connections :)

avatar

Just confirm the issue is "gone" now that you only have 2k connections?

Stéfane Lavergne

avatar

No.
I had the issue even when having 2k connection either. Changing the data source from the "old" (directly connected to the SQL Server) to the "new" one connected to DVLS.
I only did not see this issue with the last stable release, 11.1.0.0. With the BETA-Release I saw it. Tried this in the morning when uninstalling the beta clients.

Cheers,
Georg

avatar

I upgraded to 11.1.17.0 (from the last released version) and first time, I ran RDME, "Saving offline data" appears again...

avatar

This is odd. Does the "Saving offline data" eventually go away?

Also, can you double check the offline engine? File -> Options -> Advanced (tab) -> Offline engine, make sure the value is wither Default or MCDF.

Does that change anything?

Stéfane Lavergne

avatar

The Value is "Default". I will ugprade Devolutions Server 3.2 and see if the problem still exists.
first, I thought this is an upgrade issue but today, the proglam appears again.

avatar

Georg,

Something is really odd. We need to restart from the beginning.

Please perform the following:
- Clear application logs (Help -> View Application Log -> Clean Up -> All)
- Delete your offline.db file(s)

Does the issue still occur? Yes, please send us your error logs.

Regards,

Stéfane Lavergne

avatar

... when I change to SQLite for the offline database, this is not occuring. It occurs on nearly every PC that we use here.

avatar

OK, I made sure that even on the Server "SQLite" is selected because this happens here, too.
On this machine, there is no AV installed. So this cannot be the problem.

avatar

Is there any disadvantage when I use SQLite as Offline DB?