x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 76 subscribers
  • Views 3066 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
979
topics
2k
replies
Inventory, Projects, and Departments
337
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
316
topics
993
replies
Reporting and Analytics
206
topics
397
replies
Soutien Technique - Français
626
topics
1k
replies
Year End Activities
223
topics
595
replies
MicheleJ

Connection errors - database

Posted By

Help!! 

I was using the 2016 version (cloud) on Friday and then all of a sudden I started having database errors. I
was working away, and then got a big red X and the system crashed. I downloaded the latest updates but that did not help. I could
not open my database in either the 2016 or 2017 version. I did finally manage to open up my data using a back up copy. So, then I
had to enter some data, make a backup, enter more data, make a back up, etc etc. PAINFUL!!! If I waited to long to do another ba
ckup the system would crash and I'd lose everything. So, I uninstalled both 2016 and 2017, and have reinstalled 2017. When I try to
open the last file I worked on, I get this error message: Sage 50 cannot open the database because the database engine reported a
n error. Please see the error log for more information".  I have read other posts on this topic but none have helped.  I am the only user and have the programs installed on a desktop and a laptop.  I often use Sage Drive to store my data so I can pick it up where I am working.  Here is the Exception Error.  Can anyone point me in the right direction so i can get up and running again?  

ate: 2017-3-18 Time: 17:12:25:377
Sage.Simply.DataTypes.ConnectionException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRangeInternal(String query, DbOperationContext dbOperation, EntityFilter order)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRange(String query, DbOperationContext dbOperation)
--- End of inner exception stack trace ---
Full Stack Trace:
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.DLOExceptionEvent.HandleConnectionException(System.Exception)
at Sage.Simply.DataAccess.MySqlDbManager.HandleConnectionException(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRange(System.String, Sage.SBD.ACS.Framework.DataAccess.DbOperationContext)
at Sage.Simply.DataAccess.InvtTransRawDataDLO.LoadInvtTrans(Sage.SBD.ACS.Framework.DataAccess.DbOperationContext, System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Sage.Simply.Domain.Entities.InvtTransRawDataList.Load(System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransReportBuilderBase.CreateRawData()
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransDetailBuilder.CreateRawData()
at Simply.Framework.Domain.Reports.ReportBuilder.CreateReportDataViewer()
at Simply.Framework.Domain.Reports.ReportBuilder.BuildReport(Simply.Framework.Domain.Reports.Report, Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.BuildReportWithProgress(Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.RefreshReport(Boolean)
at Simply.Framework.UI.Reports.ReportController.RebuildReport(System.Object, System.EventArgs)
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)
at Sage.SBD.ACS.Framework.Common.SafeDelegate.InvokeSafe(System.Object[])
at Sage.Simply.Domain.Entities.LedgerObserver.OnUpdateReport(System.Object)
at ReportInterOp.UpdateOpenReports(UInt32)
at UpdateOpenReports(UInt32)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)

Date: 2017-3-18 Time: 17:12:29:689
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.Open()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.System.Data.IDbConnection.BeginTransaction(IsolationLevel il)
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.System.Data.IDbConnection.BeginTransaction()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.BeginTransaction()
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.BeginTransaction()
at Simply.Domain.Utility.SimplyTransactionManager.BeginTransaction()
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.DoTransaction(TransactionMethodWithParam method, Object param)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(TransactionMethodWithParam method, Object param)
Full Stack Trace:
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Simply.Domain.Utility.DomainExceptionHandler.HandleException(System.Exception)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethodWithParam, System.Object)
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethod)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethod)
at Simply.Domain.PEP.SimplyPEPTrackUsageUtil.SaveTrackedData()
at Simply.UI.Library.SimplyWindow.OnClosing(System.ComponentModel.CancelEventArgs)
at System.Windows.Forms.Form.WmClose(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
at Sage.SBD.ACS.Framework.UI.BaseForm.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.Library.SimplyForm.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.Library.SimplyWindowThinBorder.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(System.Runtime.InteropServices.HandleRef, Int32, Int32, Int32)
at System.Windows.Forms.Control.SendMessage(Int32, Int32, Int32)
at System.Windows.Forms.Form.Close()
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.DomainExceptionHandler_ForceShutDown(System.Object, System.EventArgs)
at System.EventHandler.Invoke(System.Object, System.EventArgs)
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply()
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply(System.String, System.String, Int32, System.String)
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.DLOExceptionEvent.HandleConnectionException(System.Exception)
at Sage.Simply.DataAccess.MySqlDbManager.HandleConnectionException(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRange(System.String, Sage.SBD.ACS.Framework.DataAccess.DbOperationContext)
at Sage.Simply.DataAccess.InvtTransRawDataDLO.LoadInvtTrans(Sage.SBD.ACS.Framework.DataAccess.DbOperationContext, System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Sage.Simply.Domain.Entities.InvtTransRawDataList.Load(System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransReportBuilderBase.CreateRawData()
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransDetailBuilder.CreateRawData()
at Simply.Framework.Domain.Reports.ReportBuilder.CreateReportDataViewer()
at Simply.Framework.Domain.Reports.ReportBuilder.BuildReport(Simply.Framework.Domain.Reports.Report, Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.BuildReportWithProgress(Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.RefreshReport(Boolean)
at Simply.Framework.UI.Reports.ReportController.RebuildReport(System.Object, System.EventArgs)
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)
at Sage.SBD.ACS.Framework.Common.SafeDelegate.InvokeSafe(System.Object[])
at Sage.Simply.Domain.Entities.LedgerObserver.OnUpdateReport(System.Object)
at ReportInterOp.UpdateOpenReports(UInt32)
at UpdateOpenReports(UInt32)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)

Date: 2017-3-18 Time: 17:12:53:597
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.Open()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.System.Data.IDbConnection.BeginTransaction(IsolationLevel il)
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.System.Data.IDbConnection.BeginTransaction()
at Sage.SBD.ACS.Framework.DataAccess.DbOperationContext.BeginTransaction()
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.BeginTransaction()
at Simply.Domain.Utility.SimplyTransactionManager.BeginTransaction()
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.DoTransaction(TransactionMethodWithParam method, Object param)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(TransactionMethodWithParam method, Object param)
Full Stack Trace:
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Simply.Domain.Utility.DomainExceptionHandler.HandleException(System.Exception)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethodWithParam, System.Object)
at Sage.SBD.ACS.Framework.BusinessLogic.TransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethod)
at Simply.Domain.Utility.SimplyTransactionManager.DoTransaction(Sage.SBD.ACS.Framework.BusinessLogic.TransactionMethod)
at Simply.Domain.PEP.SimplyPEPTrackUsageUtil.SaveTrackedData()
at Simply.UI.Library.SimplyWindow.OnClosing(System.ComponentModel.CancelEventArgs)
at Simply.Framework.UI.Reports.ReportForm.OnClosing(System.ComponentModel.CancelEventArgs)
at System.Windows.Forms.Form.WmClose(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
at Sage.SBD.ACS.Framework.UI.BaseForm.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.Library.SimplyForm.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(System.Runtime.InteropServices.HandleRef, Int32, Int32, Int32)
at System.Windows.Forms.Control.SendMessage(Int32, Int32, Int32)
at System.Windows.Forms.Form.Close()
at Simply.Framework.UI.Reports.ReportController.Destroy()
at Simply.Framework.UI.Reports.ReportController.CloseAllReports()
at CloseAllReports()
at Sage.Simply.InteropToLegacy.SAHomeWindow.CloseHomeWindow(Boolean)
at Simply.UI.Library.InteropWrapper.SAHomeWindowWrapper.CloseHomeWindow(Boolean)
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.SimplyForm_Closing(System.Object, System.ComponentModel.CancelEventArgs)
at System.Windows.Forms.Form.OnClosing(System.ComponentModel.CancelEventArgs)
at Simply.UI.Library.SimplyForm.OnClosing(System.ComponentModel.CancelEventArgs)
at Simply.UI.Library.SimplyWindow.OnClosing(System.ComponentModel.CancelEventArgs)
at System.Windows.Forms.Form.WmClose(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
at Sage.SBD.ACS.Framework.UI.BaseForm.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.Library.SimplyForm.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.Library.SimplyWindowThinBorder.WndProc(System.Windows.Forms.Message ByRef)
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(System.Runtime.InteropServices.HandleRef, Int32, Int32, Int32)
at System.Windows.Forms.Control.SendMessage(Int32, Int32, Int32)
at System.Windows.Forms.Form.Close()
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.DomainExceptionHandler_ForceShutDown(System.Object, System.EventArgs)
at System.EventHandler.Invoke(System.Object, System.EventArgs)
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply()
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply(System.String, System.String, Int32, System.String)
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.DLOExceptionEvent.HandleConnectionException(System.Exception)
at Sage.Simply.DataAccess.MySqlDbManager.HandleConnectionException(System.Exception)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRange(System.String, Sage.SBD.ACS.Framework.DataAccess.DbOperationContext)
at Sage.Simply.DataAccess.InvtTransRawDataDLO.LoadInvtTrans(Sage.SBD.ACS.Framework.DataAccess.DbOperationContext, System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Sage.Simply.Domain.Entities.InvtTransRawDataList.Load(System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransReportBuilderBase.CreateRawData()
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransDetailBuilder.CreateRawData()
at Simply.Framework.Domain.Reports.ReportBuilder.CreateReportDataViewer()
at Simply.Framework.Domain.Reports.ReportBuilder.BuildReport(Simply.Framework.Domain.Reports.Report, Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.BuildReportWithProgress(Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.RefreshReport(Boolean)
at Simply.Framework.UI.Reports.ReportController.RebuildReport(System.Object, System.EventArgs)
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)
at Sage.SBD.ACS.Framework.Common.SafeDelegate.InvokeSafe(System.Object[])
at Sage.Simply.Domain.Entities.LedgerObserver.OnUpdateReport(System.Object)
at ReportInterOp.UpdateOpenReports(UInt32)
at UpdateOpenReports(UInt32)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)

Date: 2017-3-18 Time: 17:12:57:798
System.InvalidOperationException: Invoke or BeginInvoke cannot be called on a control until the window handle has been created.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Simply.UI.HomeWindows.Controls.NotificationPopup.CloseNotificationPopup()
at Simply.UI.HomeWindows.Windows.SimplyHomeWindow.CloseDynamicMessageNotification()
at Simply.UI.HomeWindows.DynamicMessages.DynamicMessagesMgr.StopCheckNewMessages()
at Simply.UI.HomeWindows.DynamicMessages.DynamicMessagesMgr.DomainExceptionHandler_ForceShutDown(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply()
at Simply.Domain.Utility.DomainExceptionHandler.ForceShutDownSimply(String message, String caption, Int32 helpId, String exceptionInfo)
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(Exception e)
at Sage.SBD.ACS.Framework.DataAccess.DLOExceptionEvent.HandleConnectionException(Exception e)
at Sage.Simply.DataAccess.MySqlDbManager.HandleConnectionException(Exception e)
at Sage.SBD.ACS.Framework.DataAccess.TransientDLO.LoadRange(String query, DbOperationContext dbOperation)
at Sage.Simply.DataAccess.InvtTransRawDataDLO.LoadInvtTrans(DbOperationContext operation, IList inventoryIds, Boolean byLoc, IList locIDs, Nullable`1 start, Nullable`1 end, List`1 types)
at Sage.Simply.Domain.Entities.InvtTransRawDataList.Load(IList inventoryIds, Boolean byLoc, IList locIDs, Nullable`1 start, Nullable`1 end, List`1 types)
Full Stack Trace:
at Simply.Domain.Utility.DomainExceptionHandler.HandleFatalDataAccessExceptions(System.Exception)
at Simply.Domain.Utility.DomainExceptionHandler.HandleException(System.Exception)
at Sage.Simply.Domain.Entities.InvtTransRawDataList.Load(System.Collections.IList, Boolean, System.Collections.IList, System.Nullable`1[System.DateTime], System.Nullable`1[System.DateTime], System.Collections.Generic.List`1[Sage.Simply.Common.IT_JOURTYPES])
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransReportBuilderBase.CreateRawData()
at Simply.Domain.Reports.InventoryReports.Transactions.InvtTransDetailBuilder.CreateRawData()
at Simply.Framework.Domain.Reports.ReportBuilder.CreateReportDataViewer()
at Simply.Framework.Domain.Reports.ReportBuilder.BuildReport(Simply.Framework.Domain.Reports.Report, Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.BuildReportWithProgress(Sage.Simply.Common.Interfaces.IProgress)
at Simply.Framework.UI.Reports.ReportController.RefreshReport(Boolean)
at Simply.Framework.UI.Reports.ReportController.RebuildReport(System.Object, System.EventArgs)
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)
at Sage.SBD.ACS.Framework.Common.SafeDelegate.InvokeSafe(System.Object[])
at Sage.Simply.Domain.Entities.LedgerObserver.OnUpdateReport(System.Object)
at ReportInterOp.UpdateOpenReports(UInt32)
at UpdateOpenReports(UInt32)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
at Sage.Advisor.ClientWindowProvider.WindowMonitors.Win32WindowMonitor.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)

  • 0

    MicheleJ said:
    Sage 50 cannot open the database because the database engine reported a
    n error. Please see the error log for more information"

    The error log is the one in the company data folder (same as the company 'filename' except it has .SAJ as an extension.  Hard disk data corruption or mis-reads at the binary storage level (inside MySQL, outside of Sage 50) can result in a failed checksum, after which the database engine (MySQL) will refuse to open the data and report an error.  

    Ongoing, repeated, intermittent data corruption is absolutely not normal.  There is likely some sort of hardware or software problem outside of the Sage 50 program that is causing data corruption, such as a failing hard disk.

    Installing a newer version of the software requires running a one-way conversion process and a lot of disk reading and writing.  If there is a small problem, it could be made worse by that. 

    MicheleJ said:
     I often use Sage Drive to store my data so I can pick it up where I am working.

    I'm not sure at which level that interacts with the data on the hard disk, it's best to call Sage support to ask them. 

  • 0 in reply to RandyW
    Hi Randy - thanks for the response. I had to get Sage tech support to fix my database this morning. It is now opening correctly in 2016.4. That being said, 2017.1 is not converting the data so the tech told me I need to send my file to Sage and they will convert it for me. Not only does that process take 3-5 days, but they want me to pay for it. I'm now waiting for a manager to call me back as I don't believe I should have to pay for a file conversion just because their latest update won't do it. At least I am now back working in 2016.4.

*Community Hub is the new name for Sage City