LMS 3.2 Backup Failed

[alkabeer80]

Hi, i try to backup lms but it always give me errors,i did it 2 times one with GUI from common services and the other one using command, the output is

2 errors reported
[Sun May  8 18:20:36 2011] Validation D:/LMS-BackUp/May-2011/0\0\campus\database\ani.db failed.
[Sun May  8 18:20:36 2011] Validation D:/LMS-BackUp/May-2011/0\0\campus\database\ani.db failed.
[Sun May  8 18:20:36 2011]  ERROR(1403): Database aniDb backup failed and . Check the log file for information.
[Sun May  8 18:20:36 2011]  Backup failed: 2011/05/08 18:20:46
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Primary key for "EmbuUserTracking" has missing index entriesSQL error (-300) -- Run time SQL error -- Validation of table "EmbuUserTracking" has failed
VALIDATE TABLE "cwsiSA"."HistoryHostTracking"
Index "historyupdate" has invalid or duplicate index entries
Index "historyupdate" has missing index entries
SQL error (-300) -- Run time SQL error -- Validation of table "HistoryHostTracking" has failed
VALIDATE TABLE "cwsiSA"."HistoryUserTracking"

2 errors reported
[Sun May  8 18:19:20 2011] Validation D:/LMS-BackUp/May-2011/0\0\campus\database\ani.db failed.
SQL Anywhere Command File Hiding Utility Version 10.0.1.3830
SQL Anywhere Backup Utility Version 10.0.1.3830
(41672 of 41670 pages, 100% complete)
Database backup completed
SQL Anywhere Command File Hiding Utility Version 10.0.1.3830
SQL Anywhere Validation Utility Version 10.0.1.3830

2 errors reported

SQL error (-300) -- Run time SQL error -- Validation of table "EmbuUserTracking" has failed

SQL error (-300) -- Run time SQL error -- Validation of table "HistoryHostTracking" has failed

[Sun May 8 09:23:22 2011] Validation D:/LMS-BackUp/May-2011\0\campus\database\ani.db failed.

[Sun May 8 09:23:22 2011] Validation D:/LMS-BackUp/May-2011\0\campus\database\ani.db failed.

[Sun May 8 09:23:22 2011] ERROR(1403): Database aniDb backup failed and . Check the log file for information.

[Sun May 8 09:23:22 2011] Backup failed: 2011/05/08 09:23:32

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I have checked the directory and the size of data is aroung 15 GB is this correct backup

thanks for your help

[Joe Clarke]

Your ANI database is corrupt.  See this document for steps to reinitialize this database.

https://supportforums.cisco.com/docs/DOC-8796

[alkabeer80]

Hi Joseph,

I run the perl.exe from C:\Program Files\CSCOpx\bin and then i write the command

C:\Program Files\CSCOpx\objects\db\conf\configureDb.pl action=validate dsn=cmf

I got the below result, i am new perl script and i i dont know what i did wrong

Backslash found where operator expected at - line 1, near "CSCOpx\"
Backslash found where operator expected at - line 1, near "objects\"
Backslash found where operator expected at - line 1, near "db\"
Backslash found where operator expected at - line 1, near "conf\"

thanks for your help and support

[Joe Clarke]

First, you do not need to reinitialize the cmf database.  You only need to reinitialize ANI.  If you want to check the consistency of cmf just to be safe, you can run the command:

C:\PROGRA~1\CSCOpx\bin\perl.exe C:\PROGRA~1\CSCOpx\objects\db\conf\configureDb.pl action=validate dsn=cmf

[alkabeer80]

hi, i have run the command and the result is "NO errors reported"

now how to reinitialize ANI ?

thanks

[Joe Clarke · Accepted solution]

As is stated in the document:

C:\PROGRA~1\CSCOpx\bin\perl.exe C:\PROGRA~1\CSCOpx\bin\dbRestoreOrig.pl dsn=ani dmprefix=ANI

[alkabeer80]

Hi Joseph,

I tried it yesterday it is working fine

thankssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss