LMS3.0.1/HUM backup failed

Unanswered Question
Sep 2nd, 2009
User Badges:

Hi,


Customer has an error message when he makes a LMS backup:

extract from dbbackup.log :

1 error reported

Run time SQL error -- Index "Template18_5mins_TSINDEX" has invalid or duplicate index entries

Validation C:/Backup_LMS\436\upm\database\upm.db failed.

Validation C:/Backup_LMS\436\upm\database\upm.db failed.

ERROR(1083): Database upm backup failed and . Check the log file for information.

Backup failed: 2009/09/02 03:50:11


Thanks for help ?


Elisabeth

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Loading.
Joe Clarke Thu, 09/03/2009 - 09:26
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

The UPM database is corrupt. You will need to restore it from a known good backup, or reinitialize it with the command:


NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=upm dmprefix=UPM

ebezombes Thu, 09/03/2009 - 22:55
User Badges:

Is it possible to restore only upm database without restoring other database like rme, campus, ut, ... ?

Joe Clarke Thu, 09/03/2009 - 22:57
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

No. The LMS backup/restore is all or nothing.

ebezombes Thu, 09/03/2009 - 23:09
User Badges:

When we reinit upm.db, do we lost configuration as poller, templates and reports ? Or only data ?

Joe Clarke Fri, 09/04/2009 - 07:59
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

You lose everything in HUM. This includes pollers, custom templates, polled data, thresholds, etc.

ebezombes Sun, 09/06/2009 - 22:51
User Badges:

If we open a tac case, do you think they will be able to correct this corruption database ?

Joe Clarke Mon, 09/07/2009 - 03:54
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

No. Database corruption caanot be corrected. You can only restore from backup, or reinitialize.

paul.parquet Mon, 10/05/2009 - 07:47
User Badges:

Thanks, a lot. I reinitialize the database with the command NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=upm dmprefix=UPM and recreate my poller and report, and launch a backup.

All is right now.


Paul Parquet

Actions

This Discussion