+

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:

  1. Thanks , it really worked for me ..

    ReplyDelete
  2. It also worked for me. Thank you

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

    ReplyDelete
  4. Thanks :)

    You save my day :))))

    ReplyDelete
  5. 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.

    ReplyDelete
  6. 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

    ReplyDelete