1

Topic: Recorder 6 crashing during import process

Hi all,
I have had an issue with Recorder 6 crashing at various stages during the import process for a couple of weeks now. latest bug report below:

Can anyone shed any light on this please? Our IT people are stumped.

thanks

operating system  : Windows NT New x64 build 9200 system language   : English system up time    : 6 hours 6 minutes program up time   : 2 hours 36 minutes processors        : 4x Intel(R) Core(TM) i5-6200U CPU @ 2.30GHz physical memory   : 11223/16270 MB (free/total) free disk space   : (C:) 13.03 GB display mode      : 1920x1080, 32 bit process id        : $3b40 allocated memory  : 107.32 MB command line      : RecorderApp.exe /1771306 executable        : RecorderApp.exe exec. date/time   : 2019-04-05 13:48 version           : 6.29.0.290 compiled with     : Delphi 7 madExcept version : 3.0n callstack crc     : $5b5c45c7, $4a64375b, $4a64375b contact name      : Lorna Shaw contact email     : lornas@essexwt.org.uk exception number  : 3 exception class   : EOleException exception message : Connection failure.   main thread ($326c): 0059be26 RecorderApp.exe ADODB                      TADOCommand.Execute 0059bd80 RecorderApp.exe ADODB                      TADOCommand.Execute 0059bd60 RecorderApp.exe ADODB                      TADOCommand.Execute 006729b2 RecorderApp.exe BaseADODataModule  744  +7 TdmBaseADO.GetRecordset 009e5c91 RecorderApp.exe FileSelect         266  +2 TfraFileSelect.cmbSurveyPopulate 006ad3f5 RecorderApp.exe ComboListID        870  +2 TIDComboBox.DoPopulate 006ad334 RecorderApp.exe ComboListID        852 +10 TIDComboBox.PopulateContent 009e5f7f RecorderApp.exe FileSelect         299 +18 TfraFileSelect.LoadContent 009a8f47 RecorderApp.exe IWBasePage         117  +4 TBasePage.Create 009e9803 RecorderApp.exe FileSelect        1323  +1 TfraFileSelect.Create 00a00cb4 RecorderApp.exe ImportWizard       307 +35 TfrmImportWizard.ChangePage 00a0164d RecorderApp.exe ImportWizard       491  +4 TfrmImportWizard.UMChangePage 004dd178 RecorderApp.exe Controls                   TControl.WndProc 004e01d7 RecorderApp.exe Controls                   TWinControl.WndProc 004f7ca5 RecorderApp.exe Forms                      TCustomForm.WndProc 004dfe54 RecorderApp.exe Controls                   TWinControl.MainWndProc 00430c6c RecorderApp.exe Classes                    StdWndProc 744338bb user32.dll                                 DispatchMessageA 004fe343 RecorderApp.exe Forms                      TApplication.ProcessMessage 004fe37a RecorderApp.exe Forms                      TApplication.HandleMessage 004fe5aa RecorderApp.exe Forms                      TApplication.Run 00ab2fa6 RecorderApp.exe RecorderApp        418 +79 initialization 75d38652 KERNEL32.DLL                               BaseThreadInitThunk   thread $10e4: 7443af18 user32.dll                MsgWaitForMultipleObjectsEx 7443aecb user32.dll                MsgWaitForMultipleObjects 00476c1d RecorderApp.exe madExcept CallThreadProcSafe 00476c87 RecorderApp.exe madExcept ThreadExceptFrame 75d38652 KERNEL32.DLL              BaseThreadInitThunk >> created by main thread ($326c) at: 73c126f1 gdiplus.dll   thread $2a0c: 75d38652 KERNEL32.DLL  BaseThreadInitThunk   thread $2ad0: 74f248cd KERNELBASE.dll  WaitForMultipleObjectsEx 75d38652 KERNEL32.DLL    BaseThreadInitThunk   thread $48c: 75d38652 KERNEL32.DLL  BaseThreadInitThunk   thread $1b58: 75d38652 KERNEL32.DLL  BaseThreadInitThunk   thread $2048: 74f248cd KERNELBASE.dll            WaitForMultipleObjectsEx 00476c1d RecorderApp.exe madExcept CallThreadProcSafe 00476c87 RecorderApp.exe madExcept ThreadExceptFrame 75d38652 KERNEL32.DLL              BaseThreadInitThunk >> created by thread $1fe4 at: 74602ee3 combase.dll   thread $1db0: 74f248cd KERNELBASE.dll  WaitForMultipleObjectsEx 74673cca combase.dll     CoWaitForMultipleHandles 75d38652 KERNEL32.DLL    BaseThreadInitThunk   thread $1eec: 75d38652 KERNEL32.DLL  BaseThreadInitThunk

2

Re: Recorder 6 crashing during import process

Looks like some  sort of problem with the connection to the database,  A few questions

1. Which version of R6 are you on
2. Have there been any changes in hardware or software which happened just before this
3. Does Recorder 6 otherwise work normally
4. Are they large imports or does it happen with imports of any  size ?
5  Is there a chance that  SQL Server may have reached capacity

Mike Weideli
Littlefield Consultancy - IT Consultants

3

Re: Recorder 6 crashing during import process

Hi Mike, in answer to your questions:

1. We are on version 6.29.0.290, which I think is the most up to date one?
2. I have swapped my copy of Recorder (ours is networked) from a desktop to a laptop, but the problems started a week or so before that happened.
3. Recorder otherwise appears to be working fine
4. it happens with imports of any size, but more often if I have already imported one dataset (if I do two small datasets the second might cause it to crash). It tends to crash either at the start of the import process or right at the end
5. I don't think so - we currently have just under 750,000 records, although we are looking to upgrade to the full version of SQL shortly.

hope this helps

thanks
Lorna

4

Re: Recorder 6 crashing during import process

Thank you. Nothing much IW wise changed with 6.29 and as you say I think you should have plenty of space.

Please get your IT people to check the SQl Server timeout

Using SQL Server Management Studio

    Connect to MS SQL server via SQL Management Studio.
    In Object Explorer, right-click on the server name and then select Properties.
    In the new tab, click on Connections node.
    In Remote Query Timeout change if it isn't zero change it to zero.

If it is zero already then let me know as this will eliminate timeout as the reason for the problem.

Mike Weideli
Littlefield Consultancy - IT Consultants

5

Re: Recorder 6 crashing during import process

Hi MikeWeideli,

Your last post solved the issue until today where it has started up again.

Remote Query Timeout is on zero.

No changes to the network.

New VoIP phone system installed last week but that shouldn't make a difference.

Thanks

Deon

6

Re: Recorder 6 crashing during import process

Hi all, further to this issue today I have tried restarting Recorder and restarting the computer and then trying the import again but it is crashing at the same stage in the import process - the last step - each time. I imported another dataset earlier today with no problems. Very frustrating. Previously when Recorder has been crashing intermittently it has been working ok when I have tried the import again, but no it does not seem to want to import this dataset at all.

7

Re: Recorder 6 crashing during import process

We need to establish If it is just this dataset or a wider problem. What error message are you getting. Is it the same as before? Can you import other data ?  Try a single record test with just basic details.

Mike Weideli
Littlefield Consultancy - IT Consultants