×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

LMS 4.0.1 Backup Error Message

Unanswered Question
Jun 25th, 2012
User Badges:

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Vinod Arya Mon, 06/25/2012 - 05:49
User Badges:
  • Cisco Employee,

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

petros.drogaris Tue, 06/26/2012 - 02:09
User Badges:

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

Vinod Arya Tue, 06/26/2012 - 02:11
User Badges:
  • Cisco Employee,

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


-Thanks

Vinod    

petros.drogaris Tue, 06/26/2012 - 02:17
User Badges:

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

Vinod Arya Tue, 06/26/2012 - 02:37
User Badges:
  • Cisco Employee,

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

Vinod Arya Tue, 06/26/2012 - 02:58
User Badges:
  • Cisco Employee,

Thanks Petros,


The screenshot and services look good.


-Thanks

Vinod

petros.drogaris Tue, 06/26/2012 - 05:59
User Badges:

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

Vinod Arya Wed, 07/04/2012 - 22:23
User Badges:
  • Cisco Employee,

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

Actions

This Discussion