IBM Support

Receive "PK_FIXLETRESULTS is not a Constraint" SQL Error

Technote (FAQ)


Question

Why do I get the error "PK_FIXLETRESULTS' is not a constraint." ?

Answer

To resolve this issue, execute the following commands within SQL Query Analyzer after logging into the bfenterprise database as the sa user:

alter table FIXLETRESULTS add constraint PK_FIXLETRESULTS PRIMARY KEY NONCLUSTERED( ComputerID, SiteID, ID )

Note: These symptoms may also occur with the PK_QUESTIONRESULTS table, in which case you can execute the following SQL command:

alter table QUESTIONRESULTS add constraint PK_QUESTIONRESULTS PRIMARY KEY NONCLUSTERED( ComputerID, SiteID, ID )

Historical Number

304

Document information

More support for: IBM BigFix family

Software version: Version Independent

Operating system(s): Platform Independent

Reference #: 1505883

Modified date: 22 January 2014


Translate this page: