1 Reply by Alistair Kirk

  • Alistair Kirk
  • Member
  • Offline
  • From: Pirbright, Surrey
  • Registered: 08-06-2006
  • Posts: 28

Re: Recorder 6 Crashes When Reporting Using Selected Designation Sets

Can anyone shed any light on the following crash. It happens whn I try to include some (but not all) designation sets or statuses in a report. I say some becuase if I include "W&C Act" or "BAP 2007" the report runs successfully. If I include "Nationally Rare, Notable, Scarce" I get the following error message.

The effect is the same if I select the individual statuses which make up the designation set.

Reproducable on a networked machine running 6.14.4 and Dictionary J and a stand alone machine running 6.15.4 and Dictionary P.

Many Thanks

Alistair Kirk
Record Centre Manager
Surrey Biodiversity Information Centre




date/time         : 2010-08-18, 13:34:19, 834ms
computer name     : SHIELDBUG
user name         : akirk
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 3 hours 59 minutes
program up time   : 7 minutes 18 seconds
processor         : Intel(R) Pentium(R) 4 CPU 2.80GHz
physical memory   : 400/1022 MB (free/total)
free disk space   : (C:) 17.16 GB (H:) 33.42 GB
display mode      : 1280x1024, 32 bit
process id        : $cb4
allocated memory  : 18.07 MB
command line      : RecorderApp.exe /12322258
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 13:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : TExceptionPath
exception message : An error occurred executing the following SQL: SELECT Distinct Taxon_Occurrence.Taxon_Occurrence_Key AS Occurrence_Key, 'T' AS Type, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SURVEY_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SURVEY_EVENT_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SAMPLE_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as LIST_ITEM_KEY , Convert(varchar(40), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Spatial_Ref], Convert(varchar(4), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Spatial_Ref_System], Convert(float, Null)  as [Sample_Lat], Convert(float, Null)  as [Sample_Long], Convert(varchar(20), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample 1 km Square], Convert(Integer, Null)  as [Sample_Vague_Date_Start], Convert(Integer, Null)  as [Sample_Vague_Date_End], Convert(varchar(2), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Vague_Date_Type], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Location], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Location Name], Convert(int, Null)  as [Sample Year], Convert(varchar(8000), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Recorders], Convert(varchar(75), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Common Name], Convert(varchar(75), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Latin Name], Convert(varchar(30), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Recommended Taxon Sort Order], Convert(varchar(50), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Group], Convert(VARCHAR(1000), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Statuses of Nationally: Rare, Notable, Scarce - Short Names] into "#REPORT_OUTPUT" From ((Taxon_Occurrence LEFT JOIN Sample ON Taxon_Occurrence.sample_Key = Sample.Sample_Key ) LEFT JOIN Survey_Event ON Survey_Event.Survey_Event_Key = Sample.Survey_Event_Key ) LEFT JOIN Survey ON Survey.Survey_Key = Survey_Event.Survey_Key WHERE Survey.Survey_Key NOT IN (SELECT Survey_Key FROM User_Survey_Restriction USR WHERE USR.Name_Key = 'THU00004000000Z3') AND (Sample.Sample_Key IN (SELECT RecordKey FROM #Templist)).

main thread ($ccc):
008978d0 RecorderApp.exe 
7e4196c2 user32.dll       DispatchMessageA

thread $c9c:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7e4195f3 user32.dll    MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll    MsgWaitForMultipleObjects
>> created by main thread ($ccc) at:
4ec67b7f gdiplus.dll   

thread $524:
7c90e514 ntdll.dll   KiFastSystemCallRet
7c90daa8 ntdll.dll   NtReplyWaitReceivePortEx
>> created by main thread ($ccc) at:
77e7df36 RPCRT4.dll 

thread $c78:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $d04:
7c90e514 ntdll.dll   KiFastSystemCallRet
7c90daa8 ntdll.dll   NtReplyWaitReceivePortEx
>> created by thread $524 at:
77e7df36 RPCRT4.dll 

modules:
00340000 C4DLL.DLL         1.0.0.1          H:
003b0000 MS5User.Dll       5.0.0.4          H:
00400000 RecorderApp.exe   6.14.4.212       H:
01180000 ms5cnv.dll        5.0.0.10         H:
01a70000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
028c0000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
03490000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\OLE DB
034a0000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\MSADC
03890000 GoToKey.ocx       6.0.1.10         H:\Addins
03ab0000 ShowUnchecked.ocx 6.0.0.13         H:\Addins
03cc0000 StdValLib.dll     6.14.3.208       H:\Addins
03ea0000 SurveyDelete.ocx  6.0.0.25         H:\Addins
04470000 msader15.dll      2.81.1132.0      C:\Program Files\Common Files\System\ADO
10000000 MS5.Dll           5.0.0.12         H:
16080000 mdnsNSP.dll       1.0.6.2          C:\Program Files\Bonjour
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
60e30000 MSDATL3.dll       2.81.1132.0      C:\Program Files\Common Files\System\OLE DB
662b0000 hnetcfg.dll       5.1.2600.5512    C:\WINDOWS\system32
69b10000 msxml4.dll        4.20.9876.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL      2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll       5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll      5.1.2600.5512    C:\WINDOWS\System32
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
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
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
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
755c0000 msctfime.ime      5.1.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
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
76620000 comsvcs.dll       2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll      6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll      5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll       5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll       5.1.2600.5512    C:\WINDOWS\system32
76b40000 winmm.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
76f20000 DNSAPI.dll        5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll       5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll        5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.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
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
77a80000 crypt32.dll       5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll        5.1.2600.5875    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.5876    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.5912    C:\WINDOWS\system32
77fe0000 Secur32.dll       5.1.2600.5834    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.6018    C:\WINDOWS\system32
7e410000 user32.dll        5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx        5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL           5.1.2600.5512    C:\WINDOWS\system32

Exception Stack

----------------
EOleException : Parameter object is improperly defined. Inconsistent or incomplete information was provided

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Recorder 6 Crashes When Reporting Using Selected Designation Sets

Alistair

This isn't the SQL, but something which is happening when Recorder display the report. The problem is caused by the colon in the name of the Taxon_Designation_Set, The easiest thing to do for the moment  is to change the name of  the set in the Taxon_designation_set table. (eg. to Statuses of Nationally- Rare, Notable, Scarce ). Edit it either in MSAccess or in SQL Server tools and remove or replace the colon.  This seems to fix the problem.

Mike

Mike Weideli

MikeWeideli's Website

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Recorder 6 Crashes When Reporting Using Selected Designation Sets

This problem is linked with topic  http://forums.nbn.org.uk/viewtopic.php?id=1306. Both are the result of having colons in the output column of the report. The problems detailed in topic 1306 can be temporarily fixed by making some minor alterations in the The Report_Field and Report_Attribute table. In the Report_Field table you need to remove the colons from  Field_Item_Name and in the Report_attribute_table you need to alter the Attribute SQL field to remove the colon where appropriate. If you try this please take care and make sure you have a backup.

Mike

Mike Weideli

MikeWeideli's Website

4 Reply by johnvanbreda

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

Re: Recorder 6 Crashes When Reporting Using Selected Designation Sets

FYI, I have fixed this problem in the code now so it will accept colons in the report output columns in the next release of Recorder.
Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website