Unable to add data in multi-user mode

Technical Support Forum
Access ChemAxon scientists and developers here. For confidential or other support please email.

The time now is Mon Dec 01, 2008 11:04 pm

Register (required to post and download)

Username: Password: Remember login

FAQ

Digests

Unable to add data in multi-user mode
To watch this topic for replies Register (enables digests) or give email address:

Home -> Forums -> Support -> Storage & search: Instant JChem -> Unable to add data in multi-user mode

Display posts from previous:

View previous topic :: View next topic

Author

Message

ojankowski
Joined: 03 Aug 2006
Posts: 18

Post subject: Unable to add data in multi-user mode
Posted: Tue Jan 22, 2008 6:21 pm

We are recently unable to add new rows in any table when connected in multi-user mode to an Oracle IJC database. When connected as admin in single-user mode, we can add new rows, but not always edit fields in existing ones. When trying to add a new row as admin in multi-user mode, the following error is generated: java.lang.RuntimeException Caused: com.im.df.api.support.ObjectOwnedByOtherUserException: Cannot perform "insert data". You have insufficient access rights to modify database model. at com.im.df.impl.db.AlwaysLockedLockable.obtainLock(AlwaysLockedLockable.java:30) at com.im.df.impl.db.InsertionHandler.lockParticipatingEntities(InsertionHandler.java:119) at com.im.df.impl.db.InsertionHandler.doInTransaction(InsertionHandler.java:218) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.im.df.impl.db.DBSchemaDataProviderImpl.insert(DBSchemaDataProviderImpl.java:147) at com.im.ijc.core.api.actions.InsertRowAction$3.phase1InRequestProcessor(InsertRowAction.java:328) at com.im.df.util.BackgroundRunner.processTheTask(BackgroundRunner.java:112) at com.im.df.util.BackgroundRunner$1.run(BackgroundRunner.java:79) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) [catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)

tdudgeon
Joined: 05 Oct 2004
Posts: 617
IJC personnel

Post subject:
Posted: Tue Jan 22, 2008 6:35 pm

Can you check that your admin user has the ROLE_EDIT_DATA role. As you seem able to add rows I assume this is probably be the case, but it the obvious first thing to check. Thanks Tim

phamernik
Joined: 25 Jan 2006
Posts: 54
IJC personnel

Post subject:
Posted: Tue Jan 22, 2008 6:38 pm

Hi, I can reproduce and it looks like a bug. We are working on it, so it will be fixed in 2.2.1. Thanks for bug report. Petr

ojankowski
Joined: 03 Aug 2006
Posts: 18

Post subject:
Posted: Tue Jan 22, 2008 6:41 pm

Thanks for the instantaneous replies. Tim: Yes, the admin account has the proper priviledges as checked in both the pull-down menu and the Oracle IJC permissions table. -Orion

pwolanin
Joined: 05 Sep 2007
Posts: 20

Post subject:
Posted: Fri Jan 25, 2008 7:31 pm

I'm seeing the exact same error with a MySQL database using either the Mac or Windows client.

tdudgeon
Joined: 05 Oct 2004
Posts: 617
IJC personnel

Post subject:
Posted: Fri Jan 25, 2008 7:34 pm

We have this problem fixed. It will be in the next update that should be out soon. Tim

tdudgeon
Joined: 05 Oct 2004
Posts: 617
IJC personnel

Post subject:
Posted: Thu Feb 14, 2008 7:51 pm

This bug is now fixed in IJC 2.2.1

ojankowski
Joined: 03 Aug 2006
Posts: 18

Post subject:
Posted: Thu Feb 14, 2008 9:27 pm

Thanks! This seems to fix the problem. -Orion

Display posts from previous:

	Home -> Forums -> Storage & search: Instant JChem -> Unable to add data in multi-user mode	All times are GMT + 1 Hour
Page 1 of 1

To watch this topic for replies Register (enables digests) or give email address

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum