1 Reply by swtmike

  • swtmike
  • Member
  • Offline
  • Registered: 13-10-2009
  • Posts: 31

Re: Dictionary Upgrades Incorrectly Installed?

Hello,

we get the unhandled error message below when trying to open the Names database after incorrectly installing dictionary upgrades (K-Q).

I interepreted the instruction to 'download each file...' literally and unzipped each one to the Scripts folder expecting to have the option to run in batches once I ran DictionaryUpgrade.exe. That option did not appear and it completed 'successfully'. Is it possible the error below is because we did not run them separately as outlined in 'Dictionary Downloads' - especially N?

Do I need to restore the database and run the upgrades again (in sequence)?


date/time         : 2010-09-24, 11:52:41, 658ms
computer name     : RCDR-VLTR
user name         : recvolunteer
operating system  : Windows NT New build 7600
system language   : English
system up time    : 3 minutes 16 seconds
program up time   : 2 minutes 34 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 113.68 GB (B:) 7.40 GB
display mode      : 1280x1024, 32 bit
process id        : $ef8
allocated memory  : 54.61 MB
command line      : RecorderApp.exe /66150
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EOleException
exception message : Could not find stored procedure 'usp_RelationRoleType_Select'.

main thread ($f04):
>> internal error in CollectPossibleStackItems:
00417267 RecorderApp.exe madStackTrace SetProgressPos

>> internal error in GetThreadReport:
00417267 RecorderApp.exe madStackTrace SetProgressPos

modules:
002f0000 C4DLL.DLL            1.0.0.1            B:
00360000 MS5User.Dll          5.0.0.4            B:
003b0000 ms5cnv.dll           5.0.0.10           B:
00400000 RecorderApp.exe      6.15.4.238         B:
04120000 GoToGridControl.ocx  2.0.0.16           B:\Addins
04790000 GoToKey.ocx          6.0.1.10           B:\Addins
04ab0000 ShowUnchecked.ocx    6.0.0.13           B:\Addins
06100000 NBNExchange.ocx      6.13.2.24          B:\Addins
06470000 StdValLib.dll        6.15.1.230         B:\Addins
06650000 SurveyDelete.ocx     6.0.0.25           B:\Addins
10000000 MS5.Dll              5.0.0.12           B:
69b10000 msxml4.dll           4.20.9876.0        c:\Windows\system32
6a280000 RICHED32.DLL         6.1.7600.16385     C:\Windows\system32
6a290000 msadcer.dll          6.1.7600.16385     C:\Program Files\Common Files\System\msadc
6a2a0000 msadce.dll           6.1.7600.16385     C:\Program Files\Common Files\System\msadc
6a360000 DBNETLIB.DLL         6.1.7600.16385     C:\Windows\system32
6a390000 sqloledb.dll         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
6a480000 comsvcs.dll          2001.12.8530.16385 C:\Windows\system32
6a5c0000 oledb32.dll          6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
6a6a0000 msado15.dll          6.1.7600.16385     C:\Program Files\Common Files\System\ado
6a7a0000 HHCtrl.ocx           6.1.7600.16385     C:\Windows\system32
6a830000 SQLOLEDB.RLL         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
6a840000 MSDATL3.dll          6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
6a860000 OLEDB32R.DLL         6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
6a880000 MSDART.DLL           6.1.7600.16385     C:\Windows\system32
6a8a0000 olepro32.dll         6.1.7600.16385     C:\Windows\system32
6baa0000 RICHED20.dll         5.31.23.1229       C:\Windows\system32
6f5d0000 DAVHLPR.dll          6.1.7600.16385     C:\Windows\System32
6f5e0000 davclnt.dll          6.1.7600.16385     C:\Windows\System32
6f600000 ntlanman.dll         6.1.7600.16385     C:\Windows\System32
6f620000 drprov.dll           6.1.7600.16385     C:\Windows\System32
6f630000 security.dll         6.1.7600.16385     C:\Windows\system32
70820000 cscapi.dll           6.1.7600.16385     C:\Windows\system32
709e0000 netbios.dll          6.1.7600.16385     C:\Windows\system32
72300000 mpr.dll              6.1.7600.16385     C:\Windows\system32
727e0000 winspool.drv         6.1.7600.16385     C:\Windows\system32
729a0000 ntdsapi.dll          6.1.7600.16385     C:\Windows\system32
729f0000 SHFolder.dll         6.1.7600.16385     C:\Windows\system32
72ea0000 rasadhlp.dll         6.1.7600.16385     C:\Windows\system32
72f70000 odbcint.dll          6.1.7600.16385     C:\Windows\system32
72fd0000 odbc32.dll           6.1.7600.16385     C:\Windows\system32
734e0000 wsock32.dll          6.1.7600.16385     C:\Windows\system32
73730000 fwpuclnt.dll         6.1.7600.16385     C:\Windows\System32
73830000 WINNSI.DLL           6.1.7600.16385     C:\Windows\system32
73840000 IPHLPAPI.DLL         6.1.7600.16385     C:\Windows\system32
73b10000 ATL.DLL              3.5.2284.0         C:\Windows\system32
73df0000 winmm.dll            6.1.7600.16385     C:\Windows\system32
73e30000 ntmarta.dll          6.1.7600.16385     C:\Windows\system32
73fa0000 wkscli.dll           6.1.7600.16385     C:\Windows\system32
73fb0000 NETAPI32.dll         6.1.7600.16385     C:\Windows\system32
74230000 dwmapi.dll           6.1.7600.16385     C:\Windows\system32
743a0000 propsys.dll          7.0.7600.16385     C:\Windows\system32
74510000 gdiplus.dll          6.1.7600.16385     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca
74720000 uxtheme.dll          6.1.7600.16385     C:\Windows\system32
74760000 Comctl32.dll         6.10.7600.16385    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc
74cd0000 version.dll          6.1.7600.16385     C:\Windows\system32
74d60000 wshtcpip.dll         6.1.7600.16385     C:\Windows\System32
74f00000 credssp.dll          6.1.7600.16385     C:\Windows\system32
74f40000 bcryptprimitives.dll 6.1.7600.16385     C:\Windows\system32
74ff0000 netutils.dll         6.1.7600.16385     C:\Windows\system32
75000000 rsaenh.dll           6.1.7600.16385     C:\Windows\system32
75070000 schannel.DLL         6.1.7600.16612     C:\Windows\system32
750e0000 DNSAPI.dll           6.1.7600.16385     C:\Windows\system32
751c0000 msv1_0.DLL           6.1.7600.16420     C:\Windows\system32
75210000 wship6.dll           6.1.7600.16385     C:\Windows\System32
75220000 WINSTA.dll           6.1.7600.16385     C:\Windows\System32
75250000 mswsock.dll          6.1.7600.16385     C:\Windows\system32
75290000 CRYPTSP.dll          6.1.7600.16385     C:\Windows\system32
753a0000 bcrypt.dll           6.1.7600.16385     C:\Windows\system32
753c0000 ncrypt.dll           6.1.7600.16385     C:\Windows\system32
75480000 cryptdll.dll         6.1.7600.16385     C:\Windows\system32
75660000 srvcli.dll           6.1.7600.16385     C:\Windows\system32
756d0000 SECUR32.DLL          6.1.7600.16385     C:\Windows\system32
756f0000 SSPICLI.DLL          6.1.7600.16385     C:\Windows\system32
75760000 CRYPTBASE.dll        6.1.7600.16385     C:\Windows\system32
75770000 SXS.DLL              6.1.7600.16385     C:\Windows\system32
757d0000 RpcRtRemote.dll      6.1.7600.16385     C:\Windows\system32
757e0000 profapi.dll          6.1.7600.16385     C:\Windows\system32
75850000 MSASN1.dll           6.1.7600.16415     C:\Windows\system32
75860000 CFGMGR32.dll         6.1.7600.16385     C:\Windows\system32
75890000 CRYPT32.dll          6.1.7600.16385     C:\Windows\system32
759e0000 comctl32.dll         5.82.7600.16385    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16385_none_ebf82fc36c758ad5
75a70000 KERNELBASE.dll       6.1.7600.16385     C:\Windows\system32
75ac0000 DEVOBJ.dll           6.1.7600.16385     C:\Windows\system32
75ae0000 LPK.dll              6.1.7600.16385     C:\Windows\system32
75b00000 USP10.dll            1.626.7600.16385   C:\Windows\system32
75ba0000 advapi32.dll         6.1.7600.16385     C:\Windows\system32
75d40000 WLDAP32.dll          6.1.7600.16385     C:\Windows\system32
75d90000 MSCTF.dll            6.1.7600.16385     C:\Windows\system32
75e60000 oleaut32.dll         6.1.7600.16385     C:\Windows\system32
76090000 kernel32.dll         6.1.7600.16481     C:\Windows\system32
763a0000 user32.dll           6.1.7600.16385     C:\Windows\system32
76470000 shell32.dll          6.1.7600.16644     C:\Windows\system32
770c0000 CLBCatQ.DLL          2001.12.8530.16385 C:\Windows\system32
77150000 msvcrt.dll           7.0.7600.16385     C:\Windows\system32
77200000 SHLWAPI.dll          6.1.7600.16385     C:\Windows\system32
77260000 RPCRT4.dll           6.1.7600.16385     C:\Windows\system32
77310000 ole32.dll            6.1.7600.16385     C:\Windows\system32
77470000 comdlg32.dll         6.1.7600.16385     C:\Windows\system32
774f0000 SETUPAPI.dll         6.1.7600.16385     C:\Windows\system32
77690000 ntdll.dll            6.1.7600.16559     C:\Windows\SYSTEM32
777d0000 NSI.dll              6.1.7600.16385     C:\Windows\system32
777f0000 IMM32.DLL            6.1.7600.16385     C:\Windows\system32
77810000 WS2_32.dll           6.1.7600.16385     C:\Windows\system32
77850000 GDI32.dll            6.1.7600.16385     C:\Windows\system32
778a0000 sechost.dll          6.1.7600.16385     C:\Windows\SYSTEM32

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Dictionary Upgrades Incorrectly Installed?

Hi,
Actually this problem relates to something that should have been upgraded in your database when you upgraded to version 6.15, which is a separate process to the dictionary upgrade. Please could you try re-running the upgrade kit to upgrade the application to 6.15 again? If that does not work, can you try running the following query and posting back the results (I am assuming you have the tools to do this, if not just let me know). 

select * from setting where name='db seq'

Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by swtmike

  • swtmike
  • Member
  • Offline
  • Registered: 13-10-2009
  • Posts: 31

Re: Dictionary Upgrades Incorrectly Installed?

Thanks for the repy John.

Can I retry the upgrade with everything in place or do I need to do a restore to 6.14 and go through the upgrade again?

Michael

4 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Dictionary Upgrades Incorrectly Installed?

You could try both - it won't take long to run the upgrade and check if that approach works, then only if not you can try the restore and upgrade approach.

John van Breda
Biodiverse IT

johnvanbreda's Website

5 Reply by swtmike

  • swtmike
  • Member
  • Offline
  • Registered: 13-10-2009
  • Posts: 31

Re: Dictionary Upgrades Incorrectly Installed?

I've restored 6.14 and run the upgrade to 6.15 as well as running the dictionary upgrades.

We are still getting the unhandled exception message when trying to access the Names database.

The select query gives Name: DB Seq, Data:0000007l.

6 Reply by sallyrankin

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

Re: Dictionary Upgrades Incorrectly Installed?

If DB Sep is 0000007I your database is still a v6.14.4.212 database. If the upgrade to v6.15.4.238 had worked DB Sep would be 0000007X. Did you ran RecorderUpgrade.exe in Rec6_Upgrade from v6.14.4 to 6.15.4.zip?

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

7 Reply by swtmike

  • swtmike
  • Member
  • Offline
  • Registered: 13-10-2009
  • Posts: 31

Re: Dictionary Upgrades Incorrectly Installed?

Hi,

yes, we ran RecorderUpgrade.exe and it looked like it went through the upgrade process. I'm a bit stuck now though as I don't have 6.14 to retry. Running the upgrade again gives 'Recorder upgrade complete. No database updates were required'.

When running the upgrade I used the windows account rather than the SQL account (the windows account is db_owner) - is this likely to have caused any issues?

8 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Dictionary Upgrades Incorrectly Installed?

Just to make sure, can you please check the contents of the scripts folder beneath the RecorderUpgrade.exe you ran from Rec6_Upgrade from v6.14.4 to 6.15.4.zip, Does it contain at least the files 0000007I through to 0000007X? If not then the upgrade has either not downloaded or not unzipped properly. If it does, then the upgrade kit should not have reported that it completed if the query still returns a value of 0000007I.

John van Breda
Biodiverse IT

johnvanbreda's Website

9 Reply by swtmike

  • swtmike
  • Member
  • Offline
  • Registered: 13-10-2009
  • Posts: 31

Re: Dictionary Upgrades Incorrectly Installed?

The upgrade had not unzipped properly as there was no Scripts folder. We now get 0000007X when running the 'db seq' query and I hope all is well but need our main user to test.

Many thanks for pointing us in the right direction.

10 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Dictionary Upgrades Incorrectly Installed?

No problem.

John van Breda
Biodiverse IT

johnvanbreda's Website