Unable to add data in multi-user mode

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)

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

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

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

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

We have this problem fixed.


It will be in the next update that should be out soon.





Tim

This bug is now fixed in IJC 2.2.1

Thanks! This seems to fix the problem.





-Orion