1 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Unable to add name

When trying to import a spreadsheet of records, a recorders name wasn't in the database, so I clicked on the "make new entry" - nothing happened. I clicked on the search button to make a new entry the old fashioned way and when I try and save it:

date/time         : 2010-02-22, 13:48:41, 988ms
computer name     : DATA2
user name         : charliebarnes
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 4 hours 23 minutes 
program up time   : 2 hours 3 minutes 
processor         : Intel(R) Celeron(R) CPU 2.40GHz
physical memory   : 504/1007 MB (free/total)
free disk space   : (C:) 22.66 GB
display mode      : 1024x768, 32 bit
process id        : $ff4
allocated memory  : 40.42 MB
command line      : RecorderApp.exe /7144164
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 13:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EJNCCDatabaseError
exception message : Unable to add new item in NAME table..

main thread ($2f8):
0062bfc8 RecorderApp.exe  
7c90e485 ntdll.dll        KiUserExceptionDispatcher
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

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

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

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

thread $e8c:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx

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

thread $c8c: <priority:15>
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7c80a110 kernel32.dll  WaitForMultipleObjects

thread $a14: <priority:2>
7c90e514 ntdll.dll   KiFastSystemCallRet
7e427766 user32.dll  GetMessageA
>> created by thread $bd8 at:
76b45e9f winmm.dll   

thread $cd0:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

modules:
00340000 C4DLL.DLL       1.0.0.1          C:\Program Files\Recorder 6 Server
003b0000 MS5User.Dll     5.0.0.4          C:\Program Files\Recorder 6 Server
00400000 RecorderApp.exe 6.14.4.212       C:\Program Files\Recorder 6 Server
01180000 ms5cnv.dll      5.0.0.10         C:\Program Files\Recorder 6 Server
01a70000 odbcint.dll     3.525.1132.0     C:\WINDOWS\system32
02320000 Normaliz.dll    6.0.5441.0       C:\WINDOWS\system32
028c0000 xpsp2res.dll    5.1.2600.5512    C:\WINDOWS\system32
03ab0000 SQLOLEDB.RLL    2000.85.1132.0   C:\Program Files\Common Files\System\OLE DB
03ad0000 msadcer.dll     2.81.1132.0      C:\Program Files\Common Files\System\MSADC
03e00000 GoToKey.ocx     6.0.1.10         C:\PROGRA~1\RECORD~1\Addins
04070000 RECORD~1.OCX    6.0.0.52         C:\PROGRA~1\RECORD~1\Addins
042b0000 SHOWUN~1.OCX    6.0.0.13         C:\PROGRA~1\RECORD~1\Addins
044e0000 STDVAL~1.DLL    6.14.3.208       C:\PROGRA~1\RECORD~1\Addins
046e0000 SURVEY~1.OCX    6.0.0.25         C:\PROGRA~1\RECORD~1\Addins
04f40000 msls31.dll      3.10.349.0       C:\WINDOWS\system32
10000000 MS5.Dll         5.0.0.12         C:\Program Files\Recorder 6 Server
20000000 xpsp3res.dll    5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll     8.0.6001.18828   C:\WINDOWS\system32
3da20000 mshtml.dll      8.0.6001.18828   C:\WINDOWS\system32
3dfd0000 iertutil.dll    8.0.6001.18828   C:\WINDOWS\system32
3e1c0000 ieframe.dll     8.0.6001.18828   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
55600000 FwcWsp.dll      4.0.3440.81      C:\Program Files\Microsoft Firewall Client 2004
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
60f80000 SnacNp.dll      11.0.4010.7      C:\Program Files\Symantec AntiVirus
63380000 jscript.dll     5.8.6001.18702   C:\WINDOWS\system32
65e20000 itss.dll        5.2.3790.4186    C:\WINDOWS\system32
65e50000 itircl.dll      5.2.3790.2453    C:\WINDOWS\system32
662b0000 hnetcfg.dll     5.1.2600.5512    C:\WINDOWS\system32
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.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
71cf0000 kerberos.dll    5.1.2600.5834    C:\WINDOWS\system32
71f80000 security.dll    5.1.2600.5512    C:\WINDOWS\system32
72d10000 msacm32.drv     5.1.2600.0       C:\WINDOWS\system32
72d20000 wdmaud.drv      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
732e0000 RICHED32.DLL    5.1.2600.0       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
746f0000 msimtf.dll      5.1.2600.5512    C:\WINDOWS\system32
74720000 MSCTF.dll       5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll    5.30.23.1230     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
755c0000 msctfime.ime    5.1.2600.5512    C:\WINDOWS\system32
75cf0000 MLANG.dll       6.0.2900.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
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
767f0000 schannel.dll    5.1.2600.5834    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
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
77690000 NTMARTA.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
77b40000 appHelp.dll     5.1.2600.5512    C:\WINDOWS\system32
77bd0000 midimap.dll     5.1.2600.5512    C:\WINDOWS\system32
77be0000 MSACM32.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.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.5512    C:\WINDOWS\system32
77fe0000 Secur32.dll     5.1.2600.5834    C:\WINDOWS\system32
78130000 urlmon.dll      8.0.6001.18828   C:\WINDOWS\system32
79000000 mscoree.dll     2.0.50727.253    C:\WINDOWS\system32
79410000 mscorie.dll     1.1.4322.2443    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
7c340000 MSVCR71.dll     7.10.3052.4      C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
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.5622    C:\WINDOWS\system32
7d1e0000 msi.dll         3.1.4001.5512    C:\WINDOWS\system32
7e290000 shdocvw.dll     6.0.2900.5880    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 : Violation of PRIMARY KEY constraint 'PK_NAME'. Cannot insert duplicate key in object 'dbo.Name'
Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Unable to add name

And now it seems I can't add taxon occurences, taxon determinations or locations.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by johnvanbreda

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

Re: Unable to add name

Hi Charlie.

Just a hunch - I wonder if your last_key table is broken? You can check this with the following query:

SELECT last_key_text FROM last_key WHERE table_name='NAME'

SELECT RIGHT(MAX(name_key), 8) FROM name WHERE LEFT(name_key, 8)=(SELECT data FROM setting WHERE name='SiteID')

These queries should both return the same 8 character key. If not then the last_key table needs to be rebuilt.

Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website