Q2 cell causing hang

[ians1711]

I have 4 tabs in BA. First tab is driven using COM interface. Second tab has a quick pick list but no auto select. Third and 4th tabs have a quick pick list with auto select enabled. At 6:30am every day, I do the following:

1. Q2 = -7 to clear results pages
2. Wait for Q2 to become blank on all pages
3. Q2 = -3 or as appropriate to repopulate quick pick lists.

On several occasions (not every day), the second tab's quick pick list is repopulated, but the other two tabs hang. Q2 still has the -3 option - it has not been cleared. And the time values in cells C2 and D2 are frozen at 06:30am . I have to delete and readd the tab to get it going again.

I am running version 1.1.0.66w - any thoughts??

Can't see any errors logged

Ian S

[GaryRussell]

I'm afraid I cannot replicate the problem so will need more information. If you install the latest Beta 1.1.0.66x17 using the link below it has an an extra option on the Excel menu called "Display Excel Link Activity". Next time it happens you can go to the tab that is not updating excel and select this option and copy the displayed log and post it on this thread.

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

[ians1711]

Gary
Thanks - I'll try the new version

Ian S

[ians1711]

06:30:56:734: Requesting Excel refresh. Origin cell:A1
06:30:56:796: Excel updated.
06:30:57:734: Requesting Excel refresh. Origin cell:A1
06:30:57:781: Excel updated.
06:30:58:734: Requesting Excel refresh. Origin cell:A1
06:30:58:781: Excel updated.
06:30:59:734: Requesting Excel refresh. Origin cell:A1
06:30:59:781: Excel updated.
06:31:00:734: Requesting Excel refresh. Origin cell:A1
06:31:00:781: Excel updated.
06:31:01:734: Requesting Excel refresh. Origin cell:A1
06:31:02:734: Requesting Excel refresh. Origin cell:A1
06:31:02:734: Excel not updated. Update thread is busy.
06:31:03:734: Excel not updated. Market tree disabled.
06:31:15:718: Requesting Excel refresh. Origin cell:A1
06:31:15:718: Excel not updated. Update thread is busy.
06:31:15:765: Requesting Excel refresh. Origin cell:A1
06:31:15:765: Excel not updated. Update thread is busy.
06:31:16:734: Requesting Excel refresh. Origin cell:A1
06:31:16:734: Excel not updated. Update thread is busy.
06:31:17:734: Requesting Excel refresh. Origin cell:A1
06:31:17:734: Excel not updated. Update thread is busy.
06:31:18:734: Requesting Excel refresh. Origin cell:A1
06:31:18:734: Excel not updated. Update thread is busy.
06:31:19:734: Requesting Excel refresh. Origin cell:A1
06:31:19:734: Excel not updated. Update thread is busy.
06:31:20:734: Requesting Excel refresh. Origin cell:A1
06:31:20:734: Excel not updated. Update thread is busy.
etc

[ians1711]

Log from successful update tab

06:30:54:453: Requesting Excel refresh. Origin cell:A1
06:30:54:484: Excel updated.
06:30:55:453: Requesting Excel refresh. Origin cell:A1
06:30:55:500: Excel updated.
06:30:56:453: Requesting Excel refresh. Origin cell:A1
06:30:56:484: Excel updated.
06:30:57:453: Requesting Excel refresh. Origin cell:A1
06:30:57:484: Excel updated.
06:30:58:453: Requesting Excel refresh. Origin cell:A1
06:30:58:515: Excel updated.
06:30:59:453: Requesting Excel refresh. Origin cell:A1
06:30:59:484: Excel updated.
06:31:00:453: Requesting Excel refresh. Origin cell:A1
06:31:00:484: Excel updated.
06:31:01:453: Requesting Excel refresh. Origin cell:A1
06:31:02:562: Requesting Excel refresh. Origin cell:A1
06:31:02:562: Excel not updated. Update thread is busy.
06:31:03:453: Excel not updated. Market tree disabled.
06:31:15:718: Requesting Excel refresh. Origin cell:A1
06:31:15:718: Excel not updated. Update thread is busy.
06:31:15:796: Excel updated.
06:31:16:453: Requesting Excel refresh. Origin cell:A1
06:31:16:484: Excel updated.
06:31:17:453: Requesting Excel refresh. Origin cell:A1
06:31:17:484: Excel updated.
06:31:18:453: Requesting Excel refresh. Origin cell:A1
06:31:18:484: Excel updated.
06:31:19:453: Requesting Excel refresh. Origin cell:A1
06:31:19:484: Excel updated.
06:31:20:453: Requesting Excel refresh. Origin cell:A1
06:31:20:484: Excel updated.
06:31:21:453: Requesting Excel refresh. Origin cell:A1
06:31:21:500: Excel updated.
06:31:22:453: Requesting Excel refresh. Origin cell:A1
06:31:22:484: Excel updated.

[GaryRussell]

I am investigating.

[GaryRussell]

I need to establish if it's stuck in a loop. Next time it happens can you check the file named BA_Diagnostic.txt in "c:\temp\Betting Assistant Logs"
At the time it triggers the quick pick reload I would expect to see "completeRefreshMarkets(). Market type:" repeating in the log. Can you post this section of the log on the forum if this is the case.

[ians1711]

Gary
Here is the log from 6:30 on 12 Sep:

20:59:08:234: Excel trigger next market detected.
06:31:02:984: Attempted market change, but requests are pending.
06:31:03:015: completeRefreshMarkets(). Market type:0
06:31:03:187: completeRefreshMarkets(). Last refresh over 5 minutes ago, refreshing market tree.
06:31:03:203: completeRefreshMarkets(). Market type:30
06:31:03:250: retried market:
06:31:03:250: Attempted market change, but requests are pending.
06:31:03:265: completeRefreshMarkets(). Market type:10
06:31:04:593: completeRefreshMarkets(). Market type:30
06:31:04:593: retried market:
06:31:06:171: System.NullReferenceException: Object reference not set to an instance of an object.
at Betting_Assistant.StandardGrid.loadDisplaySettings()
06:31:06:328: completeRefreshMarkets(). Market type:10
06:31:09:062: completeRefreshMarkets(). Market type:30
06:31:11:828: completeRefreshMarkets(). Market type:10
06:31:15:078: addMarkets(). Market type:UK WIN
06:31:15:296: addMarkets(). Market type:IRE WIN
06:31:15:562: completeRefreshMarkets(). Market type:10
06:31:15:562: completeRefreshMarkets(). Last refresh less than 5 minutes ago.
06:31:15:562: addMarkets(). Market type:UK WIN
06:31:15:828: Logging Excel bet results for:Good (AvB) 12th Sep - 14:00 PowerM v SatwaM
07:02:30:078: System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'betfairTabPage'.
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 Betting_Assistant.Excel.ExcelUpdateThread()
07:02:37:375: addMarkets(). Market type:IRE WIN
07:02:49:812: System.NullReferenceException: Object reference not set to an instance of an object.
at Betting_Assistant.StandardGrid.loadDisplaySettings()
07:02:53:218: Searching for Excel instances using path:C:\Documents and Settings\Owner\My Documents\, based on path of found workbook:C:\Documents and Settings\Owner\My Documents\BetAssist3.xls


I saw the hang at 7:02 and had to delete the tab and re-add. The following is the log from this morning which was a successful refresh of the quick pick lists

17:39:08:765: Excel trigger next market detected.
06:31:02:656: Attempted market change, but requests are pending.
06:31:02:703: completeRefreshMarkets(). Market type:10
06:31:02:843: completeRefreshMarkets(). Last refresh over 5 minutes ago, refreshing market tree.
06:31:02:859: completeRefreshMarkets(). Market type:30
06:31:02:859: retried market:
06:31:02:859: Attempted market change, but requests are pending.
06:31:02:875: completeRefreshMarkets(). Market type:0
06:31:04:000: completeRefreshMarkets(). Market type:30
06:31:04:000: retried market:
06:31:04:531: System.NullReferenceException: Object reference not set to an instance of an object.
at Betting_Assistant.StandardGrid.loadDisplaySettings()
06:31:11:500: addMarkets(). Market type:UK WIN
06:31:11:687: completeRefreshMarkets(). Market type:0
06:31:11:687: completeRefreshMarkets(). Last refresh less than 5 minutes ago.
06:31:11:687: addMarkets(). Market type:UK WIN
06:31:11:843: addMarkets(). Market type:IRE WIN
06:31:12:093: completeRefreshMarkets(). Market type:30
06:31:12:093: completeRefreshMarkets(). Last refresh less than 5 minutes ago.
06:31:12:093: addMarkets(). Market type:IRE WIN
06:31:12:453: Logging Excel bet results for:Brig (AvB) 13th Sep - 14:00 Namir v Guto
11:31:02:567: Excel trigger first market detected.
11:31:02:723: System.NullReferenceException: Object reference not set to an instance of an object.
at Betting_Assistant.StandardGrid.loadDisplaySettings()
11:31:03:098: Logging Excel bet results for:Brig 13th Sep - 14:00 5f Hcap

[GaryRussell]

Thanks. That's very useful.

Logging Excel bet results for:Good (AvB) 12th Sep - 14:00 PowerM v SatwaM

I think this might be where it is getting stuck. I am investigating.

[ians1711]

Gary
The VB code at this point has just set the appropriate refresh code in each of three tabs and then calls ba.openmarket to get the first market that I am interested in

Regards
Ian S

[GaryRussell]

07:02:30:078: System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'betfairTabPage'.
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 Betting_Assistant.Excel.ExcelUpdateThread()

This is very revealing. It confirms that the Excel thread is definitely busy because it caused an error when you closed the page. I had concerns that maybe it just thought the thread was busy. If you had the symbols file this would have output the exact line of code where the problem is. I will send you a version including the symbols file as soon as I can. I just need to make a few changes first.

[GaryRussell]

I have sent you a PM with a download link for the version containing the symbols file. Next time it happens with this version can you close the problem tab as before and then post the part of the log which looks like the following.

07:02:30:078: System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'betfairTabPage'.
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 Betting_Assistant.Excel.ExcelUpdateThread()

[ians1711]

Gary
Two tabs had hung this morning. However when I deleted and re-added the tabs, there were no errors reported to the log file. I will keep monitoring.

Ian S

[ians1711]

Gary
It has now happened on 2 days in succession. Yesterday one tab hung, today three tabs had hung. Still not getting any error messages logged when I delete and readd the tabs. Any other ideas??

Thanks
Ian S

[GaryRussell]

I'm going to have to find another way of diagnosing it. Leave it with me.