S!MPLE DEFINITIONS

Port Security Overview
DHCP snooping
*************

DHCP snooping allows the switch to monitor and control DHCP messages received from

Untrusted devices connected to the switch. When DHCP snooping is enabled, the system

Snoops the DHCP messages to view DHCP lease information and build and maintain a

Database of valid address to MAC address (IP-MAC) bindings called the DHCP snooping

Database. Only clients with valid bindings are allowed access to the network.

DHCP Snooping Process
The basic process of DHCP snooping entails the following steps:
1. Device sends DHCPDISCOVER to request IP address.
2. Switch forwards the packet to the DHCP server.
3. Server sends DHCPOFFER to offer an address. If the DHCPOFFER is from a trusted
interface, switch forwards the packet to the DHCP client.
4. Device sends DHCPREQUEST to accept the IP address. Switch snoops this packet
and adds IP-MAC placeholder binding to the database. The entry is considered a
placeholder until a DHCPACK is received from the server. Until then, the IP address
could still be assigned to some other host.
5. Server sends DHCPACK to assign the IP address or DHCPNAK to deny the address
request.
6. Switch updates the DHCP database in accordance with the type of packet received:
• Upon receipt of DHCPACK, switch updates lease information for the IP-MAC binding
in its database.
• Upon receipt of DHCPNACK, switch deletes the placeholder.

EX2200 -  © 2012, Juniper Networks,

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