cancel
Showing results for 
Search instead for 
Did you mean: 

Experimental event logging issue

per_berge
Champ in-the-making
Champ in-the-making
hi.

I've installed the new 5.16 release on our dev and test environment on Oracle database.
Our installation uses a database table prefix since it's a shared database and this works fine with the activiti framework by using the databaseTablePrefix property when initializing the processEngineConfiguration.
We need to specify both a database schema and a table prefix.

However, there's an issue with the new act_evt_log_seq sequence that's been introduced.
I'm getting the following message:

ORA-02289: sequence does not exist
### SQL: insert into DBR.RT_ACT_EVT_LOG(LOG_NR_, TYPE_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, TIME_STAMP_, USER_ID_, DATA_, LOCK_OWNER_, LOCK_TIME_, IS_PROCESSED_)     values (       ACT_EVT_LOG_seq.nextVal,       ?,        ?,        ?,       ?,       ?,          ?,        ?,       ?,       ?,       ?,       ?      )

So I'm wondering if you have any way of allowing us to specify any prefix when you're making use of the ACT_EVT_LOG_seq.nextVal sequence?
If I query f.i select DBR.ACT_EVT_LOG_seq.nextVal from dual; then it works fine.

-Per-
2 REPLIES 2

smirzai
Champ on-the-rise
Champ on-the-rise
Looks like a bug. Can you create a Jira issue for it ?

jbarrez
Star Contributor
Star Contributor
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.