Jörg Rade created ISIS-3118:
-------------------------------
Summary: [SecMan] With Postgres, Schema is not Created
Automatically
Key: ISIS-3118
URL: https://issues.apache.org/jira/browse/ISIS-3118
Project: Isis
Issue Type: Bug
Components: Isis Extensions SecMan
Affects Versions: 2.0.0-M7
Reporter: Jörg Rade
Fix For: 3.0.0-M1
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)
