topic Error in setting up custom schema. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-in-setting-up-custom-schema/m-p/188233#M141363 <HTML><HEAD></HEAD><BODY><SPAN>HI</SPAN><BR /><BR /><SPAN>I manually created Schema under mssql DB also created the required table under the schema.</SPAN><BR /><BR /><SPAN> Following is the configuration.</SPAN><BR /><BR /><SPAN>&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;property name="deploymentResources" value="classpath*:*.bpmn" /&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="none" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchema" value="Activiti" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="databaseTablePrefix" value="Activiti." /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="tablePrefixIsSchema" value="true" /&gt;</SPAN><BR /><SPAN>&lt;/bean&gt;</SPAN><BR /><BR /><BR /><SPAN>Now When I'm referring those tables with databaseTablePrefix property it's appeding this Activiti. to some of the Table. But not with all the tables.</SPAN><BR /><BR /><SPAN>Like it's not appending prefix with table ACT_ID_MEMBERSHIP.</SPAN><BR /><BR /><SPAN>Below is the generated query as it has not appended prefix Activiti. With ACT_ID_MEMBERSHIP so I’m getting the error table doesn’t exist.</SPAN><BR /><BR /><SPAN>SELECT SUB.*</SPAN><BR /><SPAN>FROM</SPAN><BR /><SPAN>&nbsp; ( SELECT DISTINCT RES.* ,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; row_number() over (ORDER BY RES.ID_ ASC) rnk</SPAN><BR /><SPAN>&nbsp; FROM</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ( SELECT DISTINCT RES.*</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; FROM Activiti.ACT_RU_TASK RES</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LEFT JOIN Activiti.ACT_RU_IDENTITYLINK I</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ON I.TASK_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = RES.ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; WHERE (RES.ASSIGNEE_ = ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; OR (RES.ASSIGNEE_&nbsp;&nbsp; IS NULL</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; AND (I.USER_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; OR I.GROUP_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SELECT g.GROUP_ID_ FROM ACT_ID_MEMBERSHIP g WHERE g.USER_ID_ = ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) ) ) )</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; )RES</SPAN><BR /><SPAN>&nbsp; ) SUB</SPAN><BR /><SPAN>WHERE SUB.rnk &gt;= ?</SPAN><BR /><SPAN>AND SUB.rnk&nbsp;&nbsp;&nbsp; &lt; ?</SPAN><BR /><BR /><SPAN>Please let me know the resolution to fix the above problem.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><SPAN>Aman</SPAN><BR /></BODY></HTML> Tue, 18 Nov 2014 14:57:48 GMT mann_frnd 2014-11-18T14:57:48Z Error in setting up custom schema. https://connect.hyland.com/t5/alfresco-archive/error-in-setting-up-custom-schema/m-p/188233#M141363 HII manually created Schema under mssql DB also created the required table under the schema. Following is the configuration.&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;&nbsp; &lt;property name="deploymentResources" value="classpath*:*.bpmn" /&amp;g Tue, 18 Nov 2014 14:57:48 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-setting-up-custom-schema/m-p/188233#M141363 mann_frnd 2014-11-18T14:57:48Z Re: Error in setting up custom schema. https://connect.hyland.com/t5/alfresco-archive/error-in-setting-up-custom-schema/m-p/188234#M141364 <HTML><HEAD></HEAD><BODY><SPAN>Which query are you doing here, could you show the Java counterpart, so we know where to search?</SPAN></BODY></HTML> Thu, 20 Nov 2014 08:04:19 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-setting-up-custom-schema/m-p/188234#M141364 jbarrez 2014-11-20T08:04:19Z