[Qgis-user] Win7 with Roaming App Data and Profile Redirection - [ERROR] Can not make qgis.db private copy

[Hillers Heather]

I started QGIS 3 in a working environment as a new user and then copied the whole profile directory.  You do have to go through the settings first, particularly for Processing, and for Network and remove any paths that are specific to your user.  And if the user has already had the problem then you have to completely log them out of the system.  But then it should work.  In our case the directories themselves seemed to have the lock on them.  The error is about qgis.db but when we look at the profile, the whole profile directory is missing but secretly still there.  So just copying a particular file wouldn’t work.


Von: Alexander Numann [mailto:alexander.numann at nextfab.com]
Gesendet: Friday, July 05, 2019 5:23 PM
An: Hillers Heather
Cc: qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] Win7 with Roaming App Data and Profile Redirection - [ERROR] Can not make qgis.db private copy

Hi Heather,

Thanks for your response! In my situation, I'm getting this error for 100% of users with redirected app data rather than just some, but I am interested in your workaround.

Could you help me understand which files/folders you're copying from a known good/working profile to a problematic one? I can test in our environment and let you know if that resolves the issue for us.

Thanks again,

Alex Numann
Lead Mechanical Engineer

P: 215.921.3649<tel:2159213649>
E: alexander.numann at nextfab.com<mailto:alexander.numann at nextfab.com>


[https://nextfab.com/signature/img/logo.png]<http://nextfab.com/>


South Philadelphia<https://nextfab.com/location/south-philadelphia/>  |   North Philadelphia<https://nextfab.com/location/north-philadelphia/>  |   Wilmington, DE<https://nextfab.com/location/downtown-wilmington/>



On Thu, Jul 4, 2019 at 2:30 AM Hillers Heather <Heather.Hillers at erftverband.de<mailto:Heather.Hillers at erftverband.de>> wrote:

We have the same problem with QGIS 3 on our windows 7 network environment with user profiles on a network drive.  Here there is no permission problem.  Users have complete permission to write to their profiles.  The problem seems to come from a delay in syncronization between the Windows server and the network drive.   Basically:

1. The profile is created.  It exists on the network drive.  The windows side doesn't see it yet.
2.  Something happens (a bad miracle occurs)  that did not happen in QGIS 2 - maybe an attempt to read the database, or write to it? and it happens evidently before Windows recognizes that the profile directory exists.  This results in a mysterious lock. And your  launch time error message "[ERROR] Cannot make qgis.db private copy".

After closing qgis:
3.  The profile directory cannot be read now, or accessed in any way, because Windows says it does not exist.
4. The profile directory cannot be manually created, because the network drive says it already exists.
5. The profile directory also cannot be removed, because the Windows side says it does not exist.

Restarting QGIS 3 does not fix the problem.  This situation continues until the user completely logs out of the system.  At that point we can usually copy a dummy profile into the directory and start QGIS with that.  But with 50 users this is not optimal.  It happened generally on particular days (maybe there was more traffic than usual) to 4 out of every 5 users.

The situation is only relevant to brand new users, once the profile is established, everything is ok.

The situation is impossible to reproduce on purpose.  It is entirely dependent on the weather.

I ended up with the workaround of installing a dummy profile for all prospective users before introducing them to the system.  This is actually not a bad thing, because now the users have the right default settings all set before they start.

H. Hillers
Abteilung: Informationstechnologie
Erftverband, Am Erftverband 6 , D 50126 Bergheim


> Is anyone able to help with this error on Windows 7? "[ERROR] Can not make
> qgis.db private copy"
>
> *Alex Numann*

>
>
> On Fri, Jun 28, 2019 at 2:05 PM Alexander Numann <
> alexander.numann at nextfab.com<mailto:alexander.numann at nextfab.com>> wrote:
>
>> Hi,
>>
>> I am working to make QGIS available to the users of our Makerspace. I
>> have installed version QGIS-OSGeo4W-3.8.0-1-Setup-x86_64 on a Win7 x64
>> machine, and it tested fine with a local admin, a network admin, and a
>> local non-admin (guest user).
>>
>> The vast majority of our users are non-admin network accounts. When
>> testing with one of those users, we get an error on launch "[ERROR] Can not
>> make qgis.db private copy".
>>
>> Based on this only affecting a non-admin network account, I'm guessing
>> this is permission and/or profile redirection related.
>>
>> This is a brand new install with no customization, just running the
>> installer package. Any advice or suggestions you may be able to provide
>> would be much appreciated.
>>
>> Thank you,
>>
>> *Alex Numann*
>> *Lead Mechanical Engineer*
>>

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190708/67aa3894/attachment.html>