Database purge fails

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


Novell ZENworks Asset Management 7 - ZAM7


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.'


Fixed in ZAM 7 SP1 Interim Release 7 or later.


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".