[JBoss jBPM] - Re: Problems with indexes in jbpm.history.hbm.xml
by mwohlf
hmm, I get a similar error for the indexes
| 23:35:13,342 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HVAR on JBPM4_HIST_DETAIL (HVAR_)
| 23:35:13,342 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:13,348 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HTASK on JBPM4_HIST_DETAIL (HTASK_)
| 23:35:13,348 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:13,349 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HACTI on JBPM4_HIST_DETAIL (HACTI_)
| 23:35:13,349 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:13,351 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HPROCI on JBPM4_HIST_DETAIL (HPROCI_)
| 23:35:13,351 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:24,049 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HVAR on JBPM4_HIST_DETAIL (HVAR_)
| 23:35:24,049 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:24,055 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HTASK on JBPM4_HIST_DETAIL (HTASK_)
| 23:35:24,055 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:24,056 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HACTI on JBPM4_HIST_DETAIL (HACTI_)
| 23:35:24,056 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
| 23:35:24,058 ERROR [SchemaExport] Unsuccessful: create index IDX_HDETAIL_HPROCI on JBPM4_HIST_DETAIL (HPROCI_)
| 23:35:24,058 ERROR [SchemaExport] ORA-01408: such column list already indexed
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4248912#4248912
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4248912
16 years, 8 months
Problem when deploying process definition in Oracle Database - JBPM 4
by Rogerio Baldini das Neves
Hi Guys,
I am trying to deploy a process definition in Oracle Database with jBPM 4.
The ant task is not being completed and stands 'sleeping' .
I have deployed same process definition in a Postgresql and worked fine.
The end of my log is:
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.jdbc.util.SQLStatementLogger
logStatement
[jbpm-deploy] FINE:
[jbpm-deploy] insert
[jbpm-deploy] into
[jbpm-deploy] JBPM4_LOB
[jbpm-deploy] (DBVERSION_, BLOB_VALUE_, DBID_)
[jbpm-deploy] values
[jbpm-deploy] (?, ?, ?)
[jbpm-deploy] 10/08/2009 09:45:12
org.hibernate.persister.entity.AbstractEntityPersister dehydrate
[jbpm-deploy] FINEST: Dehydrating entity:
[org.jbpm.pvm.internal.lob.Lob#599]
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.type.NullableType
nullSafeSet
[jbpm-deploy] FINEST: binding '0' to parameter: 1
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.type.NullableType
nullSafeSet
[jbpm-deploy] FINEST: binding '599' to parameter: 3
[jbpm-deploy] 10/08/2009 09:45:12
org.hibernate.persister.entity.AbstractEntityPersister insert
[jbpm-deploy] FINEST: Inserting entity: [org.jbpm.pvm.internal.lob.Lob#600]
[jbpm-deploy] 10/08/2009 09:45:12
org.hibernate.persister.entity.AbstractEntityPersister insert
[jbpm-deploy] FINEST: Version: 0
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.jdbc.AbstractBatcher
prepareBatchStatement
[jbpm-deploy] FINE: reusing prepared statement
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.jdbc.util.SQLStatementLogger
logStatement
[jbpm-deploy] FINE:
[jbpm-deploy] insert
[jbpm-deploy] into
[jbpm-deploy] JBPM4_LOB
[jbpm-deploy] (DBVERSION_, BLOB_VALUE_, DBID_)
[jbpm-deploy] values
[jbpm-deploy] (?, ?, ?)
[jbpm-deploy] 10/08/2009 09:45:12
org.hibernate.persister.entity.AbstractEntityPersister dehydrate
[jbpm-deploy] FINEST: Dehydrating entity:
[org.jbpm.pvm.internal.lob.Lob#600]
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.type.NullableType
nullSafeSet
[jbpm-deploy] FINEST: binding '0' to parameter: 1
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.type.NullableType
nullSafeSet
[jbpm-deploy] FINEST: binding '600' to parameter: 3
[jbpm-deploy] 10/08/2009 09:45:12 org.hibernate.jdbc.BatchingBatcher
doExecuteBatch
[jbpm-deploy] FINE: Executing batch size: 12
Thanks,
Rogerio.
16 years, 8 months