Solved: Failed backup

kristoffer.sund · ‎09-09-2008

Hi,

Does anyone know what causes my backup to fail?

Database backup completed

Command file created using Adaptive Server Anywhere Command File Hiding Utility.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Validation d:/backupdir\394\dfm\database\dfmFh.db failed.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Backup Utility Version 9.0.0.1383

(1038580 of 1038580 pages, 100% complete)

Database backup completed

Command file created using Adaptive Server Anywhere Command File Hiding Utility.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

Unable to start specified database: dfmFh.log not expecting any operations in transaction log

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

Unable to start specified database: dfmFh.log not expecting any operations in transaction log

Validation d:/backupdir\394\dfm\database\dfmFh.db failed.

Stopping database engine dfmFhEng

ERROR(1226): Database dfmFhDb backup failed and . Check the log file for information.

Backup failed: 2008/09/10 05:24:10

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

Joe Clarke · ‎09-15-2008

Please start a new thread for this issue.

View solution in original post

Joe Clarke · ‎09-10-2008

Looks like your fault history transaction log is corrupt. Shutdown Daemon Manager, then remove NMSROOT\databases\dfmFh\dfmFh.log. Then run:

NMSROOT\objects\db\win32\dbsrv9 -f NMSROOT\databases\dfmFh\dfmFh.db

Then restart dmgtd. Your backup should work now.

kristoffer.sund · ‎09-12-2008

Hi,

Thanks for your answer, the first problem solved, backup started.....but failed again:

daptive Server Anywhere Backup Utility Version 9.0.0.1383

(1038580 of 1038580 pages, 100% complete)

(5980 of 5980 pages, 100% complete)

Database backup completed

Command file created using Adaptive Server Anywhere Command File Hiding Utility.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Validation d:/backupdir\394\dfm\database\dfmFh.db failed.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Backup Utility Version 9.0.0.1383

(1038580 of 1038580 pages, 100% complete)

(4102 of 4102 pages, 100% complete)

Database backup completed

Command file created using Adaptive Server Anywhere Command File Hiding Utility.

Adaptive Server Anywhere Command File Hiding Utility Version 9.0.0.1383

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Adaptive Server Anywhere Validation Utility Version 9.0.0.1383

1 error reported

Run time SQL error -- Index "eventidIndex" has missing index entries

Validation d:/backupdir\394\dfm\database\dfmFh.db failed.

ERROR(1226): Database dfmFhDb backup failed and . Check the log file for information.

Backup failed: 2008/09/12 09:29:48

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

Removing directory d:\backupdir\394

Joe Clarke · ‎09-12-2008

Your fault history database is completely corrupt. It will need to be reinitialized:

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

kristoffer.sund · ‎09-15-2008

Thank you again Jclarke for your answer, we have another problem with RME. Do you have any tips?

[ mÃ¥ sep 15 14:08:58 CEST 2008 ],ERROR,[Thread-22],com.cisco.nm.rmeng.util.logger.RMELogger,770,com.cisco.nm.rmeng.inventory.ics.invchange.AddInvChange,effect,33,Unexpected error :com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table 'PhysicalElement' is not unique

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2834)

at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2156)

at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)

at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)

at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)

at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1766)

at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758)

at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:619)

at com.cisco.nm.rmeng.inventory.ics.dbrep.DBRecord.insert(DBRecord.java:50)

at com.cisco.nm.rmeng.inventory.ics.util.ICSDatabaseConnection.insert(ICSDatabaseConnection.java:91)

at com.cisco.nm.rmeng.inventory.ics.invchange.AddInvChange.effect(AddInvChange.java:29)

at com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor.processInvData(InvDataProcessor.java:394)

at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:849)

at java.lang.Thread.run(Thread.java:534)

[ mÃ¥ sep 15 14:08:58 CEST 2008 ],ERROR,[Thread-22],com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor,448,ASA Error -193: Primary key for table 'PhysicalElement' is not unique

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table 'PhysicalElement' is not unique