11-29-2011 03:00 AM
Hi
We have recently installed a new version of LMS 3.2, and everything is working fine.
but till now the backup process hasn't started correctly to a directory on our drive D, and once I start a backup process, I recieved the following error
ERROR (1261): FATAL error: Database engine 'opsxmleng' could not be started on database 'opsxml' in Bulk mode.. Backup failed.
Has anyone seen this issue before ?
appreciate your advice.
11-29-2011 05:46 AM
Best do a dbRestoreOrig.pl for that database. Find the script in CSCOpx\bin.
Cheers,
Michel
11-29-2011 06:14 AM
thanks for your reply,
firstly I write the command "net stop crmdmgtd" and then I found the dbRestoreOrig.pl, but the question here is ,
what do I have to write inside the command prompt once I click on the dbRestoreOrig.pl
plz advice
11-29-2011 10:38 AM
Check out this document Hussein. It explains the use better then I can.
https://supportforums.cisco.com/docs/DOC-8796
Cheers,
Michel
11-30-2011 06:36 AM
hi michel,
thanks for document, I used the following command to initialize the database :
C:\Program Files (x86)\CSCOpx\bin>perl dbRestoreOrig.pl dsn=opsxml dmprefix=Opsxml
and I got the following result, there is an Error
WARNING: Existing contents of opsxml database will be lost.
Do you want to continue [y/n]?y
INFO: Starting the DataBase
Starting database engine opsxmlEng
INFO: Process created
INFO: Started the Database engine : opsxmlEng Retry 0
INFO: Started the Database engine : opsxmlEng Retry 1
INFO: Started the Database engine : opsxmlEng Retry 2
INFO: Started the Database engine : opsxmlEng Retry 3
INFO: Started the Database engine : opsxmlEng Retry 4
INFO: Started the Database engine : opsxmlEng Retry 5
INFO: Started the Database engine : opsxmlEng Retry 6
INFO: Started the Database engine : opsxmlEng Retry 7
INFO: Started the Database engine : opsxmlEng Retry 8
INFO: Started the Database engine : opsxmlEng Retry 9
INFO: Getting message
INFO: Connect the database dsn=opsxml
ERROR: Failed to authenticate [opsxml] database.
Database engine 'opsxmlEng' could not be started on database 'opsxml' in Bulk mo
de.INFO: Calling OpsConfUpdate executable for changing cwa password.
Successfully updated the CWA Engine Configuration file.
Starting database engine opsxmlEng
INFO: Process created
INFO: Started the Database engine : opsxmlEng Retry 0
INFO: Started the Database engine : opsxmlEng Retry 1
INFO: Started the Database engine : opsxmlEng Retry 2
INFO: Started the Database engine : opsxmlEng Retry 3
INFO: Started the Database engine : opsxmlEng Retry 4
INFO: Getting message
INFO: Connect the database DSN=opsxml
ERROR: Cannot connect to the Opsxml database.Can't call method "disconnect" on a
n undefined value at dbRestoreOrig.pl line 334,
C:\Program Files (x86)\CSCOpx\bin>
so what can I do at this moment ?
plz advice,
11-30-2011 10:05 AM
Best put the daemon manager service to manual and then reboot the server.
That we you are sure no other process can still lock the database. I guess that is what is happening.
Then repeat the procedure you did above.
All this is best doen as the servers local administrator.
Cheers,
Michel
12-01-2011 02:40 AM
ok,
I set the daemon manager service to manual and performed a restart to the server.
and then I noticed that all cisco works services in a manual status and all of them are not started.
So I repeated our procedure that are mentioned above and still I have received the same error.....
do I have to reinstall the LMS ???
regards.
12-01-2011 12:49 PM
That is probably the fastest way. Since you can restore a "good" backup not more more work needs to be done.
Alternatively you may want to try to see if the TAC can do something.
Cheers,
Michel
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