topic in Job.xml，missing ${prefix} before ACT_RE_PROCDEF in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177634#M130764 <HTML><HEAD></HEAD><BODY><SPAN>in Job.xml，missing ${prefix} before&nbsp; ACT_RE_PROCDEF</SPAN><BR /><BR /><SPAN>&nbsp; &lt;select id="selectJobByTypeAndProcessDefinitionKeyNoTenantId" parameterType="org.activiti.engine.impl.db.ListQueryParameterObject" resultMap="jobResultMap"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; select J.*</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ${prefix}ACT_RU_JOB J</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; inner join ACT_RE_PROCDEF P on J.PROC_DEF_ID_ = P.ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; where J.HANDLER_TYPE_ = #{parameter.handlerType} </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; and P.KEY_ = #{parameter.processDefinitionKey}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; and (P.TENANT_ID_ = ''&nbsp; or P.TENANT_ID_ is null)&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;/select&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;select id="selectJobByTypeAndProcessDefinitionKeyAndTenantId" parameterType="org.activiti.engine.impl.db.ListQueryParameterObject" resultMap="jobResultMap"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; select J.*</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ${prefix}ACT_RU_JOB J</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; inner join ACT_RE_PROCDEF P on J.PROC_DEF_ID_ = P.ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; where J.HANDLER_TYPE_ = #{parameter.handlerType} </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; and P.KEY_ = #{parameter.processDefinitionKey}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; and P.TENANT_ID_ = #{parameter.tenantId} </SPAN><BR /><SPAN>&nbsp; &lt;/select&gt;</SPAN><BR /><BR /><SPAN>this cause startup with prefix failed：</SPAN><BR /><BR /><SPAN>Caused by: org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'succezbi.act_re_procdef' doesn't exist</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Job.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectJobByTypeAndProcessDefinitionKeyNoTenantId-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select J.*&nbsp;&nbsp;&nbsp;&nbsp; from SZSYS_1_ACT_RU_JOB J&nbsp;&nbsp;&nbsp;&nbsp; inner join ACT_RE_PROCDEF P on J.PROC_DEF_ID_ = P.ID_&nbsp;&nbsp;&nbsp;&nbsp; where J.HANDLER_TYPE_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and P.KEY_ = ?&nbsp;&nbsp;&nbsp;&nbsp; and (P.TENANT_ID_ = ''&nbsp; or P.TENANT_ID_ is null)</SPAN><BR /><SPAN>### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'succezbi.act_re_procdef' doesn't exist</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.2.5.jar:3.2.5]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) ~[mybatis-3.2.5.jar:3.2.5]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) ~[mybatis-3.2.5.jar:3.2.5]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:435) ~[activiti-engine-5.18.0.jar:5.18.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:426) ~[activiti-engine-5.18.0.jar:5.18.0]</SPAN><BR /></BODY></HTML> Wed, 16 Sep 2015 02:27:34 GMT classfoo 2015-09-16T02:27:34Z in Job.xml，missing ${prefix} before ACT_RE_PROCDEF https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177634#M130764 in Job.xml，missing ${prefix} before&nbsp; ACT_RE_PROCDEF&nbsp; &lt;select id="selectJobByTypeAndProcessDefinitionKeyNoTenantId" parameterType="org.activiti.engine.impl.db.ListQueryParameterObject" resultMap="jobResultMap"&gt;&nbsp;&nbsp;&nbsp; select J.*&nbsp;&nbsp;&nbsp; from ${prefix}ACT_RU_JOB J&nbsp;&nbsp;&nbsp; inner join ACT_RE_PROCDEF P on J.PROC Wed, 16 Sep 2015 02:27:34 GMT https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177634#M130764 classfoo 2015-09-16T02:27:34Z Re: in Job.xml，missing ${prefix} before ACT_RE_PROCDEF https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177635#M130765 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>create a pull request, please.</SPAN><BR /><A href="http://www.jorambarrez.be/blog/2014/11/05/how-to-create-an-activiti-pull-request/" rel="nofollow noopener noreferrer">http://www.jorambarrez.be/blog/2014/11/05/how-to-create-an-activiti-pull-request/</A><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN><BR /></BODY></HTML> Wed, 16 Sep 2015 06:18:58 GMT https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177635#M130765 martin_grofcik 2015-09-16T06:18:58Z Re: in Job.xml，missing ${prefix} before ACT_RE_PROCDEF https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177636#M130766 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>there is already a pull request containing the fix for this issue:</SPAN><BR /><A href="https://github.com/Activiti/Activiti/issues/658" rel="nofollow noopener noreferrer">https://github.com/Activiti/Activiti/issues/658</A></BODY></HTML> Thu, 17 Sep 2015 13:41:27 GMT https://connect.hyland.com/t5/alfresco-archive/in-job-xml-missing-prefix-before-act-re-procdef/m-p/177636#M130766 vasile_dirla 2015-09-17T13:41:27Z