1 Topic by mbeard (edited by mbeard 29-11-2012 10:41:01)

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Topic: Class not registered

Hello all,

I tried a large import from another R6 database into our network copy of R6.16.2.241 and received the attached Class Not Registered error.  Searching the forum it appears to be a fairly common error normally solved by removing and installing the Standard Validation Library stdvallib.dll using the dialogue in Recorder, while logged on as local administrator.  We ended up using RunAs and received the attached DllRemove error, and then the attached DllInstall error. (the times are out of sequence because I had to retry the remove to get the error description).  Both the remove and install attempts received Class Not Registered Errors.

So the standard fix has failed, any other ideas very welome!  Thanks in anticipation.

[Edit: Class Not Registed upon all of: import, dll remove and dll install.]

Post's attachments

ClassNotRegistered.txt 16.42 kb, 8 downloads since 2012-11-29 

You don't have the permssions to download the attachments of this post.
Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

2 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Can only attach one file per post?

Post's attachments

DllRemove.txt 12.68 kb, 1 downloads since 2012-11-29 

You don't have the permssions to download the attachments of this post.
Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

3 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

So it seems...

Post's attachments

DllInstall.txt 12.79 kb, 1 downloads since 2012-11-29 

You don't have the permssions to download the attachments of this post.
Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

4 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Does anybody know if this tool is still in Beta?  What access rights are necessary, and would the server need rebooting afterwards?
"RecorderSystemCheck - a tool for diagnosing various Recorder setup problems. v1.1 BETA"
http://forums.nbn.org.uk/viewtopic.php?id=4016

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

5 Reply by MikeWeideli

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

Re: Class not registered

This was only labelled Beta because it alters the registry and had no independent test, but it has now been used fairly widely and no problems reported. You do have to be admin to run it, but  a reboot is not required.

Mike Weideli

MikeWeideli's Website

6 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Thanks Mike.

Currently negotiating with our IT department to convince them to run it for me.

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

7 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

We have now run the program and received a nice little report.  No faults found!  Any ideas what to do next?

Recorder 6 System Check Report

OK - Recorder installation detected
OK - Checking addin GoToGridControl.Go to spatial ref on map.
OK - This addin is correctly installed.
OK - Checking addin GoToKey.GoTo Key
OK - This addin is correctly installed.
OK - Checking addin LastKeyUpdate.Update Last Key
OK - This addin is correctly installed.
OK - Checking addin ShowUnchecked.Display unchecked records
OK - This addin is correctly installed.
OK - Checking addin StdValLib.Recorder 6 Standard Validation
OK - This addin is correctly installed.
OK - The Standard Validation Library has been tested and supports the correct interfaces.
OK - The Recorder addin installer is correctly installed.
OK - The Recorder OLE Server is correctly installed.
OK - The Base Maps Path setting is set.
OK - The Map File Path setting is set.
OK - The Object Sheet File Path setting is set.
OK - The Base Maps Path exists.
OK - The Base Map Path setting includes the trailing slash.
OK - The Base Maps Path points to a folder containing base maps.
OK - The Map File Path exists.
OK - The Map File Path is writeable.
OK - The Map File Path setting includes the trailing slash.
OK - The Object Sheet File Path exists.
OK - The Object Sheet File Path is writeable.
OK - The Object Sheet File Path setting includes the trailing slash.
OK - Files in the Base Maps folder are writeable and can be upgraded as required.
OK - The local copy of the Base Map Path is writeable.
OK - The network Recorder installation folder contains a Base Maps directory.
OK - The Base Maps folder in the network installation folder contains base maps.
OK - The Base Maps path is pointing to the installation Base Maps folder.
OK - The Base Maps Path setting is pointing to a local folder.
OK - The Object Sheet File Path setting is pointing to a network folder.
OK - The Map File Path setting is pointing to a local folder.
No problems were detected

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

8 Reply by MikeWeideli

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

Re: Class not registered

John advises as follows

Looking at the call stack in the errors, I notice that the error occurs in the ADOX library, meaning that it relates to MDAC and something to do with the connection to Access, used during the import. Therefore you need to be looking at whether this is specific to the operating system and whether the data access components are installed correctly and working.

Mike Weideli

MikeWeideli's Website

9 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Thanks Mike (and John),

I will see what we can do to investigate those areas.

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

10 Reply by mbeard (edited by mbeard 11-12-2012 17:36:00)

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Just had a successful small import from .csv file.

Tomorrow I will investigate the NBN Access database that holds the large import.  Maybe see if I can open it on the server - could be an Access version issue.  Hopefully the problem is not that the file is too large because I am guessing it would not be trivial to split into smaller chunks. (917KB compressed, reported to be 16448KB uncompressed)

Edit: clarifying that I am refering to the NBN database.

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

11 Reply by mbeard (edited by mbeard 11-12-2012 17:35:32)

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

Thinking things through again, I realise that the error occurred at the 'Do Import' stage, so the NBN Access database must have been read ok for the validation stage etc.  Is not the temporary database also created during validation?

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

12 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

I have found this on the JNCC website, is a complete system rebuild the next step?  Is this the entire server or just the removal and replacement of Recorder?

http://jncc.defra.gov.uk/default.aspx?page=4980

Error Message:
EOleException : Class not registered

System details:
6.10.4.120 / 6.13

Context:
Occurred during importing data

Suggestion / Solution:
The error message indicates that it's caused by something external to core Recorder - as this occurs during import it is likely to be the validation library. A suggestion would be to log in as someone with local machine admin rights on this machine, log in to Recorder, select Tools\Install\Add-in module. Select Recorder 6 Standard Validation, then click Remove. Now restart Recorder and go back to this dialog. Click Install, then browse to your Addins folder in the Recorder 6 server install folder, and select StdValLib.dll. Uninstalling an application external to Recorder had corrupted the Windows Registry - a complete system rebuild was necessary which solved the Recorder problem

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

13 Reply by MikeWeideli

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

Re: Class not registered

Can you confirm that you can still do a simple import witha csv file ? Could you also try a simple import with an Access database. Say simply taxon, recorder, date, grid ref.

Mike Weideli

MikeWeideli's Website

14 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

As reported above in post 10 a csv import works.

Could not find a direct Access import so used an ADO Connection with 'Microsoft Jet 4.0 OLE DB Provider'.  This worked, but only after I had changed the Date column to text format because of the unresolved dd/mm/yyyy - mm/dd/yyyy problems that we have with our Citrix setup.  It is in the hands of our IT Department, meantime I just use csv files. http://forums.nbn.org.uk/viewtopic.php?id=2366

Could the date problem be the cause of the Class Not Registred crash?  Maybe I will see if I can arrange for the NBN database import to be tried locally rather than using Citrix.

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

15 Reply by mbeard

  • mbeard
  • Veteran
  • Offline
  • From: Greater Manchester
  • Registered: 28-02-2010
  • Posts: 101

Re: Class not registered

SOLVED

The large NBN Database format import worked when run directly on the server rather than via Citrix, so I am glad to say that it appears to have been the date format rather than a corrupt registry!

Mike Beard
Natural Course Project Officer
Greater Manchester Local Records Centre

mbeard's Website

16 Reply by MikeWeideli

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

Re: Class not registered

Great news. I was begining to think that this was a data problem.

Mike Weideli

MikeWeideli's Website