Help please! How can I recover corrupted DB file

[mack275 0]

Hello,

My PC was hung during starting the Air Hauler. I rebooted the system...Then I have found finance tab doesn't show with correct value with error.

This is Just-In-Time debugger's output. When AI or myself has completed the jobs, I could see correct finance value without any errors. I think some table has been corrupted. The DB file is protected by password.

Before tweaking the DB, I would like to hear you guys' advice. Do you know any way to fix this issue?

==

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

at System.Data.DataSet.FailedEnableConstraints()

at System.Data.DataSet.EnableConstraints()

at System.Data.DataSet.set_EnforceConstraints(Boolean value)

at System.Data.DataTable.EndLoadData()

at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at cs.bi()

at cs.ea()

at cs.a0(Object A_0, EventArgs A_1)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Windows.Forms.Form.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5448 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

AirHauler

Assembly Version: 1.5.4.1

Win32 Version: 1.5.4.1

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/airhauler.exe

----------------------------------------

Microsoft.VisualBasic

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll

----------------------------------------

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5453 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5446 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5458 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Runtime.Remoting

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll

----------------------------------------

Interop.ADODB

Assembly Version: 6.0.0.0

Win32 Version: 6.0.0.0

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Interop.ADODB.DLL

----------------------------------------

FSUIPCClient

Assembly Version: 1.3.2758.28

Win32 Version: 1.3.2758.28

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/FSUIPCClient.DLL

----------------------------------------

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

Infragistics2.Win.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.v8.3.DLL

----------------------------------------

Infragistics2.Win.UltraWinToolbars.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinToolbars.v8.3.DLL

----------------------------------------

Infragistics2.Win.UltraWinGrid.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinGrid.v8.3.DLL

----------------------------------------

Infragistics2.Win.UltraWinTabControl.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinTabControl.v8.3.DLL

----------------------------------------

Infragistics2.Shared.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Shared.v8.3.DLL

----------------------------------------

Infragistics2.Win.Misc.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.Misc.v8.3.DLL

----------------------------------------

System.Design

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll

----------------------------------------

Infragistics2.Win.UltraWinGrid.ExcelExport.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinGrid.ExcelExport.v8.3.DLL

----------------------------------------

Infragistics2.Excel.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Excel.v8.3.DLL

----------------------------------------

Infragistics2.Win.AppStylistSupport.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.AppStylistSupport.v8.3.DLL

----------------------------------------

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

----------------------------------------

LgLcd.NET

Assembly Version: 1.0.2182.20042

Win32 Version: 1.0.2182.20042

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/LgLcd.NET.DLL

----------------------------------------

System.Management

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll

----------------------------------------

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

TaskDialog

Assembly Version: 1.2.0.0

Win32 Version: 1.2.0.0

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/TaskDialog.DLL

----------------------------------------

DundasWinMap

Assembly Version: 1.1.1.100

Win32 Version: 1.1.1.100

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/DundasWinMap.DLL

----------------------------------------

System.Runtime.Serialization.Formatters.Soap

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Serialization.Formatters.Soap/2.0.0.0__b03f5f7f11d50a3a/System.Runtime.Serialization.Formatters.Soap.dll

----------------------------------------

System.Transactions

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.EnterpriseServices

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

Infragistics2.Win.UltraWinChart.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinChart.v8.3.DLL

----------------------------------------

Infragistics2.Win.UltraWinDataSource.v8.3

Assembly Version: 8.3.20083.1009

Win32 Version: 8.3.20083.1009

CodeBase: file:///C:/Program%20Files%20(x86)/AirHauler/Infragistics2.Win.UltraWinDataSource.v8.3.DLL

----------------------------------------

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

For example:

<configuration>

<system.windows.forms jitDebugging="true" />

</configuration>

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

==

MACK275

[mutley 4,492]

Hi Mack

Sorry you've had no response so far, our AH Guru is on vacation right now, my guess is that the DB needs editing, I can't see a way back from that.

You could try posting in the Just Flight / AH forum here and you may get more help.

I hope you get it sorted, let us know how you get on.

Cheers

Joe

[mack275 0]

Hi Mack

Sorry you've had no response so far, our AH Guru is on vacation right now, my guess is that the DB needs editing, I can't see a way back from that.

You could try posting in the Just Flight / AH forum here and you may get more help.

I hope you get it sorted, let us know how you get on.

Cheers

Joe

Thanks for replying.

I am currently working with Just Flight Techsupport team.

If I find solution, I would post my update.

If AH Guru can provide a solution before TechSupport found issue, it would be great.

[rosariomanzo 545]

Hi

Did you try reloading the scenery within AH?

[allardjd 1,853]

Slopey and/or the JF guys are the only games in town for this kind of thing. A post at the JF/AH fourum will get his attention most quickly. He comes here sometimes, but not as often as the JF/AH forums.

John

[mack275 0]

Hi

Did you try reloading the scenery within AH?

Hi,

Thanks for your suggestion.

Unfortunately, it didn't work.

[mack275 0]

Hello,

The Just Flight support offered me a refund. So I think they don't want to fix my corrupt DB file. I did not refund the software... I am still enjoying it.

Now, I have started new company from scratch.... I have started taking the backup every week.

[allardjd 1,853]

Try to re-order the Cashbook table in date order, newest last. That can be done by clicking on the column header for date. If you accidently sorted that table differently by clicking on a column header, the file is not corrupted but the displayed table will not make any sense. It doesn't re-calculate when re-ordered and the balance field only makes sense when the table is lined up from oldest to newest.

John