Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1430
Views
0
Helpful
9
Replies

LMS 4.0.1 Backup Error Message

petros.drogaris
Level 1
Level 1

‎06-25-2012 01:50 AM

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

Labels:
130351-dbbackup.log.zip
0 Helpful
9 Replies 9

Vinod Arya
Cisco Employee
Cisco Employee

‎06-25-2012 05:49 AM

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. **
0 Helpful

petros.drogaris
Level 1
Level 1
In response to Vinod Arya

‎06-26-2012 02:09 AM

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

0 Helpful

Vinod Arya
Cisco Employee
Cisco Employee
In response to petros.drogaris

‎06-26-2012 02:11 AM

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. **
0 Helpful

petros.drogaris
Level 1
Level 1
In response to Vinod Arya

‎06-26-2012 02:17 AM

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

0 Helpful

Vinod Arya
Cisco Employee
Cisco Employee
In response to petros.drogaris

‎06-26-2012 02:37 AM

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. **
0 Helpful

petros.drogaris
Level 1
Level 1
In response to Vinod Arya

‎06-26-2012 02:56 AM

       Here is the screenshot for services

0 Helpful

Vinod Arya
Cisco Employee
Cisco Employee
In response to petros.drogaris

‎06-26-2012 02:58 AM

Thanks Petros,

The screenshot and services look good.

-Thanks

Vinod

-Thanks Vinod **Rating Encourages contributors, and its really free. **
0 Helpful

petros.drogaris
Level 1
Level 1
In response to Vinod Arya

‎06-26-2012 05:59 AM

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

0 Helpful

Vinod Arya
Cisco Employee
Cisco Employee
In response to petros.drogaris

‎07-04-2012 10:23 PM

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. **
0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents