topic Experimental event logging issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199168#M152298 <HTML><HEAD></HEAD><BODY><SPAN>hi.</SPAN><BR /><BR /><SPAN>I've installed the new 5.16 release on our dev and test environment on Oracle database.</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>We need to specify both a database schema and a table prefix.</SPAN><BR /><BR /><SPAN>However, there's an issue with the new act_evt_log_seq sequence that's been introduced.</SPAN><BR /><SPAN>I'm getting the following message:</SPAN><BR /><BR /><SPAN>ORA-02289: sequence does not exist</SPAN><BR /><SPAN>### 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_)&nbsp;&nbsp;&nbsp;&nbsp; values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_EVT_LOG_seq.nextVal,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>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?</SPAN><BR /><SPAN>If I query f.i select DBR.ACT_EVT_LOG_seq.nextVal from dual; then it works fine.</SPAN><BR /><BR /><SPAN>-Per-</SPAN></BODY></HTML> Wed, 20 Aug 2014 13:03:44 GMT per_berge 2014-08-20T13:03:44Z Experimental event logging issue https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199168#M152298 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 processEngineConfigurat Wed, 20 Aug 2014 13:03:44 GMT https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199168#M152298 per_berge 2014-08-20T13:03:44Z Re: Experimental event logging issue https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199169#M152299 <HTML><HEAD></HEAD><BODY><SPAN>Looks like a bug. Can you create a Jira issue for it ?</SPAN></BODY></HTML> Wed, 05 Nov 2014 16:37:14 GMT https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199169#M152299 smirzai 2014-11-05T16:37:14Z Re: Experimental event logging issue https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199170#M152300 <HTML><HEAD></HEAD><BODY><SPAN>Indeed, a bug. I fixed it on master: </SPAN><A href="https://github.com/Activiti/Activiti/commit/20d7ac1351f3587294d4f808f490203ef7be148f" rel="nofollow noopener noreferrer">https://github.com/Activiti/Activiti/commit/20d7ac1351f3587294d4f808f490203ef7be148f</A></BODY></HTML> Mon, 10 Nov 2014 10:41:41 GMT https://connect.hyland.com/t5/alfresco-archive/experimental-event-logging-issue/m-p/199170#M152300 jbarrez 2014-11-10T10:41:41Z