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/151688#M106418 <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 /><SPAN>- the activiti-standalone-context.xm is unmodified and related section is :</SPAN><BR /><SPAN>****************</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="customFormTypes"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;list&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;bean class="org.activiti.explorer.form.UserFormType" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;bean class="org.activiti.explorer.form.ProcessDefinitionFormType" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;bean class="org.activiti.explorer.form.MonthFormType" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/list&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</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:29:05 GMT danilo1 2014-02-08T07:29:05Z 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/151688#M106418 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:29:05 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/151688#M106418 danilo1 2014-02-08T07:29:05Z 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/151689#M106419 <HTML><HEAD></HEAD><BODY><SPAN>The sql files for each database are also contained in the zip file downloadable from activiti.org. Did you try those?</SPAN><BR /><BR /><SPAN>But if databaseSchemaUpdate is set to true, it should update UNLESS the running of the SQL has failed somewhere in between.</SPAN><BR /><BR /><SPAN>So I should first try with the sql files from the website, and if still failure, check the logging on debug level to see if the schema update is happening or not (there should be a log line)</SPAN></BODY></HTML> Mon, 10 Feb 2014 08:56:09 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/151689#M106419 jbarrez 2014-02-10T08:56:09Z 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/151690#M106420 <HTML><HEAD></HEAD><BODY><SPAN>I will check it.</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Mon, 10 Feb 2014 09:57:33 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-postgres-database-initialization-in-activiti-explorer/m-p/151690#M106420 danilo1 2014-02-10T09:57:33Z