Having trouble installing from source

I’m trying to install Open Suite Webapp from source. I followed the installation instructions:
Install on Linux :: Axelor Documentation and i get the error « ERROR: relation « auth_user » does not exist » after executing the command: sudo su -c « JAVA_OPTS=-Daxelor.config=/opt/tomcat/application.properties /opt/tomcat/bin/catalina.sh run » tomcat.
I don’t know what the problem is. I thought the Open Suite Webapp is only front-end and i need to install the back-end modules separately but couldn’t find any resource on that. any help would be appreciated

Hi @temanow Topic dedicated to this point can help you:

I read the topic and tried the suggestions there but still the same error. i also tried importing the project to eclipse as gradle project and tired to run it that gives me the same « ERROR: relation « auth_user » does not exist » error.

@temanow Sorry but I couldnt deploy it with Eclipse. I’ve use intelijj Idea it´s better for me.

Could you provide full logs of your terminal when executed or maybe record a video who display the error ?

~/axelor-source/axelor-erp$ ./gradlew --no-daemon run
To honour the JVM settings for this build a new JVM will be forked. Please consider using the daemon: The Gradle Daemon.
Daemon will be stopped at the end of the build stopping after processing

Task :buildSrc:compileJava UP-TO-DATE
Task :buildSrc:compileGroovy NO-SOURCE
Task :buildSrc:processResources NO-SOURCE
Task :buildSrc:classes UP-TO-DATE
Task :buildSrc:jar UP-TO-DATE
Task :buildSrc:assemble UP-TO-DATE
Task :buildSrc:compileTestJava NO-SOURCE
Task :buildSrc:compileTestGroovy NO-SOURCE
Task :buildSrc:processTestResources NO-SOURCE
Task :buildSrc:testClasses UP-TO-DATE
Task :buildSrc:test NO-SOURCE
Task :buildSrc:check UP-TO-DATE
Task :buildSrc:build UP-TO-DATE
Task :modules:axelor-exception:generateCode UP-TO-DATE
Task :modules:axelor-tool:generateCode UP-TO-DATE
Task :modules:axelor-admin:generateCode UP-TO-DATE
Task :modules:axelor-message:generateCode UP-TO-DATE
Task :modules:axelor-account:generateCode UP-TO-DATE
Task :modules:axelor-bank-payment:generateCode UP-TO-DATE
Task :modules:axelor-bank-payment:xjc UP-TO-DATE
Task :modules:axelor-studio:generateCode UP-TO-DATE
Task :modules:axelor-bpm:generateCode UP-TO-DATE
Task :modules:axelor-purchase:generateCode UP-TO-DATE
Task :modules:axelor-crm:generateCode UP-TO-DATE
Task :modules:axelor-base:generateCode UP-TO-DATE
Task :modules:axelor-stock:generateCode UP-TO-DATE
Task :modules:axelor-sale:generateCode UP-TO-DATE
Task :modules:axelor-contract:generateCode UP-TO-DATE
Task :modules:axelor-project:generateCode UP-TO-DATE
Task :modules:axelor-supplychain:generateCode UP-TO-DATE
Task :modules:axelor-business-project:generateCode UP-TO-DATE
Task :modules:axelor-business-production:generateCode UP-TO-DATE
Task :modules:axelor-human-resource:generateCode UP-TO-DATE
Task :modules:axelor-production:generateCode UP-TO-DATE
Task :modules:axelor-cash-management:generateCode UP-TO-DATE
Task :modules:axelor-business-support:generateCode UP-TO-DATE
Task :modules:axelor-gdpr:generateCode UP-TO-DATE
Task :modules:axelor-fleet:generateCode UP-TO-DATE
Task :modules:axelor-client-portal:generateCode UP-TO-DATE
Task :modules:axelor-helpdesk:generateCode UP-TO-DATE
Task :modules:axelor-maintenance:generateCode UP-TO-DATE
Task :modules:axelor-project-dms:generateCode UP-TO-DATE
Task :modules:axelor-quality:generateCode UP-TO-DATE
Task :modules:axelor-mobile:generateCode UP-TO-DATE
Task :modules:axelor-supplier-management:generateCode UP-TO-DATE
Task :modules:axelor-talent:generateCode UP-TO-DATE
Task :generateCode UP-TO-DATE
Task :modules:axelor-marketing:generateCode UP-TO-DATE
Task :processResources UP-TO-DATE
Task :modules:axelor-admin:processResources UP-TO-DATE
Task :modules:axelor-supplier-portal:generateCode UP-TO-DATE
Task :modules:axelor-bank-payment:processResources UP-TO-DATE
Task :modules:axelor-business-production:processResources UP-TO-DATE
Task :modules:axelor-business-support:processResources UP-TO-DATE
Task :modules:axelor-cash-management:processResources UP-TO-DATE
Task :modules:axelor-client-portal:processResources UP-TO-DATE
Task :modules:axelor-business-project:processResources UP-TO-DATE
Task :modules:axelor-bpm:processResources UP-TO-DATE
Task :modules:axelor-account:processResources UP-TO-DATE
Task :modules:axelor-gdpr:processResources UP-TO-DATE
Task :modules:axelor-base:processResources UP-TO-DATE
Task :modules:axelor-crm:processResources UP-TO-DATE
Task :modules:axelor-marketing:processResources UP-TO-DATE
Task :modules:axelor-contract:processResources UP-TO-DATE
Task :modules:axelor-helpdesk:processResources UP-TO-DATE
Task :modules:axelor-message:processResources UP-TO-DATE
Task :modules:axelor-maintenance:processResources UP-TO-DATE
Task :modules:axelor-project-dms:processResources UP-TO-DATE
Task :modules:axelor-mobile:processResources UP-TO-DATE
Task :modules:axelor-purchase:processResources UP-TO-DATE
Task :modules:axelor-human-resource:processResources UP-TO-DATE
Task :modules:axelor-production:processResources UP-TO-DATE
Task :modules:axelor-project:processResources UP-TO-DATE
Task :modules:axelor-quality:processResources UP-TO-DATE
Task :modules:axelor-sale:processResources UP-TO-DATE
Task :modules:axelor-supplier-management:processResources UP-TO-DATE
Task :modules:axelor-supplier-portal:processResources UP-TO-DATE
Task :modules:axelor-stock:processResources UP-TO-DATE
Task :modules:axelor-tool:processResources UP-TO-DATE
Task :modules:axelor-talent:processResources UP-TO-DATE
Task :modules:axelor-studio:processResources UP-TO-DATE
Task :modules:axelor-supplychain:processResources UP-TO-DATE
Task :modules:axelor-fleet:processResources UP-TO-DATE
Task :modules:axelor-exception:compileJava UP-TO-DATE
Task :modules:axelor-exception:processResources UP-TO-DATE
Task :modules:axelor-exception:classes UP-TO-DATE
Task :modules:axelor-exception:jar UP-TO-DATE
Task :copyWebapp UP-TO-DATE
Task :generateHotswapConfig SKIPPED
Task :modules:axelor-tool:compileJava UP-TO-DATE
Task :modules:axelor-tool:classes UP-TO-DATE
Task :modules:axelor-tool:jar UP-TO-DATE
Task :modules:axelor-message:compileJava UP-TO-DATE
Task :modules:axelor-message:classes UP-TO-DATE
Task :modules:axelor-message:jar UP-TO-DATE
Task :modules:axelor-admin:compileJava UP-TO-DATE
Task :modules:axelor-admin:classes UP-TO-DATE
Task :modules:axelor-admin:jar UP-TO-DATE
Task :modules:axelor-studio:compileJava UP-TO-DATE
Task :modules:axelor-studio:classes UP-TO-DATE
Task :modules:axelor-studio:jar UP-TO-DATE
Task :modules:axelor-bpm:compileJava UP-TO-DATE
Task :modules:axelor-bpm:classes UP-TO-DATE
Task :modules:axelor-bpm:jar UP-TO-DATE
Task :modules:axelor-base:compileJava UP-TO-DATE
Task :modules:axelor-crm:compileJava UP-TO-DATE
Task :modules:axelor-purchase:compileJava UP-TO-DATE
Task :modules:axelor-stock:compileJava UP-TO-DATE
Task :modules:axelor-base:classes UP-TO-DATE
Task :modules:axelor-gdpr:compileJava UP-TO-DATE
Task :modules:axelor-crm:classes UP-TO-DATE
Task :modules:axelor-sale:compileJava UP-TO-DATE
Task :modules:axelor-gdpr:classes UP-TO-DATE
Task :modules:axelor-fleet:compileJava UP-TO-DATE
Task :modules:axelor-fleet:classes UP-TO-DATE
Task :modules:axelor-base:jar UP-TO-DATE
Task :modules:axelor-purchase:classes UP-TO-DATE
Task :modules:axelor-helpdesk:compileJava UP-TO-DATE
Task :modules:axelor-helpdesk:classes UP-TO-DATE
Task :modules:axelor-marketing:compileJava UP-TO-DATE
Task :modules:axelor-marketing:classes UP-TO-DATE
Task :modules:axelor-project:compileJava UP-TO-DATE
Task :modules:axelor-crm:jar UP-TO-DATE
Task :modules:axelor-project:classes UP-TO-DATE
Task :modules:axelor-helpdesk:jar UP-TO-DATE
Task :modules:axelor-sale:classes UP-TO-DATE
Task :modules:axelor-gdpr:jar UP-TO-DATE
Task :modules:axelor-fleet:jar UP-TO-DATE
Task :modules:axelor-stock:classes UP-TO-DATE
Task :modules:axelor-marketing:jar UP-TO-DATE
Task :modules:axelor-purchase:jar UP-TO-DATE
Task :modules:axelor-project:jar UP-TO-DATE
Task :modules:axelor-stock:jar UP-TO-DATE
Task :modules:axelor-sale:jar UP-TO-DATE
Task :modules:axelor-project-dms:compileJava UP-TO-DATE
Task :modules:axelor-project-dms:classes UP-TO-DATE
Task :modules:axelor-project-dms:jar UP-TO-DATE
Task :modules:axelor-account:compileJava UP-TO-DATE
Task :modules:axelor-account:classes UP-TO-DATE
Task :modules:axelor-account:jar UP-TO-DATE
Task :modules:axelor-bank-payment:compileJava UP-TO-DATE
Task :modules:axelor-bank-payment:classes UP-TO-DATE
Task :modules:axelor-bank-payment:jar UP-TO-DATE
Task :modules:axelor-supplychain:compileJava UP-TO-DATE
Task :modules:axelor-supplychain:classes UP-TO-DATE
Task :modules:axelor-contract:compileJava UP-TO-DATE
Task :modules:axelor-contract:classes UP-TO-DATE
Task :modules:axelor-supplier-management:compileJava UP-TO-DATE
Task :modules:axelor-supplier-management:classes UP-TO-DATE
Task :modules:axelor-supplier-management:jar UP-TO-DATE
Task :modules:axelor-client-portal:compileJava UP-TO-DATE
Task :modules:axelor-client-portal:classes UP-TO-DATE
Task :modules:axelor-contract:jar UP-TO-DATE
Task :modules:axelor-supplychain:jar UP-TO-DATE
Task :modules:axelor-supplier-portal:compileJava UP-TO-DATE
Task :modules:axelor-supplier-portal:classes UP-TO-DATE
Task :modules:axelor-client-portal:jar UP-TO-DATE
Task :modules:axelor-supplier-portal:jar UP-TO-DATE
Task :modules:axelor-human-resource:compileJava UP-TO-DATE
Task :modules:axelor-human-resource:classes UP-TO-DATE
Task :modules:axelor-production:compileJava UP-TO-DATE
Task :modules:axelor-production:classes UP-TO-DATE
Task :modules:axelor-production:jar UP-TO-DATE
Task :modules:axelor-mobile:compileJava UP-TO-DATE
Task :modules:axelor-mobile:classes UP-TO-DATE
Task :modules:axelor-maintenance:compileJava UP-TO-DATE
Task :modules:axelor-maintenance:classes UP-TO-DATE
Task :modules:axelor-mobile:jar UP-TO-DATE
Task :modules:axelor-talent:compileJava UP-TO-DATE
Task :modules:axelor-talent:classes UP-TO-DATE
Task :modules:axelor-maintenance:jar UP-TO-DATE
Task :modules:axelor-talent:jar UP-TO-DATE
Task :modules:axelor-human-resource:jar UP-TO-DATE
Task :modules:axelor-business-project:compileJava UP-TO-DATE
Task :modules:axelor-business-project:classes UP-TO-DATE
Task :modules:axelor-quality:compileJava UP-TO-DATE
Task :modules:axelor-quality:classes UP-TO-DATE
Task :modules:axelor-business-project:jar UP-TO-DATE
Task :modules:axelor-business-support:compileJava UP-TO-DATE
Task :modules:axelor-business-support:classes UP-TO-DATE
Task :modules:axelor-business-support:jar UP-TO-DATE
Task :modules:axelor-business-production:compileJava UP-TO-DATE
Task :modules:axelor-quality:jar UP-TO-DATE
Task :modules:axelor-business-production:classes UP-TO-DATE
Task :modules:axelor-business-production:jar UP-TO-DATE
Task :modules:axelor-cash-management:compileJava UP-TO-DATE
Task :modules:axelor-cash-management:classes UP-TO-DATE
Task :modules:axelor-cash-management:jar UP-TO-DATE
Task :compileJava UP-TO-DATE
Task :classes UP-TO-DATE
Task :runnerConfig

Task :run
2023-03-01 14:52:49.183 INFO 23364 — [ main] com.axelor.app.internal.AppRunner : Starting…
2023-03-01 14:54:54.581 DEBUG 23364 — [ost-startStop-1] com.axelor.db.JpaModule : Configuring database…
2023-03-01 14:54:56.505 INFO 23364 — [ost-startStop-1] com.axelor.auth.pac4j.AuthPac4jModule : Loading pac4j: AuthPac4jModuleLocal
2023-03-01 14:54:56.916 INFO 23364 — [ost-startStop-1] com.axelor.auth.pac4j.AuthPac4jModule : Added local client: FormClient
2023-03-01 14:55:00.041 INFO 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configuring app modules…
2023-03-01 14:55:00.041 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.exception.module.AxelorExceptionModule
2023-03-01 14:55:00.044 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.tool.module.ToolModule
2023-03-01 14:55:00.077 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.base.module.AdminModule
2023-03-01 14:55:00.087 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.message.module.MessageModule
2023-03-01 14:55:00.112 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.base.module.BaseModule
2023-03-01 14:55:00.182 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.purchase.module.PurchaseModule
2023-03-01 14:55:00.223 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.account.module.AccountModule
2023-03-01 14:55:00.314 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.bankpayment.module.BankPaymentModule
2023-03-01 14:55:00.340 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.crm.module.CrmModule
2023-03-01 14:55:00.435 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.sale.module.SaleModule
2023-03-01 14:55:00.541 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.stock.module.StockModule
2023-03-01 14:55:00.671 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.supplychain.module.SupplychainModule
2023-03-01 14:55:00.948 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.production.module.ProductionModule
2023-03-01 14:55:01.089 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.contract.module.ContractModule
2023-03-01 14:55:01.104 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.project.module.ProjectModule
2023-03-01 14:55:01.151 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.hr.module.HumanResourceModule
2023-03-01 14:55:01.241 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.businessproject.module.BusinessProjectModule
2023-03-01 14:55:01.269 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.businessproduction.module.BusinessProductionModule
2023-03-01 14:55:01.282 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.cash.management.module.CashManagementModule
2023-03-01 14:55:01.294 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.projectdms.module.ProjectDMSModule
2023-03-01 14:55:01.299 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.talent.module.TalentModule
2023-03-01 14:55:01.343 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.maintenance.module.MaintenanceModule
2023-03-01 14:55:01.359 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.studio.module.StudioModule
2023-03-01 14:55:01.422 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.supplierportal.module.SupplierPortalModule
2023-03-01 14:55:01.436 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.marketing.module.MarketingModule
2023-03-01 14:55:01.445 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.helpdesk.module.HelpdeskModule
2023-03-01 14:55:01.453 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.portal.module.ClientPortalModule
2023-03-01 14:55:01.455 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.bpm.module.BpmModule
2023-03-01 14:55:01.481 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.quality.module.QualityModule
2023-03-01 14:55:01.497 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.gdpr.module.GdprModule
2023-03-01 14:55:01.514 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.businesssupport.module.BusinessSupportModule
2023-03-01 14:55:01.520 DEBUG 23364 — [ost-startStop-1] com.axelor.app.AppModule : Configure module: com.axelor.apps.fleet.module.FleetModule
2023-03-01 14:55:17.655 DEBUG 23364 — [pool-2-thread-1] com.axelor.db.JpaScanner : Searching for entity classes…
2023-03-01 14:55:17.657 DEBUG 23364 — [pool-2-thread-2] com.axelor.db.JpaScanner : Searching for repository classes…
2023-03-01 14:55:17.659 DEBUG 23364 — [pool-2-thread-3] com.axelor.db.JpaScanner : Searching for value enum classes…
2023-03-01 14:55:18.450 DEBUG 23364 — [pool-2-thread-3] com.axelor.db.JpaScanner : Value enum classes found: 8
2023-03-01 14:55:19.077 DEBUG 23364 — [pool-2-thread-2] com.axelor.db.JpaScanner : Repository classes found: 806
2023-03-01 14:55:31.773 DEBUG 23364 — [pool-2-thread-1] com.axelor.db.JpaScanner : Entity classes found: 641
2023-03-01 14:56:05.065 INFO 23364 — [ost-startStop-1] com.axelor.web.AppInitializer : Initializing…
2023-03-01 14:56:07.032 ERROR 23364 — [ost-startStop-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: relation « auth_user » does not exist
Position: 42
2023-03-01 14:56:07.058 ERROR 23364 — [ost-startStop-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: relation « auth_user » does not exist
Position: 42
2023-03-01 14:56:07.114 ERROR 23364 — [ost-startStop-1] com.axelor.web.AppInitializer : org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1463)
at com.axelor.db.Query.count(Query.java:459)
at com.axelor.meta.loader.ModuleManager.encryptPasswords(ModuleManager.java:546)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
at com.axelor.meta.loader.ModuleManager.initialize(ModuleManager.java:147)
at com.axelor.web.AppInitializer.init(AppInitializer.java:58)
at javax.servlet.GenericServlet.init(GenericServlet.java:244)
at com.google.inject.servlet.ServletDefinition.init(ServletDefinition.java:119)
at com.google.inject.servlet.ManagedServletPipeline.init(ManagedServletPipeline.java:80)
at com.google.inject.servlet.ManagedFilterPipeline.initPipeline(ManagedFilterPipeline.java:102)
at com.google.inject.servlet.GuiceFilter.init(GuiceFilter.java:232)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:106)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4548)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5193)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2123)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1911)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1887)
at org.hibernate.loader.Loader.doQuery(Loader.java:932)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
at org.hibernate.loader.Loader.doList(Loader.java:2615)
at org.hibernate.loader.Loader.doList(Loader.java:2598)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2430)
at org.hibernate.loader.Loader.list(Loader.java:2425)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:379)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1488)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
… 23 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation « auth_user » does not exist
Position: 42
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:71)
… 38 common frames omitted
2023-03-01 14:56:07.570 ERROR 23364 — [ost-startStop-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: relation « meta_select » does not exist
Position: 670
2023-03-01 14:56:07.574 ERROR 23364 — [ost-startStop-1] o.a.c.c.C.[.[localhost].[/axelor-erp] : Exception starting filter [guiceFilter]
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
at org.hibernate.query.Query.getResultList(Query.java:146)
at com.axelor.db.Query.fetch(Query.java:403)
at com.axelor.db.Query.fetch(Query.java:392)
at com.axelor.db.Query.fetchOne(Query.java:430)
at com.axelor.meta.db.repo.MetaSelectRepository.findByName(MetaSelectRepository.java:27)
at com.axelor.apps.message.service.TemplateService.createSelectionOfAllModels(TemplateService.java:125)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.axelor.event.Observer.invoke(Observer.java:104)
at com.axelor.event.EventBus.lambda$fire$9(EventBus.java:100)
at java.util.ArrayList.forEach(ArrayList.java:1259)
at com.axelor.event.EventBus.fire(EventBus.java:100)
at com.axelor.event.EventImpl.fire(EventImpl.java:59)
at com.axelor.web.AppInitializer.init(AppInitializer.java:85)
at javax.servlet.GenericServlet.init(GenericServlet.java:244)
at com.google.inject.servlet.ServletDefinition.init(ServletDefinition.java:119)
at com.google.inject.servlet.ManagedServletPipeline.init(ManagedServletPipeline.java:80)
at com.google.inject.servlet.ManagedFilterPipeline.initPipeline(ManagedFilterPipeline.java:102)
at com.google.inject.servlet.GuiceFilter.init(GuiceFilter.java:232)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:106)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4548)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5193)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2123)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1911)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1887)
at org.hibernate.loader.Loader.doQuery(Loader.java:932)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
at org.hibernate.loader.Loader.doList(Loader.java:2615)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2460)
at org.hibernate.loader.Loader.list(Loader.java:2422)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:379)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1488)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
… 34 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation « meta_select » does not exist
Position: 670
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:71)
… 48 common frames omitted
2023-03-01 14:56:07.575 ERROR 23364 — [ost-startStop-1] o.apache.catalina.core.StandardContext : One or more Filters failed to start. Full details will be found in the appropriate container log file
2023-03-01 14:56:07.575 ERROR 23364 — [ost-startStop-1] o.apache.catalina.core.StandardContext : Context [/axelor-erp] startup failed due to previous errors

Running at http://localhost:8080/axelor-erp

Which version of postgresql are you using ?

I’m using postgresql 15

So which java version and Axelor version are you using ?

I never tried to use Axelor with Postgresql 15, maybe you should try with version 12 or 13.

java 8 and axelor 6.5.1. i’m having this issue when i try to install it from the source. it works if i use the docker installation(Docker :: Axelor Documentation) and the all in one bundle(Find your solution to install Axelor platform | Axelor). but i want the source b/c i want to customize it.

Okay, if you’re using java 8, it mean you’re using Axelor ADK 5. axelor 6.5.1 is the version of the open suite. With ADK 5, you need to use Postgresql from 9 to 12. Not version 15.

1 « J'aime »

It worked when i changed postgresql version. thanks for the help

Ce sujet a été automatiquement fermé après 30 jours. Aucune réponse n’est permise dorénavant.