[CAUSEWAY-3118] [SecMan] With Postgres, Schema is not Created Automatically

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.0.0-M7
• Component/s: Ext Sec Secman
• Assignee: Unassigned
• Reporter: Jörg Rade
• Created: 11/Aug/22 07:02
• Updated: 05/Jul/24 13:43

Description

Workaround: create Schema manually

CREATE SCHEMA isisextsecman;

Console Log:

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
...

c.f. https://the-asf.slack.com/archives/CFC42LWBV/p1660148483783429