topic Error in postgres database initialization in activiti-explorer in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152145#M106820 <HTML><HEAD></HEAD><BODY><SPAN>I need to run a copy of activiti explorer under postgres and jboss7, to start from a clean database I delete and recreate by hand the activiti database itself.</SPAN><BR /><SPAN>If I use activiti via code in my project (including the activiti-engine dependencies) it works fine (creating related schema and tables).</SPAN><BR /><SPAN>If I try to deploy&nbsp; the modified activiti-engine.war in jboss an error is raised.</SPAN><BR /><SPAN>For initialize the database I have be obliged to extract the initialization "postgres sql files" from the war and run them by hand.</SPAN><BR /><BR /><SPAN>By logs seems that the deploy stops because the postgres objects in the database do not exist, but the databaseSchemaUpdate is set to true and, by documentation,&nbsp; the schema have to be created if needs.</SPAN><BR /><BR /><SPAN>Is it a bug or I have to set anything in the configuration files?</SPAN><BR /><BR /><SPAN>Thanks in advance for each suggestion.</SPAN><BR /><BR /><BR /><SPAN>Here are same infos:</SPAN><BR /><SPAN>- Postgres 9.2</SPAN><BR /><SPAN>- Jboss 7.1.3</SPAN><BR /><SPAN>- modified db.properties:</SPAN><BR /><SPAN>****************</SPAN><BR /><SPAN>db=postgres</SPAN><BR /><SPAN>jdbc.driver=org.postgresql.Driver</SPAN><BR /><SPAN>jdbc.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/activiti</SPAN><BR /><SPAN>jdbc.username=postgres</SPAN><BR /><SPAN>jdbc.password=manager</SPAN><BR /><SPAN>****************</SPAN><BR /><BR /><BR /><SPAN>Raised error in jboss log (setting an highest log level):</SPAN><BR /><SPAN>****************</SPAN><BR /><SPAN>08:04:36,778 ERROR [org.activiti.engine.impl.interceptor.CommandContext] (Thread-86) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.postgresql.util.PSQLException: ERROR: relation "act_ru_job" does not exist</SPAN><BR /><SPAN>&nbsp; Position: 36</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.selectNextJobsToExecute-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RES.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_RU_JOB RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_&nbsp;&nbsp;&nbsp;&nbsp; where (RES.RETRIES_ &gt; 0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (RES.DUEDATE_ is null or RES.DUEDATE_ &lt; ?)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ &lt; ?)&nbsp;&nbsp;&nbsp; and (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (RES.EXECUTION_ID_ is null)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (PI.SUSPENSION_STATE_ = 1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LIMIT ? OFFSET ?</SPAN><BR /><SPAN>### Cause: org.postgresql.util.PSQLException: ERROR: relation "act_ru_job" does not exist</SPAN><BR /><SPAN>&nbsp; Position: 36</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) [mybatis-3.2.2.jar:3.2.2]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) [mybatis-3.2.2.jar:3.2.2]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) [mybatis-3.2.2.jar:3.2.2]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:286) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:277) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:272) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:259) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.JobEntityManager.findNextJobsToExecute(JobEntityManager.java:105) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:48) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) [activiti-spring-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) [activiti-spring-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:59) [activiti-engine-5.14.jar:5.14]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]</SPAN><BR /><SPAN>Caused by: org.postgresql.util.PSQLException: ERROR: relation "act_ru_job" does not exist</SPAN><BR /></BODY></HTML> Sat, 08 Feb 2014 07:31:27 GMT danilo1 2014-02-08T07:31:27Z Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152145#M106820 I need to run a copy of activiti explorer under postgres and jboss7, to start from a clean database I delete and recreate by hand the activiti database itself.If I use activiti via code in my project (including the activiti-engine dependencies) it works fine (creating related schema and tables).If I Sat, 08 Feb 2014 07:31:27 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152145#M106820 danilo1 2014-02-08T07:31:27Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152146#M106821 <HTML><HEAD></HEAD><BODY><SPAN>See other post where I answered.</SPAN></BODY></HTML> Mon, 10 Feb 2014 08:57:46 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152146#M106821 jbarrez 2014-02-10T08:57:46Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152147#M106822 <HTML><HEAD></HEAD><BODY><SPAN>that's a lot of error. Well, I can't understand it myself. I'll try to recommend this problem to others so they can help.</SPAN><BR /><BR /><A href="http://www.onlinegokkasten.me/gnuf.php" rel="nofollow noopener noreferrer"><SPAN style="color: #FDFDFF; text-decoration: underline;">hier</SPAN></A><BR /></BODY></HTML> Wed, 19 Feb 2014 04:48:07 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152147#M106822 donnahutchins 2014-02-19T04:48:07Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152148#M106823 <HTML><HEAD></HEAD><BODY><SPAN>jbarrez,</SPAN><BR /><SPAN>Can you please share the link that you are asking to refer?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>schaganti</SPAN></BODY></HTML> Fri, 25 Jul 2014 07:15:31 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152148#M106823 schaganti 2014-07-25T07:15:31Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152149#M106824 <HTML><HEAD></HEAD><BODY><SPAN>No I'm sorry, I'm not a search machine</SPAN></BODY></HTML> Fri, 25 Jul 2014 08:36:13 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152149#M106824 jbarrez 2014-07-25T08:36:13Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152150#M106825 <HTML><HEAD></HEAD><BODY><SPAN>I cannot find other post.</SPAN><BR /><BR /><SPAN>If i delete &lt;property name="defaultAutoCommit" value="false" /&gt;, then create tables working.</SPAN></BODY></HTML> Tue, 16 Sep 2014 16:57:48 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152150#M106825 kapitanrum 2014-09-16T16:57:48Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152151#M106826 <HTML><HEAD></HEAD><BODY><SPAN>I cannot find previous post.</SPAN><BR /><BR /><SPAN>If i delete &lt;code&gt;&lt;property name="defaultAutoCommit" value="false" /&gt;&lt;/code&gt;, then create tables working.</SPAN></BODY></HTML> Tue, 16 Sep 2014 16:58:34 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152151#M106826 kapitanrum 2014-09-16T16:58:34Z Re: Error in postgres database initialization in activiti-explorer https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152152#M106827 <HTML><HEAD></HEAD><BODY><SPAN>Could you elaborate on your problem: what are you trying to do? What is failing?</SPAN></BODY></HTML> Wed, 17 Sep 2014 11:07:17 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/152152#M106827 jbarrez 2014-09-17T11:07:17Z