Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

LMS 4.0.1 Backup Error Message

LMS installed on Windows 2003.

Backup fais with message "Backup failed.ERROR(1297): Fatal error: Database engine 'UPMDbEngine' could not be started on database 'upm' in Bulk mode.."

dbbackup.log attached.

Any help or explanation is greatly appreciated

9 REPLIES
Cisco Employee

LMS 4.0.1 Backup Error Message

This is either a corrupt transaction log, a corrupt database, or a problem with service startup parameters.

Verify that the service startup parameters are what they should be (in services.msc, except Daemon manager all other services should be manual).

If they are, try a transaction log recovery with the following procedure :

To o a trasaction log recovery for all Db's :

     * Goto NMSROOT/databases/* and remove *.log file. (* is teh db name for all different DB flders there)

     * on command prompt run following command :

dbsrv10 -f  *.db

Example:

C:\Program Files (x86)\CSCOpx\databases\upm>dir *.log

Volume in drive C has no label.

Volume Serial Number is E492-A3AB

  Directory of C:\Program Files (x86)\CSCOpx\databases\upm

03/27/2012  07:01 AM           196,608 upm.log

               1 File(s)        196,608 bytes

               0 Dir(s)  27,119,108,096 bytes free


C:\Program Files (x86)\CSCOpx\databases\upm>del upm.log (you have to delete if from GUI, cli mostly doesnt work)

C:\Program Files (x86)\CSCOpx\databases\upm>dbsrv10 -f upm.db

If that doesn't work, then restore from a known good backup, or reinitialize the UPM database. It will wipe out all the information from HUM. See the Db reinintialize procedure for mroe details.

-Thanks

Vinod

-Thanks Vinod **Rating Encourages contributors, and its really free. **
Community Member

Re: LMS 4.0.1 Backup Error Message

Hi Vinod

I tried to reinitialize the UPM database as described but operation failed.

INFO: Connect the database dsn=upm

ERROR: Failed to authenticate [upm] database.

Database engine 'UPMDbEngine' could not be started on database 'upm' in Bulk mode.

Complete log files attached.

Regards

Petros

Cisco Employee

Re: LMS 4.0.1 Backup Error Message

Can you please share the complete output for the re-initialize process you did.

-Thanks

Vinod    

-Thanks Vinod **Rating Encourages contributors, and its really free. **
Community Member

Re: LMS 4.0.1 Backup Error Message

Sorry , but for some reason i cannot upload any files ,

This is the process for database reinit

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

WARNING: Existing contents of upm database will be lost.
Do you want to continue [y/n]?y
INFO: Starting the DataBase
    Starting database engine UPMDbEngine
INFO: Process created
INFO: Started the Database engine : UPMDbEngine Retry 0
INFO: Started the Database engine : UPMDbEngine Retry 1
INFO: Started the Database engine : UPMDbEngine Retry 2
INFO: Started the Database engine : UPMDbEngine Retry 3
INFO: Started the Database engine : UPMDbEngine Retry 4
INFO: Started the Database engine : UPMDbEngine Retry 5
INFO: Started the Database engine : UPMDbEngine Retry 6
INFO: Started the Database engine : UPMDbEngine Retry 7
INFO: Started the Database engine : UPMDbEngine Retry 8
INFO: Started the Database engine : UPMDbEngine Retry 9
INFO: Getting message

INFO: Connect the database dsn=upm
ERROR: Failed to authenticate [upm] database.
Database engine 'UPMDbEngine' could not be started on database 'upm' in Bulk mod
e.Opening C:\PROGRA~1\CSCOpx/dbupdate/CSCOdbupdate.log for logging
    Starting database engine cmfEng
INFO: Process created
INFO: Started the Database engine : cmfEng Retry 0
INFO: Started the Database engine : cmfEng Retry 1
INFO: Started the Database engine : cmfEng Retry 2
INFO: Started the Database engine : cmfEng Retry 3
INFO: Started the Database engine : cmfEng Retry 4
INFO: Started the Database engine : cmfEng Retry 5
INFO: Started the Database engine : cmfEng Retry 6
INFO: Started the Database engine : cmfEng Retry 7
INFO: Started the Database engine : cmfEng Retry 8
INFO: Started the Database engine : cmfEng Retry 9
INFO: Getting message

INFO: Connect the database DSN=cmf
Failed to delete the HUM jobs
Opening C:\PROGRA~1\CSCOpx/dbupdate/CSCOdbupdate.log for logging
    Starting database engine cmfEng
INFO: Process created
INFO: Started the Database engine : cmfEng Retry 0
INFO: Started the Database engine : cmfEng Retry 1
INFO: Started the Database engine : cmfEng Retry 2
INFO: Started the Database engine : cmfEng Retry 3
INFO: Started the Database engine : cmfEng Retry 4
INFO: Started the Database engine : cmfEng Retry 5
INFO: Started the Database engine : cmfEng Retry 6
INFO: Started the Database engine : cmfEng Retry 7
INFO: Started the Database engine : cmfEng Retry 8
INFO: Started the Database engine : cmfEng Retry 9
INFO: Getting message

INFO: Connect the database DSN=cmf
Failed to delete Pidm entries
Data cleanup for upm completed
upm database initialization failed.

C:\Program Files\CSCOpx\bin>

and this is the CSCOdbupdate.log

Beginning DB Update

Start C:\PROGRA~1\CSCOpx\dbupdate\dbupdate.pl : At C:\PROGRA~1\CSCOpx\dbupdate\dbupdate.pl, #48: Time - 2012/06/26 10:59:13

Starting DB ...: Time - 2012/06/26 10:59:13

DSN PRoperties: cmfEng: At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #119: Time - 2012/06/26 10:59:13

Executing - StartDb(DSN=cmf): At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #132: Time - 2012/06/26 10:59:13

ERROR: Unable to start DB for dsn=cmf - Database engine 'cmfEng' could not be started on database 'cmfDb' in Bulk mode.: At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #135: Time - 2012/06/26 11:00:08

Beginning DB Update

Start C:\PROGRA~1\CSCOpx\dbupdate\dbupdate.pl : At C:\PROGRA~1\CSCOpx\dbupdate\dbupdate.pl, #48: Time - 2012/06/26 11:00:09

Starting DB ...: Time - 2012/06/26 11:00:09

DSN PRoperties: cmfEng: At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #119: Time - 2012/06/26 11:00:09

Executing - StartDb(DSN=cmf): At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #132: Time - 2012/06/26 11:00:09

ERROR: Unable to start DB for dsn=cmf - Database engine 'cmfEng' could not be started on database 'cmfDb' in Bulk mode.: At C:/PROGRA~1/CSCOpx/dbupdate/dbupdateutils.pl, #135: Time - 2012/06/26 11:01:04

Cisco Employee

Re: LMS 4.0.1 Backup Error Message

I would recommend to try a transaction log recovery for all the databases. It seems the same error is there for cmf as well.

could you also share the screenshot of services.msc page.

-Thanks

-Thanks Vinod **Rating Encourages contributors, and its really free. **
Community Member

Re: LMS 4.0.1 Backup Error Message

       Here is the screenshot for services

Cisco Employee

Re: LMS 4.0.1 Backup Error Message

Thanks Petros,

The screenshot and services look good.

-Thanks

Vinod

-Thanks Vinod **Rating Encourages contributors, and its really free. **
Community Member

Re: LMS 4.0.1 Backup Error Message

I did what you suggested,
Cleared transaction logs for all databases in NMSROOT\databases , run dbsrv10 -f for each of them , nothing changed.
Finally tried to reinitialize the database with no success, same error messages comes up, although
running "perl configureDb.pl action=validate dsn=upm"  shows no database error

Any other tip ??

Thanks
Petros

Cisco Employee

LMS 4.0.1 Backup Error Message

Seems some serious issues with LMS Db's. I would recommend to open a TAC case to have them further look into this.

-Thanks

Vinod

-Thanks Vinod **Rating Encourages contributors, and its really free. **
816
Views
0
Helpful
9
Replies
CreatePlease to create content