Locking Up @ Loading Market

[Yorkie]

Hi

In the past i've had upwards of 70 ba tabs linked to excel sheets and not really had a problem. I currently have 13 tabs linked to a single worksheet and over the last few days have started to have a problem with tabs locking up when changing markets. This does not affect all tabs but when one does lock there is no way of moving it on again.

BA is set to load markets at the sceduled off of the previous race and most of the time it does. The market is the UK Greyhounds Win market and today 12 of the tabs are still running but 1 of them locked at 13:53 still showing the bets from the previous race and the words Market Loading where the market should be. The locking tabs are random in that they are not always linked to the same excel sheets & if more than 1 locks they are not always at the same time.

I accept it could be something to do with the worksheet but i don't know enough about the timeline of events BA does during market change to say, or how excel could stop the market change at all.

Any help appreciated.

Yorkie

[GaryRussell]

Can you select the tab that is stuck, select "Display Excel link activity" from the Excel menu and post the contents of the log here.

[Yorkie]

Hasn't done it for a few days but just has so here is the data.

Updating of excel by the looks of it but why only at random times? I don't know but i'm sure you can give me more info

12:16:23:261: Excel updated.
12:16:23:599: Requesting Excel refresh. Origin cell:A1
12:16:23:919: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:24:929: Requesting Excel refresh. Origin cell:A1
12:16:24:937: Excel not updated. Update thread is busy.
12:16:26:64: Requesting Excel refresh. Origin cell:A1
12:16:26:160: Excel not updated. Update thread is busy.
12:16:26:280: Excel updated.
12:16:27:570: Requesting Excel refresh. Origin cell:A1
12:16:27:673: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:28:605: Requesting Excel refresh. Origin cell:A1
12:16:28:606: Excel not updated. Update thread is busy.
12:16:29:725: Requesting Excel refresh. Origin cell:A1
12:16:29:726: Excel not updated. Update thread is busy.
12:16:30:997: Requesting Excel refresh. Origin cell:A1
12:16:30:997: Excel not updated. Update thread is busy.
12:16:31:297: Excel updated.
12:16:32:789: Requesting Excel refresh. Origin cell:A1
12:16:32:900: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:34:530: Requesting Excel refresh. Origin cell:A1
12:16:34:530: Excel not updated. Update thread is busy.
12:16:35:829: Excel updated.
12:16:36:231: Requesting Excel refresh. Origin cell:A1
12:16:36:318: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:37:646: Requesting Excel refresh. Origin cell:A1
12:16:37:646: Excel not updated. Update thread is busy.
12:16:38:427: Excel updated.
12:16:38:804: Requesting Excel refresh. Origin cell:A1
12:16:39:216: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:39:864: Requesting Excel refresh. Origin cell:A1
12:16:39:864: Excel not updated. Update thread is busy.
12:16:40:598: Excel updated.
12:16:40:869: Requesting Excel refresh. Origin cell:A1
12:16:41:150: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:41:676: Excel updated.
12:16:42:119: Requesting Excel refresh. Origin cell:A1
12:16:42:313: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:43:780: Requesting Excel refresh. Origin cell:A1
12:16:43:780: Excel not updated. Update thread is busy.
12:16:44:588: Excel updated.
12:16:44:796: Requesting Excel refresh. Origin cell:A1
12:16:45:124: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:46:102: Requesting Excel refresh. Origin cell:A1
12:16:46:102: Excel not updated. Update thread is busy.
12:16:46:903: Requesting Excel refresh. Origin cell:A1
12:16:46:903: Excel not updated. Update thread is busy.
12:16:47:720: Excel updated.
12:16:47:773: Requesting Excel refresh. Origin cell:A1
12:16:47:773: Excel not updated. Update thread is busy.
12:16:48:803: Requesting Excel refresh. Origin cell:A1
12:16:48:854: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:50:636: Requesting Excel refresh. Origin cell:A1
12:16:50:641: Excel not updated. Update thread is busy.
12:16:50:711: Excel updated.
12:16:51:518: Requesting Excel refresh. Origin cell:A1
12:16:51:578: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:53:63: Requesting Excel refresh. Origin cell:A1
12:16:53:79: Excel not updated. Update thread is busy.
12:16:53:256: Excel updated.
12:16:54:283: Requesting Excel refresh. Origin cell:A1
12:16:54:684: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:55:704: Excel updated.
12:16:56:609: Requesting Excel refresh. Origin cell:A1
12:16:57:131: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:16:58:46: Requesting Excel refresh. Origin cell:A1
12:16:58:46: Excel not updated. Update thread is busy.
12:16:59:275: Excel updated.
12:16:59:319: Requesting Excel refresh. Origin cell:A1
12:16:59:319: Excel not updated. Update thread is busy.
12:17:00:554: Requesting Excel refresh. Origin cell:A1
12:17:01:42: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:01:885: Requesting Excel refresh. Origin cell:A1
12:17:01:891: Excel not updated. Update thread is busy.
12:17:02:755: Excel updated.
12:17:03:211: Requesting Excel refresh. Origin cell:A1
12:17:03:795: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:05:88: Requesting Excel refresh. Origin cell:A1
12:17:05:88: Excel not updated. Update thread is busy.
12:17:06:59: Requesting Excel refresh. Origin cell:A1
12:17:06:95: Excel not updated. Update thread is busy.
12:17:06:613: Excel updated.
12:17:06:822: Requesting Excel refresh. Origin cell:A1
12:17:06:857: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:08:18: Requesting Excel refresh. Origin cell:A1
12:17:08:21: Excel not updated. Update thread is busy.
12:17:09:205: Requesting Excel refresh. Origin cell:A1
12:17:09:221: Excel not updated. Update thread is busy.
12:17:10:271: Excel updated.
12:17:10:271: Requesting Excel refresh. Origin cell:A1
12:17:10:271: Excel not updated. Update thread is busy.
12:17:10:963: Requesting Excel refresh. Origin cell:A1
12:17:11:671: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:12:133: Requesting Excel refresh. Origin cell:A1
12:17:12:155: Excel not updated. Update thread is busy.
12:17:13:427: Requesting Excel refresh. Origin cell:A1
12:17:13:428: Excel not updated. Update thread is busy.
12:17:14:241: Excel updated.
12:17:14:445: Requesting Excel refresh. Origin cell:A1
12:17:14:848: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:15:220: Requesting Excel refresh. Origin cell:A1
12:17:15:227: Excel not updated. Update thread is busy.
12:17:16:122: Requesting Excel refresh. Origin cell:A1
12:17:16:128: Excel not updated. Update thread is busy.
12:17:16:771: Excel updated.
12:17:17:373: Requesting Excel refresh. Origin cell:A1
12:17:17:582: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:18:258: Requesting Excel refresh. Origin cell:A1
12:17:18:261: Excel not updated. Update thread is busy.
12:17:19:240: Requesting Excel refresh. Origin cell:A1
12:17:19:240: Excel not updated. Update thread is busy.
12:17:19:865: Excel updated.
12:17:20:438: Requesting Excel refresh. Origin cell:A1
12:17:20:631: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:21:632: Requesting Excel refresh. Origin cell:A1
12:17:21:632: Excel not updated. Update thread is busy.
12:17:22:325: Requesting Excel refresh. Origin cell:A1
12:17:22:326: Excel not updated. Update thread is busy.
12:17:22:511: Excel updated.
12:17:23:356: Requesting Excel refresh. Origin cell:A1
12:17:23:761: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:24:48: Excel updated.
12:17:24:709: Requesting Excel refresh. Origin cell:A1
12:17:26:565: Excel updated.
12:17:26:579: Requesting Excel refresh. Origin cell:A1
12:17:26:836: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:27:609: Requesting Excel refresh. Origin cell:A1
12:17:27:609: Excel not updated. Update thread is busy.
12:17:28:214: Requesting Excel refresh. Origin cell:A1
12:17:28:214: Excel not updated. Update thread is busy.
12:17:29:160: Requesting Excel refresh. Origin cell:A1
12:17:29:160: Excel not updated. Update thread is busy.
12:17:29:686: Excel updated.
12:17:30:428: Requesting Excel refresh. Origin cell:A1
12:17:30:674: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:30:941: Excel updated.
12:17:31:908: Requesting Excel refresh. Origin cell:A1
12:17:32:473: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:33:806: Requesting Excel refresh. Origin cell:A1
12:17:33:806: Excel not updated. Update thread is busy.
12:17:34:307: Excel updated.
12:17:34:927: Requesting Excel refresh. Origin cell:A1
12:17:35:148: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:35:598: Excel updated.
12:17:36:149: Requesting Excel refresh. Origin cell:A1
12:17:36:257: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:37:295: Requesting Excel refresh. Origin cell:A1
12:17:37:295: Excel not updated. Update thread is busy.
12:17:38:474: Requesting Excel refresh. Origin cell:A1
12:17:38:474: Excel not updated. Update thread is busy.
12:17:39:391: Excel updated.
12:17:40:137: Requesting Excel refresh. Origin cell:A1
12:17:40:172: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:41:375: Excel updated.
12:17:41:709: Requesting Excel refresh. Origin cell:A1
12:17:42:156: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateIndexGet(Object o, Object[] args, String[] paramnames)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:42:778: Requesting Excel refresh. Origin cell:A1
12:17:42:779: Excel not updated. Update thread is busy.
12:17:44:8: Requesting Excel refresh. Origin cell:A1
12:17:44:8: Excel not updated. Update thread is busy.
12:17:44:725: Requesting Excel refresh. Origin cell:A1
12:17:44:725: Excel not updated. Update thread is busy.
12:17:45:356: Excel updated.
12:17:46:444: Requesting Excel refresh. Origin cell:A1
12:17:47:141: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:47:644: Requesting Excel refresh. Origin cell:A1
12:17:47:662: Excel not updated. Update thread is busy.
12:17:48:841: Requesting Excel refresh. Origin cell:A1
12:17:48:873: Excel not updated. Update thread is busy.
12:17:49:634: Requesting Excel refresh. Origin cell:A1
12:17:49:634: Excel not updated. Update thread is busy.
12:17:50:233: Excel updated.
12:17:50:743: Requesting Excel refresh. Origin cell:A1
12:17:50:952: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:51:880: Requesting Excel refresh. Origin cell:A1
12:17:51:881: Excel not updated. Update thread is busy.
12:17:53:28: Requesting Excel refresh. Origin cell:A1
12:17:53:102: Excel not updated. Update thread is busy.
12:17:53:519: Excel updated.
12:17:54:85: Requesting Excel refresh. Origin cell:A1
12:17:54:617: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:55:323: Requesting Excel refresh. Origin cell:A1
12:17:55:323: Excel not updated. Update thread is busy.
12:17:56:659: Requesting Excel refresh. Origin cell:A1
12:17:56:659: Excel not updated. Update thread is busy.
12:17:57:692: Excel updated.
12:17:57:997: Requesting Excel refresh. Origin cell:A1
12:17:58:116: Error retrieving workbooks and worksheets:System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.ExcelUpdateThread()
12:17:59:205: Requesting Excel refresh. Origin cell:A1
12:17:59:205: Excel not updated. Update thread is busy.
12:17:59:606: getNearestOdds invokeBegin
12:17:59:713: getNearestOdds invokeEnd
12:17:59:713: getNearestOdds invokeBegin
12:17:59:821: getNearestOdds invokeEnd
12:18:00:305: updateActionLabel invokeBegin
12:18:00:333: updateActionLabel invokeEnd
12:18:00:589: Requesting Excel refresh. Origin cell:A1
12:18:00:589: Excel not updated. Update thread is busy.
12:18:01:694: updateActionLabel invokeBegin
12:18:01:698: updateActionLabel invokeEnd
12:18:03:413: Bets refresh begin

[GaryRussell]

Sorry for the delay in replying. I am still investigating this. The last entry in the log shows it requested a refresh of the bets list, but doesn't show that it completed the update so this is where it is stuck. I am trying to replicate this.

[GaryRussell]

I think I may have prevented this happening. Can you install version 1.1.0.66x83 and let me know if it happens again. Can you also send the log file named BA_Diagnostic.txt from c:\temp\Betting Assistant Logs in addition to the Excel link activity log if it happens again.

Install from http://www.gruss-software.co.uk/Betting ... _Beta2.msi