Hi francesco, You're right, I mixed files.
Thank's Stéphane POPOFF Le mar. 31 mars 2026 à 13:33, Francesco Chicchiriccò <[email protected]> a écrit : > > Hi, > it seems you are attempting to load a pre-4.1.0-M0 (maybe 4.1.0-SNAPSHOT ?) > MasterContent.xml into a database initialized by Syncope 4.1.0-M0. > > Regards. > > On 31/03/26 13:16, Stéphane Popoff wrote: > > Hi, > > When starting a new instance of syncope 4.1.0-M0 based on the Maven > > archetype docker. I found those errors on the CORE container. > > Something wrong with the PostGreSQL schema ? > > > > 2026-03-30 03:26:48.704 INFO [ main] > > org.apache.syncope.core.provisioning.api.ConnectorManager : Done > > loading 0 connectors > > 2026-03-30 03:26:59.562 INFO [ main] > > rg.apache.syncope.core.persistence.api.content.ContentLoader : > > [Master] Empty database found, loading default content > > 2026-03-30 03:27:00.807 WARN [ main] > > core.persistence.common.content.AbstractContentLoaderHandler : No > > column type found for USEROWNER_ID > > 2026-03-30 03:27:00.861 WARN [ main] > > core.persistence.common.content.AbstractContentLoaderHandler : No > > column type found for USEROWNER_ID > > 2026-03-30 03:27:00.865 ERROR [ main] > > core.persistence.common.content.AbstractContentLoaderHandler : While > > trying to perform INSERT INTO > > SyncopeGroup(id,name,userOwner_id,realm_id,creator,lastModifier,creationDate,lastChangeDate,plainAttrs) > > VALUES (?,?,?,?,?,?,?,?,?) with params > > [ebf97068-aa4b-4a85-9f01-680e8c4cf227, director, > > 823074dc-d280-436d-a7dd-07399fae48ec, > > e4c28e7a-9dbf-4ee7-9441-93812a0d4a28, admin, admin, 2010-10-20T11:00Z, > > 2010-10-20T11:00Z, > > [{"values":[{"stringValue":"icon6"}],"schema":"icon"}]] > > > > org.springframework.jdbc.BadSqlGrammarException: > > PreparedStatementCallback; bad SQL grammar [INSERT INTO > > SyncopeGroup(id,name,userOwner_id,realm_id,creator,lastModifier,creationDate,lastChangeDate,plainAttrs) > > VALUES (?,?,?,?,?,?,?,?,?)] > > at ... [truncated by me...] > > Caused by: org.postgresql.util.PSQLException: ERROR: column > > "userowner_id" of relation "syncopegroup" does not exist > > Position: 34 > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) > > at... [truncated by me...]... 50 more > > > > 2026-03-30 03:27:00.902 ERROR [ main] > > rg.apache.syncope.core.persistence.api.content.ContentLoader : > > [Master] While loading default content > > > > org.springframework.jdbc.BadSqlGrammarException: StatementCallback; > > bad SQL grammar [SELECT * FROM TypeExtension WHERE 0=1] > > at... [truncated by me...] > > Caused by: org.postgresql.util.PSQLException: ERROR: relation > > "typeextension" does not exist > > Position: 15 > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) > > at... [truncated by me...]... 49 more > > > > Best regards, > > > > Stéphane POPOFF > > > -- > Francesco Chicchiriccò > > Tirasa - Open Source Excellence > http://www.tirasa.net/ > > Member at The Apache Software Foundation > Syncope, Cocoon, Olingo, CXF, OpenJPA > https://about.me/ilgrosso >
