Welcome

**MikeWeideli** · 19-12-2012 14:32:51

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Topic: Recorder 6.18.1 - Release Candidate

Upgrade 6.18.1 is now available as a ReleaseCandidate at www.Recorder6.Info/UpgradeKitfrom6.14to618Build259RC.zip . Also available is the associated Dictionary Upgrade www.Recorder6.info/00000015,16,17,18,19,1A.zip . Details on installing the upgrades togther with the release notes are available at www.Recorder6.info/R6v618ReleaseNotesRC.doc . Please download and read the release notes before installing the upgrades.

The Release Candidate is a version of the Recorder 6 upgrade (Version 6.18 build 259) which has been tested and which we believe to be in its final form, but which we would like to have installed on a few systems before making it more generally available. If you install the release candidate then you may need to run the final upgrade version when it becomes available on the JNCC web site.

The Dictionary update populates the new Organism table and will take a long time to run (typically 2 hours, but possibly much more). See the release notes for more information.

Mike Weideli

**RobLarge** · 20-12-2012 08:52:53

RobLarge
Veteran
Offline

From: Wiltshire
Registered: 15-07-2008
Posts: 812

Re: Recorder 6.18.1 - Release Candidate

I have installed the ugrade and the dictionary updates and it seems to work, but I will keep watching.

I did have a problem initially though. The installer failed the first time I tried, producing the following error:

exception class : EDBUpgraderError
exception message : Error occurred running script 0000008Q.sql. The error is described as: Violation of PRIMARY KEY constraint 'PK_USABLE_TABLE'. Cannot insert duplicate key in object 'USABLE_TABLE'.

I tried a second time to no avail, but then I ran the script 8Q manually using management studio to track down the error details. It was being caused by trying to insert a key which begain LC000021 (so that must be something we had got from Mike in the past). Anyway the second time I attemtped to run 8Q manually it worked, so I assume that something later on in the script removed the offending key, allowing it to work properly.

After that the installer ran through without errors and I am now updating the indexes.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

**RobLarge** · 20-12-2012 09:12:04

RobLarge
Veteran
Offline

From: Wiltshire
Registered: 15-07-2008
Posts: 812

Re: Recorder 6.18.1 - Release Candidate

I have just noticed something odd though. After the upgrade there is now an entry in the locations hierarchy called Vice-counties, with all the vice-counties as subsites of it. I had never noticed this being visible before.

Is this something deliberate. or was it unintended?

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

**MikeWeideli** · 20-12-2012 09:28:40

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Script 8Q is doing the delete in the wrong order. Only affects anyone who has loaded my scripts previously.

As far as I know the Vice Counties have always been there. Nothing we have done has added to or changed this either in the application or the Dictionary upgrade

Mike Weideli

**nmrs** · 20-12-2012 09:45:09

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Mike, I've not tested the RC here on the NMRS but I do have a question. For ID 206 Allow the output of Eastings and Northings for Sample from Report Wizard; will these new report attributes use the same keys as per http://forums.nbn.org.uk/viewtopic.php?pid=8166#p8166 ? If so, the new report attributes should simply overwrite the old ones. If not, I suspect the 'old' report attributes will need to be deleted?

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**MikeWeideli** · 20-12-2012 10:07:19

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

We should have picked up all the cases where I have previously made available UDF etc. which are now built into the system. However, sometimes I have given users early versions using different keys and names. If this happens the report attributes etc. could be in under two different names. In which case the previous one will need to be removed manually. The worst thing that could happen is that the update script will not run because some of the entries are already there. Most of the report changes are in script 0000008W with a few in 0000008Q. Looks like 0000008W has run for Rob so hopefully this isn't going to be a major issue.

Mike Weideli

**charliebarnes** · 20-12-2012 10:22:53

charliebarnes
Veteran
Offline

From: Greater Lincolnshire
Registered: 07-09-2008
Posts: 1,384

Re: Recorder 6.18.1 - Release Candidate

For information, (as before) I had problems with the database expected to be NBNData (USE [NBNData] occurs in some of the script files)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

**MikeWeideli** · 20-12-2012 10:37:26

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Thanks. We don't need NBNData in the scripts and will make sure they are not there in future.

Mike Weideli

**ser** · 20-12-2012 13:23:08

ser
Administrator
Offline

From: Staffordshire Ecological Recor
Registered: 24-09-2008
Posts: 603

Re: Recorder 6.18.1 - Release Candidate

Mike,

I've just upgraded our copy with no issues whatsoever

Craig

Craig Slawson
Staffordshire Ecological Record

**ser** · 07-01-2013 13:24:02

ser
Administrator
Offline

From: Staffordshire Ecological Recor
Registered: 24-09-2008
Posts: 603

Re: Recorder 6.18.1 - Release Candidate

Mike,

The error, whereby when editing a record the comment is not displayed nor editable is still present in 6.18.1

This error seems to reliably occur if the main Event/Sample window is opened when the "enter single record" window is open

Craig

Craig Slawson
Staffordshire Ecological Record

**Alison Stewart** · 15-01-2013 09:59:32

Alison Stewart
Member
Offline

Registered: 03-10-2006
Posts: 46

Re: Recorder 6.18.1 - Release Candidate

Hi Mike

No problems here with running the upgrade; good to see many of the fixes.

I do have a number of species that are not picking up the new format Recommended Taxon Sort Order from the Organism table and so aren't reporting the new fields of Taxon Family, Taxon Order, etc. Is this likely to be peculiar to my copy because of my previously reported dictionary issues (http://forums.nbn.org.uk/viewtopic.php?id=2399, post 12), or a general problem that needs reporting (to Chris?).

Alison Stewart
Dorset Environmental Records Centre

**MikeWeideli** · 15-01-2013 10:22:28

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Hi

Can you give me some examples please. Names and keys if possible (key from Dictionary/Taxa then using the meta data button, or from the Extra info addin). At the moment it will not pick up User added taxa, but should pick up everthing else.

Mike Weideli

**Alison Stewart** · 15-01-2013 13:56:08

Alison Stewart
Member
Offline

Registered: 03-10-2006
Posts: 46

Re: Recorder 6.18.1 - Release Candidate

Hi Mike

Below are some examples from vascular plants and birds:

Recommended TLIK,Recommended Taxon Sort Order,Recommended Taxon Name,Recommended Common Name
NHMSYS0000442131,02400006810,Eleogiton fluitans,Floating Club-rush
NHMSYS0000453225,02400007380,Stratiotes aloides,Water-soldier
NHMSYS0000444322,02400007880,Hermodactylus tuberosus,Snake's-head Iris
NHMSYS0000441419,02400012060,Dactylorhiza occidentalis,Western Marsh-orchid
NHMSYS0000437340,02400014000,Anisantha diandra,Great Brome
NHMSYS0000437344,02400014020,Anisantha madritensis,Compact Brome
NHMSYS0000437347,02400014050,Anisantha sterilis,Barren Brome
NHMSYS0000451641,02400021110,Sasaella ramosa,Hairy Bamboo
NHMSYS0000440691,02400046230,Coronopus didymus,Lesser Swine-cress
NHMSYS0000445814,02400065800,Lamiastrum galeobdolon,Yellow Archangel
NHMSYS0000445815,02400065810,Lamiastrum galeobdolon subsp. argentatum,Yellow Archangel
NHMSYS0000445817,02400065830,Lamiastrum galeobdolon subsp. montanum,Yellow Archangel
NHMSYS0000529557,10600006570,Oenanthe oenanthe,Northern Wheatear
NHMSYS0020304161,10600006574,Oenanthe oenanthe subsp. leucorhoa,Greenland Wheatear
NHMSYS0000529554,10600006590,Oenanthe hispanica,Black-eared Wheatear
NHMSYS0000529518,10600007460,Muscicapa striata,Spotted Flycatcher
NHMSYS0000529181,10600007510,Ficedula hypoleuca,Pied Flycatcher

Querying directly in SQL Server shows 155 TLIKs are affected (file attached). My SQL isn't particularly good but in the query I use to look at the dictionary tables, there wasn't a Taxon Version Key returned for any of these!

Alison Stewart
Dorset Environmental Records Centre

Post's attachments

dict 1A problems.xlsx 17.04 kb, file has never been downloaded.

You don't have the permssions to download the attachments of this post.

Alison Stewart
Dorset Environmental Records Centre

**MikeWeideli** · 15-01-2013 14:23:18

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Many thanks. On the few I have checked I have the same problem in my Dictionary so it doesn't look like it is related to any Dictionary problem specific to you, although I can only find 149. Needs more in depth investigation.

Mike Weideli

**nmrs** · 17-01-2013 08:01:11

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Hi Mike,

I took the plunge and decided to upgrade. The Recorder 6 part of the upgrade appears to have worked, however, the dictionary upgrade is another story. As soon as I ran it it crashed with an exception, something to do with the Organism table not being available (as it wasn't there) but I didn't keep the error regretfully. The upgrade ran for 4 hours and I had to let it run, for a further 36 hours, as I had to go to London yesterday. This morning I find it still running (or hanging?) so I stopped it. The ORGANISM table is empty.

Shall I rerun the dictionary upgrade again at some point?

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**nmrs** · 17-01-2013 08:35:49

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Hi Mike,

Curiosity got the better of me and I ran it again anyway. It immediately exceptioned with:

date/time : 2013-01-17, 08:29:38, 653ms
computer name : NMRS
wts client name : 60G195J
user name : Administrator <admin>
registered owner : National Moth Recording Scheme / Butterfly Conservation
operating system : Windows 2003 R2 Service Pack 2 build 3790
system language : English
system up time : 6 days 23 hours
program up time : 2 seconds
processors : 4x Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
physical memory : 2986/4091 MB (free/total)
free disk space : (C:) 2.55 GB
display mode : 1440x900, 16 bit
process id : $840
allocated memory : 9.67 MB
executable : DictionaryUpgrade.exe
exec. date/time : 2011-11-04 11:01
version : 6.17.1.245
compiled with : Delphi 7
contact name : Les Hill
contact email : lhill@butterfly-conservation.org
madExcept version : 3.0n
callstack crc : $62551a16, $784db51d, $784db51d
exception number : 1
exception class : EDBUpgraderError
exception message : Error occurred running script 00000015.sql. The error is described as: Cannot find the object "ORGANISM" because it does not exist or you do not have permissions.
main thread ($7c8):
005507f0 +218 DictionaryUpgrade.exe DBUpgrader 387 +23 TDBUpgrader.RunScript
00550e49 +191 DictionaryUpgrade.exe DBUpgrader 471 +19 TDBUpgrader.RunUpdates
00553888 +050 DictionaryUpgrade.exe UpgradeFrame 120 +4 TfraUpgrade.ProcessDatabase
005536bf +1f3 DictionaryUpgrade.exe UpgradeFrame 108 +47 TfraUpgrade.Execute
00552f71 +039 DictionaryUpgrade.exe Main 140 +4 TfrmMain.EmbedCurrentFrame
00552e9a +0ca DictionaryUpgrade.exe Main 118 +13 TfrmMain.btnProceedClick
0049e77c +064 DictionaryUpgrade.exe Controls TControl.Click
00494734 +01c DictionaryUpgrade.exe StdCtrls TButton.Click
004895fd +065 DictionaryUpgrade.exe Buttons TBitBtn.Click
00494828 +00c DictionaryUpgrade.exe StdCtrls TButton.CNCommand
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004945f8 +06c DictionaryUpgrade.exe StdCtrls TButtonControl.WndProc
0051339c +064 DictionaryUpgrade.exe XPMenu 2928 +10 TControlSubClass.ControlSubClass
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
7c81a152 +05f ntdll.dll RtlAnsiStringToUnicodeString
0049e3b4 +024 DictionaryUpgrade.exe Controls TControl.Perform
004a1667 +023 DictionaryUpgrade.exe Controls DoControlMsg
004a1cbf +00b DictionaryUpgrade.exe Controls TWinControl.WMCommand
004b9868 +02c DictionaryUpgrade.exe Forms TCustomForm.WMCommand
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004b78b9 +421 DictionaryUpgrade.exe Forms TCustomForm.WndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
004a11ac +02c DictionaryUpgrade.exe Controls TWinControl.MainWndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
7739c332 +044 user32.dll SendMessageW
773b045e +016 user32.dll CallWindowProcA
004a1613 +0d7 DictionaryUpgrade.exe Controls TWinControl.DefaultHandler
0049eb84 +010 DictionaryUpgrade.exe Controls TControl.WMLButtonUp
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004945f8 +06c DictionaryUpgrade.exe StdCtrls TButtonControl.WndProc
0051339c +064 DictionaryUpgrade.exe XPMenu 2928 +10 TControlSubClass.ControlSubClass
004a11ac +02c DictionaryUpgrade.exe Controls TWinControl.MainWndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
773a16e0 +00a user32.dll DispatchMessageA
004bdca3 +083 DictionaryUpgrade.exe Forms TApplication.ProcessMessage
004bdcda +00a DictionaryUpgrade.exe Forms TApplication.HandleMessage
004bdf0a +096 DictionaryUpgrade.exe Forms TApplication.Run
005541b3 +1fb DictionaryUpgrade.exe DictionaryUpgrade 109 +35 initialization
thread $d8:
7c827b67 +a ntdll.dll NtWaitForMultipleObjects
thread $81c:
7c8276a7 +0a ntdll.dll NtReplyWaitReceivePortEx
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($7c8) at:
77c742ba +00 RPCRT4.dll
thread $bd4:
7c826db7 +0a ntdll.dll NtDelayExecution
77e41ecf +47 kernel32.dll SleepEx
77e424f8 +0a kernel32.dll Sleep
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($7c8) at:
776b1883 +00 ole32.dll
thread $688:
7c827b77 +0a ntdll.dll NtWaitForSingleObject
77e61d00 +82 kernel32.dll WaitForSingleObjectEx
77e61c70 +0d kernel32.dll WaitForSingleObject
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($7c8) at:
4a757067 +00 comsvcs.dll
modules:
00400000 DictionaryUpgrade.exe 6.17.1.245 C:\Program Files\Recorder 6 Server\Dictionary Upgrade Kit
02520000 xpsp2res.dll 5.2.3790.3959 C:\WINDOWS\system32
02bb0000 SQLOLEDB.RLL 2000.86.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
02bc0000 msadcer.dll 2.82.3959.0 C:\Program Files\Common Files\System\msadc
4a710000 comsvcs.dll 2001.12.4720.3959 C:\WINDOWS\system32
4b3c0000 MSCTF.dll 5.2.3790.3959 C:\WINDOWS\system32
4bbe0000 msado15.dll 2.82.5011.0 C:\Program Files\Common Files\System\ado
4c850000 oledb32.dll 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
4d140000 msadce.dll 2.82.3959.0 C:\Program Files\Common Files\System\msadc
4dbb0000 OLEDB32R.DLL 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
4dc30000 msctfime.ime 5.2.3790.3959 C:\WINDOWS\system32
4e250000 sqloledb.dll 2000.86.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
5e9a0000 olepro32.dll 5.2.3790.3959 C:\WINDOWS\system32
5f270000 hnetcfg.dll 5.2.3790.3959 C:\WINDOWS\system32
61200000 MSDATL3.dll 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
68000000 rsaenh.dll 5.2.3790.3959 C:\WINDOWS\system32
68100000 dssenh.dll 5.2.3790.3959 C:\WINDOWS\system32
6d560000 DBNETLIB.DLL 2000.86.3959.0 C:\WINDOWS\system32
71ae0000 wshtcpip.dll 5.2.3790.3959 C:\WINDOWS\System32
71b20000 mswsock.dll 5.2.3790.4318 C:\WINDOWS\system32
71b70000 uxtheme.dll 6.0.3790.3959 C:\WINDOWS\system32
71bb0000 wsock32.dll 5.2.3790.0 C:\WINDOWS\system32
71bd0000 mpr.dll 5.2.3790.3959 C:\WINDOWS\system32
71bf0000 WS2HELP.dll 5.2.3790.3959 C:\WINDOWS\system32
71c00000 WS2_32.dll 5.2.3790.3959 C:\WINDOWS\system32
71c40000 NETAPI32.dll 5.2.3790.5030 C:\WINDOWS\system32
71f60000 security.dll 5.2.3790.0 C:\WINDOWS\system32
74a50000 MSDART.DLL 2.82.3959.0 C:\WINDOWS\system32
75e60000 apphelp.dll 5.2.3790.3959 C:\WINDOWS\system32
76190000 MSASN1.dll 5.2.3790.4584 C:\WINDOWS\system32
761b0000 crypt32.dll 5.131.3790.5014 C:\WINDOWS\system32
76290000 IMM32.DLL 5.2.3790.3959 C:\WINDOWS\system32
762b0000 comdlg32.dll 6.0.3790.3959 C:\WINDOWS\system32
766d0000 SHFolder.dll 6.0.3790.3959 C:\WINDOWS\system32
766e0000 cryptdll.dll 5.2.3790.3959 C:\WINDOWS\system32
766f0000 ntdsapi.dll 5.2.3790.3959 C:\WINDOWS\system32
76750000 schannel.dll 5.2.3790.5014 C:\WINDOWS\system32
76920000 USERENV.dll 5.2.3790.3959 C:\WINDOWS\system32
76b70000 PSAPI.DLL 5.2.3790.3959 C:\WINDOWS\system32
76c90000 msv1_0.dll 5.2.3790.4587 C:\WINDOWS\system32
76cf0000 iphlpapi.dll 5.2.3790.3959 C:\WINDOWS\system32
76ed0000 DNSAPI.dll 5.2.3790.4840 C:\WINDOWS\system32
76f00000 wtsapi32.dll 5.2.3790.3959 C:\WINDOWS\system32
76f10000 WLDAP32.dll 5.2.3790.3959 C:\WINDOWS\system32
76f50000 Secur32.dll 5.2.3790.4530 C:\WINDOWS\system32
76f70000 winrnr.dll 5.2.3790.3959 C:\WINDOWS\System32
76f80000 rasadhlp.dll 5.2.3790.3959 C:\WINDOWS\system32
77010000 COMRes.dll 2001.12.4720.3959 C:\WINDOWS\system32
771f0000 WINSTA.dll 5.2.3790.3959 C:\WINDOWS\system32
77380000 user32.dll 5.2.3790.4033 C:\WINDOWS\system32
77420000 comctl32.dll 6.0.3790.4770 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.4770_x-ww_05FDF087
77530000 comctl32.dll 5.82.3790.4770 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.3790.4770_x-ww_A689AB02
77670000 ole32.dll 5.2.3790.4926 C:\WINDOWS\system32
777b0000 CLBCatQ.DLL 2001.12.4720.3959 C:\WINDOWS\system32
77b90000 version.dll 5.2.3790.3959 C:\WINDOWS\system32
77ba0000 msvcrt.dll 7.0.3790.3959 C:\WINDOWS\system32
77c00000 GDI32.dll 5.2.3790.4396 C:\WINDOWS\system32
77c50000 RPCRT4.dll 5.2.3790.4759 C:\WINDOWS\system32
77e40000 kernel32.dll 5.2.3790.5069 C:\WINDOWS\system32
7c800000 ntdll.dll 5.2.3790.4937 C:\WINDOWS\system32
7c8d0000 shell32.dll 6.0.3790.5018 C:\WINDOWS\system32
7d0e0000 oleaut32.dll 5.2.3790.4807 C:\WINDOWS\system32
7d180000 SHLWAPI.dll 6.0.3790.4603 C:\WINDOWS\system32
7d1e0000 ADVAPI32.dll 5.2.3790.4555 C:\WINDOWS\system32
processes:
000 Idle 0 0 0
004 System 0 0 0 normal
140 smss.exe 0 0 0 normal C:\WINDOWS\system32
170 csrss.exe 0 0 0
190 winlogon.exe 0 0 0 high C:\WINDOWS\system32
1c0 services.exe 0 0 0 normal C:\WINDOWS\system32
1cc lsass.exe 0 0 0 normal C:\WINDOWS\system32
280 svchost.exe 0 0 0 normal C:\WINDOWS\system32
2c0 svchost.exe 0 0 0
308 svchost.exe 0 0 0
330 svchost.exe 0 0 0
340 svchost.exe 0 0 0 normal C:\WINDOWS\System32
3d0 spoolsv.exe 0 0 0 normal C:\WINDOWS\system32
3e8 msdtc.exe 0 0 0
470 dsm_sa_eventmgr32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\dataeng\bin
488 dsm_sa_datamgr32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\dataeng\bin
49c ekrn.exe 0 0 0 normal C:\Program Files\ESET\ESET NOD32 Antivirus
4b4 svchost.exe 0 0 0 normal C:\WINDOWS\System32
4d8 MsDtsSrvr.exe 0 0 0
55c msftesql.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
56c sqlservr.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
590 svchost.exe 0 0 0 normal C:\WINDOWS\System32
5a0 dsm_om_shrsvc32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\oma\bin
654 pcns.exe 0 0 0 normal C:\PROGRA~1\APC\POWERC~1\group1
668 svchost.exe 0 0 0 normal C:\WINDOWS\System32
67c svchost.exe 0 0 0
6b4 java.exe 0 0 0 normal C:\Program Files\APC\jre\jre1.5.0_18\bin
6b0 dsm_om_connsvc32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\iws\bin\win32
6c8 snmp.exe 0 0 0 normal C:\WINDOWS\System32
6e4 sqlwriter.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\90\Shared
6f8 svchost.exe 0 0 0 normal C:\WINDOWS\system32
760 beremote.exe 0 0 0 normal C:\Program Files\Symantec\Backup Exec
a84 pvlsvr.exe 0 0 0 normal
ad0 SQLAGENT90.EXE 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
c18 beserver.exe 0 0 0
c48 rsmsink.exe 0 0 0 normal C:\WINDOWS\system32
d64 benetns.exe 0 0 0
d80 bengine.exe 0 0 0 normal
e98 svchost.exe 0 0 0 normal C:\WINDOWS\System32
fc4 wmiprvse.exe 0 0 0
600 svchost.exe 0 0 0 normal C:\WINDOWS\System32
b30 logon.scr 0 0 0
f90 wmiprvse.exe 0 0 0
c7c csrss.exe 1 0 0
99c winlogon.exe 1 41 16 high C:\WINDOWS\system32
908 rdpclip.exe 1 8 9 normal C:\WINDOWS\system32
fe0 Explorer.EXE 1 164 90 normal C:\WINDOWS
e68 egui.exe 1 157 50 normal C:\Program Files\ESET\ESET NOD32 Antivirus
8a8 ctfmon.exe 1 38 22 normal C:\WINDOWS\system32
840 DictionaryUpgrade.exe 1 59 52 normal C:\Program Files\Recorder 6 Server\Dictionary Upgrade Kit
hardware:
+ Computer
- ACPI Multiprocessor PC
+ Disk drives
- DELL PERC 5/i SCSI Disk Device
- DELL PERC 5/i SCSI Disk Device
+ Display adapters
- ATI ES1000 (driver 8.19.4.0)
+ DVD/CD-ROM drives
- TSSTcorp DVD-ROM TS-H352C
+ Floppy disk controllers
- Standard floppy disk controller
+ Floppy disk drives
- Floppy disk drive
+ Human Interface Devices
- HID-compliant consumer control device
- HID-compliant device
- USB Human Interface Device
- USB Human Interface Device
+ IDE ATA/ATAPI controllers
- Intel(R) 631xESB/6321ESB Ultra ATA Storage Controller - 269E (driver 7.3.0.1010)
- Primary IDE Channel
+ Keyboards
- HID Keyboard Device
+ Mice and other pointing devices
- HID-compliant mouse
+ Monitors
- Default Monitor
+ Network adapters
- Broadcom BCM5708C NetXtreme II GigE (NDIS VBD Client) (driver 2.6.14.0)
- Broadcom BCM5708C NetXtreme II GigE (NDIS VBD Client) #2 (driver 2.6.14.0)
+ Ports (COM & LPT)
- Communications Port (COM1)
- Communications Port (COM2)
+ Processors
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
+ SCSI and RAID controllers
- Adaptec SCSI Card 39320A - Ultra320 SCSI (driver 3.0.0.0)
- Adaptec SCSI Card 39320A - Ultra320 SCSI (driver 3.0.0.0)
- DELL PERC 5/i Integrated RAID Controller (driver 2.8.0.32)
+ Sound, video and game controllers
- Audio Codecs
- Legacy Audio Drivers
- Legacy Video Capture Devices
- Media Control Devices
- Video Codecs
+ System devices
- ACPI Fixed Feature Button
- Broadcom BCM5708C NetXtreme II GigE (driver 2.6.17.0)
- Broadcom BCM5708C NetXtreme II GigE (driver 2.6.17.0)
- DELL PERC RAID Virtual Device (driver 1.18.0.32)
- Direct memory access controller
- High Precision Event Timer (driver 7.0.0.1011)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset FBD Registers - 25F5 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset FBD Registers - 25F6 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 2 - 25E2 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 3 - 25E3 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 4 - 25E4 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 5 - 25E5 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 7 - 25E7 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x8 Port 6-7 - 25F9 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Reserved Registers - 25F1 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Reserved Registers - 25F3 (driver 7.3.0.1010)
- Intel(R) 5000X Chipset Memory Controller Hub - 25C0 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Downstream Port E1 - 3510 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Downstream Port E2 - 3514 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express to PCI-X Bridge - 350C (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Upstream Port - 3500 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB LPC Interface Controller - 2670 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB PCI Express Root Port 1 - 2690 (driver 7.3.0.1010)
- Intel(R) 82801 PCI Bridge - 244E (driver 7.0.0.1011)
- ISAPNP Read Data Port
- Logical Disk Manager
- Microcode Update Device
- Microsoft ACPI-Compliant System
- Microsoft System Management BIOS Driver
- Motherboard resources
- Numeric data processor
- PCI bus
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- Plug and Play Software Device Enumerator
- Programmable interrupt controller
- System board
- System board
- System board
- System board
- System CMOS/real time clock
- System Management Device (driver 5.7.0.4821)
- System timer
- Terminal Server Device Redirector
- Terminal Server Keyboard Driver
- Terminal Server Mouse Driver
- Volume Manager
+ Tape drives
- IBM ULTRIUM III TAPE DRIVE (driver 5.1.)
+ Universal Serial Bus controllers
- Generic USB Hub
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 2688 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 2689 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 268A (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 268B (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB2 Enhanced Host Controller - 268C (driver 7.3.0.1010)
- USB Composite Device
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub

The ORGANISM table is present. This I'm 99% sure is the same exception as previously reported.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**nmrs** · 17-01-2013 09:04:11

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Further to my last, by adding "Use [NBNData]" to "TRUNCATE TABLE ORGANISM" (00000015.sql) I was able to fix the initial exception. I now have a further exception about 10 seconds into the routine (00000016.zip?) as follows:

date/time : 2013-01-17, 08:59:58, 481ms
computer name : NMRS
wts client name : 60G195J
user name : Administrator <admin>
registered owner : National Moth Recording Scheme / Butterfly Conservation
operating system : Windows 2003 R2 Service Pack 2 build 3790
system language : English
system up time : 6 days 23 hours
program up time : 5 seconds
processors : 4x Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
physical memory : 3026/4091 MB (free/total)
free disk space : (C:) 2.55 GB
display mode : 1440x900, 16 bit
process id : $e74
allocated memory : 10.84 MB
executable : DictionaryUpgrade.exe
exec. date/time : 2011-11-04 11:01
version : 6.17.1.245
compiled with : Delphi 7
contact name : Les Hill
contact email : lhill@butterfly-conservation.org
madExcept version : 3.0n
callstack crc : $8a4b43d4, $a5a82f2d, $a5a82f2d
exception number : 1
exception class : EOleException
exception message : The Microsoft Jet database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly.
main thread ($e44):
0054a343 +3ff DictionaryUpgrade.exe DatabaseAccessADO 663 +34 TdmDatabase.CreateLinkedTable
0054b7fe +19a DictionaryUpgrade.exe DBMerger 263 +24 TDBMerger.DoMerge
0054b638 +02c DictionaryUpgrade.exe DBMerger 223 +1 TDBMerger.DoMerge
00551458 +190 DictionaryUpgrade.exe DBUpgrader 566 +26 TDBUpgrader.MergeZipFile
00550e8b +1d3 DictionaryUpgrade.exe DBUpgrader 474 +22 TDBUpgrader.RunUpdates
00553888 +050 DictionaryUpgrade.exe UpgradeFrame 120 +4 TfraUpgrade.ProcessDatabase
005536bf +1f3 DictionaryUpgrade.exe UpgradeFrame 108 +47 TfraUpgrade.Execute
00552f71 +039 DictionaryUpgrade.exe Main 140 +4 TfrmMain.EmbedCurrentFrame
00552e9a +0ca DictionaryUpgrade.exe Main 118 +13 TfrmMain.btnProceedClick
0049e77c +064 DictionaryUpgrade.exe Controls TControl.Click
00494734 +01c DictionaryUpgrade.exe StdCtrls TButton.Click
004895fd +065 DictionaryUpgrade.exe Buttons TBitBtn.Click
00494828 +00c DictionaryUpgrade.exe StdCtrls TButton.CNCommand
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004945f8 +06c DictionaryUpgrade.exe StdCtrls TButtonControl.WndProc
0051339c +064 DictionaryUpgrade.exe XPMenu 2928 +10 TControlSubClass.ControlSubClass
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
7c81a152 +05f ntdll.dll RtlAnsiStringToUnicodeString
0049e3b4 +024 DictionaryUpgrade.exe Controls TControl.Perform
004a1667 +023 DictionaryUpgrade.exe Controls DoControlMsg
004a1cbf +00b DictionaryUpgrade.exe Controls TWinControl.WMCommand
004b9868 +02c DictionaryUpgrade.exe Forms TCustomForm.WMCommand
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004b78b9 +421 DictionaryUpgrade.exe Forms TCustomForm.WndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
004a11ac +02c DictionaryUpgrade.exe Controls TWinControl.MainWndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
7739c332 +044 user32.dll SendMessageW
773b045e +016 user32.dll CallWindowProcA
004a1613 +0d7 DictionaryUpgrade.exe Controls TWinControl.DefaultHandler
0049eb84 +010 DictionaryUpgrade.exe Controls TControl.WMLButtonUp
0049e5e4 +188 DictionaryUpgrade.exe Controls TControl.WndProc
004a152f +157 DictionaryUpgrade.exe Controls TWinControl.WndProc
004945f8 +06c DictionaryUpgrade.exe StdCtrls TButtonControl.WndProc
0051339c +064 DictionaryUpgrade.exe XPMenu 2928 +10 TControlSubClass.ControlSubClass
004a11ac +02c DictionaryUpgrade.exe Controls TWinControl.MainWndProc
00476300 +014 DictionaryUpgrade.exe Classes StdWndProc
773a16e0 +00a user32.dll DispatchMessageA
004bdca3 +083 DictionaryUpgrade.exe Forms TApplication.ProcessMessage
004bdcda +00a DictionaryUpgrade.exe Forms TApplication.HandleMessage
004bdf0a +096 DictionaryUpgrade.exe Forms TApplication.Run
005541b3 +1fb DictionaryUpgrade.exe DictionaryUpgrade 109 +35 initialization
thread $824:
7c827b67 +a ntdll.dll NtWaitForMultipleObjects
thread $c5c:
7c8276a7 +0a ntdll.dll NtReplyWaitReceivePortEx
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($e44) at:
77c742ba +00 RPCRT4.dll
thread $e40:
7c826db7 +0a ntdll.dll NtDelayExecution
77e41ecf +47 kernel32.dll SleepEx
77e424f8 +0a kernel32.dll Sleep
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($e44) at:
776b1883 +00 ole32.dll
thread $174:
7c827b77 +0a ntdll.dll NtWaitForSingleObject
77e61d00 +82 kernel32.dll WaitForSingleObjectEx
77e61c70 +0d kernel32.dll WaitForSingleObject
0044e3e5 +0d DictionaryUpgrade.exe madExcept CallThreadProcSafe
0044e44f +37 DictionaryUpgrade.exe madExcept ThreadExceptFrame
>> created by main thread ($e44) at:
4a757067 +00 comsvcs.dll
modules:
00400000 DictionaryUpgrade.exe 6.17.1.245 C:\Program Files\Recorder 6 Server\Dictionary Upgrade Kit
02520000 xpsp2res.dll 5.2.3790.3959 C:\WINDOWS\system32
02bb0000 SQLOLEDB.RLL 2000.86.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
02bc0000 msadcer.dll 2.82.3959.0 C:\Program Files\Common Files\System\msadc
08060000 msader15.dll 2.82.3959.0 C:\Program Files\Common Files\System\ado
08230000 odbcint.dll 3.526.3959.0 C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL 6.0.1.9431 C:\WINDOWS\system32
0f9c0000 expsrv.dll 6.0.72.9589 C:\WINDOWS\system32
1b000000 msjet40.dll 4.0.9505.0 C:\WINDOWS\system32
1b2c0000 msjter40.dll 4.0.9502.0 C:\WINDOWS\system32
1b2d0000 MSJINT40.DLL 4.0.9502.0 C:\WINDOWS\system32
1b570000 msjetoledb40.dll 4.0.9502.0 C:\WINDOWS\system32
1b5d0000 mswstr10.dll 4.0.9502.0 C:\WINDOWS\system32
1b800000 msjtes40.dll 4.0.9502.0 C:\WINDOWS\system32
4a710000 comsvcs.dll 2001.12.4720.3959 C:\WINDOWS\system32
4b3c0000 MSCTF.dll 5.2.3790.3959 C:\WINDOWS\system32
4bbe0000 msado15.dll 2.82.5011.0 C:\Program Files\Common Files\System\ado
4c850000 oledb32.dll 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
4d140000 msadce.dll 2.82.3959.0 C:\Program Files\Common Files\System\msadc
4d7a0000 odbccp32.dll 3.526.3959.0 C:\WINDOWS\system32
4d890000 msadox.dll 2.82.4795.0 C:\Program Files\Common Files\System\ado
4dbb0000 OLEDB32R.DLL 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
4dc30000 msctfime.ime 5.2.3790.3959 C:\WINDOWS\system32
4e250000 sqloledb.dll 2000.86.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
5e9a0000 olepro32.dll 5.2.3790.3959 C:\WINDOWS\system32
5f270000 hnetcfg.dll 5.2.3790.3959 C:\WINDOWS\system32
61200000 MSDATL3.dll 2.82.3959.0 C:\Program Files\Common Files\SYSTEM\Ole DB
68000000 rsaenh.dll 5.2.3790.3959 C:\WINDOWS\system32
68100000 dssenh.dll 5.2.3790.3959 C:\WINDOWS\system32
6d560000 DBNETLIB.DLL 2000.86.3959.0 C:\WINDOWS\system32
71ae0000 wshtcpip.dll 5.2.3790.3959 C:\WINDOWS\System32
71b20000 mswsock.dll 5.2.3790.4318 C:\WINDOWS\system32
71b70000 uxtheme.dll 6.0.3790.3959 C:\WINDOWS\system32
71bb0000 wsock32.dll 5.2.3790.0 C:\WINDOWS\system32
71bd0000 mpr.dll 5.2.3790.3959 C:\WINDOWS\system32
71bf0000 WS2HELP.dll 5.2.3790.3959 C:\WINDOWS\system32
71c00000 WS2_32.dll 5.2.3790.3959 C:\WINDOWS\system32
71c40000 NETAPI32.dll 5.2.3790.5030 C:\WINDOWS\system32
71f60000 security.dll 5.2.3790.0 C:\WINDOWS\system32
74a50000 MSDART.DLL 2.82.3959.0 C:\WINDOWS\system32
75e60000 apphelp.dll 5.2.3790.3959 C:\WINDOWS\system32
76190000 MSASN1.dll 5.2.3790.4584 C:\WINDOWS\system32
761b0000 crypt32.dll 5.131.3790.5014 C:\WINDOWS\system32
76290000 IMM32.DLL 5.2.3790.3959 C:\WINDOWS\system32
762b0000 comdlg32.dll 6.0.3790.3959 C:\WINDOWS\system32
766d0000 SHFolder.dll 6.0.3790.3959 C:\WINDOWS\system32
766e0000 cryptdll.dll 5.2.3790.3959 C:\WINDOWS\system32
766f0000 ntdsapi.dll 5.2.3790.3959 C:\WINDOWS\system32
76750000 schannel.dll 5.2.3790.5014 C:\WINDOWS\system32
76920000 USERENV.dll 5.2.3790.3959 C:\WINDOWS\system32
76b70000 PSAPI.DLL 5.2.3790.3959 C:\WINDOWS\system32
76c90000 msv1_0.dll 5.2.3790.4587 C:\WINDOWS\system32
76cf0000 iphlpapi.dll 5.2.3790.3959 C:\WINDOWS\system32
76ed0000 DNSAPI.dll 5.2.3790.4840 C:\WINDOWS\system32
76f00000 wtsapi32.dll 5.2.3790.3959 C:\WINDOWS\system32
76f10000 WLDAP32.dll 5.2.3790.3959 C:\WINDOWS\system32
76f50000 Secur32.dll 5.2.3790.4530 C:\WINDOWS\system32
76f70000 winrnr.dll 5.2.3790.3959 C:\WINDOWS\System32
76f80000 rasadhlp.dll 5.2.3790.3959 C:\WINDOWS\system32
77010000 COMRes.dll 2001.12.4720.3959 C:\WINDOWS\system32
771f0000 WINSTA.dll 5.2.3790.3959 C:\WINDOWS\system32
77380000 user32.dll 5.2.3790.4033 C:\WINDOWS\system32
77420000 comctl32.dll 6.0.3790.4770 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.4770_x-ww_05FDF087
77530000 comctl32.dll 5.82.3790.4770 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.3790.4770_x-ww_A689AB02
77670000 ole32.dll 5.2.3790.4926 C:\WINDOWS\system32
777b0000 CLBCatQ.DLL 2001.12.4720.3959 C:\WINDOWS\system32
77b90000 version.dll 5.2.3790.3959 C:\WINDOWS\system32
77ba0000 msvcrt.dll 7.0.3790.3959 C:\WINDOWS\system32
77c00000 GDI32.dll 5.2.3790.4396 C:\WINDOWS\system32
77c50000 RPCRT4.dll 5.2.3790.4759 C:\WINDOWS\system32
77e40000 kernel32.dll 5.2.3790.5069 C:\WINDOWS\system32
7c800000 ntdll.dll 5.2.3790.4937 C:\WINDOWS\system32
7c8d0000 shell32.dll 6.0.3790.5018 C:\WINDOWS\system32
7d0e0000 oleaut32.dll 5.2.3790.4807 C:\WINDOWS\system32
7d180000 SHLWAPI.dll 6.0.3790.4603 C:\WINDOWS\system32
7d1e0000 ADVAPI32.dll 5.2.3790.4555 C:\WINDOWS\system32
processes:
000 Idle 0 0 0
004 System 0 0 0 normal
140 smss.exe 0 0 0 normal C:\WINDOWS\system32
170 csrss.exe 0 0 0
190 winlogon.exe 0 0 0 high C:\WINDOWS\system32
1c0 services.exe 0 0 0 normal C:\WINDOWS\system32
1cc lsass.exe 0 0 0 normal C:\WINDOWS\system32
280 svchost.exe 0 0 0 normal C:\WINDOWS\system32
2c0 svchost.exe 0 0 0
308 svchost.exe 0 0 0
330 svchost.exe 0 0 0
340 svchost.exe 0 0 0 normal C:\WINDOWS\System32
3d0 spoolsv.exe 0 0 0 normal C:\WINDOWS\system32
3e8 msdtc.exe 0 0 0
470 dsm_sa_eventmgr32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\dataeng\bin
488 dsm_sa_datamgr32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\dataeng\bin
49c ekrn.exe 0 0 0 normal C:\Program Files\ESET\ESET NOD32 Antivirus
4b4 svchost.exe 0 0 0 normal C:\WINDOWS\System32
4d8 MsDtsSrvr.exe 0 0 0
55c msftesql.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
56c sqlservr.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
590 svchost.exe 0 0 0 normal C:\WINDOWS\System32
5a0 dsm_om_shrsvc32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\oma\bin
654 pcns.exe 0 0 0 normal C:\PROGRA~1\APC\POWERC~1\group1
668 svchost.exe 0 0 0 normal C:\WINDOWS\System32
67c svchost.exe 0 0 0
6b4 java.exe 0 0 0 normal C:\Program Files\APC\jre\jre1.5.0_18\bin
6b0 dsm_om_connsvc32.exe 0 0 0 normal C:\Program Files\Dell\SysMgt\iws\bin\win32
6c8 snmp.exe 0 0 0 normal C:\WINDOWS\System32
6e4 sqlwriter.exe 0 0 0 normal C:\Program Files\Microsoft SQL Server\90\Shared
6f8 svchost.exe 0 0 0 normal C:\WINDOWS\system32
760 beremote.exe 0 0 0 normal C:\Program Files\Symantec\Backup Exec
a84 pvlsvr.exe 0 0 0 normal
ad0 SQLAGENT90.EXE 0 0 0 normal C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
c18 beserver.exe 0 0 0
c48 rsmsink.exe 0 0 0 normal C:\WINDOWS\system32
d64 benetns.exe 0 0 0
d80 bengine.exe 0 0 0 normal
e98 svchost.exe 0 0 0 normal C:\WINDOWS\System32
fc4 wmiprvse.exe 0 0 0
600 svchost.exe 0 0 0 normal C:\WINDOWS\System32
b30 logon.scr 0 0 0
f90 wmiprvse.exe 0 0 0
958 csrss.exe 1 0 0
af8 winlogon.exe 1 41 16 high C:\WINDOWS\system32
db0 rdpclip.exe 1 8 9 normal C:\WINDOWS\system32
3f4 Explorer.EXE 1 164 92 normal C:\WINDOWS
084 egui.exe 1 155 50 normal C:\Program Files\ESET\ESET NOD32 Antivirus
bd4 ctfmon.exe 1 74 40 normal C:\WINDOWS\system32
e74 DictionaryUpgrade.exe 1 59 53 normal C:\Program Files\Recorder 6 Server\Dictionary Upgrade Kit
hardware:
+ Computer
- ACPI Multiprocessor PC
+ Disk drives
- DELL PERC 5/i SCSI Disk Device
- DELL PERC 5/i SCSI Disk Device
+ Display adapters
- ATI ES1000 (driver 8.19.4.0)
+ DVD/CD-ROM drives
- TSSTcorp DVD-ROM TS-H352C
+ Floppy disk controllers
- Standard floppy disk controller
+ Floppy disk drives
- Floppy disk drive
+ Human Interface Devices
- HID-compliant consumer control device
- HID-compliant device
- USB Human Interface Device
- USB Human Interface Device
+ IDE ATA/ATAPI controllers
- Intel(R) 631xESB/6321ESB Ultra ATA Storage Controller - 269E (driver 7.3.0.1010)
- Primary IDE Channel
+ Keyboards
- HID Keyboard Device
+ Mice and other pointing devices
- HID-compliant mouse
+ Monitors
- Default Monitor
+ Network adapters
- Broadcom BCM5708C NetXtreme II GigE (NDIS VBD Client) (driver 2.6.14.0)
- Broadcom BCM5708C NetXtreme II GigE (NDIS VBD Client) #2 (driver 2.6.14.0)
+ Ports (COM & LPT)
- Communications Port (COM1)
- Communications Port (COM2)
+ Processors
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
- Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
+ SCSI and RAID controllers
- Adaptec SCSI Card 39320A - Ultra320 SCSI (driver 3.0.0.0)
- Adaptec SCSI Card 39320A - Ultra320 SCSI (driver 3.0.0.0)
- DELL PERC 5/i Integrated RAID Controller (driver 2.8.0.32)
+ Sound, video and game controllers
- Audio Codecs
- Legacy Audio Drivers
- Legacy Video Capture Devices
- Media Control Devices
- Video Codecs
+ System devices
- ACPI Fixed Feature Button
- Broadcom BCM5708C NetXtreme II GigE (driver 2.6.17.0)
- Broadcom BCM5708C NetXtreme II GigE (driver 2.6.17.0)
- DELL PERC RAID Virtual Device (driver 1.18.0.32)
- Direct memory access controller
- High Precision Event Timer (driver 7.0.0.1011)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Error Reporting Registers - 25F0 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset FBD Registers - 25F5 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset FBD Registers - 25F6 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 2 - 25E2 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 3 - 25E3 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 4 - 25E4 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 5 - 25E5 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x4 Port 7 - 25E7 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset PCI Express x8 Port 6-7 - 25F9 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Reserved Registers - 25F1 (driver 7.3.0.1010)
- Intel(R) 5000 Series Chipset Reserved Registers - 25F3 (driver 7.3.0.1010)
- Intel(R) 5000X Chipset Memory Controller Hub - 25C0 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Downstream Port E1 - 3510 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Downstream Port E2 - 3514 (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express to PCI-X Bridge - 350C (driver 7.3.0.1010)
- Intel(R) 6311ESB/6321ESB PCI Express Upstream Port - 3500 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB LPC Interface Controller - 2670 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB PCI Express Root Port 1 - 2690 (driver 7.3.0.1010)
- Intel(R) 82801 PCI Bridge - 244E (driver 7.0.0.1011)
- ISAPNP Read Data Port
- Logical Disk Manager
- Microcode Update Device
- Microsoft ACPI-Compliant System
- Microsoft System Management BIOS Driver
- Motherboard resources
- Numeric data processor
- PCI bus
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- PCI standard PCI-to-PCI bridge
- Plug and Play Software Device Enumerator
- Programmable interrupt controller
- System board
- System board
- System board
- System board
- System CMOS/real time clock
- System Management Device (driver 5.7.0.4821)
- System timer
- Terminal Server Device Redirector
- Terminal Server Keyboard Driver
- Terminal Server Mouse Driver
- Volume Manager
+ Tape drives
- IBM ULTRIUM III TAPE DRIVE (driver 5.1.)
+ Universal Serial Bus controllers
- Generic USB Hub
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 2688 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 2689 (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 268A (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB Universal Host Controller - 268B (driver 7.3.0.1010)
- Intel(R) 631xESB/6321ESB USB2 Enhanced Host Controller - 268C (driver 7.3.0.1010)
- USB Composite Device
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub

I can't see anything obvious and re-running it reproduces the exception.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**nmrs** · 17-01-2013 09:34:22

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Now running from my desktop as opposed to the server (via a remote session) and it seems to be populating the ORGANISM table. Monitoring...

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**MikeWeideli** · 17-01-2013 10:06:40

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Many thanks for your comments, I am am very interested in the experiences on this because it is the biggest dictionary upgrade we have every done. I have divided up the Organism table into four, because the whole thing wouldn't run as one. Upgrade 15 truncates the table. This is really only there for the few people who did some testing on earlier version of the upgrade. Upgrades 16/17/18/19 then populate each of the 4 part of the Organism table. Finally 1A deletes the contents of the index tables. I have tested it on some very slow machines (Xp, Windows7 and windows 8) and although it has taken a long time it seems to get there eventually, but for some unknown reason sometimes stopping it and then starting again it has worked faster. One option would be to run each section separately. this means removing 17/18 and 19 from the scripts file and running the upgrade, then adding back in 17 and running again and so on. No need to update the index tables between each upgrade.

Mike

Mike Weideli

**nmrs** · 17-01-2013 10:31:21

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Ok Mike, just finished the dictionary upgrade (all 4 together in under 1 hour without error) and it completed successfully with 107,952 records in the ORGANISM table.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**nmrs** · 18-01-2013 08:32:29

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Hi,

I've just upgraded my personal copy of R6 (Windows 7/SQL Server 2008 R2) and have 108,222 entries in the ORGANISM table which matches the total of records in the 4 dictionary upgrades 00000016, 00000017, 00000018 and 00000019.

Looks like I will have to run the dictionary upgrades again on the NMRS server (Windows 2003 Server/SQL Server 2005) as there's 270 missing entries.

Both upgrades popped up the "Upgrade successful" dialogue.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**MikeWeideli** · 18-01-2013 09:32:10

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

This could possibly be down to something not right with the NMRS dictionary. I will give you a report which identifies the missing Organism entries and if there is some reason for them not being there.

Mike Weideli

**nmrs** · 18-01-2013 11:19:27

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Many thanks Mike, I'm not in the office until next Wednesday so no rush.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**nmrs** · 23-01-2013 08:13:48

nmrs
Veteran
Offline

From: London
Registered: 22-11-2006
Posts: 382

Re: Recorder 6.18.1 - Release Candidate

Hi Mike, I'm back in the office now. Looking forward to receiving the report you mentioned.

Les Evans-Hill
Senior Data Officer, National Moth Recording Scheme

**MikeWeideli** · 28-01-2013 19:35:31

MikeWeideli
Administrator
Offline

From: Littlefield Consultancy
Registered: 05-07-2006
Posts: 2,625

Re: Recorder 6.18.1 - Release Candidate

Attached is a report which will list any missing Organisms. Once it has run we need to check to see if the Taxon_version_Key it returns are present in the full Organism table. If you send me the results I can check this or you can check it against the Organism table you have at home. If the entries are in the full table then the problem is in the population of the table in the Dictionary upgrade. It would then be worth you running the upgrade again, by changing the Dict Seq in the setting table to 00000015 (not 14), so that the upgrade is run again without deleting what is already there. If they are not in the full Organism table then this means the Dictionary has some missing or incorrect data. I may be able to work out why this is has happended from the list.

Mike Weideli

Welcome

Recorder 6.18.1 - Release Candidate (Page 1 of 2)

Posts: 1 to 25 of 36

1 Topic by MikeWeideli 19-12-2012 14:32:51

Topic: Recorder 6.18.1 - Release Candidate

2 Reply by RobLarge 20-12-2012 08:52:53

Re: Recorder 6.18.1 - Release Candidate

3 Reply by RobLarge 20-12-2012 09:12:04

Re: Recorder 6.18.1 - Release Candidate

4 Reply by MikeWeideli 20-12-2012 09:28:40

Re: Recorder 6.18.1 - Release Candidate

5 Reply by nmrs 20-12-2012 09:45:09

Re: Recorder 6.18.1 - Release Candidate

6 Reply by MikeWeideli 20-12-2012 10:07:19

Re: Recorder 6.18.1 - Release Candidate

7 Reply by charliebarnes 20-12-2012 10:22:53

Re: Recorder 6.18.1 - Release Candidate

8 Reply by MikeWeideli 20-12-2012 10:37:26

Re: Recorder 6.18.1 - Release Candidate

9 Reply by ser 20-12-2012 13:23:08

Re: Recorder 6.18.1 - Release Candidate

10 Reply by ser 07-01-2013 13:24:02 (edited by ser 07-01-2013 13:34:06)

Re: Recorder 6.18.1 - Release Candidate

11 Reply by Alison Stewart 15-01-2013 09:59:32

Re: Recorder 6.18.1 - Release Candidate

12 Reply by MikeWeideli 15-01-2013 10:22:28

Re: Recorder 6.18.1 - Release Candidate

13 Reply by Alison Stewart 15-01-2013 13:56:08

Re: Recorder 6.18.1 - Release Candidate

14 Reply by MikeWeideli 15-01-2013 14:23:18

Re: Recorder 6.18.1 - Release Candidate

15 Reply by nmrs 17-01-2013 08:01:11

Re: Recorder 6.18.1 - Release Candidate

16 Reply by nmrs 17-01-2013 08:35:49

Re: Recorder 6.18.1 - Release Candidate

17 Reply by nmrs 17-01-2013 09:04:11

Re: Recorder 6.18.1 - Release Candidate

18 Reply by nmrs 17-01-2013 09:34:22

Re: Recorder 6.18.1 - Release Candidate

19 Reply by MikeWeideli 17-01-2013 10:06:40

Re: Recorder 6.18.1 - Release Candidate

20 Reply by nmrs 17-01-2013 10:31:21

Re: Recorder 6.18.1 - Release Candidate

21 Reply by nmrs 18-01-2013 08:32:29

Re: Recorder 6.18.1 - Release Candidate

22 Reply by MikeWeideli 18-01-2013 09:32:10

Re: Recorder 6.18.1 - Release Candidate

23 Reply by nmrs 18-01-2013 11:19:27

Re: Recorder 6.18.1 - Release Candidate

24 Reply by nmrs 23-01-2013 08:13:48

Re: Recorder 6.18.1 - Release Candidate

25 Reply by MikeWeideli 28-01-2013 19:35:31

Re: Recorder 6.18.1 - Release Candidate

Posts: 1 to 25 of 36