mack275 0 Posted April 23, 2012 Report Share Posted April 23, 2012 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 Link to post Share on other sites
mutley 4,495 Posted April 24, 2012 Report Share Posted April 24, 2012 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 Link to post Share on other sites
mack275 0 Posted April 26, 2012 Author Report Share Posted April 26, 2012 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. Link to post Share on other sites
rosariomanzo 545 Posted April 26, 2012 Report Share Posted April 26, 2012 Hi Did you try reloading the scenery within AH? Link to post Share on other sites
allardjd 1,853 Posted April 27, 2012 Report Share Posted April 27, 2012 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 Link to post Share on other sites
mack275 0 Posted May 6, 2012 Author Report Share Posted May 6, 2012 Hi Did you try reloading the scenery within AH? Hi, Thanks for your suggestion. Unfortunately, it didn't work. Link to post Share on other sites
mack275 0 Posted December 3, 2012 Author Report Share Posted December 3, 2012 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. Link to post Share on other sites
allardjd 1,853 Posted December 3, 2012 Report Share Posted December 3, 2012 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 Link to post Share on other sites
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now