topic Tables missing for component(s) engine, history, identity in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157275#M111471 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>I'm new to activiti and need some help…</SPAN><BR /><BR /><SPAN>I want to integrate activiti into an existing oracle 11 database.</SPAN><BR /><SPAN>I've created a new schema "activiti" with all the tables.</SPAN><BR /><BR /><SPAN>I must log on to the databse with a specific user e.g. "SUPPORT_USER".</SPAN><BR /><BR /><SPAN>I use this configuration:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />setDatabaseSchemaUpdate(false);<BR />setDatabaseSchema("ACTIVITI");<BR />setDatabaseTablePrefix("ACTIVITI.");<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I get this exception:</SPAN><BR /><SPAN>org.activiti.engine.ActivitiException: Activiti database problem: Tables missing for component(s) engine, history, identity</SPAN><BR /><BR /><SPAN>The problem is in DbSqlSession:</SPAN><BR /><SPAN>- dbSchemaCheckVersion calls "getDbVersion()" to get the version:</SPAN><BR /><SPAN>select VALUE_ from ACTIVITI.ACT_GE_PROPERTY where NAME_ = 'schema.version'</SPAN><BR /><SPAN>-&gt; "5.14" is returned</SPAN><BR /><BR /><SPAN>- then "isEngineTablePresent()" is called which calles "isTablePresent()"</SPAN><BR /><SPAN>This code is executed:</SPAN><BR /><SPAN>tables = databaseMetaData.getTables(this.connectionMetadataDefaultCatalog, schema, tableName, JDBC_METADATA_TABLE_TYPES);</SPAN><BR /><BR /><SPAN>In my case this looks like this:</SPAN><BR /><SPAN>tables = databaseMetaData.getTables(null, "ACTIVITI", "ACTIVITI.ACT_RU_EXECUTION", JDBC_METADATA_TABLE_TYPES);</SPAN><BR /><BR /><SPAN>-&gt; In Oracle 11 this does not work! The tables are not returned!</SPAN><BR /><SPAN>It should look like this:</SPAN><BR /><SPAN>tables = databaseMetaData.getTables(null, "ACTIVITI", "ACT_RU_EXECUTION", JDBC_METADATA_TABLE_TYPES);</SPAN><BR /><SPAN>The tableName parameter must not include the schema name!</SPAN><BR /><BR /><BR /><SPAN>So I the table perfix must be set to get the version in "getDbVersion()" but it must not be be set in "getTables(…)"</SPAN><BR /><BR /><SPAN>How can I fix this?</SPAN><BR /><BR /><SPAN>Another question:</SPAN><BR /><SPAN>Why is it necessary to check the DB every time the engine is created?</SPAN><BR /><SPAN>Could you implement a flag to configure if the check should be performed?</SPAN><BR /><BR /><SPAN>Thanks for you help!</SPAN><BR /><BR /><SPAN>Rolf</SPAN><BR /><BR /><BR /><BR /><BR /><BR /><BR /></BODY></HTML> Tue, 17 Dec 2013 11:14:36 GMT rolf 2013-12-17T11:14:36Z Tables missing for component(s) engine, history, identity https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157275#M111471 Hello!I'm new to activiti and need some help…I want to integrate activiti into an existing oracle 11 database.I've created a new schema "activiti" with all the tables.I must log on to the databse with a specific user e.g. "SUPPORT_USER".I use this configuration:setDatabaseSchemaUpdate(false);setData Tue, 17 Dec 2013 11:14:36 GMT https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157275#M111471 rolf 2013-12-17T11:14:36Z Re: Tables missing for component(s) engine, history, identity https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157276#M111472 <HTML><HEAD></HEAD><BODY><SPAN>If you set the flag to "false", the minimal checking will be performed (table exists and right version). To circumvent this (eg. you use a manual process to create/update tables), you can set it to ANY value different from "true", "false", "create", …</SPAN><BR /><BR /><SPAN>Eg. if you use the setDatabaseSchemaUpdate("none"), nothing will be done. This is offcourse, an undocumented feature, as it's always safer to have it set to false, to ensure engine boots on a correct engine version. Offcourse, if this doensn't work as expected in the targeted database, this is a good workaround.</SPAN></BODY></HTML> Wed, 18 Dec 2013 08:04:45 GMT https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157276#M111472 frederikherema1 2013-12-18T08:04:45Z Re: Tables missing for component(s) engine, history, identity https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157277#M111473 <HTML><HEAD></HEAD><BODY><SPAN>We check the database after running the update scripts. So we do not need to check each time the engine starts.</SPAN><BR /><BR /><SPAN>Thanks for your help!</SPAN><BR /></BODY></HTML> Wed, 18 Dec 2013 09:14:14 GMT https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157277#M111473 rolf 2013-12-18T09:14:14Z Re: Tables missing for component(s) engine, history, identity https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157278#M111474 <HTML><HEAD></HEAD><BODY><SPAN>Okay, so setting that property is perfectly fine for your usecase.</SPAN></BODY></HTML> Wed, 18 Dec 2013 10:43:55 GMT https://connect.hyland.com/t5/alfresco-archive/tables-missing-for-component-s-engine-history-identity/m-p/157278#M111474 frederikherema1 2013-12-18T10:43:55Z