Hello Lynn et al,
sorry for long delay...
sadly not best news. We have upgraded to Recorder 6.13.3, and we have upgraded to ShowUnchecked v.6.0.0.13, and we are still getting the error reported above. Happening on more than one pc, and happening consistently, like every time. You run the Addin, and it tries to display the Survey hierarchy but goes to white-screen for ages; when it finally displays Survey hierarchy you can only navigate one or two levels down before it errors with the error message. (Full details at end of this post.)
These are new pcs, with 2GB of RAM, and I've expanded the virtual memory on one of them as well and even that doesn't help. Database on SQL Server 2000. I know there are a lot (a LOT) of unchecked records in the database, but I thought the limit in previous versions of R6 (as per post referenced by Charles above) had been removed in 6.13?
If not, and see also Microsoft KB article http://support.microsoft.com/kb/288095 as referenced from that previous post, is there any chance of Dorset amending the way ShowUnchecked works, eg to use a temp table or whatever, so it doesn't fall into this trap?
Or any other ideas or pointers, anyone? will be very much appreciated!
Thanks in advance,
Claire
Full error message:
date/time : 2009-02-11, 16:49:03, 532ms
computer name : LCC57006
user name : chigman
operating system : Windows XP Service Pack 2 build 2600
system language : English
system up time : 22 minutes 33 seconds
program up time : 12 minutes 58 seconds
processors : 2x Intel(R) Pentium(R) Dual CPU E2180 @ 2.00GHz
physical memory : 1573/2002 MB (free/total)
free disk space : (C:) 60.33 GB (F:) 12.58 GB
display mode : 1024x768, 32 bit
process id : $d64
allocated memory : 24.59 MB
command line : RecorderApp.exe /721050
executable : RecorderApp.exe
exec. date/time : 2008-11-04 08:45
version : 6.13.3.182
madExcept version : 2.7h
exception class : EOleException
exception message : Internal Query Processor Error: The query processor ran out of stack space during query optimization.
main thread ($e08):
0055fd9e RecorderApp.exe ADODB TADOCommand.Execute
0055fcf8 RecorderApp.exe ADODB TADOCommand.Execute
0055fcd8 RecorderApp.exe ADODB TADOCommand.Execute
0062ba94 RecorderApp.exe DatabaseAccessADO 909 TdmDatabase.ExecuteSQL
007994d7 RecorderApp.exe Observations 1754 TfrmObservations.PopulateSampleLevel
0079b60e RecorderApp.exe Observations 1972 TfrmObservations.tvObservationsExpanding
00594a5d RecorderApp.exe RapTree 4799 TCustomRapidTree.CanExpand
005958fb RecorderApp.exe RapTree 5567 TFlyNode.DoCanExpand
00595f7c RecorderApp.exe RapTree 5763 TFlyNode.ExpandItem
005916a0 RecorderApp.exe RapTree 2995 TCustomRapidTree.MouseDown
006fb2cf RecorderApp.exe KeyboardRapidTree 192 TKeyboardRapidTree.MouseDown
004b411e RecorderApp.exe Controls TControl.DoMouseDown
004b416a RecorderApp.exe Controls TControl.WMLButtonDown
00585875 RecorderApp.exe exgrid 4342 TCustomExGrid.WMLButtonDown
00590555 RecorderApp.exe RapTree 2388 TCustomRapidTree.WMLButtonDown
004b3eb0 RecorderApp.exe Controls TControl.WndProc
004b6f0f RecorderApp.exe Controls TWinControl.WndProc
00590f7f RecorderApp.exe RapTree 2714 TCustomRapidTree.WndProc
004b6b8c RecorderApp.exe Controls TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes StdWndProc
7e41c660 user32.dll CallWindowProcW
5d095fdf comctl32.dll DefSubclassProc
7e4196c2 user32.dll DispatchMessageA
004d4de3 RecorderApp.exe Forms TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms TApplication.HandleMessage
004d503a RecorderApp.exe Forms TApplication.Run
0099f832 RecorderApp.exe RecorderApp 317 initialization
