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:
  1. The first part of 'a2d6e5f5943b4f2eb6b02fd2fd0498b9-3534e7633fe310e491049d1c3f5607b' identifies the client by its assigned GUID. To identify the server, please run:

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

    smt-delete-registration -g a2d6e5f5943b4f2eb6b02fd2fd0498b9
     
  3. Connect to the client via SSH
     
  4. 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/*
       
  5. On the client run suse_register to re-register the client
  6. Use smt-list-registration on the server to check the registration status of the client
  7. 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.

  • Document ID:7011387
  • Creation Date: 16-Nov-2012
  • Modified Date:28-Sep-2022
    • Subscription Management Tool
    • SUSE Linux Enterprise Server

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center