Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
Unable to add data in multi-user mode
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Orion

Joined: 03 Aug 2006
Posts: 18

View user's profile

Back to top
Link to postPosted: Tue Jan 22, 2008 6:21 pmPost subject: Unable to add data in multi-user mode Reply with quote

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)
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Tue Jan 22, 2008 6:35 pmPost subject: Reply with quote

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
Petr
IJC personnel
Joined: 25 Jan 2006
Posts: 217

View user's profile

Back to top
Link to postPosted: Tue Jan 22, 2008 6:38 pmPost subject: Reply with quote

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
Orion

Joined: 03 Aug 2006
Posts: 18

View user's profile

Back to top
Link to postPosted: Tue Jan 22, 2008 6:41 pmPost subject: Reply with quote

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
Peter

Joined: 05 Sep 2007
Posts: 20

View user's profile

Back to top
Link to postPosted: Fri Jan 25, 2008 7:31 pmPost subject: Reply with quote

I'm seeing the exact same error with a MySQL database using either the Mac or Windows client.
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Fri Jan 25, 2008 7:34 pmPost subject: Reply with quote

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

Tim
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Thu Feb 14, 2008 7:51 pmPost subject: Reply with quote

This bug is now fixed in IJC 2.2.1
Orion

Joined: 03 Aug 2006
Posts: 18

View user's profile

Back to top
Link to postPosted: Thu Feb 14, 2008 9:27 pmPost subject: Reply with quote

Thanks! This seems to fix the problem.

-Orion
This topic is locked: you cannot edit posts or make replies.
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