1 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hello,
we upgraded yesterday from 6.10 to 6.13.3.  In testing the Report Wizard, our users have had problems, particularly when using the Restrict to One or More Polygons. 

Experiments run by several users, on various pcs, with the following criteria:

Report Wizard criteria:
Rucksack open : "Protected Species - NEW" - cpntains 379 records
+ Taxon Records
+ Restrict to one or more Polygons - used a Parish
Taxa selection - used Current Rucksack - Select All

Results as follows:

Two users, using their own Recorder logins to test on pcs other than their own, got
    An essential sheet cannot be found in the current map dataset

Two users working on their own pcs got
    Error message including "exception class : EOutOfRangeError ----- exception message : Beyond System Limits…"



Another user on her own pc and Recorder login, with following criteria:

(no Rucksack open)
+ Taxon Records
+ Restrict to one or more Polygons - used a District
Taxa selection: Check List - eg Bat Conservation Trust list of UK bat names (2004) - all Taxa from list

Results:
    Yesterday, error message including "exception class : eOleException ------ exception message : Internal Query Processor Error: the query processor ran out of stack space during query optimization"
    Today, errored first thing, but OK since then

All find above criteria work fine when using criterion Select by Bounding Box instead of Polygon Filter (except where polygons not found at all - different problem)

Can anyone suggest what might be wrong here?  Any advice gratefully received.

Thanks,
Claire

(ps.  Complete text of error messages quoted above can be supplied to anyone who wants to see them)

2 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hi Claire,

With the EOutOfRangeError can I check that you have the base map sheet set up - beyond system limits may refer to grid refs outside the British National Grid - or the base map. It may be worth checking the grid refs on the section of the dataabase that the person with this error was working.

Internal Query Processor Error
Queries that contain a large number of arguments (thousands) inside an IN or a NOT IN clause may generate a stack overflow. This can also cause the system to crash. This is sounds very similiar to the post: http://forums.nbn.org.uk/viewtopic.php?pid=2991. I will ask Dorset Software where we are with getting to the bottom of this/fixing it.

I will ask Dorset to look at your post -sorry to have not been of more help.
Lynn

3 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hello Lynn,

thanks for response. 
I can confirm that the base map is set up and has not been changed since the upgrade.  I'm not clear how I should check grid refs in "the section of the database where <the user> was working" - not sure how to define section of database.  Sorry...

Queries with a large number of arguments - could you advise me how to tell numbers of arguments in a query/in an IN or NOT IN clause?  As far as I can guess, this should be a simple query, and should work on much the same basis as Restrict on Bounding Box - which works fine.   We've tried now with various different polygons, and none of them run successfully.

Incidentally, it happens the same on Windows 2000 and Windows XP Pro.

Any advice, from anyone, anywhere will be much appreciated, as some of our users are really seriously stuck without this one.  Thanks in advance!

Claire

4 Reply by SimonWood

  • SimonWood
  • Veteran
  • Offline
  • Registered: 09-09-2008
  • Posts: 63

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hi Claire,

I think the IN clause generated by the polygon search query reflects the number of samples that would have been found in the polygon. Can you try creating a small polygon, or perhaps even a polygon outside the area which you hold data for, then try the polygon report for this polyogn?  I'd expect the report to return very few, if any records.  If the error doesn't occur then it would seem that it is only caused when a polygon contains many thousands of samples - does this seem likely.

Recorder uses SQL 2000 & 2005 which are not true spatial databases, doing a polygon query is quite different to a bounding box query which can be simply done by looking at the latitude and longitude being in a certain range.

If you send me the error messages I'll be able to investigate further,

Thanks

Simon Wood
[url=http://www.dorsetsoftware.com/]Dorset Software Services[/url]

SimonWood's Website

5 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hello Simon,
further tests today, results as follows:
I created a new little polygon somewhere well away from anywhere we'd have records for.  Ran Report Wizard restricting to this new little polygon:
date/time         : 2009-02-02, 10:00:05, 758ms
computer name     : LCC54573
user name         : chigman
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 1 hour 30 minutes
program up time   : 5 minutes 2 seconds
processors        : 2x Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz
physical memory   : 1166/2038 MB (free/total)
free disk space   : (C:) 51.65 GB (G:) 16.50 GB
display mode      : 1024x768, 32 bit
process id        : $c50
allocated memory  : 20.89 MB
command line      : RecorderApp.exe /1705168
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOutOfRangeError
exception message : Beyond System Limits..

main thread ($1a0):
0057306f RecorderApp.exe SpatialRefFuncs   2249 LatLongToEastNorth
00573ab3 RecorderApp.exe SpatialRefFuncs   2603 LatLongToOSGBEastNorth
0056f7ba RecorderApp.exe SpatialRefFuncs    665 LatLongToSpecificEN
00576314 RecorderApp.exe SpatialRefFuncs   3730 GetPoint
00576377 RecorderApp.exe SpatialRefFuncs   3735 GridSquareToRegion
0071e58b RecorderApp.exe MapPolygonScanner  155 TPolygonScanner.CreateRgnFromSpatialRef
0071e64e RecorderApp.exe MapPolygonScanner  171 TPolygonScanner.CreateRgnFromSpatialRef
0071ed88 RecorderApp.exe MapPolygonScanner  294 TPolygonScanner.GetKeysForPolygon
0071e71b RecorderApp.exe MapPolygonScanner  206 TPolygonScanner.GetSamplesForPolygon
00867d78 RecorderApp.exe Wizard            3326 GetSamplesFromPolygons
0086856a RecorderApp.exe Wizard            3434 TdlgWizard.CheckSources
0086afc5 RecorderApp.exe Wizard            4020 TdlgWizard.BuildSpeciesReport
00867880 RecorderApp.exe Wizard            3215 TdlgWizard.FinishWizard
00861c51 RecorderApp.exe Wizard            1092 TdlgWizard.bbNextClick
004b4048 RecorderApp.exe Controls               TControl.Click
004a9160 RecorderApp.exe StdCtrls               TButton.Click
004a9254 RecorderApp.exe StdCtrls               TButton.CNCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b3c80 RecorderApp.exe Controls               TControl.Perform
004b7047 RecorderApp.exe Controls               DoControlMsg
004b769f RecorderApp.exe Controls               TWinControl.WMCommand
004d0754 RecorderApp.exe Forms                  TCustomForm.WMCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
7e41b8fe user32.dll                             SendMessageW
7e41f658 user32.dll                             CallWindowProcA
004b6ff3 RecorderApp.exe Controls               TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls               TControl.WMLButtonUp
004b43c6 RecorderApp.exe Controls               TControl.WMMouseMove
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
7e4196c2 user32.dll                             DispatchMessageA
004d4de3 RecorderApp.exe Forms                  TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                  TApplication.HandleMessage
004d1989 RecorderApp.exe Forms                  TCustomForm.ShowModal
0084ae02 RecorderApp.exe FilterResult       523 TfrmFilterResult.RunWizard
0084ad6c RecorderApp.exe FilterResult       505 TfrmFilterResult.WMRunWizard
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
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


A colleague also created a new polygon well away from our area, and ran the report wizard using it, and got:
date/time         : 2009-02-02, 11:27:07, 841ms
computer name     : LCC36860
user name         : econnor
operating system  : Windows 2000 Service Pack 4 build 2195
system language   : English
system up time    : 1 hour 33 minutes
program up time   : 1 hour 23 minutes
processor         : Intel(R) Pentium(R) 4 CPU 2.26GHz
physical memory   : 96/511 MB (free/total)
free disk space   : (C:) 28.63 GB (F:) 22.17 GB
display mode      : 1024x768, 16 bit
process id        : $6f4
allocated memory  : 23.68 MB
command line      : RecorderApp.exe /197002
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOutOfRangeError
exception message : Beyond System Limits..

main thread ($1ec):
0057306f RecorderApp.exe SpatialRefFuncs   2249 LatLongToEastNorth
00573ab3 RecorderApp.exe SpatialRefFuncs   2603 LatLongToOSGBEastNorth
0056f7ba RecorderApp.exe SpatialRefFuncs    665 LatLongToSpecificEN
00576314 RecorderApp.exe SpatialRefFuncs   3730 GetPoint
00576377 RecorderApp.exe SpatialRefFuncs   3735 GridSquareToRegion
0071e58b RecorderApp.exe MapPolygonScanner  155 TPolygonScanner.CreateRgnFromSpatialRef
0071e64e RecorderApp.exe MapPolygonScanner  171 TPolygonScanner.CreateRgnFromSpatialRef
0071ed88 RecorderApp.exe MapPolygonScanner  294 TPolygonScanner.GetKeysForPolygon
0071e71b RecorderApp.exe MapPolygonScanner  206 TPolygonScanner.GetSamplesForPolygon
00867d78 RecorderApp.exe Wizard            3326 GetSamplesFromPolygons
0086856a RecorderApp.exe Wizard            3434 TdlgWizard.CheckSources
0086afc5 RecorderApp.exe Wizard            4020 TdlgWizard.BuildSpeciesReport
00867880 RecorderApp.exe Wizard            3215 TdlgWizard.FinishWizard
00861c51 RecorderApp.exe Wizard            1092 TdlgWizard.bbNextClick
004b4048 RecorderApp.exe Controls               TControl.Click
004a9160 RecorderApp.exe StdCtrls               TButton.Click
004a9254 RecorderApp.exe StdCtrls               TButton.CNCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b3c80 RecorderApp.exe Controls               TControl.Perform
004b7047 RecorderApp.exe Controls               DoControlMsg
004b769f RecorderApp.exe Controls               TWinControl.WMCommand
004d0754 RecorderApp.exe Forms                  TCustomForm.WMCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
77e25044 user32.dll                             CallWindowProcW
7175264f comctl32.dll                           #413
77e1735c user32.dll                             SendMessageW
77e16b5f user32.dll                             CallWindowProcA
004b6ff3 RecorderApp.exe Controls               TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls               TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
77e15b72 user32.dll                             DispatchMessageA
004d4de3 RecorderApp.exe Forms                  TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                  TApplication.HandleMessage
004d1989 RecorderApp.exe Forms                  TCustomForm.ShowModal
0084ae02 RecorderApp.exe FilterResult       523 TfrmFilterResult.RunWizard
0084ad6c RecorderApp.exe FilterResult       505 TfrmFilterResult.WMRunWizard
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
77e25044 user32.dll                             CallWindowProcW
7175264f comctl32.dll                           #413
77e15b72 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


And I created a new polygon and linked it to a location; running the Occurrences for Places report gave 7 records for this location; running the Report Wizard using this polygon got:
date/time         : 2009-02-02, 11:59:19, 354ms
computer name     : LCC54573
user name         : chigman
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 3 hours 29 minutes
program up time   : 22 minutes 4 seconds
processors        : 2x Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz
physical memory   : 1345/2038 MB (free/total)
free disk space   : (C:) 51.65 GB (G:) 25.64 GB
display mode      : 1024x768, 32 bit
process id        : $ea4
allocated memory  : 25.63 MB
command line      : RecorderApp.exe /788406
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOutOfRangeError
exception message : Beyond System Limits..

main thread ($3ec):
0057306f RecorderApp.exe SpatialRefFuncs   2249 LatLongToEastNorth
00573ab3 RecorderApp.exe SpatialRefFuncs   2603 LatLongToOSGBEastNorth
0056f7ba RecorderApp.exe SpatialRefFuncs    665 LatLongToSpecificEN
00576314 RecorderApp.exe SpatialRefFuncs   3730 GetPoint
00576377 RecorderApp.exe SpatialRefFuncs   3735 GridSquareToRegion
0071e58b RecorderApp.exe MapPolygonScanner  155 TPolygonScanner.CreateRgnFromSpatialRef
0071e64e RecorderApp.exe MapPolygonScanner  171 TPolygonScanner.CreateRgnFromSpatialRef
0071ed88 RecorderApp.exe MapPolygonScanner  294 TPolygonScanner.GetKeysForPolygon
0071e71b RecorderApp.exe MapPolygonScanner  206 TPolygonScanner.GetSamplesForPolygon
00867d78 RecorderApp.exe Wizard            3326 GetSamplesFromPolygons
0086856a RecorderApp.exe Wizard            3434 TdlgWizard.CheckSources
0086afc5 RecorderApp.exe Wizard            4020 TdlgWizard.BuildSpeciesReport
00867880 RecorderApp.exe Wizard            3215 TdlgWizard.FinishWizard
00861c51 RecorderApp.exe Wizard            1092 TdlgWizard.bbNextClick
004b4048 RecorderApp.exe Controls               TControl.Click
004a9160 RecorderApp.exe StdCtrls               TButton.Click
004a9254 RecorderApp.exe StdCtrls               TButton.CNCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b3c80 RecorderApp.exe Controls               TControl.Perform
004b7047 RecorderApp.exe Controls               DoControlMsg
004b769f RecorderApp.exe Controls               TWinControl.WMCommand
004d0754 RecorderApp.exe Forms                  TCustomForm.WMCommand
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
7e41b8fe user32.dll                             SendMessageW
7e41f658 user32.dll                             CallWindowProcA
004b6ff3 RecorderApp.exe Controls               TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls               TControl.WMLButtonUp
004b43c6 RecorderApp.exe Controls               TControl.WMMouseMove
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls               TButtonControl.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
7e4196c2 user32.dll                             DispatchMessageA
004d4de3 RecorderApp.exe Forms                  TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                  TApplication.HandleMessage
004d1989 RecorderApp.exe Forms                  TCustomForm.ShowModal
0084ae02 RecorderApp.exe FilterResult       523 TfrmFilterResult.RunWizard
0084ad6c RecorderApp.exe FilterResult       505 TfrmFilterResult.WMRunWizard
004b3eb0 RecorderApp.exe Controls               TControl.WndProc
004b6f0f RecorderApp.exe Controls               TWinControl.WndProc
004ce7ad RecorderApp.exe Forms                  TCustomForm.WndProc
004b6b8c RecorderApp.exe Controls               TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                StdWndProc
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

Hope that tells you something useful!

If we can't find a way through this fairly quickly now, we're considering rolling back to 6.10.  Has anyone else done this, is there any advice on taking such an action?

Many thanks in anticipation,
Claire

6 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hi,
just in case of interest - I've also tried the XML reporting today.  Hopes dashed.  Reporting on anything except polygons - fine.  Any of the reports based on polygons fails with the same EOutOfRangeError: Beyond System Limits as reported above - full error message below.
Thanks,
Claire

(XML report P1 Summary by Polygon – using a new, small, unlinked polygon:)

date/time         : 2009-02-03, 09:47:37, 707ms
computer name     : LCC54573
user name         : chigman
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 1 hour 13 minutes
program up time   : 57 minutes 28 seconds
processors        : 2x Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz
physical memory   : 1350/2038 MB (free/total)
free disk space   : (C:) 51.60 GB (G:) 24.53 GB
display mode      : 1024x768, 32 bit
process id        : $460
allocated memory  : 23.28 MB
command line      : RecorderApp.exe /197952
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOutOfRangeError
exception message : Beyond System Limits..

main thread ($594):
0057306f RecorderApp.exe SpatialRefFuncs     2249 LatLongToEastNorth
00573ab3 RecorderApp.exe SpatialRefFuncs     2603 LatLongToOSGBEastNorth
0056f7ba RecorderApp.exe SpatialRefFuncs      665 LatLongToSpecificEN
00576314 RecorderApp.exe SpatialRefFuncs     3730 GetPoint
00576377 RecorderApp.exe SpatialRefFuncs     3735 GridSquareToRegion
0071e58b RecorderApp.exe MapPolygonScanner    155 TPolygonScanner.CreateRgnFromSpatialRef
0071e64e RecorderApp.exe MapPolygonScanner    171 TPolygonScanner.CreateRgnFromSpatialRef
0071ed88 RecorderApp.exe MapPolygonScanner    294 TPolygonScanner.GetKeysForPolygon
0071e71b RecorderApp.exe MapPolygonScanner    206 TPolygonScanner.GetSamplesForPolygon
009435aa RecorderApp.exe CRFrmParametersUnit 3046 GetItemsFromPolygons
00943791 RecorderApp.exe CRFrmParametersUnit 3086 TPolygonSelection.ReadItemsInPolygon
009438a9 RecorderApp.exe CRFrmParametersUnit 3110 TfrmParameters.SetupPolygonResults
0093f4b3 RecorderApp.exe CRFrmParametersUnit 1589 TfrmParameters.PutSingleInputValuesIntoParam
0093e267 RecorderApp.exe CRFrmParametersUnit 1055 TfrmParameters.PutInputValuesIntoParam
0093e7bc RecorderApp.exe CRFrmParametersUnit 1213 TfrmParameters.ProcessParams
0093e0dd RecorderApp.exe CRFrmParametersUnit 1006 TfrmParameters.btnOKClick
004b4048 RecorderApp.exe Controls                 TControl.Click
004a9160 RecorderApp.exe StdCtrls                 TButton.Click
004a9254 RecorderApp.exe StdCtrls                 TButton.CNCommand
004b3eb0 RecorderApp.exe Controls                 TControl.WndProc
004b6f0f RecorderApp.exe Controls                 TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                 TButtonControl.WndProc
004b3c80 RecorderApp.exe Controls                 TControl.Perform
004b7047 RecorderApp.exe Controls                 DoControlMsg
004b769f RecorderApp.exe Controls                 TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls                 TControl.WndProc
004b6f0f RecorderApp.exe Controls                 TWinControl.WndProc
004b6b8c RecorderApp.exe Controls                 TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                  StdWndProc
7e41b8fe user32.dll                               SendMessageW
7e41f658 user32.dll                               CallWindowProcA
004b6ff3 RecorderApp.exe Controls                 TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls                 TControl.WMLButtonUp
004b43c6 RecorderApp.exe Controls                 TControl.WMMouseMove
004b3eb0 RecorderApp.exe Controls                 TControl.WndProc
004b6f0f RecorderApp.exe Controls                 TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                 TButtonControl.WndProc
004b6b8c RecorderApp.exe Controls                 TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                  StdWndProc
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

7 Reply by SimonWood

  • SimonWood
  • Veteran
  • Offline
  • Registered: 09-09-2008
  • Posts: 63

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hi Claire,

When viewing the map screen in Recorder can you confirm that when selecting a polygon the spatial reference label is populated with a true value rather than the text  'Beyond System Limits'.   It sounds like the polygons are outside the region of the UK's national grid.  Are the polyogns you're using on the Uk's landmass?

Thanks,

Simon Wood
[url=http://www.dorsetsoftware.com/]Dorset Software Services[/url]

SimonWood's Website

8 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Hello Simon,

the polygons are in Leicestershire/Rutland. Definitely UK landmass! 
How do I check the spatial reference label of a polygon?  In the Spatial Ref field at the bottom of the map window, it is displaying values like "SK4959012582" - is that what you need?

The base maps and the polygons being used are all the ones that were in use before our upgrade to 6.13 a fortnight ago, and the Restrict to ...Polygons was working fine with them then.

Thanks,
Claire

9 Reply by CH

  • CH
  • Member
  • Offline
  • Registered: 24-10-2008
  • Posts: 15

Re: Report Wizard problems - with Polygon Filters? - in R.6.13.3

Dear all,

Just to let you know - A Solution Has Been Found!!

Many thanks to Sally Rankin and Mike Weideli, who came to the conclusion that we had a data problem and told me how to find it.  We had one Survey_Event and its related Sample, which had Spatial Reference of UK (instead of a normal grid ref like SK412945 or something).  This works out its own lat/long - and these were of course way outside what is normal.  Hence our Beyond System Limits error. 
(Simon - you were on these lines too, but as it was only one record, I didn't happen to find it and didn't know to look further, or how. Thanks.)

I found these records via the Access .mdb and looking in the Sample and Survey_Event tables.  Then we used the Survey_Event_Key and Recorder's Go To add-in to fetch up the records.  Editing the Spatial Reference to a sensible gridref value seems to have cured the problem.

These records must have been like this since at least 2006 (last edited). Presumably previous versions of Recorder coped (or ignored them), but the shiny new version recognised them as problems for the Polygon restriction.

Best wishes to all,
Claire