1 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Import Wizard Error - Class Not Registered

In trying to import a small dataset from Excel (c120 records) the import wizard fails at the creating temporary database stage giving the exception posted below and the helpful message of 'Class not registered'.

Has anyone had this error before and can tell me what is wrong with either the database or the spreadsheet?

Regards,
Dave


Exception occurred in application Recorder 6 at 10/01/2008 10:24:09.
Version : 6.10.4.120

Exception path:
EOleException : Class not registered

Last event\actions:
  TfrmSurveyDetails destroyed
  TfrmSurveyDetails created
  TfrmSurveyDetails destroyed
  TfrmObservations destroyed
  TfrmObservations deactivated
  TfrmIndOrg activated
  actTransferData invoked
  TfrmIndOrg deactivated
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 523,276 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3159)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3139)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

2 Reply by DaveSlade (edited by DaveSlade 21-01-2008 12:38:10)

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Import Wizard Error - Class Not Registered

Following a re-boot of the server the import process has progressed but fails at the actual import stage with the following posted below. I now fear that this is a symptom of a wider problem with the database.

Exception occurred in application Recorder 6 at 17/01/2008 09-05-22.
Version : 6.10.4.120

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

Last event\actions:
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,046,508 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3159)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3139)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)


Subsequently I have found that the error was due to the database reaching it's maximum size.

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

3 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Import Wizard Error - Class Not Registered

It would appear that only the second part of this problem was related to the database size. The 'Class not registered' error still occurs when trying to import from one workstation. The same file imports without a problem from a different workstation. The exception is reproduced below in case this helps.

Exception occurred in application Recorder 6 at 23/01/2008 10:53:57.
Version : 6.10.4.120

Exception path:
EOleException : Class not registered

Last event\actions:
  TfrmTaxonDictBrowser activated
  TfrmTaxonDictBrowser deactivated
  TfrmTaxonDictBrowser destroyed
  TfrmTaxonDictBrowser deactivated
  TfrmIndOrg activated
  TfrmIndOrg destroyed
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 523,276 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3159)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3139)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

4 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Import Wizard Error - Class Not Registered

Hi Dave

I normally tackle these things by obtaining a copy of the import file and reproducing the error here - however, if this only happens on one workstation it does suggests it is something to do with that specific workstation installation.

John from Dorset Software is spending some time looking into another issue for us at the moment - but I'll ask him to take a look at the error message when he can.

Best wishes,

Sarah Shaw
Biodiversity Information Assistant
JNCC

5 Reply by johnvanbreda

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

Re: Import Wizard Error - Class Not Registered

Hi Dave

The error message indicates that it's caused by something external to core Recorder, which because it is happening at this stage suggests the validation library is the most likely candidate.

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.

Now retry the import and let us know what happens.

Good luck,

John

John van Breda
Biodiverse IT

johnvanbreda's Website