Re: Problem with beckup LMS 3.1

spocnocacea · ‎01-22-2010

hello, somebody can tell me why I did not make cisco works plus beckup?
Folder of beckup I always find a file called beckup.lock
If the gate when I make my next beckup regenerates the same file beckup.lock and I can not do beckup.
in the error log it says this:

[Wed Nov 25 21:44:31 2009] Validation C: / TESTBA ~ 1/AUTOMA ~ 1/CMFBAC ~ 1 \ 0 \ dfm \ database \ dfmInv.db failed.
SQL Anywhere Command File Hiding Utility Version 10.0.1.3694
SQL Anywhere Backup Utility Version 10.0.1.3694
(686 of 684 pages, 100% complete)
Database backup completed
SQL Anywhere Command File Hiding Utility Version 10.0.1.3694
SQL Anywhere Validation Utility Version 10.0.1.3694
VALIDATE TABLE "dbo". "EXCLUDEOBJECT"
VALIDATE TABLE "dbo". "Ix_consultant_affected_columns"
VALIDATE TABLE "dbo". "Ix_consultant_index"
VALIDATE TABLE "dbo". "Ix_consultant_ixcol"
VALIDATE TABLE "dbo". "Ix_consultant_log"
VALIDATE TABLE "dbo". "Ix_consultant_master"
VALIDATE TABLE "dbo". "Ix_consultant_query_index"
VALIDATE TABLE "dbo". "Ix_consultant_query_phase"
VALIDATE TABLE "dbo". "Ix_consultant_query_text"
VALIDATE TABLE "dbo". "Jdbc_function_escapes"
VALIDATE TABLE "dbo". "Migrate_remote_fks_list"
VALIDATE TABLE "dbo". "Migrate_remote_table_list"
VALIDATE TABLE "dbo". "Migrate_sql_defn"
VALIDATE TABLE "dbo". "RowGenerator"
VALIDATE TABLE "dbo". "Sa_diagnostic_auxiliary_catalog"
VALIDATE TABLE "dbo". "Sa_diagnostic_blocking"
VALIDATE TABLE "dbo". "Sa_diagnostic_cachecontents"
VALIDATE TABLE "dbo". "Sa_diagnostic_connection"
VALIDATE TABLE "dbo". "Sa_diagnostic_cursor"
VALIDATE TABLE "dbo". "Sa_diagnostic_deadlock"
VALIDATE TABLE "dbo". "Sa_diagnostic_hostvariable"
VALIDATE TABLE "dbo". "Sa_diagnostic_internalvariable"
VALIDATE TABLE "dbo". "Sa_diagnostic_optblock"
VALIDATE TABLE "dbo". "Sa_diagnostic_optjoinstrategy"
VALIDATE TABLE "dbo". "Sa_diagnostic_optorder"
VALIDATE TABLE "dbo". "Sa_diagnostic_optquantifier"
VALIDATE TABLE "dbo". "Sa_diagnostic_optrewrite"
VALIDATE TABLE "dbo". "Sa_diagnostic_query"
VALIDATE TABLE "dbo". "Sa_diagnostic_request"
VALIDATE TABLE "dbo". "Sa_diagnostic_statement"
VALIDATE TABLE "dbo". "Sa_diagnostic_statistics"
VALIDATE TABLE "dbo". "Sa_diagnostic_tracing_level"
VALIDATE TABLE "dbo". "Spt_collation_map"
VALIDATE TABLE "dbo". "Spt_jdatatype_info"
VALIDATE TABLE "dbo". "Spt_jdbc_conversion"
VALIDATE TABLE "dbo". "Spt_jtext"
VALIDATE TABLE "dbo". "Spt_mda"
VALIDATE TABLE "itemInvUser". "DbVersion"
VALIDATE TABLE "itemInvUser". "DbVersionHistory"
VALIDATE TABLE "itemInvUser". "DCRDeviceFilter"
VALIDATE TABLE "itemInvUser". "DeviceTable"
VALIDATE TABLE "itemInvUser". "Event_set_table"
VALIDATE TABLE "itemInvUser". "NOS_DbVersion"
VALIDATE TABLE "itemInvUser". "NOS_NEW_DeviceDetailTable"
4 errors reported
SQL error (-85) - Communication error
SQL error (-101) - Not connected to a database
SQL error (-101) - Not connected to a database
SQL error (-101) - Not connected to a database
[Wed Nov 25 21:46:06 2009] Validation C: / TESTBA ~ 1/AUTOMA ~ 1/CMFBAC ~ 1 \ 0 \ dfm \ database \ dfmInv.db failed.
[Wed Nov 25 21:46:06 2009] Validation C: / TESTBA ~ 1/AUTOMA ~ 1/CMFBAC ~ 1 \ 0 \ dfm \ database \ dfmInv.db failed.
[Wed Nov 25 21:46:06 2009] ERROR (1101): Database backup failed dfmInvDb and. Check the log file for information.
[Wed Nov 25 21:46:06 2009] Backup failed: 2009/11/25 21:46:06
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!

How can I fix?
Thanks so much.

Sven Hruza · ‎01-22-2010

I think you have to check the file dbbackup.log under \CSCOpx\log\ for further details.

The file backup.lock will be created by the backup process to lock the DB for access.

No other backup will be done since you have deleted this backup.lock

I think you can delet this file if there is no backup process active.

spocnocacea · ‎01-22-2010

you specify the log tells me this error:

SQL Anywhere Command File Hiding Utility Version 10.0.1.3694
SQL Anywhere Validation Utility Version 10.0.1.3694
SQL error (-832) - Connection error: Found server but communication error occurred
SQL error (-832) - Connection error: Found server but communication error occurred
[Mon Jan 18 00:32:28 2010] Validation E: / \ 0 \ dfm \ database \ dfmInv.db failed.
[Mon Jan 18 00:32:28 2010] Validation E: / \ 0 \ dfm \ database \ dfmInv.db failed.
[Mon Jan 18 00:32:28 2010] ERROR (1101): Database backup failed dfmInvDb and. Check the log file for information.
[Mon Jan 18 00:32:28 2010] Backup failed: 2010/01/18 00:32:28
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!

Although the gate beckup.lock file when you restart the backup creates the file again backup.lock and I can not complete the backup.

The thing I do not understand the log that I've written on this item is: "SQL error (-832) - Connection error: Found server but communication error occurred"

What could stop the backup?

Thank you very much.

Sven Hruza · ‎01-22-2010

It is okay that backup creates a backup.lock. It is only for getting single access to the databases.

After backup finish successful it will be deleted automatically.

I think your problem could be that:

Validation E: / \ 0 \ dfm \ database \ dfmInv.db failed.

dfmInv.db should be the database of module "device fault manager", so please check which is the right path to the dfmInv.db

The path written in the logfile is not right I think.

spocnocacea · ‎01-22-2010

ok, thanks.
The path is definitely not right. Where can I change this parameter?
in Device Fault Manager has neither voice say from where the system has to read the DB.
How can I tell the system where the file should read dfmInv.db?

The strange thing is that suddenly CiscoWorks did not do more back up!

Sven Hruza · ‎01-22-2010

I'm not sure, but it is possible that you can find the path for every part of LMS under

\CSCOpx\backup\manifest\

and for dfmInv.db it is

\CSCOpx\backup\manifest\dfm\database\dfmInv.txt

In my dfmInv.txt teh right path is written down:

[dfmInv]

root=D:\PROGRA~1\CSCOpx\databases\dfmInv\dfmInv.db

But I do not know if it is possible to change the path in the txt file without any side effects.

Sven

spocnocacea · ‎01-22-2010

thanks sven
in my file is the correct string.
I just can not understand how I solve this problem.
If I want to backup manually which folders should I backup?
Avro doing manual backup if I have problems after restore CiscoWorks?

Sven Hruza · ‎01-22-2010

Hm...okay....

I found a thread about a simmilar issue like yours:

https://supportforums.cisco.com/message/663068#663068

Hope this helps