Cannot view an Incident Report on the VPC Administration Site after doing a search. (NETIQKB51248)

Cannot view an Incident Report on the VPC Administration Site after I do a search.
Error: 'Error Encountered.'

Incident Report display fails.

To resolve the issue:

1. Open SQL Enterprise Manager.
2. Expand the server that contains your PentaSafeVPC or NetIQVPC database.
3. Expand the Databases folder.
4. Expand the PentaSafeVPC or NetIQVPC database.
5. Click Tables.
6. In the right pane, right-click AnonymousIncidentReporting> Design Table. 
7. In the column TypeOfIncident, ensure that the datatype is nvarchar and the length is 1024.
8. Save the changes.
9. In the right pane, right-click Incident> Design Table.
10. In the column IncidentType, ensure that the datatype is nvarchar and the length is 1024. 
11. Save the changes.
12. In the right pane, right-click IncidentAdmin> Design Table. 
13. In the column TypeOfIncident, ensure that the datatype is nvarchar and the length is 1024.
14. Save the changes.

 

note

The following table defines the table, column name, data type, and length required to avoid the issue: 

Table	Column Name	Data Type	Length
AnonymousIncidentReporting	TypeOfIncident	nvarchar	1024
Incident	IncidentType	nvarchar	1024
Incident Admin	TypeOfIncident	nvarchar	1024

 

NetIQ Technical Support has determined that this as a known issue when upgrading from NetIQ VigilEnt Policy Center from 4.0 or 4.1 to NetIQ VigilEnt Policy Center 4.2.

Formerly known as NETIQKB51248

The following table defines the table, column name, data type, and length required to avoid the issue: 

 

Table	Column Name	Data Type	Length
AnonymousIncidentReporting	TypeOfIncident	nvarchar	1024
Incident	IncidentType	nvarchar	1024
Incident Admin	TypeOfIncident	nvarchar	1024