1 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Import wizard fails with Full Edit rights

Just had someone with Full Edit right try to do an import today and they get an error message when clicking on the final Do Import button. I've tried the same import as System Manager and it worked as normal. I tried yet again with another Full Edit user and got the same error, so it definitely seems related to the app roles. Here's the error message:

Exception occurred in application Recorder 6 at 05/02/2007 11-58-15.
Version : 6.9.3.102

Exception path:
EOleException : Cannot find the object "Taxon_List_Item" because it does not exist or you do not have permissions

Last event\actions:
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,046,516 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.2818)
  HHCtrl.ocx (5.2.3790.2744)
  kernel32.dll (5.1.2600.2945)
  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.2180)
  shell32.dll (6.0.2900.2951)
  user32.dll (5.1.2600.2622)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Information has been saved to the file T:\Recorder 6 Server\LastError.txt

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by Sarah Shaw

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

Re: Import wizard fails with Full Edit rights

Hi Charles

I came across this too last week on a laptop but haven't had chance to run through it on another machine to double check/investigate.

I'm not sure what is happening here - looking at permissions it seems the 'R2k_Full_Edit' role has select, insert, update and delete rights for this table.

Definitely something that needs further investigation/fixing.

Kind regards,

Sarah Shaw
Biodiversity Information Assistant
JNCC

Sarah Shaw
Biodiversity Information Assistant
JNCC

3 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Import wizard fails with Full Edit rights

Sarah Shaw wrote:

looking at permissions it seems the 'R2k_Full_Edit' role has select, insert, update and delete rights for this table.

Just for the record, same here.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

4 Reply by johnvanbreda

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

Re: Import wizard fails with Full Edit rights

Ok, we have followed this through and will issue a fix in the next release of Recorder.
For those of you who are able to run scripts against your database, here's the update SQL that will fix the problem:

exec sp_addrolemember N'db_ddladmin', N'R2k_FullEdit'
GO

IF EXISTS (SELECT * FROM SysUsers WHERE NAME = 'R2k_FullEdit')
    GRANT EXECUTE ON [dbo].[usp_RemoveUnwantedOccurrences] TO [R2k_FullEdit]
GO
John van Breda
Biodiverse IT

johnvanbreda's Website