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
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
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
06-26-2012 02:11 AM
Can you please share the complete output for the re-initialize process you did.
-Thanks
Vinod
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
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
06-26-2012 02:56 AM
Here is the screenshot for services
06-26-2012 02:58 AM
Thanks Petros,
The screenshot and services look good.
-Thanks
Vinod
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
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide