Re: Using WCA1 Report
I have just tried to get a list of records for the Andrena taxon from Rec 3.3 checklist and the WCA1 Report crashed with the following error (this report works fine for a species e.g. Andrena bicolor, but not for the genus):
date/time : 2009-04-15, 10:03:02, 421ms
computer name : WS10
user name : slawsoc
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 2 hours 4 minutes
program up time : 51 seconds
processors : 2x Intel(R) Pentium(R) 4 CPU 3.00GHz
physical memory : 532/1023 MB (free/total)
free disk space : (C:) 2.14 GB (R:) 22.54 GB
display mode : 1600x1200, 32 bit
process id : $a84
allocated memory : 24.40 MB
command line : RecorderApp.exe /4391140
executable : RecorderApp.exe
exec. date/time : 2008-11-04 09:45
version : 6.13.3.182
madExcept version : 2.7h
exception class : TExceptionPath
exception message : An error occurred executing the following SQL: CREATE UNIQUE CLUSTERED INDEX IX_OCCURRENCE_KEY ON "#REPORT_OUTPUT" (OCCURRENCE_KEY, [TYPE]).
main thread ($f14):
007ad423 RecorderApp.exe ReportGenerator 958 TReportGenerator.ExecuteSQL
007ab2bf RecorderApp.exe ReportGenerator 621 TReportGenerator.CreateReportTableIndexes
007a9560 RecorderApp.exe ReportGenerator 268 TReportGenerator.PrepareTable
007af19e RecorderApp.exe WizardData 315 TdmWizard.PrepareOutput
0084afa8 RecorderApp.exe FilterResult 562 TfrmFilterResult.UpdateResults
0084ee37 RecorderApp.exe FilterResult 1705 TfrmFilterResult.RunReportWithFilter
0084a721 RecorderApp.exe FilterResult 367 TfrmFilterResult.CreateAndRunWithFilter
00920a36 RecorderApp.exe Maintbar 2004 TfrmMain.QuickReportClick
004c5a96 RecorderApp.exe Menus TMenuItem.Click
004c6d33 RecorderApp.exe Menus TMenu.DispatchCommand
004c7aba RecorderApp.exe Menus TPopupList.WndProc
004c7a09 RecorderApp.exe Menus TPopupList.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
Exception Stack
----------------
EOleException : The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.#REPORT_OUTPUT______________________________________________________________________________________________________000000000021' and the index name 'IX_OCCURRENCE_KEY'. The duplicate key value is (MMEEE3MPEEE5QQOK, T)
Staffordshire Ecological Record