Run the application then select Open Database & select the SQLite file that has the issue - Make sure you do not have this open in Primavera at the same time, as P6 does not like you making changes to the SQLite database when it is open.
Select the Browse Data tab, then from the Table Selection box select "PROJSHAR"
You should now see a list of all Projects that the database thinks are open in the application.
Go to Execute SQL & run the following SQL Query:
Delete from PROJSHAR where session_id NOT in (SELECT session_id FROM USESSION where delete_session_id is NULL)
If you go back to the PROJSHAR table (Hit the Refresh Button), you should see that these have all now been removed.
Close the database in the DB Browser application (before quitting the application) & open in P6 & see if it is still an issue.
Please note that as the SQLite is simply a file, I would make a backup copy of it before running any query against the database.
This should stop the annoying popup!
I have this function within a small Admin utility to allow me to clear locked user sessions, Clear Old Project Sessions & resetting passwords. Works for SQLite & MSSQL, but as yet untested against Oracle as I don't have an Oracle database to test against (but should work).
It's basically running the above query to clear old project sessions, but without having to download the DB Browser first.
Regards,
Steven
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Thu, 2021-02-11 16:52
to Steven points when ever you exit out of P6 make sure that you select file close all and then exit. Do not just use the X in the upper right to exit the program. Selecting file close all logs the user out of the project and then exiting the program closes the database properly.
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Thu, 2021-02-11 11:35
I should have written that the database is SQLite, and that behaviour only comes with one specific project, either when I am rescheduling or closing this project. I have created this project on the same PC, in the same database, with an earlier P6 release (15 or somethnig)
There certainly is some miscrepancies somewhere in the "file" data, some P6 bug may be? As I am the sole user on my PC, the issue is only an "intellectual" one, if I can say.
I am assuming that you are either using a MSSQL Database or Oracle, as this does not come up as an option when opening a SQLite database.
When you are opening a Project from Either a MSSQL or Oracle Database (PPM or EPPM), the application does not know that you are using it as a stand alone database, so comes up with options in the Open Project dialogue box whether you want to open as Exclusive (no one else can modify), Shared or Read Only.
A MSSQL / Oracle database would only require you to share the connection details with someone else to allow them to open the same projects.
When using an SQLite database, it is not possible to select whether it is shared or exclusive, as SQLite databases do not work as well in a multi user setting & you may see issues in the P6 application if you are running SQL Queries against the database at the same time as the application is running.
If you are just right clicking on the Project from the Projects list & selecting Open, you will not see this option - only if using the File - Open menu (Ctrl + O).
When scheduling projects in shared mode that are open by multiple users, you get a warning every time you reschedule the project to let you know other users have the same projects open.
Member for
22 years 9 monthsSteven and Zoltan,thank you
Steven and Zoltan,
thank you very much, I do appreciate your help and advices
Alexandre
Member for
8 years 1 monthZoltan,Updated my previous
Zoltan,
Updated my previous post to make this a bit clearer.
Regards,
Steven
Member for
8 years 1 monthAlexandre,I think that there
Alexandre,
I think that there is still an old user session stored in the database - possibly if P6 didn't close down correctly.
If you download "DB Browser for SQLite" which is a free utility from DB Browser for SQLite (sqlitebrowser.org)
Run the application then select Open Database & select the SQLite file that has the issue - Make sure you do not have this open in Primavera at the same time, as P6 does not like you making changes to the SQLite database when it is open.
Select the Browse Data tab, then from the Table Selection box select "PROJSHAR"
You should now see a list of all Projects that the database thinks are open in the application.
Go to Execute SQL & run the following SQL Query:
Delete from PROJSHAR where session_id NOT in (SELECT session_id FROM USESSION where delete_session_id is NULL)
If you go back to the PROJSHAR table (Hit the Refresh Button), you should see that these have all now been removed.
Close the database in the DB Browser application (before quitting the application) & open in P6 & see if it is still an issue.
Please note that as the SQLite is simply a file, I would make a backup copy of it before running any query against the database.
This should stop the annoying popup!
I have this function within a small Admin utility to allow me to clear locked user sessions, Clear Old Project Sessions & resetting passwords. Works for SQLite & MSSQL, but as yet untested against Oracle as I don't have an Oracle database to test against (but should work).
It's basically running the above query to clear old project sessions, but without having to download the DB Browser first.
Regards,
Steven
Member for
16 years 3 monthsto Steven points when ever
to Steven points when ever you exit out of P6 make sure that you select file close all and then exit. Do not just use the X in the upper right to exit the program. Selecting file close all logs the user out of the project and then exiting the program closes the database properly.
Member for
22 years 9 monthsHi Steven,Thank you for your
Hi Steven,
Thank you for your post.
I should have written that the database is SQLite, and that behaviour only comes with one specific project, either when I am rescheduling or closing this project. I have created this project on the same PC, in the same database, with an earlier P6 release (15 or somethnig)
There certainly is some miscrepancies somewhere in the "file" data, some P6 bug may be? As I am the sole user on my PC, the issue is only an "intellectual" one, if I can say.
Alexandre
Member for
8 years 1 monthAlexandre,I am assuming that
Alexandre,
I am assuming that you are either using a MSSQL Database or Oracle, as this does not come up as an option when opening a SQLite database.
When you are opening a Project from Either a MSSQL or Oracle Database (PPM or EPPM), the application does not know that you are using it as a stand alone database, so comes up with options in the Open Project dialogue box whether you want to open as Exclusive (no one else can modify), Shared or Read Only.
A MSSQL / Oracle database would only require you to share the connection details with someone else to allow them to open the same projects.
When using an SQLite database, it is not possible to select whether it is shared or exclusive, as SQLite databases do not work as well in a multi user setting & you may see issues in the P6 application if you are running SQL Queries against the database at the same time as the application is running.
If you are just right clicking on the Project from the Projects list & selecting Open, you will not see this option - only if using the File - Open menu (Ctrl + O).
When scheduling projects in shared mode that are open by multiple users, you get a warning every time you reschedule the project to let you know other users have the same projects open.
Regards,
Steven