Missing tables in openkm 5.0

[surajaya]

Hello All,

I have a problem with workflow in openkm 5.0. My configuration is : openkm 5 & mysql database, OS linux ubuntu, jboss 4.2.3, jbpm 3.3.1GA, sun java 1.6.
My curiosity start when I tried to run some task assignment to other user. The task is succesfully writen to table : JBPM_TASK, the swimlane is succesfully writen to table : JBPM_SWIMLANE, but when I logged in as the user who should do the task, no task is in his dashboard.

An then I inspect the database (comparing version 4.1 database dan 5.0 database) I notice that some tables are missing in 5.0. The tables are all JBPM related :

Code: Select all

| JBPM_ID_GROUP           |
| JBPM_ID_MEMBERSHIP      |
| JBPM_ID_PERMISSIONS     |
| JBPM_ID_USER  

If the user is no longer in the JBPM_ID_USER, I wonder how we can do task assigment in openkm 5.0 ?. Is there anyone that already successfully using workflow in openkm ?. Should I create and insert data manually for all those user related tables ?.

Thanks in advance for your help,
regards,
surajaya

[surajaya]

Should I insert all the OKM_USER to the JBPM_ID_USER tables ?. Any thought ?

[jllort]

it's strange error, probably could happen some error during creation.

Try put on OpenKM.cfg the hibernate.dll=update and restart jboss.
Be care with log file ... to see if some error happens !

[surajaya]

it's strange error, probably could happen some error during creation.

Try put on OpenKM.cfg the hibernate.dll=update and restart jboss.
Be care with log file ... to see if some error happens !

You meant "hibernate.hbm2ddl=update" instead of "hibernate.ddl=update" ?.
I've tried both of that and nothing happened, no error / warning, but the missing tables is not created / updated.

[jllort]

Yes, I was talking about hibernate.hbm2ddl=update

Have you restarted jboss after changing it ? there's no error on creation tables during jboss starting ?

[surajaya]

Yes, I was talking about hibernate.hbm2ddl=update

Have you restarted jboss after changing it ? there's no error on creation tables during jboss starting ?

Yes, I have restarted the jboss. I even set hibernate.show_sql=true, and restart jboss
This is fresh install of openkm 5.0 and am sure that other user of openkm 5.0 should experience this too

[pavila]

These tables:

* JBPM_ID_GROUP
* JBPM_ID_MEMBERSHIP
* JBPM_ID_PERMISSIONS
* JBPM_ID_USER

Are not needed because OpenKM handle the workflow users and groups by itself.

[surajaya]

Finally found the config : User.hbm.xml

[surajaya]

Finally solved. I can assign task to some specific user.
However, that's not work for Pooled Actor

[pavila]

Please, post detailed steps to reproduce the issue (including workflow definition).