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

Mon Jul 8 08:02:34 PDT 2019

Hi Heather,

Thank you very much for the suggestion - I was able to test this today, and
confirmed the software will start. I have an actual user who will do some
more thorough testing, but we're already making progress.

In my case, the profile directory is not secretly still there, so I wonder
if perhaps QGIS is unable to resolve a UNC path
<https://en.wikipedia.org/wiki/Path_(computing)#Uniform_Naming_Convention>
when expecting a local app data location (in this case
\\servername\dfsr\Members\Redirection\franklinwaits\AppData\Roaming
rather than C:\Users\franklinwaits\AppData\Roaming). I may look into
submitting this issue to the devs.

Thanks for your help!

*Alex Numann*
*Lead Mechanical Engineer*

*P:* 215.921.3649 <2159213649>
*E:* alexander.numann at nextfab.com
<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 Mon, Jul 8, 2019 at 2:40 AM Hillers Heather <
Heather.Hillers at erftverband.de> wrote:

>
> 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 <2159213649>
> *E:* alexander.numann at nextfab.com
>
> <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> 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> 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
> 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/7d2dfe6e/attachment.html>