SMT reports duplicate registration database entries

  • 7011387
  • 16-Nov-2012
  • 23-Dec-2012

Environment

Subscription Management Tool 10
Subscription Management Tool 11
SUSE Linux Enterprise Server 11
SUSE Linux Enterprise Server 10
Novell Open Enterprise Server 11 (OES 11) Linux
Novell Open Enterprise Server 2 (OES 2) Linux

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