1 (edited by TonyP 12-01-2010 11:07:59)

Re: Adding a Tag to Survey.

Run R6, open observations. Open Termlists. Create new tag. Locate Survey edit, add tag. Locate another survey add Tag, Click on Tag and....

operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 7 days
program up time   : 19 minutes
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 1442/1919 MB (free/total)
free disk space   : (C:) 46.10 GB (U:) 44.90 GB
display mode      : 1280x1024, 32 bit
process id        : $d08
allocated memory  : 29.95 MB
command line      : RecorderApp.exe /4589136
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 08:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleException
exception message : Violation of UNIQUE KEY constraint 'IX_Term_Unique'. Cannot insert duplicate key in object 'dbo.Term'.

main thread ($36c):
005658a2 RecorderApp.exe 
7e42f406 user32.dll       SendMessageA
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00340000 C4DLL.DLL         1.0.0.1          U:
003b0000 MS5User.Dll       5.0.0.4          U:
00400000 RecorderApp.exe   6.14.5.218       U:
013c0000 ms5cnv.dll        5.0.0.10         U:
01b50000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
02ce0000 Normaliz.dll      6.0.5441.0       C:\WINDOWS\system32
036a0000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
036b0000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
039e0000 ShowUnchecked.ocx 6.0.0.13         U:\Addins
03c40000 StdValLib.dll     6.14.3.208       U:\Addins
04930000 SPGRMR.DLL        5.1.2600.5512    C:\WINDOWS\IME
04e70000 SKCHUI.DLL        1.0.1038.0       C:\Program Files\Common Files\Microsoft Shared\INK
06ca0000 msls31.dll        3.10.349.0       C:\WINDOWS\system32
07860000 MSVCR80.dll       8.0.50727.4053   C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989
10000000 MS5.Dll           5.0.0.12         U:
16080000 mdnsNSP.dll       1.0.3.1          C:\Program Files\Bonjour
20000000 xpsp3res.dll      5.1.2600.5512    C:\WINDOWS\system32
3d7a0000 jscript.dll       5.8.6001.22886   C:\WINDOWS\system32
3d930000 WININET.dll       8.0.6001.18854   C:\WINDOWS\system32
3da20000 mshtml.dll        8.0.6001.18854   C:\WINDOWS\system32
3dfd0000 iertutil.dll      8.0.6001.18854   C:\WINDOWS\system32
3e1c0000 ieframe.dll       8.0.6001.18854   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
548e0000 MSDBG2.DLL        8.0.50727.42     C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG
54b20000 PDM.DLL           8.0.50727.42     C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG
5ad70000 uxtheme.dll       6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll      5.1.2600.5694    C:\WINDOWS\system32
5c2c0000 sptip.dll         5.1.2600.5512    C:\WINDOWS\ime
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
63f00000 mscorie.dll       2.0.50727.3053   c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
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
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
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
74c80000 OLEACC.dll        4.2.5406.0       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
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
76080000 MSVCP60.dll       6.2.3104.0       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
76600000 CSCDLL.dll        5.1.2600.5512    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
769c0000 USERENV.dll       5.1.2600.5512    C:\WINDOWS\system32
76b40000 winmm.dll         5.1.2600.5512    C:\WINDOWS\system32
76bf0000 PSAPI.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
77a20000 cscui.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
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.18854   C:\WINDOWS\system32
79000000 mscoree.dll       2.0.50727.3053   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.5622    C:\WINDOWS\system32
7d1e0000 msi.dll           3.1.4001.5512    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

Is there a time when R6 does something without a debug event? Is it worth me posting these?

Data Manger
Somerset Environmental Records Centre

2

Re: Adding a Tag to Survey.

Hi Tony,

Are you adding a survey tag (ie grouping your surveys)? if so you can do this in the observation hierarchy or the enhanced termlist (select tag from the dropdown). It sounds like you are trying to add something else which does not like to be duplicated. posting your exact steps would be helpful.

Cheers,
Lynn

3 (edited by TonyP 13-01-2010 10:19:07)

Re: Adding a Tag to Survey.

Thanks

Run R6, open observations. Open enhanced termlist. Create new tag. Locate Survey edit, add tag using search button. Locate another survey add Tag, Click on Tag and....

I did it this way as that is what the help says to do. It appears one has to create the tag before being able to choose and that is how the context help described the process.

As R6 has crashed so badly I now have to restart my PC any better answer will have to wait. I'd just like it to run for a few hours without crashing.

I finally tracked the crash down to a server failure. The reason unknown. I have not yet retried the Tag issue but will address that later today perhaps after my current import.

Data Manger
Somerset Environmental Records Centre

4

Re: Adding a Tag to Survey.

I'm afraid this is still an issue. This time I created a survey tag from the survey list and assigned one survey the tag. On trying to add another survey the system crashes [restart/continue dialog].

The system becomes unstable and continues to fail even after restarting. I will now have to restart the PC to clear the error. The behaviour therefore appears consistent for me at least.

Lynn let me know if you would like me to supply further details as I know others are not having the same trouble with tags.

Tony

Data Manger
Somerset Environmental Records Centre

5

Re: Adding a Tag to Survey.

Hi Tony,

Unfortunately I was unable to reproduce your error using the steps outlined above so this issue may be user-specific. Can I recommend that you upgrade to 6.15 once available as this contains better error handling and will help us diagnose the problem.

Best wishes,
Mary Campling
(Recorder Project Manager)

6

Re: Adding a Tag to Survey.

Thanks Mary much appreciated.

Data Manger
Somerset Environmental Records Centre

7

Re: Adding a Tag to Survey.

Hi Tony
I can't reproduce this either in 6.14.5. Definitely worth a shot in 6.15 because even if it still fails, we should get more detailed error information.
Best Wishes

John van Breda
Biodiverse IT

8 (edited by charliebarnes 11-09-2014 15:46:11)

Re: Adding a Tag to Survey.

Editing a specific tag name in the enhanced term list is now giving me this error - however the edits are being saved to the TERM table but not shown in the hierachy (which may explain the duplicate key error if dupe tags names aren't allowed... ? but they seem to be...?)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

9

Re: Adding a Tag to Survey.

Following on from these it appears I have a lot of tags in the TERM table that I had thought I had deleted, but apparently aren't.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership