error - user is logged on

I am using a standalone P6 v16.2 and cannot get logged on after my computer crashed.   I keep getting error message that 'user is logged on'.

Any advice on how to clear this?

Oracle Primavera - PM6
S
Santosh Bhat 👤 Member for 21 years 1 month
· Permalink

Doyin,

The issue is that, due to the computer crash, the user session that was last used hasn't been closed, and therefore P6 thinks that user is still logged in. You have to be able to connect to the database and modify some of the records - in this case delete the user sesson record.

Luckily as you're using SQLite, its somewhat easy, you can use a tool like DB Browser for SQLite to view and modify SQLite data tables.

Follow these instructions on how to use the DB Browser: http://www.p6academy.com/index.php/n111-primavera-p6-with-sqlite-and-sqlite-browser/

And the Scripts you need to run to delete the user session record is shown here: https://deepinthecode.com/2018/06/29/primavera-p6-session-hung-on-oracle-database/ you can use the same commands.

D
doyin mcarthur 👤 Member for 22 years 7 months
· Permalink

I am using Windows 16299 and on a SQLite as the database.

There is no error code except when I logon I get username is already logged on and I cannot get in

B
Bian Mutang Tagal 👤 Member for 11 years 11 months
· Permalink

Hi Doyin,

Which Windows are you on (7, 8, 10)

Are you using SQL Server or SQLite as the database, if SQL Server then which version?

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