[
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)
