1 Reply by Darwyn Sumner (LERC)

  • Darwyn Sumner (LERC)
  • Veteran
  • Offline
  • Registered: 07-06-2006
  • Posts: 176

Re: Filter errors on Location

I get the following error message on every attempt to filter on Locations:
Exception occurred in application Recorder 6 at 30/08/2006 14:22:10.
Version : 6.6.8.59

Exception path:
EOleException : Internal Query Processor Error: The query processor ran out of stack space during query optimization

Last event\actions:
  TfrmLocations destroyed
  TfrmLocations deactivated
  TfrmObservations activated
  actLocations invoked
  TfrmLocations created
  TfrmObservations deactivated
  TfrmLocations activated
  TfrmLocationDetails created
  TfrmLocationDetails destroyed

Operating System : Windows 2000  5.00.2195  Service Pack 4
Physical Memory available : 523,252 KB

DLLs loaded:
  advapi32.dll (5.0.2195.7038)
  comctl32.dll (5.81.4916.400)
  comdlg32.dll (5.0.3700.6693)
  gdi32.dll (5.0.2195.7073)
  HHCtrl.ocx (5.2.3790.309)
  kernel32.dll (5.0.2195.7006)
  mpr.dll (5.0.2195.6824)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1062.0)
  ole32.dll (5.0.2195.7059)
  oleaut32.dll (2.40.4522.0)
  shell32.dll (5.0.3900.7080)
  user32.dll (5.0.2195.7032)
  version.dll (5.0.2195.6623)
  winmm.dll (5.0.2161.1)
  winspool.drv (5.0.2195.6659)

Information has been saved to the file F:\LRC\Recorder6Server\LastError.txt

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Filter errors on Location

Darwyn,

Could you post details of exactly what filter you're running to produce this error. Also, how many locations do you have?

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by brianmiller

  • brianmiller
  • Veteran
  • Offline
  • Registered: 10-05-2006
  • Posts: 113

Re: Filter errors on Location

Did a resolution to this arise please?

The reason being that I have been doing some importing of data (test at this stage thankfully) from another Recorder 6 and when I go to Display Unchecked records I get the following similar error message and it fails to display any of the taxon occurrences, but will allow me to get down to the level before in the Obs Hierarchy.

Exception occurred in application Recorder 6 at 16/06/2008 15:28:27.
Version : 6.10.4.120

Exception path:
EOleException : Internal Query Processor Error: The query processor ran out of stack space during query optimization

Last event\actions:
  TdlgContainer activated
  TfrmSurveyDetails destroyed
  TfrmSurveyDetails created
  TdlgContainer deactivated
  TdlgContainer destroyed
  TfrmSurveyDetails destroyed
  TfrmEventDetails created
  TfrmEventDetails destroyed
  TfrmSampleDetails created

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,308,656 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3316)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3266)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

In terms of number of locations, it has 4,169, Names and Addresses: 3,346, Refs.: 405, Surveys: 331, Spp. Obs.: 375,937 and Hab. Obs.: 6,407.

Is it anything to do with the amount of RAM?

Cheers

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

brianmiller's Website

4 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Filter errors on Location

Are you using SQL Server 2005? If so it may be a good idea to download the latest service pack:
http://support.microsoft.com/kb/943656/LN/

Hope that helps,

John van Breda
Biodiverse IT

johnvanbreda's Website

5 Reply by brianmiller

  • brianmiller
  • Veteran
  • Offline
  • Registered: 10-05-2006
  • Posts: 113

Re: Filter errors on Location

Hi John,

No, this was a standalone install, up to the latest released version, using the MSDE instance.

Graham Hawker at the Thames Valley ERC also has this error when trying to show unchecked items.

Any other ideas?

Thanks

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

brianmiller's Website

6 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Filter errors on Location

Looks like it might be related to this: http://support.microsoft.com/kb/288095

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

7 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Filter errors on Location

Without testing against your data I can't be sure, but there have been improvements made to version 6.13 in this area so hopefully it will be fixed when that is released.

John van Breda
Biodiverse IT

johnvanbreda's Website

8 Reply by brianmiller

  • brianmiller
  • Veteran
  • Offline
  • Registered: 10-05-2006
  • Posts: 113

Re: Filter errors on Location

The bit where the MS article syas:

In some cases, SQL Server may actually shutdown as a result of the stack overflow.

Is a bit worrying in terms of the eventual data being on out SQL server instead of the msde standalone version as our membership database is held on the SQL server too. Myabe though this an msde only problem.

Would you recommend us waiting for the new update before pursuing this further John?

Thanks

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

brianmiller's Website