Collection server failing to load in .wif components

  • 3529374
  • 18-Feb-2008
  • 27-Apr-2012

Environment

Novell ZENworks 7 Asset Management - ZAM7

Situation

Collection server failing to load in scanned components.
Collection server core log presented many database persistor errors displaying the failed to load components.

Resolution

NOTE: This is a very specific case, and if the errors shown in the log are not matching the errors listed below, it may be necessary to contact Novell ZENworks Support to troubleshoot further.

Fixed in ZENworks Asset Management 7 Interim Release 15 or newer

Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com. The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 15 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.

Additional Information

Exampleof a usage component failing to load with error in ColsvrCoreEvent.log (product name examples would change with a different usage component):

Application Object Error at 11/21/2007 6:18:35 AM on EG-ZENWRKS-B01 by svcnetcensus
Object Store Error
[2.4.104] An error occurred while storing the object.
Class:"Network Software Usage History"
Name:"{29AB772F-B36F-4710-8BF4-ACE598024687}"
Application Object Error at 11/21/2007 6:18:35 AM on EG-ZENWRKS-B01 by svcnetcensus
Unexpected Exception
[2.4.3] Unexpected exception [2.5.12]... operation failed.
Database Persistence Layer Info in CDBPersister::InsertObjectIntoDatabase at 11/21/2007 6:18:35 AM
Invalid Proxy
[2.5.605] Network Software Usage History:VRB Software is not a valid Microsoft Systems Management Server 2.50 in the database.
Database Persistence Layer Error in DBPException::DBPException at 11/21/2007 6:18:35 AM
Query Error
[2.5.12] General error occurred while performing the query.
Database Persistence Layer Info in DBSQLServerErrorHandler::serverError at 11/21/2007 6:18:35 AM
Referential Integrity Error
[2.5.604] Object could not be removed.
Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at 11/21/2007 6:18:35 AM
Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at 11/21/2007 6:18:35 AM
Database Error
[2.5.3] Error: '[5] [SERVERERROR] INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_NetSWUH_VRBSWOID'. The conflict occurred in database 'TS_Census', table 'NC_VRBSoftware', column'VRBSoftwareOID'.