News:

Buying something from Amazon? Please consider using my affiliate links - Amazon.com or Amazon.co.uk - You get your stuff, Plan-G gets a little boost :)   

Main Menu

Cannot build database

Started by nikolasd, September 10, 2012, 10:42:26 AM

Previous topic - Next topic

nikolasd

I have installed Plan-G on my computer but I cannot create the database. After processing the sceneries it gets stuck (not hanged, but I have left it the whole weekend and on Monday had not proceeded) on "Writing 103277 Intersections".



I guess the problem is that (as I see on the log)

"There is a file sharing violation. A different process might be using the file. [ \\Lifthrasir\Users\nikolas\My Documents\Plan-G Files\Data\PlanG3_FSX.sdf ]"

My Documents folder is on a network share (through Folder Redirection Group Policy).

Is there any way I can change where the Plan-G Data will be stored?

Thank you in advance

tim arnot

What is the version of Plan-G, and what is your operating system?

(you cut these lines out of your log file)

Tim. @TimArnot

nikolasd

Windows 7 64bit

Plan-G v.3.0.0.46

tim arnot

Ta.

Two things to try: Shut sown PG3 and then delete the PlanG3_FSX.sdf file from your My Plan-G files folder. It'll recreate it on startup. You may need a reboot if there really is a lock left open on it. Also try updating to build 49 - there are several database fixes in it.

Tim. @TimArnot

nikolasd

I tried the .50 build but same thing happened. I also tried to delete the PlanG3_FSX.sdf file and then rerun PlanG to recreate it and got same error (with some additional .net errors). I did a little research and I found that the SQLCE does not support multiple processes. Since My Documents folder (where the PlanG db is located) is a folder redirection (with offline files enabled), I guess that the "other" process that locks the DB file is the Syncronization process. If I disconnect the network (so I can be in Offline mode) I cannot access the DBs at all, since no DB files are synchronized (Windows feature). I don't want to disable offline folders for my own reasons.

Is there any way that I can "move" the DataDirectory outside the My Documents folders?

tim arnot

Hang on, so is your "my documents" folder on a different machine? With syncing?

There's no way to change the location of the database. The best I can suggest is that you create a virtual folder for it that is stored locally. So it would be physically outside the My Documents hierarchy, although still there logically. (it's how those of us with SSDs get around the Orbx "everything must be inside the main FSX folder" annoyance) Even then I have no guarantee it would work.


Tim. @TimArnot

nikolasd

So I managed to fix somehow my problem by doing the following.

I started Plan-G using the local pc user and not the network user. Local user has not folder redirection and offline files enabled. So I started Plan-G (note. I did not started by the Plan-G icon on the Desktop, but by running the executable Plan-G3.exe). Plan-G started and created the required data folders on user documents folder (which is a local folder). I made the Plan-G Files folder shared and after the build database process ended I copied the files to the network user's my documents folder and everything worked like a charm.
The only disadvantage is that I have to switch to the local user every time I want to rebuild database, but this is not happening regularly.

Plan-G is great! Thank you Tim!

One feature I would love to see is the ability to see the IVAO traffic the same way I see VATSIM.