1

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)

Craig Slawson
Staffordshire Ecological Record