1 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Recorder 6.14.5 is now available to download http://www.jncc.gov.uk/page-4612 This is a mini release which fixes several incidents arising from 6.14.4 (such as the order of rucksacks being preserved in the recording cards and the matching of locations when importing a GI file). It also includes three enhancements commissioned by the Luxembourg Museum of Natural History (ability ot customise the name_relation_role, remembering the bounding box and ability to alter it when stepping backwards in the report wizard and the production of a metadata file detailing the filters used in a report wizard output). For more information please see the release notes on the webiste (link above).

Dictionaries 0000000K, 0000000L and 0000000M are now available http://www.jncc.gov.uk/page-4615 These correct a number of issues with the designation set items (eg several items such as protection of Badgers not inlcuded correctly), updates the taxon_deisgnation_type table to include the agreed status abbreviations for use in reporting and an update to the habitats dictionary.

2 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Ooops, we broke our copy of recorder installing this!

Not entirely clear how, since I wasn't in the room. But I gather an attempt was made to do the upgrade using SQL server authentication (which we have never used previously , having relied on Windown authentication). The istall progressed apparently normally, then produced an error message which disappeared almost instantly, Then it hung.

I then ran the upgrade again, this time using windows auth and it seemed to work, a few progress bars progessed normally, then errored out again and hung.

The database looked updated, with correct version numbers etc. and we went on to upgrade the dictionaries with no more problems than normal.

Trouble is now the database works normally, until we try to open the Names and addresses view, when it crashes with following message.

I have checked and the usp referred to is not present in the database.

What do I do now, should we restore the backup we made prior to the upgrade (if so how?) and try again.

Help!

date/time         : 2009-12-03, 14:15:29, 965ms
computer name     : WWTMG5-2
user name         : robl
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 4 hours 50 minutes
program up time   : 19 seconds
processors        : 2x Intel(R) Pentium(R) D CPU 3.00GHz
physical memory   : 381/999 MB (free/total)
free disk space   : (C:) 42.12 GB
display mode      : 1280x960, 32 bit
process id        : $9cc
allocated memory  : 22.97 MB
command line      : RecorderApp.exe /590244
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 08:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleException
exception message : Could not find stored procedure 'usp_RelationRoleType_Select'.

main thread ($cec):
005658a2 RecorderApp.exe 
7e4196c2 user32.dll       DispatchMessageA

modules:
00340000 C4DLL.DLL                1.0.0.1          \\wwtsql01\d$\recorder6
003b0000 MS5User.Dll              5.0.0.4          \\wwtsql01\d$\recorder6
00400000 RecorderApp.exe          6.14.5.218       \\wwtsql01\d$\recorder6
013b0000 ms5cnv.dll               5.0.0.10         \\wwtsql01\d$\recorder6
01b50000 odbcint.dll              3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll             5.1.2600.5512    C:\WINDOWS\system32
03690000 SQLOLEDB.RLL             2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
036a0000 msadcer.dll              2.81.1132.0      C:\Program Files\Common Files\System\msadc
03990000 GoToKey.ocx              6.0.1.10         \\wwtsql01\recorder6\Addins
03c00000 LastKeyUpdate.ocx        6.0.0.6          \\wwtsql01\recorder6\Addins
03e00000 NBNExchange.ocx          6.13.2.24        \\wwtsql01\recorder6\Addins
04050000 Phenology.ocx            6.0.1.10         \\wwtsql01\recorder6\Addins
04370000 Recorder_3_Import_v6.ocx 6.0.0.52         \\wwtsql01\recorder6\Addins
045d0000 ShowUnchecked.ocx        6.0.0.13         \\wwtsql01\recorder6\Addins
04800000 StdValLib.dll            6.14.3.208       \\Wwtsql01\recorder6\Addins
10000000 MS5.Dll                  5.0.0.12         \\wwtsql01\d$\recorder6
20000000 xpsp3res.dll             5.1.2600.5512    C:\WINDOWS\system32
4dd00000 sqloledb.dll             2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll              2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll              5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
5ad70000 uxtheme.dll              6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll             5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll             5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll             5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll              2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll              5.1.2600.5512    C:\WINDOWS\system32
69b10000 msxml4.dll               4.20.9876.0      c:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL             2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll              5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll             5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll              5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll               5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll              5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll                  5.1.2600.5512    C:\WINDOWS\system32
71f80000 security.dll             5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv             5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll              2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
732e0000 RICHED32.DLL             5.1.2600.0       C:\WINDOWS\system32
74060000 msadce.dll               2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll               3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll                5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll             5.30.23.1230     C:\WINDOWS\system32
750b0000 RESUTILS.DLL             5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL               2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL              2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL             2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
755c0000 msctfime.ime             5.1.2600.5512    C:\WINDOWS\system32
76390000 IMM32.DLL                5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll             6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL               2.81.1132.0      C:\WINDOWS\system32
76620000 comsvcs.dll              2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll             6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll             5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll              5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll              5.1.2600.5512    C:\WINDOWS\system32
76b40000 winmm.dll                5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL              5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll             5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll               5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll              5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll               5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll             5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL              2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll               2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll             5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll             6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll                5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll             5.1.2600.5512    C:\WINDOWS\system32
77a80000 crypt32.dll              5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll               5.1.2600.5875    C:\WINDOWS\system32
77c00000 version.dll              5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll               7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll               5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll             5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll               5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll                5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll              6.0.2900.5512    C:\WINDOWS\system32
77fe0000 Secur32.dll              5.1.2600.5834    C:\WINDOWS\system32
7c800000 kernel32.dll             5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll                5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll              6.0.2900.5622    C:\WINDOWS\system32
7e410000 user32.dll               5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx               5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL                  5.1.2600.5512    C:\WINDOWS\system32

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

3 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Panic over, I managed to fix it.

I investigated all the various SQL scripts un the update & realised that 0000007J.sql must have failed, probably due to insufficient permissions for the GRANT statements it contains.

So I ran the script on its own and now have cured the problem. Now I just need to see if there are any other problems downstream of this.

But this is really not good enough. It would be the work of a few minutes to modify the update installer to check in advance whether the person doing the upgrade had sufficient access to complete the process, BEFORE doing anything which will make the system unstable.

I have to say that this seems to be a problem throughout Recorder 6. Exception handling is generally quite poor and relies quite heavily on people remembering instructions they read months or years ago.

It would seem in this instance that the update must be run by someone with a very high level of access to the database (dbo_owner?) and yet there is no warning anywhere on the update which warns of this. If the installer was up to the task of checking none would be needed of course.

Please sort this out, it would make life loads easier for all of us.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

4 Reply by RobLarge (edited by RobLarge 04-12-2009 10:16:47)

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Turns out that I had to run all of the supplied scripts as none had completed.

Of course I have no way of knowing whether there is anything else which would have been installed which hasn't. I do know that the access databse hasn't been updated (of course).

So I might be coming back to you with more of this.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

5 Reply by Syrphus

  • Syrphus
  • Veteran
  • Offline
  • From: Strathpeffer, Highland
  • Registered: 16-12-2008
  • Posts: 535

Re: Recorder 6.14.5 and dictionaries K, L and M now available

I have just tried to update dictionaries K, L, M.  I downloaded the files for all three upgrades, and unzipped them to the Scripts folder.  I have a stand-alone running Vista, and was previously on dictionary J.

On running the Upgrades Kit as Administrator and with SQL authentication, I got the error 'Unrecognised database format [path]0000000K.sql'

I downloaded the zip file again, unzipped it, and tried again with the same result.

Any advice?

Murdo

Syrphus's Website

6 Reply by Syrphus

  • Syrphus
  • Veteran
  • Offline
  • From: Strathpeffer, Highland
  • Registered: 16-12-2008
  • Posts: 535

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Further to my post of last night, this morning I

restored the database (it was then in the same state as last night);
upgraded to 6.14.5;
tried the dictionary upgrade;
got a similar message, but this time relating to ...J.sql.

M.

Syrphus's Website

7 Reply by Syrphus

  • Syrphus
  • Veteran
  • Offline
  • From: Strathpeffer, Highland
  • Registered: 16-12-2008
  • Posts: 535

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Further again, I should have said that the 'About' tells me that Dictionary M is the one installed.

M.

Syrphus's Website

8 Reply by johnvanbreda

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

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Hi Murdo,

Just a thought, when you download and unzip the files, are you leaving the downloaded zip files in the scripts folder? Or are you downloading them somewhere else and only putting the unzipped files into the scripts folder? I think if you do the former then it might have the effect you have seen.

Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

9 Reply by Syrphus

  • Syrphus
  • Veteran
  • Offline
  • From: Strathpeffer, Highland
  • Registered: 16-12-2008
  • Posts: 535

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Thanks, John.  I has done exactly that, and after removing them the process ran without a problem.

M.

Syrphus's Website

10 Reply by johnvanbreda

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

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Lynn - Apart from making the code a bit more robust, I guess the download website needs another little clarification about this?

John van Breda
Biodiverse IT

johnvanbreda's Website

11 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Hi John
Yes agreed. I just wanted to check that Murdo actually rolled back the database and ran the updates properly. From the above it looks like if you leave the zip files in the counter get incremented even though the updates cannot have run. If Murdo has just run the updates with the dictionary on M it would appear to be OK but would not have done anything.
WIll get the text changed tomorrow.
Steve

12 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Recorder 6.14.5 and dictionaries K, L and M now available

The website makes it clear to download the files into a temporary folder and THEN unzip them into the scripts folder - but I have clarified the point further to avoid this.

Lynn

13 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Just tried to run the update to 6.14.5 and it fell over with the following error:

Error occurred running script 0000007J.sql. The error is described as:
Cannot find the object 'Relation_Role_Type', because it does not exist or you do not have permission.

----

I ran the upgrade as Windows Authentication, which is what I use to access SQL Server via the management utility,

---

I when into the SQL Server management software and gave my login permission to do everything, ran the upgrade again and got the error:

The SELECT permission was denied on the object 'MAP_SHEET', database 'NBNData', schema 'dbo'

At this point, I cannot find any other permissions to change - so I'm stuck HELP!

Craig Slawson
Staffordshire Ecological Record

ser's Website

14 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Partially sorted - I went into SQL Server and gave my logon permission to do everything (not in NBNData, but in SQL Server) - this now ran the upgrade successfully, but finished with the error that the associated database has not been updated

Craig Slawson
Staffordshire Ecological Record

ser's Website

15 Reply by johnvanbreda

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

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Hi Craig

Does your setting table indicate that the upgrade went through OK?

John van Breda
Biodiverse IT

johnvanbreda's Website

16 Reply by Mary Campling

  • Mary Campling
  • Administrator
  • Offline
  • Registered: 16-04-2010
  • Posts: 101

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Error message:
"The SELECT permission was denied on the object 'MAP_SHEET', database 'NBNData', schema 'dbo'.

See post: http://forums.nbn.org.uk/viewtopic.php?id=1105  for further information.

Mary Campling
(Recorder Project Manager)

17 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Hi,

We are currently on dictionary version J and want to update to the latest version P.  Presumably we need to apply the updates in batches as follows:

1. Apply updates K, L and M
2. Apply update N (must be applied alone according to the instructions)
3. Apply updates O and P

Can all three batches of updates be applied, one after the other, before the indexes are rebuilt, or do the indexes have to be rebuilt between each batch?

Many thanks,
Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

18 Reply by Mary Campling

  • Mary Campling
  • Administrator
  • Offline
  • Registered: 16-04-2010
  • Posts: 101

Re: Recorder 6.14.5 and dictionaries K, L and M now available

Hi Andy,

Yes your batches are correct and you can re-build the indexes at the end, rather than after each batch.

Best wishes, Mary