Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Failed backup

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Failed backup

Please start a new thread for this issue.

5 REPLIES
Cisco Employee

Re: Failed backup

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.

New Member

Re: Failed backup

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

Cisco Employee

Re: Failed backup

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

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

New Member

Re: Failed backup

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)

Cisco Employee

Re: Failed backup

Please start a new thread for this issue.

366
Views
5
Helpful
5
Replies