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