1

Topic: Unable to upgrade dictionary definitions

Hi
We have recently upgraded to v6.24.0.280 of the Recorder software, this completed successfully however we are seeing errors when we try to upgrade the dictionary files. We are currently on 0000002M, when we extract '0000002N,2O,2P,2Q,2R,2S.zip' and run the dictionary upgrade kit we get an error stating "ODBC--connection to '{SQL Server}SERVERNAME' failed", this is using the same credentials as were used to upgrade the core application. Our DBAs say they can see the connection being made to the database but no further traffic is logged. After the update fails the dictionary version now says 0000002P.
Any help would be appreciated.
Thanks

2

Re: Unable to upgrade dictionary definitions

At the point where the upgrade fails (2Q) the application is trying to copy data from a temporary access database which should have been created from ther zipped file 0000002Q.zip.   Possibly the person running the upgrade does not have sufficient permission on the R6 user file path to create the  temporary database.

Mike Weideli

3

Re: Unable to upgrade dictionary definitions

Hi Mike
Thanks for the quick reply. I am running with an admin account with full access to both the PC with the Recorder client installed and the network share where the application files are hosted. I am also selecting the run as administrator option when running the file. I have run a Procmon trace which suggests the 0000002Q files are being extracted successfully to my %temp% directory. The trace indicates it is failing to find 3 files in the system32 folder just as the error pops up, comsvcs.map, comsvcs.mad, and comsvcs.jdbg (although that could be procmon throwing a red herring).
Thanks

4

Re: Unable to upgrade dictionary definitions

I will try and get more advice on this. Could be something to do with MDAC components.

Mike Weideli

5

Re: Unable to upgrade dictionary definitions

Hi Mike
Have you had a chance to look into this yet?
Thanks

6

Re: Unable to upgrade dictionary definitions

Not as yet, but will chase it up. This doesn't usually cause any problems and I am not sure where to go next. Can you confirm that you have not unzipped the 0000002Q file and  that you have 0000002Q.zip in the scripts folder.

Mike Weideli

7

Re: Unable to upgrade dictionary definitions

The original downloaded file was unzipped but none of the zip files within this have been unzipped, they are in the scripts folder as zip files.

8

Re: Unable to upgrade dictionary definitions

Hi
Could we get an update on this please
Thanks

9

Re: Unable to upgrade dictionary definitions

I have tried to duplicate this without any success and John van-Breda can't  think of anything which might cause  the problems you describe.  The only things we can do now is to change the code to identify exactly where the problem is occurring. John does not have the time to look at this, so I will have go, but unlike John I have not worked on this code before so it is going to be a slow process. I will get back in touch with a special diagnostic version as soon as I can

Mike Weideli

10

Re: Unable to upgrade dictionary definitions

Thanks Mike

11 (edited by james.avery 18-01-2016 15:35:30)

Re: Unable to upgrade dictionary definitions

Hi Mike
The customers who use the software tell me they frequently see an error when they try to view a table in NBNData.mdb where the software reports a SQL connection error stating the server does not exist or access is denied. I do not recognise the name of the server it is trying to make the connection to and it doesn't seem to exist on our network. Could this dud reference be impacting dictionary upgrade? Do you have any idea where it could be storing this server name?

Post's attachments

Recorder6 Error.JPG 40.22 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

12

Re: Unable to upgrade dictionary definitions

Seems strange if Recorder is actually working. The dictionary upgrade will look in the registry. HKEY_Local_Machine/Software/Dorset Software/Recorder 6 to get the Server Name, but so will the application. Is is possible that something in your set up causing a problem here ?

Mike Weideli

13

Re: Unable to upgrade dictionary definitions

I've been running the dictionary updates from a virtual PC with a fresh install of the software and the entry in the registry is correct on that. I guess the only way in which the issue could be common to both machines was if this rogue server setting was stored somewhere on the server share that hosts the application.