-
1. Re: login to jbpm_console failed
kukeltje May 18, 2007 6:04 AM (in response to naseem.k)look at the gettingstarted document. you need to inser more than just a user
-
2. Re: login to jbpm_console failed
naseem.k May 18, 2007 8:06 AM (in response to naseem.k)Hi Ronald,
I found one link where configuration required for database change is given, but there as well just inserts are made only in jbpm_id_user table. Here is the link:
http://docs.jboss.com/jbpm/v3.2/userguide/html/thejbpmdatabase.html
Can you please provide me the link of jbpmstarted which you are talking about.
Thanks
Naseem -
3. Re: login to jbpm_console failed
kukeltje May 18, 2007 8:13 AM (in response to naseem.k)it's the second sticky post in this forum... you can't miss it (hmmm..... )
-
4. Re: login to jbpm_console failed
estaub May 18, 2007 8:53 AM (in response to naseem.k)Ronald, I can't figure out what you're trying to get Naseem to see. All I ever have to do is add users and stir.
Naseem, at the risk of seeming insulting... did you commit?
-Ed Staub -
5. Re: login to jbpm_console failed
sergey.rybets May 19, 2007 3:33 PM (in response to naseem.k)Hi.
I've got similar problem as Naseem - after migration from hsqldb to oracle I can't login to console. Records with users and passwords are present in jbpm_id_user (commit was done ;) ). Server starts without exceptions, datasource is configured properly. Everything was done like described in jBPM jPDL User Guide.
Thank you for your time -
6. Re: login to jbpm_console failed
sergey.rybets May 19, 2007 3:50 PM (in response to naseem.k)may be some additional data should be provided in db like groups, memberships?
-
7. Re: login to jbpm_console failed
kukeltje May 20, 2007 5:48 AM (in response to naseem.k)@sergey: correct
@ed: with jboss you have this login-config.xml or something like that. This makes sure you atuhenticate user users against the jbpm databbase. You have to do something similar for wannaBea Weblogic. -
8. Re: login to jbpm_console failed
kukeltje May 20, 2007 5:51 AM (in response to naseem.k)sorry.... the weblogic statement was wrong here.... wrong topic
-
9. Re: login to jbpm_console failed
naseem.k May 21, 2007 6:13 AM (in response to naseem.k)Hi Guys,
Finally I am able to login to jbpm-console page by adding records in JBPM_ID_MEMBERSHIP table for the new users I created and assigned them to a group by groupid as a foreign key.
Now I am getting exception at the time of process start.
First time when I start a new process, it works fine. There is no exception on the console. Second time when I start the same process version, exception is generated on the console saying...15:32:26,701 DEBUG [JbpmContext] closing JbpmContext
15:32:26,701 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@1fa2b3e
15:32:26,701 DEBUG [DbPersistenceService] committing hibernate transaction
15:32:26,717 WARN [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
15:32:26,717 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (RND.SYS_C0014481) violated
15:32:26,717 WARN [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
15:32:26,717 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (RND.SYS_C0014481) violated
15:32:26,732 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2106)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.ja
va:297)
I got this exception only with oracle database. With hypersonic database, there was no exception.
Please help. What could be the cause?
Thanks
Naseem -
10. Re: login to jbpm_console failed
kukeltje May 21, 2007 6:33 AM (in response to naseem.k)two things:
- STFF (e.g. with google) for the oracle and unique constraint problem
- search the jira for comparable things
Only if this does not turn up anything post in a NEW topic
hint: the orcale/unique constraint thing has been previously addressed -
11. Re: login to jbpm_console failed
naseem.k May 21, 2007 7:53 AM (in response to naseem.k)Thanks Ronald,
I resolved the problem. In fact it became quite easier to find out the problem after your post.
Basically problem was in the process instance table, unique constraint was imposed on (ID_, PROCESSDEFINITION_) composite column. I just removed unique constraint and it worked.
Thanks once again
Regards
Naseem -
12. Re: login to jbpm_console failed
estaub May 21, 2007 10:21 AM (in response to naseem.k)Naseem,
I suggest that you crank up the logging out of hibernate, so that you can see what SQL is failing.
FWIW, I'd guess that the key generation for the process instance isn't working. I don't know why it would fail, though!
-Ed Staub -
13. Re: login to jbpm_console failed
kukeltje May 21, 2007 10:24 AM (in response to naseem.k)@Ed, I think it was/is just related to the known issue. It is in the Jira for 3.2.1. Take a look there for more info