LMS 4.0.1, backup failed.

[andrea.meconi]

Hello at all.

We are using CiscoWorks LMS 4.0.1.

Backup fails with this log entries:

mkdir D:/Backup\7\upm\database\

[Wed Aug 10 01:11:02 2011] Backing up database upm:SQL Anywhere Command File Hiding Utility Version 10.0.1.4051

The system cannot find the path specified.

[Wed Aug 10 01:11:04 2011] Backup upm to D:/Backup\7\upm\database\upm.db failed. Retry backup database upm

SQL Anywhere Command File Hiding Utility Version 10.0.1.4051

The system cannot find the path specified.

[Wed Aug 10 01:12:05 2011] Backup upm to D:/Backup\7\upm\database\upm.db failed second time.

[Wed Aug 10 01:12:05 2011]  ERROR(1439): Database upm backup failed and . Check the log file for information.

[Wed Aug 10 01:12:05 2011]  Backup failed: 2011/08/10 01:12:15

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Wed Aug 10 01:12:16 2011] Removing directory D:\Backup\7

[Wed Aug 10 01:12:22 2011] INFO: Notifying BackupFailureEvent.

How can I fix this error?

Thanks.

Regards.

Andrea

[AFROJ AHMAD]

Hi Andrea,

Try the below steps :

1.stop the daemon Manager

2. go to NMSROOT\databases\UPM  >> look for upm.log ,if Exist  delete the log file or you can backup it somewhere else..

3.on the command prompt:

NMSROOT\databases\upm>dbsrv10.exe -f upm.db

--Then start the daemon Manager

--wait for 15 min and then try to take the backup again..

--if it fails again ,send me the dbbackup.log

Thanks

Afroj

[andrea.meconi]

Hello Afroj and many thanks for your help.

Backup fails with the same error.

mkdir D:/Backup\0\upm\database\

[Thu Aug 11 12:39:34 2011] Backing up database upm:SQL Anywhere Command File Hiding Utility Version 10.0.1.4051

The system cannot find the path specified.

[Thu Aug 11 12:39:37 2011] Backup upm to D:/Backup\0\upm\database\upm.db failed. Retry backup database upm

SQL Anywhere Command File Hiding Utility Version 10.0.1.4051

The system cannot find the path specified.

[Thu Aug 11 12:40:37 2011] Backup upm to D:/Backup\0\upm\database\upm.db failed second time.

[Thu Aug 11 12:40:37 2011]  ERROR(1439): Database upm backup failed and . Check the log file for information.

[Thu Aug 11 12:40:37 2011]  Backup failed: 2011/08/11 12:40:47

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Thu Aug 11 12:40:53 2011] INFO: Notifying BackupFailureEvent.

Regards.

Andrea

[AFROJ AHMAD]

Hi ,

Please check if the UPM database is valid :

NMSRROT\bin>perl configureDb.pl action=validate dsn=upm

please attach the dbbackup.log

Thanks-

Afroj

[andrea.meconi]

Hi Afroj.

Check fails with these messages:

C:\Program Files\CSCOpx\objects\db\conf>perl configureDb.pl action=validate dsn=upm

INFO: C:\PROGRA~1\CSCOpx/objects/db/conf/ConfigureDB.LOCK locked for the operation...

INFO: File exists.SQL Anywhere Command File Hiding Utility Version 10.0.1.4051

The system cannot find the path specified.

ERROR: [StandardDbUpgrade] Validation of upm database failed

INFO: C:\PROGRA~1\CSCOpx/objects/db/conf/ConfigureDB.LOCK released for the future operations...

C:\Program Files\CSCOpx\objects\db\conf>

Because this command reports an error, we may try with restoring from a previous good backup or reinitializing the database with

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

Thanks.

Andrea

[AFROJ AHMAD]

Hi ,

It looks like the UPM database is corrupted ,if possible  reintilze the Database of UPM ..

you can use the below link for Database ReInit given by Joseph Clarke:

https://supportforums.cisco.com/docs/DOC-8796

Thanks

Afroj

[andrea.meconi]

Sorry Afroj but I'm not able to reinit the UPM database: dbsrv10 missing.

We are using Windows 2003, 32 bit: we can find dbsrv10 into win32 folder.

C:\Program Files\CSCOpx\bin>perl dbRestoreOrig.pl dsn=upm dmprefix=UPM

WARNING: Existing contents of upm database will be lost.

Do you want to continue [y/n]?y

upm Unregistration failed

ERROR: [RegisterWithDM] UPMDbEngine: C:\PROGRA~1\CSCOpx\objects\db\x64\dbsrv10.exe missing or not executable

upm registration failed

INFO: Starting the DataBase

    Starting database engine UPMDbEngine

ERROR: Failed to authenticate [upm] database.

The system cannot find the path specified.

Opening C:\PROGRA~1\CSCOpx/dbupdate/CSCOdbupdate.log for logging

    Starting database engine cmfEng

Failed to delete the HUM jobs

Opening C:\PROGRA~1\CSCOpx/dbupdate/CSCOdbupdate.log for logging

    Starting database engine cmfEng

Failed to delete Pidm entries

Data cleanup for upm completed

upm database initialization failed.

C:\Program Files\CSCOpx\bin>

Regards.

Andrea

[andrea.meconi]

Hi Afroj.

My customer has two main issues with LMS 4.0.1.

First, backup fails because UPM database is corrupted.

Second, not able to generate UT custom report, it fails with a system message "path not found": you can find more info about on discussion

https://supportforums.cisco.com/message/3417865.

When I try to reinitialize UPM db, or restore entire solution, restore fails with this message

ERROR: [RegisterWithDM] CmfDbEngine: C:\PROGRA~1\CSCOpx\objects\db\x64\dbsrv10.exe missing or not executable

I can find dbsrv10.exe on a win32 folder.

CiscoWorks LMS 4.0.1 is running on Windows 2003 EE SP2.

Many thanks for your help.

Regards.

Andrea

[andrea.meconi]

Any ideas?

Thanks.

Andrea