Content fails to download on Linux managed device

ZCM agent runs on Linux device

Content fails to download to Linux managed device
System update fails to install

Error message in zmd-messages.log:
"...
[Debug] [10/08/2012 12:16:54.107] [] [26694] [ZenworksAgent] [716] [ZenCache] [Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL121002155456522' defined on 'FILESOURCES'.] [] []
[Debug] [10/08/2012 12:16:54.107] [] [26694] [ZenworksAgent] [716] [ZenCache] [Exception Type: class java.sql.SQLIntegrityConstraintViolationException] [] []
[Debug] [10/08/2012 12:16:54.111] [] [26694] [ZenworksAgent] [716] [ZenCache] [Stack: org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)] [] []
[Debug] [10/08/2012 12:16:54.139] [] [26694] [ZenworksAgent] [716] [ZenCache] [SQL Exception putting file record, errorcode: 20000] [] []
..."

This is fixed in version 11.2.3a - see KB 7011295 "ZENworks Configuration Management 11.2.3a - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7011295

Workaround:
Correct device DNS/hosts file configuration so that other devices do not register with same DNS name as the affected content server.

The URL for a content server is listed twice for a content object since a different device registers with same DNS name e.g., because of wrong hosts file configuration.

The fix is that the ZCM agent can now filter duplicate URL entries before saving them to the local agent cache avoiding this "...SQL Exception putting file record, errorcode: 20000..." error.