1

Topic: Error at the end of import

We just had this error come up right at the end of importing a dataset, although it looks like the import went ok (all the records that should have been imported were imported).

Any more info on what this means would be appreciated.

Thanks,

Phil




operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : English
system up time    : 3 hours 59 minutes
program up time   : 3 hours 44 minutes
processors        : 2x Pentium(R) Dual-Core CPU E5700 @ 3.00GHz
physical memory   : 2064/3996 MB (free/total)
free disk space   : (C:) 60.55 GB
display mode      : 1440x900, 32 bit
process id        : $f80
allocated memory  : 109.71 MB
command line      : RecorderApp.exe /197750
executable        : RecorderApp.exe
exec. date/time   : 2014-03-24 11:48
version           : 6.22.2.274
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $10656e4e, $a9ca2ce4, $a9ca2ce4
exception number  : 1
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_SURVEY_EVENT_RECORDER into the main database.

main thread ($a58):
0075d5ba RecorderApp.exe DBMerger        337 +42 TDBMerger.CopyTableIntoMainDB
778a015e ntdll.dll                               KiUserExceptionDispatcher
0075fa96 RecorderApp.exe DBMerger        748  +3 TDBMerger.ExcludedRecord
0075d776 RecorderApp.exe DBMerger        357  +9 TDBMerger.CopySingleRecord
0075d496 RecorderApp.exe DBMerger        313 +18 TDBMerger.CopyTableIntoMainDB
0075d1b5 RecorderApp.exe DBMerger        274 +35 TDBMerger.DoMerge
007674b7 RecorderApp.exe TempData_ADO   1332  +8 TTempData.CopyRecordsIntoMainDB
009dedf7 RecorderApp.exe ImportAnalysis  769  +6 TfraImportAnalysis.SaveContent
009f0a1b RecorderApp.exe ImportWizard    180  +8 TfrmImportWizard.btnNextClick
004dd2c8 RecorderApp.exe Controls                TControl.Click
004d23d0 RecorderApp.exe StdCtrls                TButton.Click
00499075 RecorderApp.exe Buttons                 TBitBtn.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
00751bc9 RecorderApp.exe XPMenu         2928 +10 TControlSubClass.ControlSubClass
778be78d ntdll.dll                               RtlAnsiStringToUnicodeString
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
76fc7945 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
00751bc9 RecorderApp.exe XPMenu         2928 +10 TControlSubClass.ControlSubClass
00430c3c RecorderApp.exe Classes                 StdWndProc
004dfe0c RecorderApp.exe Controls                TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes                 StdWndProc
76fb7bc5 USER32.dll                              DispatchMessageA
004fe2fb RecorderApp.exe Forms                   TApplication.ProcessMessage
004fe332 RecorderApp.exe Forms                   TApplication.HandleMessage
004fe562 RecorderApp.exe Forms                   TApplication.Run
00a95918 RecorderApp.exe RecorderApp     414 +79 initialization
75773378 kernel32.dll                            BaseThreadInitThunk

thread $1544:
759015f1 KERNELBASE.dll            WaitForMultipleObjectsEx
75771a07 kernel32.dll              WaitForMultipleObjectsEx
76fc0864 USER32.dll                MsgWaitForMultipleObjectsEx
76fc0b64 USER32.dll                MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75773378 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($a58) at:
757734a0 kernel32.dll              CreateThread

thread $cf4:
75773378 kernel32.dll  BaseThreadInitThunk

thread $b30:
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75773378 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($a58) at:
757734a0 kernel32.dll              CreateThread

thread $e54:
759014a5 KERNELBASE.dll            WaitForSingleObjectEx
7577118f kernel32.dll              WaitForSingleObjectEx
75771143 kernel32.dll              WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
75773378 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($a58) at:
757734a0 kernel32.dll              CreateThread

thread $173c:
778b1f8b ntdll.dll     NtWaitForWorkViaWorkerFactory
75773378 kernel32.dll  BaseThreadInitThunk

2

Re: Error at the end of import

It looks like it has failed to create records in Survey Event Recorder. This may not be that obvious in the output results as the records will be there, but with no recorders.  I can't think why this should happen, especially if all the other  information has imported correctly. Can you have a look at a few of the records to see if the Recorders are there. they will be missing on they Survey Events.

Mike Weideli

3

Re: Error at the end of import

No, there seems to be no issue with the Survey Event recorders in the records that were imported so I am not sure why that message came up.

4

Re: Error at the end of import

May be worth running the Last Key addin if you have it installed.

Mike Weideli