Wednesday, July 16, 2014

Access Violation in Primavera P6.(SQL Database )




Primavera 'not responding ' Error 

Exception EAccess Violation in module PM.exe at 0043BFBF. Access Violation SQL DB


Access Violation in Primavera P6.(SQL Database ) 

Crashing Primavera Application after Login



Problem Event Name:     APPCRASH
Application Name:     PM.exe
Application Version:     8.2.0.1926
Application Timestamp:     4ee27395
Fault Module Name:     PM.exe
Fault Module Version:     8.2.0.1926
Fault Module Timestamp:     4ee27395
Exception Code:     c0000005
Exception Offset:     0043bfbf
OS Version:     6.1.7601.2.1.0.256.1
Locale ID:     2057
Additional Information 1:     1916
Additional Information 2:     191667bbc08faf1653550925626544ea
Additional Information 3:     c25e
Additional Information 4:     c25e5f798c98459e39a3c269a71bb5fd


Solution:

Login SQL Management Studio

select the Database 

Run the following Query .

disable trigger TR_PROJWBS_OBSPROJ on PROJWBS; 


User session remains active in MS SQL server

 •Launch SQL Server Management Studio and login with SQL Authentication as PRIVUSER


1. start all programs
2. Microsoft SQL server 
3. SQL Server Management Studio Express 

4. login name is sa                                                ------default
5. password should be Prima123Vera                  ------default
6. click on databases
7. click on pmdb$primavera                                   ----Make sure your database name--- 
8. right click new query 
9. copy and paste below query and run ( in the fields put your session id ,user name )
select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = ‘’);
Delete from UPKLIST where session_id = ;
Delete from PROJSHAR where session_id = ;
Delete from USESSION where session_id = ;
13. exit out of sql

2 comments:

Burak BAS said...

thank you so much it worked!

Sabrin said...

@Burak what is session id & user name