|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Recorder Troubleshooting and Bug Reports → Merging individuals - A problem occurred during the merge.
When trying to merge two (just added) individuals I get the error:
A problem occurred during the merge. All data changes have been undone.This appears to be happening with individuals & organisations, but not with locations, documents, surveys, events, samples or occurrences.
I have been trying various things to see if I can get the merge on individuals to fail, but so far with no sucesss. Is it happening every time you try a merge or just on specific individuals. I can't think of any tables where the merge would fail to make the change, so my first thought is that it must failing when it attempts to delete the original entry, which suggests that the name is being used in a table which is not being updated by the merge. Any thoughts ?
Appears to occur with any individual - old or new.
If I create two test individuals (with just a surname), they can't be merged together but I can delete them.
Thanks. Will investigate further.
Following the updates to Recorder, I'm give the following error message when trying to merge individuals:
date/time : 2012-12-20, 16:34:23, 138ms
computer name : LBP2
user name : charliebarnes
registered owner : User
operating system : Windows 7 build 7600
system language : English
system up time : 7 hours 18 minutes
program up time : 50 seconds
processors : 2x Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
physical memory : 1311/3037 MB (free/total)
free disk space : (C:) 225.85 GB
display mode : 1280x1024, 32 bit
process id : $1184
allocated memory : 41.49 MB
command line : RecorderApp.exe /1115506
executable : RecorderApp.exe
exec. date/time : 2012-12-17 14:41
version : 6.18.1.259
compiled with : Delphi 7
madExcept version : 3.0n
callstack crc : $96d947b1, $6608c258, $6608c258
exception number : 1
exception class : EMergeDataError
exception message : A problem occurred during the merge. All data changes have been undone.
main thread ($794):
00760121 RecorderApp.exe MergeDataData 203 +29 TdmMergeData.ProcessMerge
0093f2b2 RecorderApp.exe MergeData 449 +17 TfrmMergeData.bbMergeClick
004dd2c8 RecorderApp.exe Controls TControl.Click
004d23d0 RecorderApp.exe StdCtrls TButton.Click
004d24c4 RecorderApp.exe StdCtrls TButton.CNCommand
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004d2294 RecorderApp.exe StdCtrls TButtonControl.WndProc
004dcf00 RecorderApp.exe Controls TControl.Perform
004e02c7 RecorderApp.exe Controls DoControlMsg
004e091f RecorderApp.exe Controls TWinControl.WMCommand
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004dfe0c RecorderApp.exe Controls TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes StdWndProc
77047690 user32.dll SendMessageW
770641f4 user32.dll CallWindowProcA
004e0273 RecorderApp.exe Controls TWinControl.DefaultHandler
004dd6d0 RecorderApp.exe Controls TControl.WMLButtonUp
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004d2294 RecorderApp.exe StdCtrls TButtonControl.WndProc
004dfe0c RecorderApp.exe Controls TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes StdWndProc
77043573 user32.dll DispatchMessageA
004fe2fb RecorderApp.exe Forms TApplication.ProcessMessage
004fe332 RecorderApp.exe Forms TApplication.HandleMessage
004fe562 RecorderApp.exe Forms TApplication.Run
00a8edb0 RecorderApp.exe RecorderApp 414 +79 initialization
775e1152 kernel32.dll BaseThreadInitThunk
thread $17b8:
776b5aea ntdll.dll NtWaitForMultipleObjects
75a2691e KERNELBASE.dll WaitForMultipleObjectsEx
775df105 kernel32.dll WaitForMultipleObjectsEx
770490b8 user32.dll MsgWaitForMultipleObjectsEx
770459f9 user32.dll MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
775e1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($794) at:
775e27f8 kernel32.dll CreateThread
thread $d8c:
776b5aea ntdll.dll NtWaitForMultipleObjects
775e1152 kernel32.dll BaseThreadInitThunk
thread $15cc:
776b5b1a ntdll.dll NtWaitForWorkViaWorkerFactory
775e1152 kernel32.dll BaseThreadInitThunk
thread $8d8:
776b5b1a ntdll.dll NtWaitForWorkViaWorkerFactory
775e1152 kernel32.dll BaseThreadInitThunk
thread $1468:
776b5b1a ntdll.dll NtWaitForWorkViaWorkerFactory
775e1152 kernel32.dll BaseThreadInitThunk
thread $139c:
776b48ba ntdll.dll NtDelayExecution
75a21870 KERNELBASE.dll SleepEx
75a21813 KERNELBASE.dll Sleep
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
775e1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($794) at:
775e27f8 kernel32.dll CreateThread
thread $fd0:
776b5aea ntdll.dll NtWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
775e1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($794) at:
775e27f8 kernel32.dll CreateThread
thread $1278:
776b5b0a ntdll.dll NtWaitForSingleObject
75a21796 KERNELBASE.dll WaitForSingleObjectEx
775defde kernel32.dll WaitForSingleObjectEx
775def8d kernel32.dll WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
775e1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($794) at:
775e27f8 kernel32.dll CreateThread
thread $100c:
776b5b1a ntdll.dll NtWaitForWorkViaWorkerFactory
775e1152 kernel32.dll BaseThreadInitThunk
modules:
00160000 MS5User.Dll 5.0.0.4 C:\Program Files\Recorder 6 Server
00330000 C4DLL.DLL 1.0.0.1 C:\Program Files\Recorder 6 Server
003a0000 ms5cnv.dll 5.0.0.10 C:\Program Files\Recorder 6 Server
00400000 RecorderApp.exe 6.18.1.259 C:\Program Files\Recorder 6 Server
01cd0000 SysHook.dll 1.0.3005.0 C:\Program Files\Acer\Acer PowerSaver
01d80000 SQLOLEDB.RLL 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
05f10000 GoToKey.ocx 6.0.1.10 C:\PROGRA~1\RECORD~1\Addins
06130000 LCPROC~1.OCX C:\PROGRA~1\RECORD~1\Addins
062f0000 PROJEC~1.OCX C:\PROGRA~1\RECORD~1\Addins
07340000 SHOWUN~1.OCX 6.0.0.13 C:\PROGRA~1\RECORD~1\Addins
07550000 STDVAL~1.DLL 6.15.1.230 C:\PROGRA~1\RECORD~1\Addins
07730000 SURVEY~1.OCX 6.0.0.25 C:\PROGRA~1\RECORD~1\Addins
10000000 MS5.Dll 5.0.0.12 C:\Program Files\Recorder 6 Server
547a0000 msadce.dll 6.1.7600.16385 C:\Program Files\Common Files\System\msadc
54830000 msado15.dll 6.1.7600.17036 C:\Program Files\Common Files\System\ado
54940000 sqloledb.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
57660000 HHCtrl.ocx 6.1.7600.16385 C:\Windows\system32
57d10000 DBNETLIB.DLL 6.1.7600.16385 C:\Windows\system32
57d40000 MSDATL3.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
58b40000 RICHED20.dll 5.31.23.1229 C:\Windows\system32
5cfd0000 comsvcs.dll 2001.12.8530.16385 C:\Windows\system32
5d450000 OLEDB32R.DLL 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
5d470000 MSDART.DLL 6.1.7600.16385 C:\Windows\system32
5d490000 oledb32.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
66e10000 olepro32.dll 6.1.7600.16385 C:\Windows\system32
68740000 msadcer.dll 6.1.7600.16385 C:\Program Files\Common Files\System\msadc
68840000 odbc32.dll 6.1.7600.16688 C:\Windows\system32
69340000 netbios.dll 6.1.7600.16385 C:\Windows\system32
69380000 odbcint.dll 6.1.7600.16385 C:\Windows\system32
69b10000 msxml4.dll 4.20.9876.0 C:\Windows\system32
6c7a0000 RICHED32.DLL 6.1.7600.16385 C:\Windows\system32
6dcc0000 security.dll 6.1.7600.16385 C:\Windows\system32
6e900000 mpr.dll 6.1.7600.16385 C:\Windows\system32
6e920000 winspool.drv 6.1.7600.16385 C:\Windows\system32
6ea30000 SHFolder.dll 6.1.7600.16385 C:\Windows\system32
71920000 comctl32.dll 5.82.7600.16661 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16661_none_ebfb56996c72aefc
72c10000 ntdsapi.dll 6.1.7600.16385 C:\Windows\system32
72f30000 rasadhlp.dll 6.1.7600.16385 C:\Windows\system32
73970000 fwpuclnt.dll 6.1.7600.16385 C:\Windows\System32
73a70000 WINNSI.DLL 6.1.7600.16385 C:\Windows\system32
73a80000 IPHLPAPI.DLL 6.1.7600.16385 C:\Windows\system32
73d00000 winmm.dll 6.1.7600.16385 C:\Windows\system32
74440000 gdiplus.dll 6.1.7600.17007 C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.17007_none_72f44f3186198a88
745d0000 uxtheme.dll 6.1.7600.16385 C:\Windows\system32
74610000 dwmapi.dll 6.1.7600.16385 C:\Windows\system32
74640000 Comctl32.dll 6.10.7600.16661 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd
74c40000 wshtcpip.dll 6.1.7600.16385 C:\Windows\System32
74ce0000 version.dll 6.1.7600.16385 C:\Windows\system32
74e10000 credssp.dll 6.1.7600.16385 C:\Windows\system32
74e40000 bcryptprimitives.dll 6.1.7600.16385 C:\Windows\system32
74e80000 ATL.DLL 3.5.2284.0 C:\Windows\system32
74f20000 wkscli.dll 6.1.7600.16385 C:\Windows\system32
74f30000 netutils.dll 6.1.7600.16385 C:\Windows\system32
74f40000 NETAPI32.dll 6.1.7600.17056 C:\Windows\system32
74f60000 wsock32.dll 6.1.7600.16385 C:\Windows\system32
75020000 rsaenh.dll 6.1.7600.16385 C:\Windows\system32
75090000 schannel.DLL 6.1.7600.17035 C:\Windows\system32
75100000 DNSAPI.dll 6.1.7600.16772 C:\Windows\system32
751e0000 msv1_0.DLL 6.1.7600.16420 C:\Windows\system32
75230000 wship6.dll 6.1.7600.16385 C:\Windows\System32
75240000 mswsock.dll 6.1.7600.16385 C:\Windows\system32
75280000 CRYPTSP.dll 6.1.7600.16385 C:\Windows\system32
753b0000 bcrypt.dll 6.1.7600.16385 C:\Windows\system32
753d0000 ncrypt.dll 6.1.7600.17035 C:\Windows\system32
75490000 cryptdll.dll 6.1.7600.16385 C:\Windows\system32
75650000 srvcli.dll 6.1.7600.16385 C:\Windows\system32
756c0000 SECUR32.DLL 6.1.7600.16915 C:\Windows\system32
756e0000 SSPICLI.DLL 6.1.7600.16915 C:\Windows\system32
75750000 CRYPTBASE.dll 6.1.7600.16385 C:\Windows\system32
75760000 SXS.DLL 6.1.7600.16385 C:\Windows\system32
757c0000 RpcRtRemote.dll 6.1.7600.16385 C:\Windows\system32
75870000 MSASN1.dll 6.1.7600.16415 C:\Windows\system32
758e0000 CRYPT32.dll 6.1.7600.17035 C:\Windows\system32
75a20000 KERNELBASE.dll 6.1.7600.17135 C:\Windows\system32
75b00000 shell32.dll 6.1.7600.17038 C:\Windows\system32
76750000 sechost.dll 6.1.7600.16385 C:\Windows\SYSTEM32
76930000 LPK.dll 6.1.7600.16385 C:\Windows\system32
76b80000 msvcrt.dll 7.0.7600.16930 C:\Windows\system32
76c30000 SHLWAPI.dll 6.1.7600.16385 C:\Windows\system32
76c90000 GDI32.dll 6.1.7600.16385 C:\Windows\system32
76ce0000 USP10.dll 1.626.7600.16385 C:\Windows\system32
76e00000 CLBCatQ.DLL 2001.12.8530.16385 C:\Windows\system32
77030000 user32.dll 6.1.7600.16385 C:\Windows\system32
77100000 RPCRT4.dll 6.1.7600.16385 C:\Windows\system32
771b0000 ole32.dll 6.1.7600.16624 C:\Windows\system32
77310000 NSI.dll 6.1.7600.16385 C:\Windows\system32
77320000 MSCTF.dll 6.1.7600.16385 C:\Windows\system32
77400000 oleaut32.dll 6.1.7600.16872 C:\Windows\system32
774f0000 advapi32.dll 6.1.7600.16385 C:\Windows\system32
77590000 kernel32.dll 6.1.7600.17135 C:\Windows\system32
77670000 ntdll.dll 6.1.7600.16915 C:\Windows\SYSTEM32
777b0000 WS2_32.dll 6.1.7600.16385 C:\Windows\system32
777f0000 comdlg32.dll 6.1.7600.16385 C:\Windows\system32
77880000 IMM32.DLL 6.1.7600.16385 C:\Windows\system32
processes:
0000 Idle 0 0 0
0004 System 0 0 0
0128 smss.exe 0 0 0
01cc csrss.exe 0 0 0
01f4 wininit.exe 0 0 0
01fc csrss.exe 1 0 0
0220 winlogon.exe 1 0 0
0248 services.exe 0 0 0
0254 lsass.exe 0 0 0
0260 lsm.exe 0 0 0
02d8 svchost.exe 0 0 0
0318 AtService.exe 0 0 0
0348 svchost.exe 0 0 0
03ac svchost.exe 0 0 0
0404 svchost.exe 0 0 0
041c svchost.exe 0 0 0
0484 svchost.exe 0 0 0
04b0 svchost.exe 0 0 0
0504 svchost.exe 0 0 0
05d0 spoolsv.exe 0 0 0
05f0 svchost.exe 0 0 0
0668 ASLSvc.exe 0 0 0
0694 eLockServ.exe 0 0 0
0778 ETService.exe 0 0 0
07ac GREGsvc.exe 0 0 0
07e8 INVU.Client.Services.exe 0 0 0
0140 sqlservr.exe 0 0 0
0194 IScheduleSvc.exe 0 0 0
0330 ccSvcHst.exe 0 0 0
04d8 svchost.exe 0 0 0
0540 UpdaterService.exe 0 0 0
0724 winvnc.exe 0 0 0
087c unsecapp.exe 0 0 0
0888 WmiPrvSE.exe 0 0 0
0a18 Smc.exe 0 0 0
0ac0 WUDFHost.exe 0 0 0
0b6c svchost.exe 0 0 0
0cfc winvnc.exe 1 0 0
0ed8 svchost.exe 0 0 0
0f9c SearchIndexer.exe 0 0 0
03b8 taskhost.exe 1 26 20 normal C:\Windows\system32
084c ccSvcHst.exe 1 75 31 normal C:\Program Files\Symantec\Symantec Endpoint Protection\12.1.671.4971.105\Bin
0f38 Dwm.exe 1 21 3 high C:\Windows\system32
0f74 Explorer.EXE 1 517 388 normal C:\Windows
0fb8 BackupManagerTray.exe 1 40 15 normal C:\Program Files\NewTech Infosystems\Acer Backup Manager
0aa4 PowerSaverTray.exe 1 15 9 normal C:\Program Files\Acer\Acer PowerSaver
0d7c WavXDocMgr.exe 1 9 3 normal C:\Program Files\Wave Systems Corp\Services Manager\DocMgr\bin
0ea4 hkcmd.exe 1 10 16 normal C:\Windows\System32
0f78 igfxpers.exe 1 9 4 normal C:\Windows\System32
03b4 jusched.exe 1 9 2 normal C:\Program Files\Common Files\Java\Java Update
06b0 OUTLOOK.EXE 1 886 533 normal C:\Program Files\Microsoft Office\Office14
0b40 mobsync.exe 1 17 13 normal C:\Windows\System32
0eb4 OSPPSVC.EXE 0 0 0
1490 MSPUB.EXE 1 174 88 normal C:\Program Files\Microsoft Office\Office14
1138 FNPLicensingService.exe 0 0 0
0e90 mapshell.drv 1 78 65 normal C:\Program Files\MapInfo\Professional
10d4 Mapinfow.exe 1 321 106 normal C:\Program Files\MapInfo\Professional
0ae8 taskeng.exe 0 0 0
15d8 firefox.exe 1 37 41 normal C:\Program Files\Mozilla Firefox
1184 RecorderApp.exe 1 250 161 normal C:\Program Files\Recorder 6 Server
1380 audiodg.exe 0 0 0
hardware:
+ [xufkY][DVÐ/CÐ-GÖ? d????? !!! ]
- HL-DT-ST DVDRAM GH60N ATA Device
+ Computer
- ACPI x86-based PC
+ Disk drives
- Generic- Compact Flash USB Device
- Multiple Flash Reader USB Device
- WDC WD6400AAKS-22A7B2 ATA Device
+ Display adapters
- Intel(R) G41 Express Chipset (driver 8.15.10.2202)
+ Human Interface Devices
- HID-compliant consumer control device
- HID-compliant device
- HID-compliant device
- HID-compliant device
- USB Input Device
- USB Input Device
- USB Input Device
- USB Input Device
+ IDE ATA/ATAPI controllers
- ATA Channel 0
- ATA Channel 0
- ATA Channel 1
- ATA Channel 1
- Intel(R) ICH7 Family Ultra ATA Storage Controllers - 27DF (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family Serial ATA Storage Controller - 27C0 (driver 9.1.1.1016)
+ Keyboards
- HID Keyboard Device
- Standard PS/2 Keyboard
+ Mice and other pointing devices
- HID-compliant mouse
- Microsoft PS/2 Mouse
+ Monitors
- Generic PnP Monitor
+ Network adapters
- Broadcom NetXtreme Gigabit Ethernet (driver 12.4.0.2)
+ Portable Devices
- F:\
- G:\
+ Ports (COM & LPT)
- Communications Port (COM1)
- Communications Port (COM2)
- Printer Port (LPT1)
+ Processors
- Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
- Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
+ Sound, video and game controllers
- Realtek High Definition Audio (driver 6.0.1.5983)
+ Storage volume shadow copies
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
+ System devices
- ACPI Fixed Feature Button
- ACPI Power Button
- ACPI Thermal Zone
- ACPI Thermal Zone
- Composite Bus Enumerator
- Direct memory access controller
- File as Volume Driver
- High Definition Audio Controller
- High precision event timer
- Intel(R) 4 Series Chipset Processor to I/O Controller - 2E30
- Intel(R) 82801 PCI Bridge - 244E
- Intel(R) 82802 Firmware Hub Device
- Intel(R) ICH7 Family LPC Interface Controller - 27B8 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family PCI Express Root Port - 27D0 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family SMBus Controller - 27DA (driver 9.1.1.1016)
- Microsoft ACPI-Compliant System
- Microsoft System Management BIOS Driver
- Microsoft Virtual Drive Enumerator Driver
- Microsoft Windows Management Interface for ACPI
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Numeric data processor
- PCI bus
- Plug and Play Software Device Enumerator
- Printer Port Logical Interface
- Programmable interrupt controller
- Remote Desktop Device Redirector Bus
- System board
- System board
- System CMOS/real time clock
- System speaker
- System timer
- Terminal Server Keyboard Driver
- Terminal Server Mouse Driver
- UMBus Enumerator
- UMBus Enumerator
- UMBus Root Bus Enumerator
- Virtual PC Host Bus Driver
- Volume Manager
+ Universal Serial Bus controllers
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27C8 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27C9 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27CA (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27CB (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB2 Enhanced Host Controller - 27CC (driver 9.1.1.1016)
- USB Composite Device
- USB Composite Device
- USB Mass Storage Device
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
+ USB Virtualization
- USB Virtualization Connector DriverNot sure why this is happening and can't duplicate it. The erorr mesage isn't too helpful so John has done a special .exe which will produce a more meaningful error message. This is too big to include as an attachment so is at www.Recorder6.info/RecorderApp.zip
Find you existing Recorderapp.exe and temporarily rename it. Then replace it with the new file unzipped. If you run the merge again this should hopefully give us a better idea of what is happening.
Hi Mike, see below... looks even less useful though?
date/time : 2012-12-21, 09:30:38, 953ms
computer name : LBP2
user name : charliebarnes
registered owner : User
operating system : Windows 7 build 7600
system language : English
system up time : 10 minutes 31 seconds
program up time : 25 seconds
processors : 2x Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
physical memory : 1501/3037 MB (free/total)
free disk space : (C:) 227.81 GB
display mode : 1280x1024, 32 bit
process id : $8bc
allocated memory : 35.17 MB
executable : RecorderApp.exe
exec. date/time : 2012-12-21 09:30
version : 6.18.1.259
compiled with : Delphi 7
madExcept version : 3.0n
callstack crc : $2199054b, $732ace3d, $732ace3d
exception number : 1
exception class : Unknown
exception message : Unknown.
main thread ($1110):
007600f9 RecorderApp.exe MergeDataData 203 +29 TdmMergeData.ProcessMerge
0093f28a RecorderApp.exe MergeData 449 +17 TfrmMergeData.bbMergeClick
004dd2c8 RecorderApp.exe Controls TControl.Click
004d23d0 RecorderApp.exe StdCtrls TButton.Click
004d24c4 RecorderApp.exe StdCtrls TButton.CNCommand
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004d2294 RecorderApp.exe StdCtrls TButtonControl.WndProc
004dcf00 RecorderApp.exe Controls TControl.Perform
004e02c7 RecorderApp.exe Controls DoControlMsg
004e091f RecorderApp.exe Controls TWinControl.WMCommand
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004dfe0c RecorderApp.exe Controls TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes StdWndProc
76347690 user32.dll SendMessageW
763641f4 user32.dll CallWindowProcA
004e0273 RecorderApp.exe Controls TWinControl.DefaultHandler
004dd6d0 RecorderApp.exe Controls TControl.WMLButtonUp
004dd130 RecorderApp.exe Controls TControl.WndProc
004e018f RecorderApp.exe Controls TWinControl.WndProc
004d2294 RecorderApp.exe StdCtrls TButtonControl.WndProc
004dfe0c RecorderApp.exe Controls TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes StdWndProc
76343573 user32.dll DispatchMessageA
004fe2fb RecorderApp.exe Forms TApplication.ProcessMessage
004fe332 RecorderApp.exe Forms TApplication.HandleMessage
004fe562 RecorderApp.exe Forms TApplication.Run
00a8ed88 RecorderApp.exe RecorderApp 414 +79 initialization
767c1152 kernel32.dll BaseThreadInitThunk
thread $1154:
77a95aea ntdll.dll NtWaitForMultipleObjects
75cf691e KERNELBASE.dll WaitForMultipleObjectsEx
767bf105 kernel32.dll WaitForMultipleObjectsEx
763490b8 user32.dll MsgWaitForMultipleObjectsEx
763459f9 user32.dll MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
767c1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($1110) at:
767c27f8 kernel32.dll CreateThread
thread $1658:
77a95aea ntdll.dll NtWaitForMultipleObjects
767c1152 kernel32.dll BaseThreadInitThunk
thread $1144:
77a95b1a ntdll.dll NtWaitForWorkViaWorkerFactory
767c1152 kernel32.dll BaseThreadInitThunk
thread $230:
77a95b1a ntdll.dll NtWaitForWorkViaWorkerFactory
767c1152 kernel32.dll BaseThreadInitThunk
thread $13fc:
77a948ba ntdll.dll NtDelayExecution
75cf1870 KERNELBASE.dll SleepEx
75cf1813 KERNELBASE.dll Sleep
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
767c1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($1110) at:
767c27f8 kernel32.dll CreateThread
thread $16d8:
77a95aea ntdll.dll NtWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
767c1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($1110) at:
767c27f8 kernel32.dll CreateThread
thread $16e8:
77a95b0a ntdll.dll NtWaitForSingleObject
75cf1796 KERNELBASE.dll WaitForSingleObjectEx
767befde kernel32.dll WaitForSingleObjectEx
767bef8d kernel32.dll WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
767c1152 kernel32.dll BaseThreadInitThunk
>> created by main thread ($1110) at:
767c27f8 kernel32.dll CreateThread
modules:
00160000 MS5User.Dll 5.0.0.4 C:\Program Files\Recorder 6 Server
00310000 C4DLL.DLL 1.0.0.1 C:\Program Files\Recorder 6 Server
00400000 RecorderApp.exe 6.18.1.259 C:\Program Files\Recorder 6 Server
01c20000 ms5cnv.dll 5.0.0.10 C:\Program Files\Recorder 6 Server
02ad0000 SysHook.dll 1.0.3005.0 C:\Program Files\Acer\Acer PowerSaver
03fd0000 SQLOLEDB.RLL 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
05af0000 GoToKey.ocx 6.0.1.10 C:\PROGRA~1\RECORD~1\Addins
05ff0000 STDVAL~1.DLL 6.15.1.230 C:\PROGRA~1\RECORD~1\Addins
061d0000 SURVEY~1.OCX 6.0.0.25 C:\PROGRA~1\RECORD~1\Addins
06d20000 LCPROC~1.OCX C:\PROGRA~1\RECORD~1\Addins
06ee0000 PROJEC~1.OCX C:\PROGRA~1\RECORD~1\Addins
070b0000 SHOWUN~1.OCX 6.0.0.13 C:\PROGRA~1\RECORD~1\Addins
10000000 MS5.Dll 5.0.0.12 C:\Program Files\Recorder 6 Server
531c0000 msado15.dll 6.1.7600.17036 C:\Program Files\Common Files\System\ado
56480000 sqloledb.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
58290000 RICHED20.dll 5.31.23.1229 C:\Windows\system32
58380000 HHCtrl.ocx 6.1.7600.16385 C:\Windows\system32
597e0000 odbc32.dll 6.1.7600.16688 C:\Windows\system32
5a490000 DBNETLIB.DLL 6.1.7600.16385 C:\Windows\system32
5a4c0000 odbcint.dll 6.1.7600.16385 C:\Windows\system32
5be50000 MSDATL3.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
5be80000 comsvcs.dll 2001.12.8530.16385 C:\Windows\system32
5bfc0000 OLEDB32R.DLL 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
5bfe0000 oledb32.dll 6.1.7600.16385 C:\Program Files\Common Files\System\Ole DB
66a80000 olepro32.dll 6.1.7600.16385 C:\Windows\system32
67ce0000 msadcer.dll 6.1.7600.16385 C:\Program Files\Common Files\System\msadc
694d0000 netbios.dll 6.1.7600.16385 C:\Windows\system32
69780000 RICHED32.DLL 6.1.7600.16385 C:\Windows\system32
69b10000 msxml4.dll 4.20.9876.0 C:\Windows\system32
69e40000 MSDART.DLL 6.1.7600.16385 C:\Windows\system32
6df70000 security.dll 6.1.7600.16385 C:\Windows\system32
6ece0000 SHFolder.dll 6.1.7600.16385 C:\Windows\system32
6efc0000 mpr.dll 6.1.7600.16385 C:\Windows\system32
6efe0000 winspool.drv 6.1.7600.16385 C:\Windows\system32
71d40000 comctl32.dll 5.82.7600.16661 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16661_none_ebfb56996c72aefc
73120000 ntdsapi.dll 6.1.7600.16385 C:\Windows\system32
73340000 rasadhlp.dll 6.1.7600.16385 C:\Windows\system32
73e20000 WINNSI.DLL 6.1.7600.16385 C:\Windows\system32
73e30000 IPHLPAPI.DLL 6.1.7600.16385 C:\Windows\system32
73e60000 winmm.dll 6.1.7600.16385 C:\Windows\system32
73eb0000 fwpuclnt.dll 6.1.7600.16385 C:\Windows\System32
744a0000 dwmapi.dll 6.1.7600.16385 C:\Windows\system32
747f0000 gdiplus.dll 6.1.7600.17007 C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.17007_none_72f44f3186198a88
74980000 uxtheme.dll 6.1.7600.16385 C:\Windows\system32
749c0000 Comctl32.dll 6.10.7600.16661 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd
75020000 wshtcpip.dll 6.1.7600.16385 C:\Windows\System32
750c0000 version.dll 6.1.7600.16385 C:\Windows\system32
751f0000 credssp.dll 6.1.7600.16385 C:\Windows\system32
75220000 bcryptprimitives.dll 6.1.7600.16385 C:\Windows\system32
75260000 ATL.DLL 3.5.2284.0 C:\Windows\system32
75300000 wkscli.dll 6.1.7600.16385 C:\Windows\system32
75310000 netutils.dll 6.1.7600.16385 C:\Windows\system32
75320000 NETAPI32.dll 6.1.7600.17056 C:\Windows\system32
75340000 wsock32.dll 6.1.7600.16385 C:\Windows\system32
75400000 rsaenh.dll 6.1.7600.16385 C:\Windows\system32
75470000 schannel.DLL 6.1.7600.17035 C:\Windows\system32
754e0000 DNSAPI.dll 6.1.7600.16772 C:\Windows\system32
755c0000 msv1_0.DLL 6.1.7600.16420 C:\Windows\system32
75610000 wship6.dll 6.1.7600.16385 C:\Windows\System32
75620000 mswsock.dll 6.1.7600.16385 C:\Windows\system32
75660000 CRYPTSP.dll 6.1.7600.16385 C:\Windows\system32
75790000 bcrypt.dll 6.1.7600.16385 C:\Windows\system32
757b0000 ncrypt.dll 6.1.7600.17035 C:\Windows\system32
75870000 cryptdll.dll 6.1.7600.16385 C:\Windows\system32
75a30000 srvcli.dll 6.1.7600.16385 C:\Windows\system32
75aa0000 SECUR32.DLL 6.1.7600.16915 C:\Windows\system32
75ac0000 SSPICLI.DLL 6.1.7600.16915 C:\Windows\system32
75b30000 CRYPTBASE.dll 6.1.7600.16385 C:\Windows\system32
75b40000 SXS.DLL 6.1.7600.16385 C:\Windows\system32
75ba0000 RpcRtRemote.dll 6.1.7600.16385 C:\Windows\system32
75c50000 MSASN1.dll 6.1.7600.16415 C:\Windows\system32
75cf0000 KERNELBASE.dll 6.1.7600.17135 C:\Windows\system32
75d60000 CRYPT32.dll 6.1.7600.17035 C:\Windows\system32
75ee0000 GDI32.dll 6.1.7600.16385 C:\Windows\system32
75f30000 SHLWAPI.dll 6.1.7600.16385 C:\Windows\system32
76280000 msvcrt.dll 7.0.7600.16930 C:\Windows\system32
76330000 user32.dll 6.1.7600.16385 C:\Windows\system32
76400000 ole32.dll 6.1.7600.16624 C:\Windows\system32
76560000 MSCTF.dll 6.1.7600.16385 C:\Windows\system32
76630000 oleaut32.dll 6.1.7600.16872 C:\Windows\system32
766c0000 comdlg32.dll 6.1.7600.16385 C:\Windows\system32
76770000 kernel32.dll 6.1.7600.17135 C:\Windows\system32
76850000 RPCRT4.dll 6.1.7600.16385 C:\Windows\system32
76ae0000 WS2_32.dll 6.1.7600.16385 C:\Windows\system32
76b20000 NSI.dll 6.1.7600.16385 C:\Windows\system32
76b30000 advapi32.dll 6.1.7600.16385 C:\Windows\system32
76d70000 CLBCatQ.DLL 2001.12.8530.16385 C:\Windows\system32
76e00000 shell32.dll 6.1.7600.17038 C:\Windows\system32
77a50000 ntdll.dll 6.1.7600.16915 C:\Windows\SYSTEM32
77b90000 LPK.dll 6.1.7600.16385 C:\Windows\system32
77ba0000 IMM32.DLL 6.1.7600.16385 C:\Windows\system32
77bc0000 sechost.dll 6.1.7600.16385 C:\Windows\SYSTEM32
77be0000 USP10.dll 1.626.7600.16385 C:\Windows\system32
77d00000 msadce.dll 6.1.7600.16385 C:\Program Files\Common Files\System\msadc
processes:
0000 Idle 0 0 0
0004 System 0 0 0
0128 smss.exe 0 0 0
01cc csrss.exe 0 0 0
01ec wininit.exe 0 0 0
0200 csrss.exe 1 0 0
0220 winlogon.exe 1 0 0
0248 services.exe 0 0 0
0254 lsass.exe 0 0 0
0260 lsm.exe 0 0 0
02d8 svchost.exe 0 0 0
031c AtService.exe 0 0 0
0348 svchost.exe 0 0 0
0398 svchost.exe 0 0 0
03e0 svchost.exe 0 0 0
0408 svchost.exe 0 0 0
0448 audiodg.exe 0 0 0
0468 svchost.exe 0 0 0
048c svchost.exe 0 0 0
04e8 svchost.exe 0 0 0
05d0 spoolsv.exe 0 0 0
05f4 svchost.exe 0 0 0
0668 ASLSvc.exe 0 0 0
0690 eLockServ.exe 0 0 0
0778 ETService.exe 0 0 0
07a8 GREGsvc.exe 0 0 0
07e0 INVU.Client.Services.exe 0 0 0
0150 sqlservr.exe 0 0 0
0198 IScheduleSvc.exe 0 0 0
0178 ccSvcHst.exe 0 0 0
04b0 svchost.exe 0 0 0
0544 UpdaterService.exe 0 0 0
06a0 winvnc.exe 0 0 0
0874 unsecapp.exe 0 0 0
087c WmiPrvSE.exe 0 0 0
09c8 Smc.exe 0 0 0
0ab0 WUDFHost.exe 0 0 0
0b80 svchost.exe 0 0 0
0cdc winvnc.exe 1 0 0
0ee0 svchost.exe 0 0 0
0fb0 SearchIndexer.exe 0 0 0
0d28 TrustedInstaller.exe 0 0 0
0a94 ccSvcHst.exe 1 74 31 normal C:\Program Files\Symantec\Symantec Endpoint Protection\12.1.671.4971.105\Bin
0b94 taskhost.exe 1 26 23 normal C:\Windows\system32
0e78 Dwm.exe 1 17 2 high C:\Windows\system32
0ec0 Explorer.EXE 1 622 477 normal C:\Windows
0d74 BackupManagerTray.exe 1 40 15 normal C:\Program Files\NewTech Infosystems\Acer Backup Manager
0c24 PowerSaverTray.exe 1 15 9 normal C:\Program Files\Acer\Acer PowerSaver
0f08 WavXDocMgr.exe 1 9 3 normal C:\Program Files\Wave Systems Corp\Services Manager\DocMgr\bin
0674 hkcmd.exe 1 10 16 normal C:\Windows\System32
0558 igfxpers.exe 1 9 4 normal C:\Windows\System32
0ecc jusched.exe 1 9 2 normal C:\Program Files\Common Files\Java\Java Update
0d9c OUTLOOK.EXE 1 625 364 normal C:\Program Files\Microsoft Office\Office14
0e60 mobsync.exe 1 17 13 normal C:\Windows\System32
102c OSPPSVC.EXE 0 0 0
10b4 wuauclt.exe 1 22 6 normal C:\Windows\system32
121c svchost.exe 0 0 0
13a8 SearchProtocolHost.exe 1 24 28 normal C:\Windows\system32
15fc firefox.exe 1 102 53 normal C:\Program Files\Mozilla Firefox
0f8c SearchProtocolHost.exe 0 0 0
058c SearchFilterHost.exe 0 0 0
17e4 taskeng.exe 0 0 0
08bc RecorderApp.exe 1 244 155 normal C:\Program Files\Recorder 6 Server
hardware:
+ [xufkY][DVÐ/CÐ-GÖ? d????? !!! ]
- HL-DT-ST DVDRAM GH60N ATA Device
+ Computer
- ACPI x86-based PC
+ Disk drives
- Generic- Compact Flash USB Device
- Multiple Flash Reader USB Device
- WDC WD6400AAKS-22A7B2 ATA Device
+ Display adapters
- Intel(R) G41 Express Chipset (driver 8.15.10.2202)
+ Human Interface Devices
- HID-compliant consumer control device
- HID-compliant device
- HID-compliant device
- HID-compliant device
- USB Input Device
- USB Input Device
- USB Input Device
- USB Input Device
+ IDE ATA/ATAPI controllers
- ATA Channel 0
- ATA Channel 0
- ATA Channel 1
- ATA Channel 1
- Intel(R) ICH7 Family Ultra ATA Storage Controllers - 27DF (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family Serial ATA Storage Controller - 27C0 (driver 9.1.1.1016)
+ Keyboards
- HID Keyboard Device
- Standard PS/2 Keyboard
+ Mice and other pointing devices
- HID-compliant mouse
- Microsoft PS/2 Mouse
+ Monitors
- Generic PnP Monitor
+ Network adapters
- Broadcom NetXtreme Gigabit Ethernet (driver 12.4.0.2)
+ Portable Devices
- F:\
- G:\
+ Ports (COM & LPT)
- Communications Port (COM1)
- Communications Port (COM2)
- Printer Port (LPT1)
+ Processors
- Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
- Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
+ Sound, video and game controllers
- Realtek High Definition Audio (driver 6.0.1.5983)
+ Storage volume shadow copies
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
- Generic volume shadow copy
+ System devices
- ACPI Fixed Feature Button
- ACPI Power Button
- ACPI Thermal Zone
- ACPI Thermal Zone
- Composite Bus Enumerator
- Direct memory access controller
- File as Volume Driver
- High Definition Audio Controller
- High precision event timer
- Intel(R) 4 Series Chipset Processor to I/O Controller - 2E30
- Intel(R) 82801 PCI Bridge - 244E
- Intel(R) 82802 Firmware Hub Device
- Intel(R) ICH7 Family LPC Interface Controller - 27B8 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family PCI Express Root Port - 27D0 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family SMBus Controller - 27DA (driver 9.1.1.1016)
- Microsoft ACPI-Compliant System
- Microsoft System Management BIOS Driver
- Microsoft Virtual Drive Enumerator Driver
- Microsoft Windows Management Interface for ACPI
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Motherboard resources
- Numeric data processor
- PCI bus
- Plug and Play Software Device Enumerator
- Printer Port Logical Interface
- Programmable interrupt controller
- Remote Desktop Device Redirector Bus
- System board
- System board
- System CMOS/real time clock
- System speaker
- System timer
- Terminal Server Keyboard Driver
- Terminal Server Mouse Driver
- UMBus Enumerator
- UMBus Enumerator
- UMBus Root Bus Enumerator
- Virtual PC Host Bus Driver
- Volume Manager
+ Universal Serial Bus controllers
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27C8 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27C9 (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27CA (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB Universal Host Controller - 27CB (driver 9.1.1.1016)
- Intel(R) N10/ICH7 Family USB2 Enhanced Host Controller - 27CC (driver 9.1.1.1016)
- USB Composite Device
- USB Composite Device
- USB Mass Storage Device
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
- USB Root Hub
+ USB Virtualization
- USB Virtualization Connector DriverYou are right - it didn't help. We think this must be data, but don't know what can be causing it. If you woudl like it investigated further then we will need a copy of your database ( a backup will be Ok) so that John can investigate.
Thanks Mike - I'll give the data another once over and have a go with a clean db. I'll let you/John know if I get to a dead end.
Did you ever get to the bottom of this Charlie?
We are now getting this exact same error. I don't know if it happens with every merge, but I have had it with at least three different ones today and have not successfully merged anything so it looks likely.
We had the same problem a week or so back, but then one of the duplicate names was from an imported dataset of which we don't have custodianship. so I circumvented it by editing via the access database (we are allowed to do this because of the relationship we have with the other custodian, basically a one-way data exchange setup).
I have just attempted a similar fix with one of the duplicate pairs from today, where the offending individual had only a few samples I did the following (names have been changed to protect the innocent).
1. For each survey event associated with the individual JS, added the recorder John Smith
2. For each sample within those events unticked the recorder JS and ticked John Smith
3. Back in the survey event deleted JS from the recorders
4. In the Access database, created an update query which changed the TAXON_DETERMINATION.DETERMINER value of all records where JS was the determiner to the NAME_KEY of John Smith
5. Deleted the individual JS from the database.
This worked.
But I still cannot merge any of the other examples and some of those have a lot more survey events and samples.
Any ideas?
Yes, but I forget the "answer" - a row had been added to a table that (I think) meant Recorder was looking for the individual to be deleted in a non-existant table - it couldn't find this table, so it flopped. It had something to do with MapInfo (I wondered if I had tried to connect to our DB with MapInfo?)
I had to use watch the SQL statements that were being issued to find out the problem.
Mike may remember or have the emails.... I'll see if anything rings a bell.
Do you remember how you watched the SQL statements? Sounds like a useful thing I should be able to do but can't.
One of the free SQL profilers available.. not sure which one; something like http://expressprofiler.codeplex.com/ (something similar should be built into SQL Server)
The profiler comes with SQL Server (full version) or with the developers version, but not with SQL Express. I tried to free tools once and they did work, but no recent experience. It would certainly help to find out what is causing this.
a row had been added to a table
I think it might have been the DATABASE_RELATIONSHIP table?
Have you got any non standard tables installed, say by addins ? I attach the install version of the relationship table. Are there any obvious differences with your version especially where NAME is involved ?
Well that's a new table on me, didn't even know it was there. I just queried our table & didn't find any with NAME as the Master Table or Detail Table that were not in your list.
What next?
OK I have got hold of the profiler and run a trace, caused the error, what am I looking for?
I assume that the last item in the trace before the transaction rollback is likely to be the problem, in which case it has nothing to do with the NAME table, it seems to be a problem with the execution of a user view. This particular view takes a while to execute, could this be some kind of timeout? Or a permissions issue? Or am I on the wrong track entirely?
I have put a special version of recorderapp,exe at www.Lfield.co.uk/download/RecorderApp.zip
If you can download this and replace your existing RecorderApp.exe temporarily (take a copy of the current one and restore it afterwards), it will show a bit more information as it processes the merge.
Just try one merge and note the message which appear. The .exe is for version R6 v6.22 so it may cause problems if you try to open the observation hierarchy.
Mike
The Message was
DELETE FROM USER WHERE NAME_KEY = "DSS00628000003XK"
This was the Name which needed deleting, but they are not in the USER table
Does that help?
Did it error after that ? It should have gone on and displayed all the queries it was trying to run.
No it errored after that.
I think I have a partial solution though. As I described in my post above when I traced the merge process it showed that the error occurred as the database was executing a user view called WWT\robl.uvw_WSBRC_NonNotableFilter. This lists every record in the database with a flag saying whether the species is considered non-notable in Wiltshire. We intended to use this in an additional filter to exclude from wizard report which selects species with notable statuses, those species which we do not consider to be locally notable, despite their national status (such as Scots Pine). Since this view displays all 1.5 million records it is a bit slow to use, but very helpful.
However at the time that I created the view, for some reason I didn't like the result (can't remember the reasoning, but probably permissions related) so I created another (identical one) called dbo.WSBRC_NONNOTABLEFILTER and this was the one which I put into the USEABLE_FIELD table, the other version was not used.
I have just deleted the WWT\robl version and now the merge works properly. I have no idea exactly why the database was processing that view when logged into through Recorder UI, but it seems clear that something was indeed timing out and now does not.
Can you shed any light Mike, I sometimes feel I understand less about SQL dbs than I really should?
The only thing I know of which could have an impact is if there was an index on the view as I think these are updated dynamically.
I don't think I put an index on it, but it might have included an indexed field. However the second version is functionally identical and this does not cause the problem, indeed I could not even find it in the trace.
The last six items in the trace were all execution of user views, all of which began with my windows login and they are all the views I have created since I ceased to be the dbOwner a year or so ago. Now the dbOwner is linked to the sa login, so if I use SQL verification as sa to open management studio, the views I create begin with dbo (I now realise). No dbo views were executed in the trace as far as I could see. None of the other views executed caused the problem, but all were relatively trivial ones. The execution items followed on from some references to the USER table (explaining why your exe produced that message and no other.
A mystery then, but at least the problem was solved.
Forum → Recorder Troubleshooting and Bug Reports → Merging individuals - A problem occurred during the merge.
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.