Hi Ivan, Your message has been moderated, else it would not have reached this Mailing List.
Please subscribe to the user ML for such questions and then use your email client. See why here http://ofbiz.apache.org/mailing-lists.html. You will get a better support, people can answer you on the ML. The wider the audience the better the answers you might get. Also it's more work for moderators who have to accept your messages as long as you have not subscribed. I'll personally no longer accept them (other moderators still could). This said, I suggest that you create at Jira issue where you give us more information. Notably what you exactly did, including detailed steps to reproduce. Also the OFBiz version you used. To create a Jira please follow https://s.apache.org/yp9d0 Before doing that, did you load the demo data using "gradlew loadAll"? For more information you may refer to https://nightlies.apache.org/ofbiz/trunk/readme/html5/README.html Thanks Jacques Le 30/04/2024 à 04:45, Ivan Drinks Sr a écrit :
Trying to create a new tenant produces the following error: Detail: Key (group_id)=(SUPER) is not present in table "security_group".))). Rolling back transaction. org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp" Detail: Key (group_id)=(SUPER) is not present in table "security_group".)) (Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp" Detail: Key (group_id)=(SUPER) is not present in table "security_group".))) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:921) ~[main/:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1357) ~[main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:314) ~[main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:284) ~[main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261) ~[main/:?] at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:267) ~[main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:432) ~[main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) ~[main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) ~[main/:?] at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:140) ~[main/:?] at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:104) ~[main/:?] at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:74) ~[main/:?] at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) ~[main/:?] at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) ~[main/:?] at org.apache.ofbiz.base.start.Start.main(Start.java:89) ~[main/:?] Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
