Database purge fails

  • 3276790
  • 23-Aug-2006
  • 27-Apr-2012

Environment

Novell ZENworks Asset Management 7 - ZAM7

Situation

Message seen within the Database Persistor log file when persistor logging is set for the Task server doing the task purge:

Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at
1/27/2006 7:39:03 AM
Database Error
[2.5.3] Error: '[5] [SERVERERROR] DELETE statement conflicted with COLUMN
REFERENCE constraint 'FK_Comp_ProductOID'. The conflict occurred in database
'TS_Census', table 'NC_Component', column 'ProductOID'.
[SERVERMESSAGE] The statement has been terminated.'

Resolution


Fixed in ZAM 7 SP1 Interim Release 7 or later.

Status

Reported to Engineering

Additional Information

The fix is to be sure that the Persistor layer doesn't "remove" (change the IsDeleted date) for any
component if it's already been set. This prevents old "deleted" components from being brought up-do-date if their associated workstation is subsequently "deleted".