Shared mode

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.

Oracle Primavera - PM6
Z
Zoltan Palffy 👤 Member for 16 years 10 months
· Permalink

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.

D
david kelly 👤 Member for 10 years 3 months
· Permalink

You can probably clear the phantom user using "DB Browser for SQLite"

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts