[ https://issues.apache.org/jira/browse/CAUSEWAY-3118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Keir Haywood updated CAUSEWAY-3118: ------------------------------------------ Fix Version/s: (was: 2.2.0) > [SecMan] With Postgres, Schema is not Created Automatically > ----------------------------------------------------------- > > Key: CAUSEWAY-3118 > URL: https://issues.apache.org/jira/browse/CAUSEWAY-3118 > Project: Causeway > Issue Type: Bug > Components: Ext Sec Secman > Affects Versions: 2.0.0-M7 > Reporter: Jörg Rade > Priority: Minor > > Workaround: create Schema manually > {code}CREATE SCHEMA isisextsecman;{code} > Console Log: > {code} > 2022-08-10 18:13:51.500 INFO 27068 --- [ main] > o.a.i.e.s.a.s.SeedSecurityModuleService : SEED security fixtures (Users and > Roles) > [EL Warning]: 2022-08-10 18:13:51.552--UnitOfWork(2129226780)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - > 2.7.10.v20211216-fe64cd39c3): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: org.postgresql.util.PSQLException: ERROR: relation > "isisextsecman.applicationtenancy" does not exist > Position: 45 > Error Code: 0 > Call: SELECT PATH, NAME, VERSION, parentPath FROM > isisExtSecman.ApplicationTenancy WHERE (PATH = ?) > bind => [1 parameter bound] > Query: ReadObjectQuery(name="isis.ext.secman.ApplicationTenancy.findByPath" > referenceClass=ApplicationTenancy sql="SELECT PATH, NAME, VERSION, parentPath > FROM isisExtSecman.ApplicationTenancy WHERE (PATH = ?)") > 2022-08-10 18:13:51.561 ERROR 27068 --- [ main] > o.a.i.t.f.a.f.FixtureScript : > seed-users-and-roles-fixture-script/global-tenancy: JPA operation: ERROR: > relation "isisextsecman.applicationtenancy" does not exist > Position: 45; bad SQL grammar []; nested exception is > org.postgresql.util.PSQLException: ERROR: relation > "isisextsecman.applicationtenancy" does not exist > Position: 45 > 2022-08-10 18:13:51.561 ERROR 27068 --- [ main] > o.a.i.t.f.a.f.FixtureScript : seed-users-and-roles-fixture-script > org.springframework.jdbc.BadSqlGrammarException: JPA operation: ERROR: > relation "isisextsecman.applicationtenancy" does not exist > Position: 45; bad SQL grammar []; nested exception is > org.postgresql.util.PSQLException: ERROR: relation > "isisextsecman.applicationtenancy" does not exist > ... > {code} > c.f. https://the-asf.slack.com/archives/CFC42LWBV/p1660148483783429 -- This message was sent by Atlassian Jira (v8.20.10#820010)