Failed backup

Answered Question
Sep 9th, 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.

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

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

Correct Answer by Joe Clarke about 8 years 5 months ago

Please start a new thread for this issue.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Joe Clarke Wed, 09/10/2008 - 07:22

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 Fri, 09/12/2008 - 02:18

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.

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 Fri, 09/12/2008 - 07:09

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 Mon, 09/15/2008 - 04:17

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

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.core.CollectionController,861, Exception occured in process method while processing: 172.19.6.125 ASA Error -193: Primary key for table 'PhysicalElement' is not unique

ICSException :: ASA Error -193: Primary key for table 'PhysicalElement' is not unique

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

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

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

Actions

This Discussion