SMT reports duplicate registration database entries

This document (7011387) is provided subject to the disclaimer at the end of this document.

Environment

Subscription Management Tool 11
Subscription Management Tool 10
SUSE Linux Enterprise Server 11
SUSE Linux Enterprise Server 10

Situation

During smt-ncc-sync or in the /var/log/smt/smt-report.log the following error is noted:

2012-11-12 05:14:07 SMT::NCCRegTools - [error] DBD::mysql::db do failed: Duplicate entry 'a2d6e5f5943b4f2eb6b02fd2fd0498b9-3534e7633fe310e491049d1c3f5607b' for key 1 at /usr/lib/perl5/vendor_perl/5.10.0/SMT/NCCRegTools.pm line 699.

Resolution

In order to resolve this issue please follow these steps:

The first part of 'a2d6e5f5943b4f2eb6b02fd2fd0498b9-3534e7633fe310e491049d1c3f5607b' identifies the client by its assigned GUID. To identify the server, please run:

smt-list-registrations | grep a2d6e5f5943b4f2eb6b02fd2fd0498b9
Delete the client from the SMT database:

smt-delete-registration -g a2d6e5f5943b4f2eb6b02fd2fd0498b9
Connect to the client via SSH
Delete the following files:

SLE10 based products:
- /etc/zmd/deviceid
- /etc/zmd/secret
- /var/cache/SuseRegister/*
- Restart the zmd service to recreate the deleted files in /etc/zmd: rczmd restart
SLE11 based products:
- /etc/zypp/credentials.d/NCCcredentials
- /var/cache/SuseRegister/*
On the client run suse_register to re-register the client
Use smt-list-registration on the server to check the registration status of the client
Run smt-ncc-sync and check whether the data is submitted to the Novell Customer Center (*) account accordingly

(*) NOTE:
The Novell Customer Center (NCC) and nu.novell.com are not available anymore. SLE10 and SLE11 Systems still registered to the Novell Customer Center (NCC) can be migrated to the SUSE Customer Center (SCC) as outlined at: https://www.suse.com/support/kb/doc/?id=000019508

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.