topic Activiti Multitenant + Postgres in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-multitenant-postgres/m-p/218847#M171977 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm trying to implement a solution based on Activiti 5.19.0 and PostgreSQL with multi-tenancy support. The solution works well with one schema, but when i'm going to create another tenant I got the following exception:</SPAN><BR /><BR /><SPAN>00:32:19 | DEBUG | http-bio-9966-exec-1 | o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver | Resolving exception from handler [public void com.newco.teamwork2.activiti.controller.TenantController.registerTenant(com.newco.teamwork2.activiti.dto.TenantDTO) throws java.sql.SQLException]: org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.postgresql.util.PSQLException: ERRORE: la relazione "act_ge_property" non esiste</SPAN><BR /><SPAN>&nbsp; Posizione: 20</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Property.xml</SPAN><BR /><SPAN>### The error may involve defaultParameterMap</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'</SPAN><BR /><SPAN>### Cause: org.postgresql.util.PSQLException: ERRORE: la relazione "act_ge_property</SPAN><BR /><BR /><SPAN>I create one datasource for tenant with the search path included in it. I use the property currentSchema, because i'm on Postgresql 9.4. </SPAN><BR /><BR /><SPAN>Any clue?</SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Sun, 01 May 2016 22:41:31 GMT mario_gallo 2016-05-01T22:41:31Z Activiti Multitenant + Postgres https://connect.hyland.com/t5/alfresco-archive/activiti-multitenant-postgres/m-p/218847#M171977 Hi,I'm trying to implement a solution based on Activiti 5.19.0 and PostgreSQL with multi-tenancy support. The solution works well with one schema, but when i'm going to create another tenant I got the following exception:00:32:19 | DEBUG | http-bio-9966-exec-1 | o.s.w.s.m.m.a.ExceptionHandlerExcepti Sun, 01 May 2016 22:41:31 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-multitenant-postgres/m-p/218847#M171977 mario_gallo 2016-05-01T22:41:31Z Re: Activiti Multitenant + Postgres https://connect.hyland.com/t5/alfresco-archive/activiti-multitenant-postgres/m-p/218848#M171978 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mario,</SPAN><BR /><BR /><SPAN>it seems that property table is not created in the second schema.</SPAN><BR /><SPAN>Is it possible to reproduce the issue in the jUnit test?</SPAN><BR /><A href="https://forums.activiti.org/content/sticky-how-write-unit-test" rel="nofollow noopener noreferrer">https://forums.activiti.org/content/sticky-how-write-unit-test</A><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Mon, 02 May 2016 04:39:32 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-multitenant-postgres/m-p/218848#M171978 martin_grofcik 2016-05-02T04:39:32Z