1 Reply by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 325

Re: Report Wizard > Export to ESRI Shape File

Report Wizard > Report Output > Export to ESRI Shape File..........If I run a report with more than about 400 records with attributes selected of Taxon Latin Name, Taxon Common Name, Sample Location Name, Sample Location, Sample Longitude, Sample Latitude, Sample date, Sample spatial ref,) I get an unhandled error, the full text of which appears below. As you can see, the message refers to the spatial refence system not being recognised. The routine works fine with a small number of records. I want it to work with about 100,000 records.
Is anybody out there using the Report Wizard to link with GIS in this way? Can anyone throw any light on this problem?

The LastError.txt file is below

date/time         : 2010-05-06, 12:56:10, 83ms
computer name     : DMBC66641
user name         : BobMa
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 5 hours 53 minutes
program up time   : 1 hour 44 minutes
processor         : Intel(R) Pentium(R) 4 CPU 2.80GHz
physical memory   : 261/1534 MB (free/total)
free disk space   : (C:) 11.57 GB
display mode      : 1024x768, 32 bit
process id        : $b4c
allocated memory  : 23.48 MB
command line      : RecorderApp.exe /6422730
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 09:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : ESpatialRefError
exception message : The spatial reference system cannot be recognised..

main thread ($9fc):
0057dc85 RecorderApp.exe 
7e4196c2 user32.dll       DispatchMessageA

modules:
00350000 C4DLL.DLL             1.0.0.1          C:\Program Files\Recorder 6
003c0000 MS5User.Dll           5.0.0.4          C:\Program Files\Recorder 6
00400000 RecorderApp.exe       6.14.5.218       C:\Program Files\Recorder 6
01200000 ms5cnv.dll            5.0.0.10         C:\Program Files\Recorder 6
01af0000 odbcint.dll           3.525.1132.0     C:\WINDOWS\system32
02930000 xpsp2res.dll          5.1.2600.5512    C:\WINDOWS\system32
034f0000 SQLOLEDB.RLL          2000.85.1132.0   C:\Program Files\Common Files\System\OLE DB
03500000 msadcer.dll           2.81.1132.0      C:\Program Files\Common Files\System\MSADC
03840000 GOTOGR~1.OCX          2.0.0.16         C:\PROGRA~1\RECORD~1\Addins
03a00000 GoToKey.ocx           6.0.1.10         C:\PROGRA~1\RECORD~1\Addins
03c20000 PHENOL~1.OCX          6.0.1.10         C:\PROGRA~1\RECORD~1\Addins
03f30000 SHOWUN~1.OCX          6.0.0.13         C:\PROGRA~1\RECORD~1\Addins
04160000 STDVAL~1.DLL          6.14.3.208       C:\PROGRA~1\RECORD~1\Addins
04360000 SURVEY~1.OCX          6.0.0.29         C:\PROGRA~1\RECORD~1\Addins
07160000 Audiodev.dll          5.2.5721.5145    C:\WINDOWS\system32
10000000 MS5.Dll               5.0.0.12         C:\Program Files\Recorder 6
10930000 PortableDeviceApi.dll 5.2.5721.5145    C:\WINDOWS\system32
11c70000 WMASF.DLL             11.0.5721.5238   C:\WINDOWS\system32
15110000 WMVCore.DLL           11.0.5721.5265   C:\WINDOWS\system32
16210000 wpdshext.dll          5.2.5721.5145    C:\WINDOWS\system32
20000000 xpsp3res.dll          5.1.2600.5512    C:\WINDOWS\system32
4dd00000 sqloledb.dll          2000.85.1132.0   C:\Program Files\Common Files\System\OLE DB
4de10000 msado15.dll           2.81.1132.0      C:\Program Files\Common Files\System\ADO
4ec50000 gdiplus.dll           5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
5ad70000 uxtheme.dll           6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll          5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll          5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll          5.1.2600.5512    C:\WINDOWS\system32
605d0000 mslbui.dll            5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll           2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
68000000 rsaenh.dll            5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll            5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll            4.20.9870.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL          2000.85.1132.0   C:\WINDOWS\system32
6fa00000 SOPHOS~1.DLL          9.0.0.9055       C:\PROGRA~1\Sophos\SOPHOS~1
71aa0000 WS2HELP.dll           5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll            5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll           5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll               5.1.2600.5512    C:\WINDOWS\system32
71bf0000 SAMLIB.dll            5.1.2600.5512    C:\WINDOWS\System32
71c10000 ntlanman.dll          5.1.2600.5512    C:\WINDOWS\System32
71c80000 NETRAP.dll            5.1.2600.5512    C:\WINDOWS\System32
71c90000 NETUI1.dll            5.1.2600.5512    C:\WINDOWS\System32
71cd0000 NETUI0.dll            5.1.2600.5512    C:\WINDOWS\System32
71d40000 actxprxy.dll          6.0.2900.5512    C:\WINDOWS\system32
71f80000 security.dll          5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv          5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll           2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
73b30000 mscms.dll             5.1.2600.5627    C:\WINDOWS\system32
74060000 msadce.dll            2.81.3002.0      C:\Program Files\Common Files\System\MSADC
74320000 odbc32.dll            3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll             5.1.2600.5512    C:\WINDOWS\system32
74ae0000 CFGMGR32.dll          5.1.2600.5512    C:\WINDOWS\system32
74b80000 printui.dll           5.1.2600.5512    C:\WINDOWS\system32
74cd0000 DBmsLPCn.dll          2000.80.760.0    C:\WINDOWS\system32
750b0000 RESUTILS.DLL          5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL            2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL           2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL          2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
754d0000 CRYPTUI.dll           5.131.2600.5512  C:\WINDOWS\system32
75f60000 drprov.dll            5.1.2600.5512    C:\WINDOWS\System32
75f70000 davclnt.dll           5.1.2600.5512    C:\WINDOWS\System32
75f80000 browseui.dll          6.0.2900.5512    C:\WINDOWS\system32
76390000 imm32.dll             5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll          6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL            2.81.1132.0      C:\WINDOWS\system32
76600000 CSCDLL.dll            5.1.2600.5512    C:\WINDOWS\System32
76620000 comsvcs.dll           2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll          6.0.2900.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll           5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll          5.1.2600.5721    C:\WINDOWS\system32
76980000 LINKINFO.dll          5.1.2600.5512    C:\WINDOWS\system32
76990000 ntshrui.dll           5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll           5.1.2600.5512    C:\WINDOWS\system32
76b20000 ATL.DLL               3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll             5.1.2600.5512    C:\WINDOWS\system32
76bf0000 PSAPI.DLL             5.1.2600.5512    C:\WINDOWS\system32
76c30000 WINTRUST.dll          5.131.2600.5512  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll          5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL           5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll          5.1.2600.5512    C:\WINDOWS\system32
76e10000 adsldpc.dll           5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll            5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll           5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL           2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll            2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll          5.1.2600.5512    C:\WINDOWS\system32
771b0000 WININET.dll           6.0.2900.5897    C:\WINDOWS\system32
773d0000 comctl32.dll          6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll             5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll          5.1.2600.5512    C:\WINDOWS\system32
77a20000 cscui.dll             5.1.2600.5512    C:\WINDOWS\System32
77a80000 crypt32.dll           5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll            5.1.2600.5875    C:\WINDOWS\system32
77b40000 appHelp.dll           5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll           5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll            7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll            5.1.2600.5512    C:\WINDOWS\system32
77cc0000 ACTIVEDS.dll          5.1.2600.5512    C:\WINDOWS\system32
77dd0000 advapi32.dll          5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll            5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll             5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll           6.0.2900.5512    C:\WINDOWS\system32
77fe0000 Secur32.dll           5.1.2600.5753    C:\WINDOWS\system32
7c800000 kernel32.dll          5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll             5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll           6.0.2900.5512    C:\WINDOWS\system32
7e290000 shdocvw.dll           6.0.2900.5897    C:\WINDOWS\system32
7e410000 user32.dll            5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx            5.2.3790.4110    C:\WINDOWS\system32
7e540000 UNIDRV.DLL            0.3.6001.22116   C:\WINDOWS\System32\spool\DRIVERS\W32X86\3
7e5a0000 UNIDRVUI.DLL          0.3.6000.20691   C:\WINDOWS\System32\spool\DRIVERS\W32X86\3
7e720000 SXS.DLL               5.1.2600.5512    C:\WINDOWS\system32

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website

2 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Report Wizard > Export to ESRI Shape File

I suspect you have empty entries in the Spatial_reference_system column of your Sample table.
Alternatively you might have Northern Ireland references within it, which might create conflict.

You'll need to set empty values to 'OSGB' assuming they are GB references.

M

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

3 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Report Wizard > Export to ESRI Shape File

There was a problem with disappearing Spatial Reference System values which caused this error message, although it mostly affected me regarding locations, and I believe it was fixed in 6.14 (still with 6.13 here so can't confirm that). Might make a difference whether the error message appears before the table of search results comes up, or afterwards and only when you attempt the export.

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

4 Reply by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 325

Re: Report Wizard > Export to ESRI Shape File

Thanks Matt, Gordon - I will look into this further.....

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website