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 11 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 4 months
· Permalink

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

Forum Sponsor

Top Posters

James Williams
75 posts
christiandt
0 posts
J Vaartjes
3 posts
Aidar Kurmantayev
0 posts
Noe Radovan
8 posts
GeoVe
0 posts
Johannes Vandenberg
14 posts
Soheil Barekat
4 posts
Peter Holroyd
51 posts
Neil Atkinson
5 posts