Oracle Primavera - PM6 Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:11 Permalink thank you so very much, you thank you so very much, you are a life saver Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:10 Permalink thank you so very much, you thank you so very much, you are a life saver Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:10 Permalink thank you so very much, you thank you so very much, you are a life saver Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Thu, 2021-06-17 15:05 Permalink you have to log into the you have to log into the sql Start programs Microsoft SQL server Management Studio Express Login into SQL Server Management Studio with login in is sa password is Prima123Vera expand the databases and look for your database click on new query Select * from Usession note the User_ID from the query that you just ran foro example user_id is 123 new query UPDATE usesession SET delete_session_ID=0, delete_date=GETDATE() WHERE user_ID = 123 close the Microsoft SQL server Management Studio Express and log in Member for 8 years 1 month Member for 8 years 1 month Submitted by StevenA on Thu, 2021-06-17 12:37 Permalink Cynthia,I have a small Cynthia, I have a small application that I have created that may help. If you can PM me with your contact details if you are interested & I can sent it through for you to try. It allows you to clear old User Sessions, Clear Orphaned Project Sessions & Clear User Passwords. I have tested it on SQLite and SQL only - not yet tested on Oracle as I don't have an Oracle Install to test against. Create a copy of the .db file before running to ensure that you have a backup first. Regards, Steven Log in or register to post comments
Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:11 Permalink thank you so very much, you thank you so very much, you are a life saver
Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:10 Permalink thank you so very much, you thank you so very much, you are a life saver
Member for 17 years 8 months Member for 17 years 8 months Submitted by WAEL ELHAJJ on Sat, 2022-12-24 13:10 Permalink thank you so very much, you thank you so very much, you are a life saver
Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Thu, 2021-06-17 15:05 Permalink you have to log into the you have to log into the sql Start programs Microsoft SQL server Management Studio Express Login into SQL Server Management Studio with login in is sa password is Prima123Vera expand the databases and look for your database click on new query Select * from Usession note the User_ID from the query that you just ran foro example user_id is 123 new query UPDATE usesession SET delete_session_ID=0, delete_date=GETDATE() WHERE user_ID = 123 close the Microsoft SQL server Management Studio Express and log in
Member for 8 years 1 month Member for 8 years 1 month Submitted by StevenA on Thu, 2021-06-17 12:37 Permalink Cynthia,I have a small Cynthia, I have a small application that I have created that may help. If you can PM me with your contact details if you are interested & I can sent it through for you to try. It allows you to clear old User Sessions, Clear Orphaned Project Sessions & Clear User Passwords. I have tested it on SQLite and SQL only - not yet tested on Oracle as I don't have an Oracle Install to test against. Create a copy of the .db file before running to ensure that you have a backup first. Regards, Steven
Member for
17 years 8 monthsthank you so very much, you
thank you so very much,
you are a life saver
Member for
17 years 8 monthsthank you so very much, you
thank you so very much,
you are a life saver
Member for
17 years 8 monthsthank you so very much, you
thank you so very much,
you are a life saver
Member for
16 years 3 monthsyou have to log into the
you have to log into the sql
Start programs Microsoft SQL server Management Studio Express
Login into SQL Server Management Studio with login in is sa password is Prima123Vera
expand the databases and look for your database
click on new query
Select * from Usession
note the User_ID from the query that you just ran foro example user_id is 123
new query
UPDATE usesession
SET delete_session_ID=0, delete_date=GETDATE()
WHERE user_ID = 123
close the Microsoft SQL server Management Studio Express and log in
Member for
8 years 1 monthCynthia,I have a small
Cynthia,
I have a small application that I have created that may help.
If you can PM me with your contact details if you are interested & I can sent it through for you to try.
It allows you to clear old User Sessions, Clear Orphaned Project Sessions & Clear User Passwords.
I have tested it on SQLite and SQL only - not yet tested on Oracle as I don't have an Oracle Install to test against.
Create a copy of the .db file before running to ensure that you have a backup first.
Regards,
Steven