1 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: error and other problems importing onto a laptop

Dear all,

have been busy importing data for a large cross-border project into a laptop version of Recorder 6 (6.14).  have been importing relatively straightforward - with the occassional "recorder has encountered an error -close/restart//continue option box....but now, that happens every time, and I cannot create new observers!

heer is the error on the last import - only happens at the final do import stage, when everythign matched up and ready to go....

very tight timeline on this project and we do not really want to put this databse on our server, wheer we have our standard county databse with a separate ID etc.

any ideas what Ican easily do next?
Louise
CPERC

date/time         : 2011-12-14, 11:00:47, 448ms
computer name     : CPERC-LAPTOP
user name         : Administrator
operating system  : Windows NT New x64 build 7600
system language   : English
system up time    : 1 hour 40 minutes
program up time   : 3 minutes 37 seconds
processors        : 2x Pentium(R) Dual-Core CPU       T4400  @ 2.20GHz
physical memory   : 2414/4056 MB (free/total)
free disk space   : (C:) 380.49 GB
display mode      : 1366x768, 32 bit
process id        : $758
allocated memory  : 78.51 MB
command line      : RecorderApp.exe /2294998
executable        : RecorderApp.exe
exec. date/time   : 2011-11-30 11:27
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EDBMergerError
exception message : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database.

main thread ($73c):
>> internal error in CollectPossibleStackItems:
00417887 ???

>> internal error in GetThreadReport:
00417887 ???

modules:
00400000 RecorderApp.exe      6.14.4.212         C:\Program Files (x86)\Recorder 6 Server
00c20000 C4DLL.DLL            1.0.0.1            C:\Program Files (x86)\Recorder 6 Server
00c90000 MS5User.Dll          5.0.0.4            C:\Program Files (x86)\Recorder 6 Server
00d40000 ms5cnv.dll           5.0.0.10           C:\Program Files (x86)\Recorder 6 Server
05380000 GOTOGR~1.OCX         2.0.0.16           C:\PROGRA~2\RECORD~1\Addins
064b0000 GoToKey.ocx          6.0.1.8            C:\PROGRA~2\RECORD~1\Addins
066d0000 SHOWUN~1.OCX         6.0.0.11           C:\PROGRA~2\RECORD~1\Addins
068e0000 STDVAL~1.DLL         6.13.2.175         C:\PROGRA~2\RECORD~1\Addins
071c0000 iertutil.dll         8.0.7600.16700     C:\Windows\syswow64
0f9a0000 VBAJET32.DLL         6.0.1.9431         C:\Windows\system32
0f9c0000 expsrv.dll           6.0.72.9589        C:\Windows\system32
10000000 MS5.Dll              5.0.0.12           C:\Program Files (x86)\Recorder 6 Server
65e30000 GRA32A~1.DLL         12.0.4518.1014     C:\PROGRA~2\MICROS~2\Office12
661c0000 GR469A~1.DLL         12.0.4518.1014     C:\PROGRA~2\MICROS~2\Office12
68ef0000 GrooveUtil.DLL       12.0.4518.1014     C:\PROGRA~2\MICROS~2\Office12
68ff0000 GrooveNew.DLL        12.0.4518.1014     C:\PROGRA~2\MICROS~2\Office12
69b10000 msxml4.dll           4.20.9876.0        c:\Windows\SysWOW64
70550000 odbccp32.dll         6.1.7600.16385     C:\Windows\system32
70570000 sqlsrv32.rll         6.1.7600.16385     C:\Windows\system32
70590000 SQLSRV32.dll         6.1.7600.16385     C:\Windows\system32
70650000 msjtes40.dll         4.0.9756.0         C:\Windows\SysWOW64
706a0000 mswstr10.dll         4.0.9756.0         C:\Windows\SysWOW64
70740000 msjet40.dll          4.0.9756.0         C:\Windows\SysWOW64
708d0000 msjetoledb40.dll     4.0.9756.0         C:\Windows\SysWOW64
70930000 msadox.dll           6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
70990000 ieframe.DLL          8.0.7600.16700     C:\Windows\system32
71410000 SearchFolder.dll     6.1.7600.16385     C:\Windows\system32
714b0000 WindowsCodecs.dll    6.1.7600.16385     C:\Windows\system32
715f0000 msader15.dll         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
71600000 msadrh15.dll         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
71620000 SHDOCVW.dll          6.1.7600.16385     C:\Windows\system32
71650000 ntshrui.dll          6.1.7600.16385     C:\Windows\system32
71750000 odbc32.dll           6.1.7600.16385     C:\Windows\system32
717e0000 comctl32.dll         5.82.7600.16661    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16661_none_ebfb56996c72aefc
71870000 propsys.dll          7.0.7600.16385     C:\Windows\system32
719b0000 uxtheme.dll          6.1.7600.16385     C:\Windows\system32
71a30000 OLEACC.dll           7.0.0.0            C:\Windows\system32
71a70000 ieproxy.dll          8.0.7600.16700     C:\Program Files (x86)\Internet Explorer
71aa0000 dwmapi.dll           6.1.7600.16385     C:\Windows\system32
71ac0000 version.dll          6.1.7600.16385     C:\Windows\system32
71bd0000 msxml3.dll           8.110.7600.16605   C:\Windows\System32
71d60000 bcryptprimitives.dll 6.1.7600.16385     C:\Windows\SysWOW64
71da0000 bcrypt.dll           6.1.7600.16385     C:\Windows\system32
71ed0000 msjter40.dll         4.0.9756.0         C:\Windows\SysWOW64
71ef0000 actxprxy.dll         6.1.7600.16385     C:\Windows\SysWOW64
71f40000 MSJINT40.DLL         4.0.9756.0         C:\Windows\SysWOW64
71f50000 StructuredQuery.dll  7.0.7600.16587     C:\Windows\System32
71fb0000 EhStorShell.dll      6.1.7600.16385     C:\Windows\system32
71ff0000 tiptsf.dll           6.1.7600.16385     C:\Program Files (x86)\Common Files\microsoft shared\ink
72050000 thumbcache.dll       6.1.7600.16385     C:\Windows\SysWOW64
72070000 slc.dll              6.1.7600.16385     C:\Windows\system32
72080000 MSImg32.dll          6.1.7600.16385     C:\Windows\system32
72090000 ATL80.DLL            8.0.50727.4053     C:\Windows\WinSxS\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.4053_none_d1c738ec43578ea1
720b0000 msadcer.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
720c0000 msadce.dll           6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
72150000 SQLOLEDB.RLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
72160000 DBNETLIB.DLL         6.1.7600.16385     C:\Windows\system32
72190000 netbios.dll          6.1.7600.16385     C:\Windows\system32
721a0000 MSDATL3.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
721c0000 sqloledb.dll         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
722b0000 ATL.DLL              3.5.2284.0         C:\Windows\system32
722d0000 comsvcs.dll          2001.12.8530.16385 C:\Windows\system32
72410000 OLEDB32R.DLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
72430000 oledb32.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
72510000 MSDART.DLL           6.1.7600.16385     C:\Windows\system32
72530000 msado15.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\ado
72630000 SXS.DLL              6.1.7600.16385     C:\Windows\system32
72690000 olepro32.dll         6.1.7600.16385     C:\Windows\system32
726b0000 gdiplus.dll          6.1.7600.16385     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca
72840000 HHCtrl.ocx           6.1.7600.16385     C:\Windows\system32
72cc0000 SHFolder.dll         6.1.7600.16385     C:\Windows\system32
731f0000 odbcint.dll          6.1.7600.16385     C:\Windows\system32
73230000 ntdsapi.dll          6.1.7600.16385     C:\Windows\system32
73370000 cryptdll.dll         6.1.7600.16385     C:\Windows\system32
73390000 msv1_0.DLL           6.1.7600.16420     C:\Windows\SysWOW64
734a0000 credssp.dll          6.1.7600.16385     C:\Windows\system32
734b0000 security.dll         6.1.7600.16385     C:\Windows\system32
73550000 wsock32.dll          6.1.7600.16385     C:\Windows\system32
73590000 Comctl32.dll         6.10.7600.16661    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd
73730000 ntmarta.dll          6.1.7600.16385     C:\Windows\system32
738d0000 RpcRtRemote.dll      6.1.7600.16385     C:\Windows\system32
738e0000 rsaenh.dll           6.1.7600.16385     C:\Windows\system32
73920000 CRYPTSP.dll          6.1.7600.16385     C:\Windows\system32
73960000 mpr.dll              6.1.7600.16385     C:\Windows\system32
73980000 winspool.drv         6.1.7600.16385     C:\Windows\system32
73a70000 apphelp.dll          6.1.7600.16385     C:\Windows\system32
73ae0000 cscapi.dll           6.1.7600.16385     C:\Windows\system32
73b20000 wkscli.dll           6.1.7600.16385     C:\Windows\system32
73b30000 srvcli.dll           6.1.7600.16385     C:\Windows\system32
73b50000 netutils.dll         6.1.7600.16385     C:\Windows\system32
73b60000 NETAPI32.dll         6.1.7600.16385     C:\Windows\system32
73b80000 winmm.dll            6.1.7600.16385     C:\Windows\system32
73bc0000 profapi.dll          6.1.7600.16385     C:\Windows\system32
73c80000 MSVCR80.dll          8.0.50727.4927     C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5
74810000 SECUR32.DLL          6.1.7600.16484     C:\Windows\system32
74b10000 CRYPTBASE.dll        6.1.7600.16385     C:\Windows\syswow64
74b20000 SspiCli.dll          6.1.7600.16484     C:\Windows\syswow64
74bb0000 WS2_32.dll           6.1.7600.16385     C:\Windows\syswow64
74bf0000 DEVOBJ.dll           6.1.7600.16385     C:\Windows\syswow64
74cd0000 DBmsLPCn.dll         2000.80.760.0      C:\Windows\system32
74e10000 user32.dll           6.1.7600.16385     C:\Windows\syswow64
74f10000 kernel32.dll         6.1.7600.16385     C:\Windows\syswow64
75010000 SETUPAPI.dll         6.1.7600.16385     C:\Windows\syswow64
751b0000 MSASN1.dll           6.1.7600.16415     C:\Windows\syswow64
751c0000 SHLWAPI.dll          6.1.7600.16385     C:\Windows\syswow64
75220000 MSCTF.dll            6.1.7600.16385     C:\Windows\syswow64
752f0000 RPCRT4.dll           6.1.7600.16385     C:\Windows\syswow64
753e0000 oleaut32.dll         6.1.7600.16567     C:\Windows\syswow64
75470000 sechost.dll          6.1.7600.16385     C:\Windows\SysWOW64
75490000 WININET.dll          8.0.7600.16700     C:\Windows\syswow64
75590000 WLDAP32.dll          6.1.7600.16385     C:\Windows\syswow64
756a0000 KERNELBASE.dll       6.1.7600.16385     C:\Windows\syswow64
756f0000 CFGMGR32.dll         6.1.7600.16385     C:\Windows\syswow64
75720000 Normaliz.dll         6.1.7600.16385     C:\Windows\syswow64
75730000 urlmon.dll           8.0.7600.16700     C:\Windows\syswow64
75870000 comdlg32.dll         6.1.7600.16385     C:\Windows\syswow64
758f0000 USP10.dll            1.626.7600.16385   C:\Windows\syswow64
75990000 LPK.dll              6.1.7600.16385     C:\Windows\syswow64
759a0000 IMM32.DLL            6.1.7600.16385     C:\Windows\system32
75a00000 msvcrt.dll           7.0.7600.16385     C:\Windows\syswow64
75ab0000 ole32.dll            6.1.7600.16624     C:\Windows\syswow64
75c10000 GDI32.dll            6.1.7600.16385     C:\Windows\syswow64
75ca0000 shell32.dll          6.1.7600.16644     C:\Windows\syswow64
768f0000 ADVAPI32.dll         6.1.7600.16385     C:\Windows\syswow64
76990000 CRYPT32.dll          6.1.7600.16385     C:\Windows\syswow64
76ab0000 PSAPI.DLL            6.1.7600.16385     C:\Windows\syswow64
76ac0000 CLBCatQ.DLL          2001.12.8530.16385 C:\Windows\syswow64
76f80000 NSI.dll              6.1.7600.16385     C:\Windows\syswow64
76fb0000 ntdll.dll            6.1.7600.16559     C:\Windows\SysWOW64

Exception Stack

----------------
EOleException : ODBC--insert on a linked table 'SQLSERVER_SURVEY_EVENT' failed
EDBMergerError : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: error and other problems importing onto a laptop

Have you reached the maximum size of the database for the version of SQL Server you are using ?.

See topic http://forums.nbn.org.uk/viewtopic.php?id=2486 and

http://forums.nbn.org.uk/viewtopic.php?pid=9737#p9737

Mike Weideli

MikeWeideli's Website

3 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: error and other problems importing onto a laptop

Dear all,

I will miss out some of the unpleasant details from the middle, but with Sally's guidance we have migrated the database to SQL server2005.  However, despite correcting the registry bits as in the network recorder documentation, and enabling the NBNUser, we still get an error message on start up, which says:


An error occurred whilst starting the application.
EOleException: Login failed for user ‘NBNUser’. The user is not associated with a trusted SQL server connection


Both Sally Rankin and Mike Widelli are now stumped, we have chacked all the security and roles bits for NBN User in studio management express, mine and sally say the same, she canget into her datbase, I cannot.......

  So, anyone with any bright and helpful ideas, or more preferably a solution.............

Louise
CPERC

4 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: error and other problems importing onto a laptop

hello again,

more persistent digging from Sally and Mike, and we seem to be back on track.  who would think so much can be influenced by a (1) or a (0)................

CPERC

5 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: error and other problems importing onto a laptop

Changing Trusted Security from 0 to 1 in HKey_Local_Machine in the Registry enabled Louise to use Recorder 6 with her instance of SQL Server 2005 Express instead of her MSDE instance after migrating the database from one to the other and enabling the NBNUser login with the query

EXEC sp_change_users_login 'Update_One', 'NBNUser', 'NBNUser'

from page 10 of the Network Installation Guide.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687