Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Shared mode

No replies
Thu, 2025-01-16 16:57
Nick Jackson
User offline. Last seen 24 weeks 5 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Hi

Got a stange one. I'm running standalone as follows:

About: Primavera P6 Professional 24
Release: 24.12.0.51267
Platform: x64
Database Schema Version: PPMDB,2412.0000.0000.0006

PPMDBSQLite.db

Every time I schedule the shared mode warning comes up. No one else uses the database (its standalone). I don't appear to have the 'access' option which lets me choose shared or exclusive use.

I logged out and even tried re-booting.

Anyone know how I can stop this message - its not fatal but very irritating.

Top
Thu, 2025-05-22 21:47
#1
Zoltan Palffy
User offline. Last seen 15 weeks 8 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3091
Groups: None

here is the fix 

For SQLite

  1. Download and install the SQLite Browser utility.
  2. Close P6 Professional.
  3. Open SQLite DB Browser.
  4. Select Open Database and navigate to the SQLite database

Database Location

C:\P6localDB\Mydatabse.db or wherever yours is located and named.

5. Run the following queries: by selecting the tab Execute SQL

delete from projshar;    Then press the play button

delete from usession;    Then press the play button

6. Click Write Changes then close the utility.

7. Login to P6 Professional and test.

Top
Thu, 2025-04-17 12:41
#2
Nick Jackson
User offline. Last seen 24 weeks 5 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Thanks David (sorry for late reply)

Never used that before but downloaded it and fopund an excellent guide on this operation here:

https://www.youtube.com/watch?app=desktop&v=JgZwDd-6m7U&ab_channel=Ahmad...

Top
Thu, 2025-04-17 11:33
#3
Nick Jackson
User offline. Last seen 24 weeks 5 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Thanks David (sorry for late reply)

Never used that before but downloaded it and fopund an excellent guide on this operation here:

https://www.youtube.com/watch?app=desktop&v=JgZwDd-6m7U&ab_channel=Ahmad...

Top
Thu, 2025-04-17 11:30
#4
Nick Jackson
User offline. Last seen 24 weeks 5 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Thanks David (sorry for late reply)

Never used that before but downloaded it and fopund an excellent guide on this operation here:

https://www.youtube.com/watch?app=desktop&v=JgZwDd-6m7U&ab_channel=Ahmad...

Top
Thu, 2025-04-17 10:17
#5
Nick Jackson
User offline. Last seen 24 weeks 5 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Thanks David

Incidentally there's an excellent walkthough on how to do this on YouTube - it works (copy6 and paste in brower I can't seem to make a link)!

https://www.youtube.com/watch?app=desktop&v=JgZwDd-6m7U&ab_channel=Ahmad...

 

Top
Fri, 2025-01-17 10:38
#6
david kelly
User offline. Last seen 3 hours 47 min ago. Offline
Joined: 12 Feb 2016
Posts: 40
Groups: None
You can probably clear the phantom user using "DB Browser for SQLite"
Top