Wednesday, January 7, 2015

User is already logged in, PRIMAVERA ERROR SQL Database



User is already logged in PMDB Databse (SQL Server)





Type this Query in the database


SELECT us.actual_name, dbo.USESSION.*  
FROM dbo.USERS AS us 
     LEFT JOIN dbo.USESSION ON us.user_id = dbo.USESSION.user_id 
WHERE user_name = 'your_login_name'

Delete the Session 

You might be able to reset the login with a delete on this session.
DELETE FROM dbo.USESSION where session_id = 

8 comments:

Anonymous said...

Thanks , it really worked for me ..

Anonymous said...

It also worked for me. Thank you

Femi Wuyi said...

Can someone explain to me better, am experiencing this problem now

Anonymous said...

Thanks :)

You save my day :))))

pavithra dass said...

Appreciate Your Work... Thanks for Sharing Useful Information. I Just want to Share Some information related to Primavera training in chennai hope it is useful for the Community Here.

rajmohan1140 said...

This is an awesome motivating article. I am practically satisfied with your great work. You put truly extremely supportive data. Keep it up. Continue blogging. Hoping to perusing your next post

Java Training in Chennai

Java Course in Chennai

Aishwariya said...

Primavera Course in Chennai | primavera online training

Aishwariya said...

Primavera Course in Chennai | primavera online training